View Single Post
  #1  
Old 9th September 2010, 09:02
jithinkcs jithinkcs is offline
Junior Member
 
Join Date: Sep 2010
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default My SQL Replication issue ?

Hi Guys,


I have two My SQL servers running on two different machines.

PC -1 ( Master)
****
Version :My SQL 5.1.30
IP : 192.168.0.97

PC -2 ( Slave)
****
Version : My SQL 5.1.30
IP : 192.168.0.37


I have two databases running on PC-1. After the successfull configuration of MySQL replication , i started the slave. And i found that the the database 1 is replicating fine . At the same time database 2 is not at all replicating . So in order to check out the database 2 replication issue , i just made some changes to database 2 in PC-1 (matster) and check for the changes in PC-2 ( Slave). Unfortunatly its not replicating , and i found that database-1 also failed the replication. Again i changed the configuration in my.ini in master and slave. But the Database1 is replicating and databse 2 failed in replication.

Please help me to solve the issue .. I attached my master my.ini,slave my.ini file and mysql log of slave.

I configured musql replication based on this link http://www.howtoforge.com/mysql_database_replication.
Attached Files
File Type: txt my.ini Master.txt (5.1 KB, 205 views)
File Type: txt my.ini Slave.txt (5.1 KB, 202 views)
File Type: txt Slave mysql log.txt (7.9 KB, 465 views)
Reply With Quote
Sponsored Links