MySQL Replication

Discussion in 'Server Operation' started by dclardy, Jan 10, 2011.

  1. dclardy

    dclardy Member

    All,

    I have followed the tutorial to setup replication, but it is not working properly. I am getting an error.

    error connecting to master '[email protected]:3306'

    Any ideas? I have been trying to get this working all day.
     
  2. Torsson

    Torsson New Member

    Just a long shot..

    Check that you dont have bind-address to localhost in your mysql config (my.conf)

    if your bind-address is like this
    bind-address = 127.0.0.1
    then try with changing it to
    #bind-address = 127.0.0.1

    and se if that helps.
     
  3. BorderAmigos

    BorderAmigos New Member

    Hmm... Make sure the port isn't blocked by a firewall at either master or slave?

    Master /etc/mysql/my.conf relevant part...
    Code:
    log-bin = /var/log/mysql/mysql-bin.log
    server-id = 1
    binlog-do = db1
    binlog-do = db2
    binlog-do = ...
    
    Slave /etc/mysql/my.conf relevant part...
    Code:
    #### For Database Replication
    ### from http://www.howtoforge.com mysql_database_replication_p2
    server-id=2
    master-host=nnn.nnn.nnn.nnn
    master-user=slave_user_name
    master-password=xxx
    master-connect-retry=60
    relay-log=mysqld-relay-bin
    replicate-do-db = db1
    replicate-do-db = db2
    replicate-do-db = ...
    
     
    Last edited: Jan 14, 2011
  4. BorderAmigos

    BorderAmigos New Member

    ^^^^ Is venritz a bot of some sort? Seems to have several posts that are just cut and pastes from wikipedia or similar and don't really say anything.
     

Share This Page