(Dave Stokes) The Symfony Frame work is very popular with PHP developers and it has a very nice Demo Application to help novices learn the intricacies involved.
Tag: Open Source
Caveats With pt-table-checksum Using Row-Based Replication, and Replication Filters
(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.
MySQL InnoDB Cluster with 2 Data Centers for Disaster Recovery: howt
(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.
How to Encrypt Your MySQL & MariaDB Backups
(Krzysztof Ksiazek) We usually take care of things we value, whether it is an expensive smartphone or the company’s servers.
MySQL Multi Source Replication With GTID and Non-GTID Mode
(Ankit Kumar) During our recent migration we migrated a part of a app to different region with new db.
MySQL Memory Consumption and Open Prepare Statements
(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).
Updated: Doctrine and MySQL 8 – An Odd Connection Refused Error
(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.
MySQL: when will the password of my users expire ?
(Frederic Descamps) Has you may already know, in MySQL it is possible to set an expiration period for passwords.
MySQL High Availability On-Premises: A Geographically Distributed Scenario
(Marco Tusa) In this article, we’ll look at an example of an on-premises, geographically distributed MySQL high availability solution.