I have two machines which I am trying to set up replication on. I followed
the howto as describe in the manual, and everything seemed to be okay (i.e.
no errors), but it simply doesn't work.
Heres what I did on the master:
1. Copied /usr/share/my-large.cnf to /etc/my.cnf
2. my.cnf already had log-bin, server-id=1, so I didnt touch anything else
3. Granted file to user repl as in howto
4. Shut down master
5. Tarred data dir, copied it to slave
6. Restarted master
Heres what I did on the slave:
1. Copied /usr/share/my-large.cnf to /etc/my.cnf
2. Added following info:
master-host = 172.34.123.34 # IP of master
master-user = repl
master-password = repl
master-port = 3306
server-id = 2
3. Untarred data directories to /var/lib/mysql
4. Verified permissions on directories/files untarred
5. Restarted slave
The my.cnf file appears to be read okay, because on both machines began
generating the binary log files immediately.
Both machines report everything normal and happy, with no entries in the
.err log files. Users can connect to each machine independently and its
business as usual.
There is no file 'master.info' generated on the slave (I even checked on the
master too)...
I was also unable to find anything similar in the archives...
Suggestions?
Thanks!
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
