In my last post, I summarized when MySQL replication is typically implemented. I now want to expand on that and talk about MySQL replication use cases. Scaling out using MySQL Replication Let's take a typical example, the application is read-heavy versus writes. The server is under heavy read load and you want to reduce that. You have optimized indexes etc all you can but the … [Read more...] about MySQL Replication Use Cases
MySQL replication, a.k.a MySQL database replication provides the facility to make replicas of databases. The ability to make exact copies of databases and keep them in real-time sync as changes are made at the "master" provides a number of advantages. In summary these are: Scaling out a database application Reducing database backup impact Facilitate reporting … [Read more...] about What is MySQL Replication and How Does It Work?
Database performance monitoring is something every DBA worth their salt should be doing on a regular basis. It should be adopted as a proactive task to help identify issues early on before they become too serious and be part of a post code deployment monitoring process. Bundled in with linux based operating systems are a heap of great tools that you can use as a DBA to … [Read more...] about 10 Database Performance Monitoring Tools You Can Get For Free
Innodb statistics are used by the query optimizer to assist it in choosing an efficient query execution plan. They are estimated values relating to each Innodb table and index. But what updates them? Let's take a look. Operations that update Innodb table statistics Typically this happens during metadata statements such as SHOW INDEX or SHOW TABLE STATUS. It also occurs … [Read more...] about When are Innodb Table Statistics Updated?
So here is a scenario, you have a number of poorly performing MySQL database queries which are consuming resources on your server. Users are complaining and you need to do something fast. Having viewed the output of SHOW FULL PROCESSLIST, you can see that they are coming from one user and have been running for a long time. You need a way to kill all MySQL processes … [Read more...] about How to Kill All MySQL Processes For a Specific User