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
Author: Affifa Shaik
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 ?
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