Stream MySQL data with mydumper

Mydumper supports streaming of backups right from version 0.11.3 and the latest version Mydumper 0.12.3 it enabled its support for compressed streaming backup. This was the most awaited feature added to Mydumper, making it a more powerful tool for data migration to RDS or Cloud. If you are hearing mydumper for the first time, then … Continue reading Stream MySQL data with mydumper

Synopsis of Mydbops 15th edition of MyWebinar

We’re ecstatic and energised about the prospect of sowing seeds of knowledge in our opensource database community. Thank you to everyone who joined us for the 15th edition of MyWebinar. We hope that our time together helped to elevate and seam your work to perfection. We’re committed to giving back to the opensource database community … Continue reading Synopsis of Mydbops 15th edition of MyWebinar

Faster Logical Backup/Restore using pgcopydb – PostgreSQL

No doubt, pg_dump/pg_restore is an amazing tool to perform logical backup and restorations in PostgreSQL. We have already explained in detail about pg_dump/pg_restore here. The tool pgcopydb is an Open Source tool that automates executing pg_dump and pg_restore between two PostgreSQL servers. It is a wrapper over pg_dump and pg_restore to simplify the process with … Continue reading Faster Logical Backup/Restore using pgcopydb – PostgreSQL

Exploring Aurora Serverless V2 for MySQL

Aurora Serverless V2 is generally available around the corner recently 21-04-22 for MySQL 8 and PostgreSQL, with promising features that overcome the V1 disadvantages. Below are those major features Features Online auto instance upsize (vertical scaling)Read scaling (Supports up to 15 Read-replica)Supports mixed-configuration cluster ie, the master can be normal Aurora(provisioned) and readers can be … Continue reading Exploring Aurora Serverless V2 for MySQL

AWS MySQL Security on RDS: Database Level

In the previous blog, we have gone through about network-level security in RDS. In this blog, we will see about the Database level security in RDS. After network-level restriction to host, we can't allow a user to connect to the database from anywhere over the internet. We need to restrict user access at the Database … Continue reading AWS MySQL Security on RDS: Database Level

Introduction to AWS MySQL Security on RDS : Network

Nowadays everything is getting digitalized and migration toward the cloud is at its peak. There is a high chance of data leaks if we don't tighten the security of the Database servers. It is mandatory to secure the database by restricting access to Database. Although we have restricted the access. We need to monitor the … Continue reading Introduction to AWS MySQL Security on RDS : Network

Faster Load data outfile in MySQL

While exporting the table with MySQL native utility, we don't have any control on the process, and also there will be no progress update as well on the process completion. So when exporting the larger table will consume high resource utilization and also the disk space usage will also be high. MySQL shell utility will … Continue reading Faster Load data outfile in MySQL

Troubleshooting an unique key addition during pt-online-schema-change

We all tried various alternative methods for modifying the table structure, but pt-online-schema-change (pt-osc) is the most convenient and preferred method for performing the alter online. It has more granular control too. But it may lead to data loss if proper precautionary steps are not taken care of. In this blog, we are going to … Continue reading Troubleshooting an unique key addition during pt-online-schema-change

PostgreSQL automatic failover with pg_auto_failover

PostgreSQL is a powerful, open-source relational database with a strong reputation for reliability, robustness, and performance. It supports replication to achieve high availability for a very long. But it lacks an important feature on its own, that is the concept of automated failover. Of course, there are a lot of open-source tools available to do … Continue reading PostgreSQL automatic failover with pg_auto_failover

Aurora MySQL Parallel query Performance and its gains

As a continuation to my previous blog , I have made benchmarking to find the performance improvement using parallel query.Before starting the testing, we will go through the monitoring stats variables and query analysis (explain). Monitoring Aurora Parallel Query stats S:NoParameter Purpose 1Aurora_pq_request_attemptedNo of attempt that query tried to use parallel query feature.2Aurora_pq_request_executedNo of query … Continue reading Aurora MySQL Parallel query Performance and its gains