Prevent ProxySQL from directing traffic to broken MySQL replica

ProxySQL is an open-source MySQL proxy server, meaning it serves as an intermediary between a MySQL server and the applications that access its databases. ProxySQL can improve performance by distributing traffic among a pool of multiple database servers. Consider 2 slaves are routed under Proxysql , In any one of the slave, if the replication … Continue reading Prevent ProxySQL from directing traffic to broken MySQL replica

pt-online-schema-change resulted in missing MySQL triggers ?

Recently, while doing a test process to examine resource usage and the time required to alter the table using pt-osc, it leads to a loss of triggers even though the --preserve-triggers option is specified. I made the decision to recreate the identical circumstance so that everyone could see it. Test environment :  OS: Amazon Linux … Continue reading pt-online-schema-change resulted in missing MySQL triggers ?

Beware of your Backup before upgrading MySQL 8.0.30

MySQL 8.0.30 was released on 26-07-2022. It has a good list of features. Generated Invisible Primary Key Dynamic Redo log Sizing Instruments to monitor group replication memory Support for Ubuntu 22.04 A most notable feature for Database Administrators and database reliability engineers is Dynamic redo logging. The more widely adopted open-source backup tool is Xtrabackup. … Continue reading Beware of your Backup before upgrading MySQL 8.0.30

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”

Handling case sensitive column in pt-archiver

To copy the data of the particular column of the table to another table/server, We have an option to export the data as CSV and import the data back to a different table. But when the table size is large and we need to copy the data only for the required data to the target … Continue reading Handling case sensitive column in pt-archiver

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

MySQL Binlog server with Maxscale

This is the our next blog in Maxscale series, Below is a list of our previous blogs, which provides deep insight for Maxscale and its use cases for different architectures. Scale with Maxscale part – 1 (Intro & Galera Cluster) Scale with Maxscale part – 2 (Administration, Installation & operation) Scale with Maxscale part – … Continue reading MySQL Binlog server with Maxscale