Mysql SQL master - slave

Discussion in 'Server Operation' started by vuit, Jul 8, 2009.

  1. vuit

    vuit New Member

    Hi all

    Please help me fix error in mysql master

    I config server 1 to Master server .


    [mysqld]
    server-id = 2
    [-----------]
    log-bin = /var/lib/mysql/mysql-master-bin.log
    binlog-do-db = sinhvien
    binlog-ignore-db = mysql
    relay-log=GTWebFMaster-relay-bin
    [-----------]

    I use command
    show master status;

    ERROR 2006 (HY000): MySQL server has gone away
    No connection. Trying to reconnect...
    Connection id: 4166476
    Current database: *** NONE ***


    | File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
    +-------------------------+-----------+-------------------------+------------------+
    | mysql-master-bin.001262 | 525103035 | sinhvien,sinhvien | mysql,mysql |


    and error duplicate table
     
  2. falko

    falko Super Moderator ISPConfig Developer

    Is the master configured to allow remote connections?
    What's the output of netstat -tap on the master? What's in my.cnf on the master and the slave?
    Which tutorial (URL) did you use?
     

Share This Page