multiple master replication with mysql 5

Discussion in 'HOWTO-Related Questions' started by tanoy999, Oct 25, 2008.

  1. tanoy999

    tanoy999 New Member

    I want howto multiple master replication with mysql 5 in centos / fedora,
    example have 3 master or 4 master .etc.. ..... Thank you



    from tanoy999 >>>>Thailand
     
  2. marchost

    marchost New Member HowtoForge Supporter

    Try circular replication....

    A--------------B
    |................|
    |................|
    D--------------C

    A slave of D
    B slave of A
    C slave of B
    D slave of C

    In /etc/mysql/my.cnf (mysql config file)

    [...]
    auto-increment-offset = 1
    [...]

    Has to be changed. A=1, B=2, C=3, D=4

    The rest should be pretty much the same as : http://howtoforge.com/mysql5_master_master_replication_debian_etch

    Marc
     
    Last edited: Oct 25, 2008

Share This Page