(Alexander Rubin) Working on a test case with sysbench, I encountered this:
Tag: Open Source
MySQL on Docker: Multiple Delayed Replication Slaves for Disaster Recovery with Low RTO
(Ashraf Sharif) Delayed replication allows a replication slave to deliberately lag behind the master by at least a specified amount of time.
MySQL 8 and the FRM drop.
(Marco Tusa) (What I should keep in mind in case of disaster)
MySQL 8: Drop Several Stored Events, Procedures, or Functions
(Jesper Krogh) Maybe the biggest new feature in MySQL 8 is the new transaction data dictionary that improves the consistency of schema objects among other things.
Database Backup Encryption – Best Practices
(Krzysztof Ksiazek) Offsite backup storage should be a critical part of any organisation’s disaster recovery plan. The ability to store data in a separate physical location, where it could survive a catastrophic event which destroys all the data in your primary data center, ensures your data surviva
MariaDB indexing of NULL values
(Shinguz) In the recent MariaDB DBA advanced training class the question came up if MariaDB can make use of an index when searching for NULL values.
Cloud Backup Options for MySQL & MariaDB Databases
(Bart Oles) The principal objective of backing up your data is, of course, the ability to roll back and access your archives in case of hardware failure.
What Happens If You Set innodb_open_files Higher Than open_files_limit?
(James Lawrie) The settings of MySQL configuration variables have a fundamental impact on the performance of your database system.
MySQL InnoDB Cluster with 2 Data Centers for Disaster Recovery: howto – part 2
(Frederic Descamps) In the first part of this howto, I illustrated how to setup two MySQL InnoDB Cluster linked by an asynchronous replication.
Compression options in MySQL (part 1)
(Yves Trudeau) Over the last year, I have been pursuing a part time hobby project exploring ways to squeeze as much data as possible in MySQL.