Problem with the mysql.sock in one replica!

Discussion in 'Server Operation' started by gral, Aug 15, 2007.

  1. gral

    gral Member

    Hello everybody, i have a replicaion server with four replics working on it, in one of them, im receiving the error:

    "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql-xxxreplic4/mysql.sock' (2)"

    All replicas work fine until the afternoon, when a local mysqlserver was installed.


    The error in the not working replic is:

    I was reading what this error could be the same server_id in the my.cnf, but in my my.cnf all the replics have the same number and are working ok, and i try use it with the all choice posible.

    Other tip is: the replic what is working bad, is taking the same port what was config in the local mysqlserver in the my.cnf

    Any suggestion will be very apprecited.

    Guille.
     
  2. falko

    falko Super Moderator Howtoforge Staff

    Is the new slave allowed to connect to the master? Can you try to connect manually, e.g. like this:
    Code:
    mysql -h [I]<master_ip>[/I] -u [I]<slave_user>[/I] -p
     

Share This Page