It only update WITCD. I finish the switching, query still doesn't update in slave.
Liying ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "Liying Huang" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, February 12, 2004 11:00 AM Subject: Re: Re; Re: question for replication Was the update peformed in either the WITCD or WITTD database? >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2/12/04, 9:52:57 AM, Liying Huang <[EMAIL PROTECTED]> wrote regarding Re; Re: question for replication: > Show slave status: > *************************** 1. row *************************** > Master_Host: lhuang > Master_User: test > Master_Port: 3306 > Connect_retry: 60 > Master_Log_File: lhuang-bin.001 > Read_Master_Log_Pos: 79 > Relay_Log_File: liyingtop-relay-bin.001 > Relay_Log_Pos: 120 > Relay_Master_Log_File: lhuang-bin.001 > Slave_IO_Running: Yes > Slave_SQL_Running: Yes > Replicate_do_db: WITCD,WITTD > Replicate_ignore_db: mysql > Last_errno: 0 > Last_error: > Skip_counter: 0 > Exec_master_log_pos: 79 > Relay_log_space: 116 > 1 row in set (0.00 sec) > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: "Liying Huang" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]>Sent: Thursday, February 12, 2004 10:28 AM > Subject: Re: question for replication > What is the output from show slave status? > >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< > On 2/12/04, 8:43:44 AM, Liying Huang <[EMAIL PROTECTED]> wrote > regarding question for replication: > > Hi, > > I tried to do replication from master-> slave, I used windows, > > MySql 4.0.17 version on both. I have set bin-log option > > in my.cfg in master computer, set master-host, master-user, > master-password, > > replicate-do-db and replicate-ignore-db=mysql, skip-slave-start in > > my.cfg in slave. I have zipped the database from master, copy the zip to > > slave and unzip it, then I start both server, start slave. When I do some > > update in master computer in database, the query showed in master-bin.001 > > and it is shown in slave-relay-bin.001 too (slave IO thread seems > working), > > but database in slave doesn't update. What have I done wrong? The > database > > is > > not small, it will take forever if I use 'load data from master', so I > > copy the database instead. The outcome from "Show processlist\G" > > is attached below too. It seems slave SQL thread is running without > problem. > > Liying > > > *************************** 1. row *************************** > > > Id: 1 > > > User: test > > > Host: localhost:1110 > > > db: NULL > > > Command: Query > > > Time: 0 > > > State: NULL > > > Info: show processlist > > > *************************** 2. row *************************** > > > Id: 2 > > > User: system user > > > Host: > > > db: NULL > > > Command: Connect > > > Time: 7 > > > State: Waiting for master to send event > > > Info: NULL > > > *************************** 3. row *************************** > > > Id: 3 > > > User: system user > > > Host: > > > db: NULL > > > Command: Connect > > > Time: 7 > > > State: Has read all relay log; waiting for the I/O slave thread to > > update > > > it > > > Info: NULL > > > 3 rows in set (0.02 sec) > > > > > > After I do some update in master, show processlist\G gives me: > > > > > > *************************** 1. row *************************** > > > Id: 1 > > > User: test > > > Host: localhost:1110 > > > db: NULL > > > Command: Query > > > Time: 0 > > > State: NULL > > > Info: show processlist > > > *************************** 2. row *************************** > > > Id: 2 > > > User: system user > > > Host: > > > db: NULL > > > Command: Connect > > > Time: 323 > > > State: Waiting for master to send event > > > Info: NULL > > > *************************** 3. row *************************** > > > Id: 3 > > > User: system user > > > Host: > > > db: NULL > > > Command: Connect > > > Time: 7 > > > State: Has read all relay log; waiting for the I/O slave thread to > > update > > > it > > > Info: NULL > > > > > > The time for id 2 and 3 are very differnet. > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]