Exploring Aurora serverlessV2 for MySQL Part 2 – Migration

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 …

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 …

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 …

Dynamic 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 …

How to Estimate time for Rollback in a cancelled transaction MySQL ?

Rollback is an operation, which changes the current state of the transaction to the previous state. Undo logs are generally required if we want to roll back any of the uncommitted transactions and it plays a major role in Isolation. For any changes made during a transaction, it must be stored priorly, because they are …

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 …

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 …

Synopsis of Mydbops 10th edition of opensource database meetup

We're ecstatic and energised at the prospect of sowing the seeds of knowledge in our opensource database community. Thank you to everyone who came out to our 10th opensource database meetup. Our meetup series began in 2018, and the 10th edition took nearly three years to complete. However, we prioritised quality above quantity when distilling. …

Webinar Summary: Migrate your EOL MySQL Servers

This brief summarises the proceedings and outcomes of the 2nd MyWebinar which was held on 13th February 2021 at Online Webinar. As part of our thought leadership webinar series, our latest hosting webinar Migrate your EOL MySQL Servers (seamless migration to MySQL group replication / InnoDB cluster) We have conducted MyWebinar with a very positive …

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 …