(James Lawrie) As per the documentation, pt-table-checksum is a tool to perform online replication consistency checks by executing checksum queries on the master, which produces different results on replicas that are inconsistent with the master.
Tag: Open Source
(Frederic Descamps) As you know, MySQL InnoDB Cluster is a High Availability solution for MySQL. However more and more people are trying to use it as a Disaster Recovery solution with 2 data centers.
(Krzysztof Ksiazek) We usually take care of things we value, whether it is an expensive smartphone or the company’s servers.
(Ankit Kumar) During our recent migration we migrated a part of a app to different region with new db.
(Frederic Descamps) Today I read the nice post of Bhuvanesh on the memory leak issue they experienced with MySQL. In fact when you read the post, you realize that MySQL was just following the parameters that were setup (the default of max_prepare_stmt_count is 16382 even on 5.6).
(Dave Stokes) I am currently working my way through the many PHP Frameworks to see how they get on with MySQL 8. The Frameworks that can take advantage of the MySQL Improved Extension or mysqli can take advantage of the SHA256 Caching Authentication method.
How Not to do MySQL High Availability: Geographic Node Distribution with Galera-Based Replication Misuse
(Marco Tusa) Let’s talk about MySQL high availability (HA) and synchronous replication once more.
(Frederic Descamps) Has you may already know, in MySQL it is possible to set an expiration period for passwords.
(Marco Tusa) In this article, we’ll look at an example of an on-premises, geographically distributed MySQL high availability solution.
(Paulo Jesus) MySQL Shell 8.0.13 (GA) introduced a new feature to allow you to easily import JSON documents to MySQL.