High performance MySQL, live.

Aug 08, 2005

We need to upgrade our dying MySQL server. It serves more than 30 databases, some of them having multi-million-row tables, for more than 10 different projects, one of them being jamendo.

With the cool book, I just began configuring from scratch our new MySQL server, with replication and all the good stuff.

So here we go. A little emerge-webrsync to sync both servers (master is" vador", slave is "yoda" : not logical but well...).... This is sooo long, I remember early gentoo days, it only took like 2 minutes back then :/ mysql-4.0.24 is the gentoo HEAD, we'll stick to that. USE flags for mysql : "readline innodb tcpd ssl perl".

Next step is creating the replication user on both master and slave :

mysql> FLUSH PRIVILEGES;
mysql> GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO [email protected]"192.168.0.0/255.255.255.0" IDENTIFIED BY "xxxxxxx";
mysql> FLUSH PRIVILEGES;

Here are my edits of the configuration for the master :

log-bin
server-id = 193 #use IP
log-bin = /home/mysql/repl/log-bin

For the slave :

server-id = 196
read-only #only accept queries from replication
master-host = 192.168.0.193
master-user = repl
master-password = xxxxxxxxxxx
master-port=3306

A few restarts later replication is working.

Oops, while reading the book I just stumbled upon the sentence "There
is currently no workaround to this problem. Make sure the power cables
are plugged in tightly !"... Quite frightening, uh ?