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

Edit | Attach | Watch | Print version | History: r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r1 - 2008-03-07 - MarkoNiinimaki
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    Inspire All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2023 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback