How to Determine Which Port MySQL is Running On

MySQL defaults to port 3306 when installed but sometimes for another reason, it may be listening on a different port. In this post, I list some ways in which you can find out which port your MySQL instance is running on. Using the MySQL configuration file to determine which port it is running on If you […]

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