Revision History: Setting up Master/Slave Replication from an existing MySQL server

MySQL

Currently https://cryptfolio.com is running off a single MySQL server. I want to switch this to a master/slave setup, which I intend will:

1. increase performance (0.10% of queries are blocked by updates), but not too much since the database is very write-heavy (59% of queries)
2. increase visible performance greatly (often graphs are blocked by pending writes especially to summary_instances and balances tables)
3. improve reliability (if the slave goes down, I can point web servers to master; if the master goes down, I can enable read-only site mode)
4. cost more money to run (since I'll be running two nodes rather than one) but still much cheaper (and more interesting) than going through S3
5. databases suitable for memcachedb/keystores are not yet used that heavily

I'll be using the MySQL guide to set up replication and cover my steps here.

1. Setup master

16.1.1.1 Setting the Replication Master Configuration

1. Edit my.cnf and set:

[mysqld]
log-bin=mysql-bin            # enable binary logging
server-id=1                  # this ID cannot be used by any other server

# Restart server