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…
-
How to backup MySQL Master or Slave by making it Read only?
Why Consumer SSD Reviews are Useless for Database Performance Use Case
Controlling Replication Failover for MySQL and MariaDB with Pre- or Post-Failover Scripts
6 Common Failure Scenarios for MySQL & MariaDB, and How to Fix Them
Troubleshooting PostgreSQL Streaming Replication Synchronization (Good stuff here.)
PostgreSQL LISTEN/NOTIFY
Setting Up MySQL Encrypted Replication On MySQL 5.7 With GTID
Which Character Set Should You Use in MySQL?
InnoDB physical files on MySQL 8.0