Greetings everyone!!!!! Let's begin the phase II of our blog on Aurora serverless-V2. Part 1 - https://mydbops.wordpress.com/2022/05/22/exploring-auAurora-serverless-v2-for-mysqlHere, I have focused primarily on the migration strategies, hence this blog will be helpful for those who are in a stance to migrate towards serverless V2. Before entering into the migration strategies, let's take a look at the … Continue reading Exploring Aurora serverlessV2 for MySQL Part 2 – Migration
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
Terminate In-Progress Index Builds in MongoDB (series 3)
MongoDB uses B-Tree internally. We will understand about Terminating In-progress index builds, and the index build process, commit quorum, and dropping an index in this blog. I have added flow charts to make the information interactive. let's start! Terminate In-Progress Index Builds Before 4.4From 4.4Abort In-Progress Index BuildsCommit QuorumRequires featureCompatibilityVersion 4.4+Index Build ProcessSet Index Commit QuorumsetIndexCommitQuorumResource … Continue reading Terminate In-Progress Index Builds in MongoDB (series 3)
Readable MultiAZ Cluster with AWS RDS MySQL under the hood.
Amazon Web Services (AWS) very recently(March 02, 2022) announced the GA of its new RDS feature “Readable standby with Multi-AZ deployments” for MySQL. Yes !! you heard it right you can now use the standby instances created with Multi-AZ deployments for failover as well as for Read-scaling starting with version 8.0.26 and later for MySQL … Continue reading Readable MultiAZ Cluster with AWS RDS MySQL under the hood.
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
Maintenance of MySQL Binary logs
In this blog, we are going to discuss the Maintenance of binary logs. Before going into our topic, let’s recall the basics of binary logs. Binary logs Binary logs contain all the changes and records that take place in any database. It will log the statements like CREATE, ALTER, DELETE, INSERT and UPDATE. It will … Continue reading Maintenance of MySQL Binary logs
Replication Filters in MySQL an Overview
What are Replication Filters in MySQL? A replication filter is used to filter out the necessary databases and tables that will be replicated in the replica. The replication filter can be set either in my. cnf or the command line. The change made in those databases will be logged in binary log files. The filter … Continue reading Replication Filters in MySQL an Overview
Fastest Parallel replication method in MySQL 8.
From MySQL 5.7, we had a Multi-threaded Slave (MTS) Applier mechanism called LOGICAL_CLOCK to overcome the problems of parallel replication within a database. To further improve the parallelisation mechanism, from MySQL 8 (5.7.22) we have write-set replication, so before going further , lets look at the difference between Logical clock (LC) and Writeset. LOGICAL_CLOCK Transactions that … Continue reading Fastest Parallel replication method in MySQL 8.
MySQL Group Replication and its Memory consumption (troubleshooting).
This blog is about one of the issues encountered by our Remote DBA Team in one of the production servers. We have a setup of MySQL 5.7 Single Primary (Writer) GR with cluster size of 3 . Due to OOM, the MySQL process in the primary node got killed, this repeated over the course of … Continue reading MySQL Group Replication and its Memory consumption (troubleshooting).
Monitoring MySQL using ProxySQL
ProxySQL is a high-performance load balancer that helps DBAs a lot and gives more control over MySQL Database. At Mydbops we use ProxySQL extensively to support our customers. We have seen a variety of use cases with ProxySQL and blogged a few We have written a series of blogs on ProxySQL (ProxySQL Series) MySQL replication … Continue reading Monitoring MySQL using ProxySQL