Well, I successfully setup replication for one server/slave. Now I'm
trying to do the same for another set.
I've tried both the tar method and load data from master and can't
seem to get either to work.
Nothing replicates to the slave.
I'm running Mysql 5.022.
===================
My error log is showing this - note the error reading packet from server.
060723 21:01:01 InnoDB: Started; log sequence number 0 44044
060723 21:01:01 [Note] Slave SQL thread initialized, starting
replication in log 'FMSweb-bin.000004' at position 349828, relay log
'.\FMSbuilding-relay-bin.000006' position: 236
060723 21:01:01 [Note] Slave I/O thread: connected to master
'[EMAIL PROTECTED]:3306', replication started in log
'FMSweb-bin.000004' at position 349828
060723 21:01:01 [Note] C:\Program Files\MySQL\MySQL Server
5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.21-community-nt-log' socket: '' port: 3306 MySQL
Community Edition (GPL)
060723 21:01:11 [ERROR] Error reading packet from server: Lost
connection to MySQL server during query ( server_errno=2013)
060723 21:01:11 [Note] Slave I/O thread killed while reading event
060723 21:01:11 [Note] Slave I/O thread exiting, read up to log
'FMSweb-bin.000004', position 349828
060723 21:01:11 [Note] Error reading relay log event: slave SQL
thread was killed
060723 21:01:41 [Note] Slave SQL thread initialized, starting
replication in log 'FMSweb-bin.000004' at position 98, relay log
'.\FMSbuilding-relay-bin.000001' position: 4
060723 21:01:41 [Note] Slave I/O thread: connected to master
'[EMAIL PROTECTED]:3306', replication started in log
'FMSweb-bin.000004' at position 98
================
After taring my Master Status was this:
mysql> SHOW MASTER STATUS;
+-------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+-------------------+----------+--------------+------------------+
| FMSweb-bin.000004 | 98 | | |
+-------------------+----------+--------------+------------------+
1 row in set (0.00 sec)
Upon doing a Start Slave I had his for Slave Status
show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 206.103.218.36
Master_User: FMSReplicate
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: FMSweb-bin.000004
Read_Master_Log_Pos: 349828
Relay_Log_File: FMSbuilding-relay-bin.000002
Relay_Log_Pos: 349966
Relay_Master_Log_File: FMSweb-bin.000004
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB: FMS
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 349828
Relay_Log_Space: 349966
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
1 row in set (0.00 sec)
My Master Status is
mysql> show master status\g
+-------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+-------------------+----------+--------------+------------------+
| FMSweb-bin.000004 | 349828 | | |
+-------------------+----------+--------------+------------------+
1 row in set (0.00 sec)
=======================================================================
My Master Config is
server-id=1
My Salve Config is
server-id=2
replicate-do-db=FMS
master-host=xxx.xxx.xxx.xxx
master-user=FMSReplicate
master-password=password
relay-log=FMSbuilding-relay-bin
log-bin=FMSbuilding-bin
I did:
CHANGE MASTER TO
-> MASTER_HOST='xxx.xxx.xxx.xxx',
-> MASTER_USER='TenenzReplicate',
-> MASTER_PASSWORD='password',
-> MASTER_LOG_FILE='FMSweb-bin.000004',
-> MASTER_LOG_POS=98;
any ideas? how do I get it to replicate properly?
Thanks!
--
--------------------------------------------------------------------------------
/Brett C. Harvey;
/Creative-Pages.Net, President;
/Facility Management Systems, CTO (www.fmsystems.biz);
/Lasso Partner Association Member ID #LPA135259
(www.omnipilot.com/www.lassopartner.com);
--------------------------------------------------------------------------------
