Enhancing Performance with Parallel Index Rebuild in MySQL 8.0.31

Enhancing Performance with Parallel Index Rebuild in MySQL 8.0.31

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 …

Advertisement

Synopsis of Mydbops 19th edition of MyWebinar

Thank you to everyone who joined us for the 19th 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 in the coming days by presenting more LIVE events. Recently, Mydbops conducted a webinar on the top …

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 …

Synopsis of Mydbops 17th 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 17th 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 …

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 …

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 …

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 …

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 …

Replication Filters in MySQL an Overview

What are Replication Filters in MySQL?Replication Filter types in MySQL?Binary log Filteri) Binlog_do_dbii) Binlog_ignore_dbReplicate Filteri) Replicate_do_dbii) Replicate_ignore_dbiii) Replicate_do_tableiv) Replicate_ignore_tablev) Replicate_wild_do_tablevi) Replicate_wild_ignore_tablevii) Replicate_rewrite_dbMulti-source replication Filter 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 …