One of the most commonly misunderstood configurations in MySQL is related to parallel replication threads in MySQL, and more importantly how do I monitor my replica to ensure its configured effectively. Background on parallel replication Traditionally, MySQL replication was single threaded where changes applied on a writer database are fetched by a replica and applied serially on a replica using a…
Earlier today lefred tweeted that the new MySQL releases were rolling out today! As per the usual release process, the yum repositories typically have the release rpms available first, followed by github (release tags here ) and then the release notes . Hey hey! It's that time again! #MySQL 🐬 9️⃣ .1️⃣ being released! Stay tuned for release notes tomorrow at 9.00AM PDT pic.twitter.com/rIvZrDtP7z —…
Troubleshooting a database crash or regression can be a tedious task. Whether you have recently deployed new application changes, upgraded your database or "nothing has changed" ™ it can be tricky to corner why the database started behaving differently to how it has before. In the case of a database crash or regression post upgrade, my usual first step in troubleshooting will be to take a look at…