MySQL Replication Events – Statement versus Row-Based Formats

In a recent post, I briefly touched upon mysql replication events. It is important to know the advantages and disadvantages of each type. There are two types of replication event: Statement based – these are the write operations. They written to the binary log as SQL statements. Row based – these are the row changes and they are written to […]

MySQL Replication Use Cases

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 […]

What is MySQL Replication and How Does It Work?

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 without affecting […]

10 Database Performance Monitoring Tools You Can Get For Free

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 […]

When are Innodb Table Statistics Updated?

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 […]