MySQL master master replication, also known as "mysql chained replication", "multi master replication or "mysql daisy chaining replication" is an extension of mysql replication allowing the creation of multiple master servers that can then be masters of multiple slaves. In this post, I demonstrate how to setup mysql master master replication. In a multi master mysql … [Read more...] about How to Setup MySQL Master Master Replication
MySQL Administration
How to set up MySQL Replication Tutorial
One may setup MySQL replication typically either to scale out, facilitate reporting or to provide backups of MySQL databases. I wrote a post about this before. The whole process relies on binary logs which are output to a location on the master server and read in by the slave. This post is a MySQL replication tutorial. I am going to setup MySQL replication involving two … [Read more...] about How to set up MySQL Replication Tutorial
How to Take a Backup of a Table in MySQL
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
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 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
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 the binary log as … [Read more...] about MySQL Replication Events – Statement versus Row-Based Formats