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…
- MySQL 8.0: MVCC of Large Objects in InnoDB
- MySQL 8.0 InnoDB Cluster – Creating a sandbox and testing MySQL Shell, Router and Group Replication
- How to Recover Galera Cluster or MySQL Replication from Split Brain Syndrome
- Why is PostgreSQL Running Slow? Tips & Tricks to Get to the Source
- PostgreSQL Streaming Replication – a Deep Dive
- POSTGRESQL: DETECTING PERIODS OF ACTIVITY IN A TIMESERIES
- CREATE VIEW VS. ALTER TABLE IN POSTGRESQL
- Benchmarking InnoDB and MyRocks Performance using Sysbench
- TAP tests and external modules
- Multi Datacenter setups with PostgreSQL
- How to use PostgreSQL to streamline Python code (Really good read here)
- INPLACE upgrade from MySQL 5.7 to MySQL 8.0