Hi, I tried to create replication. I have edited my.cnf on master and slave side.
Grant necessary privileges on master side, then start both servers, when I update the database in master side, I could see the query showed up in ***-bin.001, and it is passed to slave side successfully, shown in ***-bin.001, but database doesn't reflect the change. I have checked status, "slave running" is on, check slave status, slave_IO_Running and Slave_SQL_Running both are 'yes', What could be possibly wrong or what shall I do to make the database updating? Appreciated any help. Liying