Hello All,
I set up replication between 2 servers recently. I just need one db to be
replicated and the SHOW SLAVE STATUS shows this:
Relay_Master_Log_File: gyana01-bin.02
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB: tallydb,tallydb
Now the problem is that there is
Hello All,
I need to add a couple of more tables to the list of tables to be replicated
from a particular db in the salve my.cnf.
Can this be done without restarting the mysql server on the slave?
Thanks regards,
Ratheesh
Hello all,
I cannot afford to stop my slave server. I have list of tables of the master
that are being replicated on the slave.
Now I want to remove a couple of tables from this list without affecting the
master and slave. How is this possible?
Thanks regards,
Ratheesh
Running this statement on the master should do it:
DROP TABLE table1, table2...;
That will remove the tables.
Baron
Ratheesh K J wrote:
Hello all,
I cannot afford to stop my slave server. I have list of tables of the master
that are being replicated on the slave.
Now I want to remove a
PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, October 02, 2007 4:16 PM
Subject: Re: [Replication] - urgent
Ratheesh K J schrieb:
Hello all,
I issued a create table statement on the master for a table which was not
present on the master but present on the slave.
I did this purposely to see
Ratheesh K J schrieb:
Thanks,
It helped me a lot. I wanted to know
1. what are the various scenarios where my replication setup can
fail? (considering even issues like network failure and server
reboot etc). What is the normal procedure to correct the failure
when
Hello all,
I issued a create table statement on the master for a table which was not
present on the master but present on the slave.
I did this purposely to see the error on slave.
I am a newbie to replication. Now when i see SLave status on the slave machine
it shows that the SQL Thread has
Ratheesh K J schrieb:
Hello all,
I issued a create table statement on the master for a table which was not
present on the master but present on the slave.
I did this purposely to see the error on slave.
I am a newbie to replication. Now when i see SLave status on the slave machine
it shows