MySql Replication

Discussion in 'MySQL' started by protocol96, Mar 30, 2007.

0
  1. #1
    my.cnf file on server 2
    server-id = 2
    log-bin = mysql-bin
    log-slave-updates
    replicate-same-server-id = 0
    auto_increment_increment = 1
    auto_increment_offset = 2
    master-host = 192.168.1.40
    master-user =mysql
    my.cnf file on server 1
    server-id = 1
    log-bin = mysql-bin
    log-slave-updates
    replicate-same-server-id = 0
    auto_increment_increment = 1
    auto_increment_offset = 1
    master-host = 192.168.1.34
    master-user = mysql

    I am trying to have a circular replication and using this url, but it aint just happening.
    http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html?page=2

    PS:i had not set any user or pswd for the database
     
    protocol96, Mar 30, 2007 IP