Weekly Reading

Enjoy the weekend with these great open-source SQL blog posts from around the web… At times, a few may be a bit dated, but worth the read, while others are relatively current… Share them along…

• Migrate MySQL data to RDS/Aurora Using Xtrabackup
• Slow MySQL Start Time in GTID mode? Binary Log File Size May Be The Issue
• Nondeterministic Functions in MySQL (i.e. rand) Can Surprise You
• MySQL 8 and The FRM Drop… How To Recover Table DDL
• MySQL on Docker: Multiple Delayed Replication Slaves for Disaster Recovery with Low RTO
• What May Cause MySQL ERROR 1213
• PostgreSQL Bloat: origins, monitoring and managing
• How to Upgrade PostgreSQL10 to PostgreSQL11 with Zero Downtime
• MySQL on Docker: Multiple Delayed Replication Slaves for Disaster Recovery with Low RTO
• SETTING UP A FAST, COMPREHENSIVE SEARCH ROUTINE WITH POSTGRESQL
• How to Take Advantage of the New Partitioning Features in PostgreSQL 11
• Using PostgreSQL Logical Replication to Maintain an Always Up-to-Date Read/Write TEST Server
• Some Notes on MariaDB system-versioned Tables
• You Can Do It in SQL, Stop Writing Extra Code for That
• MySQL ORDER BY / LIMIT performance: late row lookups (Dated a bit yet, still a good read.)