mysql replication question(s)
Hi All, I'm having a few issues getting things up and running in regards to replication. I believe I have everything setup correctly the slave is roughly in the same spot as the master as far as the logs are concerned. However, when I make changes in the master db I don't see them show up in the slave db? show master status: 'mhqedi02-bin.012','622609','','' show slave status: 'mhqedi02','replicant','7003','60','mhqedi02-bin.012','630264','royedi01-relay-bin.001','630874','mhqedi02-bin.007','Yes','Yes','','','0','','0','629259','630874' show process list (slave): '3','system user','none','','Connect','20139','Reading master update','' '4','system user','none','','Connect','20139','Slave: waiting for binlog update','' my main concern is that the time on the process list is so long. Am I missing anything? I noticed there is a show hosts command to run on the master. When I run this I get an empty set back. Is this needed? Thanks for your help, Mario __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql replication question(s)
Hi All, I'm having a few issues getting things up and running in regards to replication. I believe I have everything setup correctly the slave is roughly in the same spot as the master as far as the logs are concerned. However, when I make changes in the master db I don't see them show up in the slave db? show master status: 'mhqedi02-bin.012','622609','','' show slave status: 'mhqedi02','replicant','7003','60','mhqedi02-bin.012','630264','royedi01-relay-bin.001','630874','mhqedi02-bin.007','Yes','Yes','','','0','','0','629259','630874' show process list (slave): '3','system user','none','','Connect','20139','Reading master update','' '4','system user','none','','Connect','20139','Slave: waiting for binlog update','' my main concern is that the time on the process list is so long. Am I missing anything? I noticed there is a show hosts command to run on the master. When I run this I get an empty set back. Is this needed? Thanks for your help, Mario __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
