Sometimes, there is a requirement to make a backup of a table in MySQL. For instance, there could be a data update planned, schema change needed or that it is necessary to work with a copy of a table, perhaps for some report. A possible approach to this is to run a full backup of the database to call upon if something goes wrong. This is feasible but sometimes not practical. … [Read more...] about How to Take a Backup of a Table in MySQL
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 are running linux, then this is an easy one liner. On my test machine, my … [Read more...] about How to Determine Which Port MySQL is Running On
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 the binary log as … [Read more...] about MySQL Replication Events – Statement versus Row-Based Formats
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?