tag:blogger.com,1999:blog-8745038623152910760.post6079169583081381124..comments2024-02-03T02:16:02.991-08:00Comments on Mysql Research: Master Slave, Master Master ReplicationMukesh Vishwakarmahttp://www.blogger.com/profile/01285461490636331493noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-8745038623152910760.post-12333662619753946402019-10-16T04:24:54.852-07:002019-10-16T04:24:54.852-07:00quotes about anniversary wishes about uncle and au...quotes about anniversary wishes about uncle and aunt<br /><a href="https://www.quotewishes.online/2019/05/wedding-anniversary-wishes-uncle-aunt.html" rel="nofollow">happy anniversary uncle and aunty</a><br />Jatin Sethihttps://www.blogger.com/profile/10809681545644007453noreply@blogger.comtag:blogger.com,1999:blog-8745038623152910760.post-83274803755081675372019-05-14T22:04:45.021-07:002019-05-14T22:04:45.021-07:00This comment has been removed by the author.Seema Singhhttps://www.blogger.com/profile/10184851643173684206noreply@blogger.comtag:blogger.com,1999:blog-8745038623152910760.post-47487682523833146332013-06-21T08:20:30.720-07:002013-06-21T08:20:30.720-07:00This article is quite simplified and there are mis...This article is quite simplified and there are missing details. If you really want to help people in trouble, take the time to include all the details.<br /><br />Regards,<br />Anthonylferhttps://www.blogger.com/profile/00618392085702183279noreply@blogger.comtag:blogger.com,1999:blog-8745038623152910760.post-87655149335445847542013-06-21T02:14:17.040-07:002013-06-21T02:14:17.040-07:00Replication is failing.Could you please help me.
...Replication is failing.Could you please help me.<br /><br />I have followed the below steps:<br /><br />1.I have taken 2 windows server 2008 r2 machines and joined into domain(consider master as C1 and slave as C2)<br />2.Installed the "mysql-installer-community-5.6.12.0" in both the servers<br />3.In Master(C1) machine:<br />1.go to(C:\Programfiles\MYsqL\mYsql server 5.6) and edited my_default file<br /><br />added the below lines into the file<br />server-id = 1<br />log_bin = /var/log/mysql/mysql-bin.log<br />expire_logs_days = 10<br />max_binlog_size = 100M<br />binlog_do_db = exampledb<br />(I have restarted the machine)<br />4.Open the command prompt in master(C1) and navigate to mysql bin path and connected to the mysql with the credentials<br />5.create a user using the below command<br /><br />create user 'username'@'slave machine ipaddress' identified by 'user password';<br /><br />6.Grent permissions to the user using the below command<br /><br />GRANT REPLICATION SLAVE ON *.* TO 'username'@'slave ipaddress' IDENTIFIED BY 'user password';<br />7.typed the command 'Show master status;'<br /><br />it has shown as "empty set(0.00 sec)"<br /><br />7.Go to slave machine and edited my_default file<br /><br />added the below lines into the file<br />erver-id=2<br />master-connect-retry=60<br />replicate-do-db=exampledb<br />(I have restarted the machine)<br />8.Open the cmd in slave,navigate to mysql bin path and connected to the mysql with the credentials, typed the below command:<br /><br />CHANGE MASTER TO <br />MASTER_HOST='10.0.0.18', <br />MASTER_USER='k', <br />MASTER_PASSWORD='slave', <br />MASTER_LOG_FILE='mysql-bin.000001', <br />MASTER_LOG_POS=3344;KALYAN CHERUKURIhttps://www.blogger.com/profile/16350077111237507064noreply@blogger.com