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.)