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

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

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.

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 … Continue reading How to Estimate time for Rollback in a cancelled transaction MySQL ?

MySQL ERROR Log Table Explained

Over the decades we have been reading the MySQL error log from the server system file, if there are any issues in MySQL or any unknown restart happened , generally we look at the mysql error log. By default MySQL error log can be found in the default path /var/log/mysqld.log , or it can be … Continue reading MySQL ERROR Log Table Explained

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.

Install Specific Version of MySQL 8 using YUM

We have many ways to install MySQL on linux machines such as source, binary and so on. But most of the Engineers always prefer default package managers (yum for RPM-Based distributions and apt for DPKG-Based distributions) for its ease of use and it can resolve all dependencies on its own. And of course, it is … Continue reading Install Specific Version of MySQL 8 using YUM

Faster logical backup of a single table in MySQL.

Logical backup's are of great use in data migration across cloud environments and table level recoveries. The new Mysql shell 8.0.22 ,has introduced a couple of new utilities named util.dumpTable() and util.exportTable() to export individual tables from a MySQL. Prior to 8.0.22 it is not possible to make a backup of single table using MySQL … Continue reading Faster logical backup of a single table in MySQL.