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 ?

Advertisement

Generate Invisible Primary Key (GIPK) MySQL 8.0

The Primary key is like the hero of a row, which has more beneficial features in the table while performing any task on the table. The DBA knows the importance of the primary key in the table and how to handle it. Notable features of having a primary key:Requirements:Enabling GIPK:Handling GIPK:BenchmarkingData loading :Limitations:Conclusion: Notable features … Continue reading Generate Invisible Primary Key (GIPK) MySQL 8.0

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

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

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