MySql

taaz
taaz used Ask the Experts™
on
I ran the replication and it was running good.
Now I am having problem
On the Slave I am getting either

slave_io_running: No
Slave_SQL_running: Yes

or
slave_io_running: Yes
Slave_SQL_running:No

what could be the proble I am following the exact same steps that gave me the replication
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
execute follow command in your slave:

Mysql> Slave Status;

you would get rough idea from there

Author

Commented:
Slave status is incorrect command but I ran  show slave status\G;


the thing is
on the slave
stop slave;
Change Master to
 MASTER_HOST='Master IP') ,
 MASTER_PORT=3306,
 MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=106,
MASTER_USER='repl_slave',
MASTER_PASSWORD='ABCDEF';

start slave;

show databases;
use database;
select * from table;
it does not show the insert that I made to the table in Master

Author

Commented:
Change Master to
 MASTER_HOST='Master IP',
 MASTER_PORT=3306,
 MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=106,
MASTER_USER='repl_slave',
MASTER_PASSWORD='ABCDEF';

start slave;

show databases;
use database;
select * from table;
it does not show the insert that I made to the table in Master

Author

Commented:
First time i was able to see the database and table on the slave that i only created on the master.
but when i made an other insert into the table on the master it did not showed up in the same table on the slave

Commented:
Sorry , it is
Mysql > show slave status;

Any error showing when you execute the Show Slave Status ??


Your change MASTER setting looks good.
first of all, of course i would advice to check if the physical tables are tally between the master and the slave,
secondly check if the Network is enabled between the MySQL server
Third, both MySQL server are the same version ( to avoid the server have different features supported )


Commented:
and check your my.cnf, see if you had excluded the table from your replication?

Author

Commented:
the harwares and the os and the Mysql version are same.

As I mentioned earlier I was able to see the database on the slave created on the master.
but when I insert another row i to the tabel and
did the
FLUSH LOGS;
show master status\G;

and then on the slave
stop slave;

Change Master to
 MASTER_HOST='Master IP',
 MASTER_PORT=3306,
 MASTER_LOG_FILE='mysql-bin.000002',
MASTER_LOG_POS=106,
MASTER_USER='repl_slave',
MASTER_PASSWORD='ABCDEF';

start slave;

then I query the databses and table and found the tbale is not showng the insert .

Commented:
so, you mean your table creation query is replicated into the slave, but not the insert right ?
can have your copy of your master's my.cnf ??

let me run some test before proceed with your answer

Author

Commented:
thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial