Timeline for How to setup replication(Master/slave) in MySQL 5.5.20?
Current License: CC BY-SA 3.0
10 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Oct 9, 2015 at 8:06 | comment | added | John Little | Where wouild we specify which particular schema should be replicated? Don't we need to dump it on the master, and import it into he slave, once the base configuration is done? | |
Oct 9, 2015 at 7:59 | comment | added | John Little | I tried your CreateMySQLSlave.sh on ubuntu 14, mysql 5.6, and it just hangs and I had to kill it unfortuatnely. I am assuming you run this script on the slave server, not the master. It is also unclear if you should run the script first, or do the steps that you list after the script first. | |
Feb 15, 2012 at 18:24 | vote | accept | vinny | ||
Feb 7, 2012 at 20:21 | comment | added | vinny | Thanks a lot for such an explanatory answer.But, the problem is, The data has already been transferred from DB1 to DB2. I only need a way to set up auto-replication from Master to Slave. Please tell me what changes to be done in "my.cnf" | |
Feb 6, 2012 at 19:40 | comment | added | vinny | CentOS 6 and MySQL5.5.20 | |
Feb 6, 2012 at 18:46 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 |
added 237 characters in body
|
Feb 6, 2012 at 18:43 | comment | added | RolandoMySQLDBA | I gave the lines for a script in my answer to create a slave on another machine running mysql. You need to create a file on the DB server with these lines, make the script executable (chmod +x) and run the script as given. By the way, what OS are you using, Windows or Linux ??? | |
Feb 6, 2012 at 18:40 | comment | added | vinny | What exactly do you mean by run this script?? Where should i run it? (sorry i am a very novice user) | |
Feb 6, 2012 at 18:38 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 |
added 290 characters in body
|
Feb 6, 2012 at 18:27 | history | answered | RolandoMySQLDBA | CC BY-SA 3.0 |