Load Balancing/Query Routing using PGPOOL-II ( Part-II)

In our first part of the Pgpool-II series, the Installation and Configuration of Pgpool-II were discussed. This part will focus on one prominent feature of Pgpool-II, which is Load Balancing/Query Routing.  What is Load Balancing?Why do we need Pgpool-II for load balancing?How is it actually work?Types of Load Balancing modesSession Level Load Balancing:Statement Level Load … Continue reading Load Balancing/Query Routing using PGPOOL-II ( Part-II) →

Synopsis of Mydbops 16th 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 16th 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 16th edition of MyWebinar →

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 →

MySQL Schema change With Skeema – Part 1 “Basic Operations”

As a Database Engineer, One of the biggest challenges in day-to-day activity is performing DDL on high-traffic and transaction-intensive tables. It will become overhead when handling a large number of servers/shards. As a standard process, we will first deploy the changes in DEV and QA before deploying them in production. In the sharded environment, It … Continue reading MySQL Schema change With Skeema – Part 1 “Basic Operations” →

Troubleshooting XA transactions in MySQL

This is one of the exciting troubleshooting related to XA transactions let’s dive in. Let me provide a few backgrounds. For one of our clients, when we try to drop a table, it is waiting for metadata lock. On debugging it is one of the XA transactions is holding the shared write lock and causing … Continue reading Troubleshooting XA transactions in MySQL →

Online InnoDB Redo log Resize MySQL 8.0.30

  Tired of downtimes and planning to resize your redo log files in MySQL ( InnoDB)? Here we can find a smile on our faces! The latest release of MySQL 8.0.30 ( 2022-07-26 ) has added the Online resize of the InnoDB Redo log. Summary Need for Redo Log InnoDB Redo log Before 8.0.30InnoDB Redo … Continue reading Online InnoDB Redo log Resize MySQL 8.0.30 →

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 →