Faster logical backup of a single table in MySQL.

Logical backup's are of great use in data migration across cloud environments and table level recoveries. The new Mysql shell 8.0.22 ,has introduced a couple of new utilities named util.dumpTable() and util.exportTable() to export individual tables from a MySQL. Prior to 8.0.22 it is not possible to make a backup of single table using MySQL … Continue reading Faster logical backup of a single table in MySQL.

Mydbops Database Meetup #7 (Virtual Meetup)

Partnering to participate in knowledge sharing for the community of open source Database Administrators. In continuation to the community contribution with knowledge gained out of experience and demo, Mydbops IT Solutions, conducted it's 7th Database Meetup (Virtual) on Saturday, 3rd of October 2020. Due to these Pandemic situation, and for the first time, we have … Continue reading Mydbops Database Meetup #7 (Virtual Meetup)

Is your database robust to accommodate high traffic throughout this festival season?

This year's predicted traffic trends are 2X. https://www.businessinsider.in/advertising/brands/news/myntra-expects-2x-increase-in-traffic-over-the-previous-festive-season-in-its-upcoming-big-fashion-festival/articleshow/78554170.cms Be it e-commerce, logistics, fintech & many more, higher traffic is expected. Is your database permanence enough to nullify the downtime and provide a hustle free journey for your customers? Speaking of season, here is a fascinating dissection of one of our esteemed client who during the … Continue reading Is your database robust to accommodate high traffic throughout this festival season?

Annoucement: Mydbops Virtual database Meetup ( Oct 03 2020)

"The first step towards wisdom is to acquire knowledge. The first step towards humanity is knowledge sharing." YES, WE ARE GOING LIVE!! Mydbops Live is a community centered meetup for Database Engineers, Cloud DBA's, DB Reliability Engineers, CTO's, DB Architects & Cloud Architects, Engineering Manager, VP & Director of Engineering to comprehend the latest opensource … Continue reading Annoucement: Mydbops Virtual database Meetup ( Oct 03 2020)

“Chore”​ or “Core”​ why Mydbops support is an inevitable prerequisite for managing your Opensource database ?

At some point, your database will be in need of a critical upgrade, or you might need to migrate workloads to the cloud, to tune your database for performance, or consolidate your database infrastructure. Do you have in-house Expertise/ Database Team up for the task? Specialized database projects will require a high level of expertise, are … Continue reading “Chore”​ or “Core”​ why Mydbops support is an inevitable prerequisite for managing your Opensource database ?

Deduplication of B Tree Indexes in PostgreSQL 13

PostgreSQL 13 is generally available from September 24, 2020. Last year, PostgreSQL 12 was released with a lot of features like Generated Columns, Partitioning Improvements and so on and started to be widely used in Production Environments. This year, PostgreSQL 13 comes up with more exciting features as well as performance and security improvements. Here … Continue reading Deduplication of B Tree Indexes in PostgreSQL 13

Dockerizing MySQL step by step.

As a Database Engineer in Mydbops. We tend to solve multiple complex problems for our esteemed customers. To control the System resources and scale up /down based on needed we are evaluating Dockers and Kubernetes. Docker is a set of platform as a service products that uses OS-level virtualization to deliver software in packages called … Continue reading Dockerizing MySQL step by step.

Integrating MariaDB Audit plugin in MySQL 5.7

Basically, Auditing is the process of monitoring and recording the activity happening inside the Server. MariaDB Audit Plugin works with MariaDB, MySQL and Percona Servers. It is used to log the database Operations like, SQL Statements, User informations, Connections. The information is stored in a user defined log file or in Syslog. Available audit plugins … Continue reading Integrating MariaDB Audit plugin in MySQL 5.7

MongoDB Transaction a walk through

Mydbops MongoDB

In this blog I will walk through the Transaction in MongoDB. It's quite an interesting topic to discuss, nowadays most of the NoSQL technology adopting transactions in their database system and MongoDB also not an exception in this. The WiredTiger storage engine plays a very vital role in accomplishing the transaction in MongoDB. The interesting … Continue reading MongoDB Transaction a walk through

Creating a Simple MySQL Binlog Server

In my previous Blog i have explained how we can integrate MySQL tools ( Percona Tool kit ) with systemd service, At Mydbops works with multiple clients ,we get various requirements from customers a few may be a complex ones ,one of the requirement was to setup a binlog server and copy the Production binlogs … Continue reading Creating a Simple MySQL Binlog Server