Michael M. schrieb:
I'm attempting to take a brand new mysql server build on gentoo and set up
replication.
I'm using
GRANT REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO
'repl'@"192.168.1.0/255.255.255.0" IDENTIFIED BY 'secret';
I'm not sure if this is correct syntax.
Use the specific IP address instead and execute
"show grants for repl@"ip"
Do this for both machines in your multimaster setup (replace the ip of
course)
Now, what I'll eventually be setting up is a master-master replication
(basically only for failover using keepalived), so if anyone has any
experience with that, I'd be much appreciated.
I set up such a system and wrote a little howto on that in the LVS
documentation:
http://www.austintek.com/LVS/LVS-HOWTO/HOWTO/LVS-HOWTO.failover.html#ha_mysql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
