Tag: MySQL

Enhancing Performance with Parallel Index Rebuild in MySQL 8.0.31

Enhancing Performance with Parallel Index Rebuild in MySQL 8.0.31

How to Troubleshoot a MySQL Replica IO Thread that is Stuck in a Connecting State

How to Troubleshoot a MySQL Replica IO Thread that is Stuck in a Connecting State

PostgreSQL 16 brings Load Balancing Support in libpq (psql)

Get ready for PostgreSQL 16's release and learn about the new Connection Load Balancing Support feature in libpq. Discover how it can help scale out read queries and improve PostgreSQL's performance.

Mastering MySQL Group Replication Primary Promotion Techniques

Table of contents: IntroductionCommon reasons for switching the primary nodePrimary Promotion and its importanceMethods for switching the primary nodeSetting up a three-node MySQL group replication cluster for demonstrationAuto-switch method and its implementationAuto-switch by weight of the node method and its implementationManual Primary Promotion method and its implementationConclusion Introduction MySQL's group replication is a powerful feature … Continue reading Mastering MySQL Group Replication Primary Promotion Techniques →

Advertisement

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

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 ? →

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 →

Stream MySQL data with mydumper

Mydumper supports streaming of backups right from version 0.11.3 and the latest version Mydumper 0.12.3 it enabled its support for compressed streaming backup. This was the most awaited feature added to Mydumper, making it a more powerful tool for data migration to RDS or Cloud. If you are hearing mydumper for the first time, then … Continue reading Stream MySQL data with mydumper →