A simple demonstration of creating a fault resistant database replication between institutes.

Infrastructure setup: 'master' database at CERN in inspire.cern.ch, replicating databases in other sites, including tislnx1.slac.stanford.edu

At master: my.cnf, in section [mysqld]

language        = /usr/share/mysql/english
skip-external-locking
log-bin
binlog-do-db=invenio  # input the database which should be replicated
binlog-ignore-db=mysql            # input the database that should be ignored for replication
binlog-ignore-db=test
server-id=1

At master, start mysql with root access (mysql -u root) and enter:

 grant replication slave on *.* to 'replicator' identified by 'password';

.....

-- MarkoNiinimaki - 07 Mar 2008