Hello List,
Has anyone seen any problems using LOAD DATA FROM MASTER on a second slave
using a secondary network interface?
I have:
mysql-master / {172.25.7.20 / eth0, 192.168.7.20 / eth1} / Red Hat EL V.4 /
MySQL 5.0.22
mysql-slave1 / 172.25.1.58 / Windows XP / MySQL 5.0.18
mysql-slave2 / 192.168.7.48 / Windows XP / MySQL 5.0.21
My grant was:
GRANT REPLICATION SLAVE,SELECT,SUPER,RELOAD ON *.* TO 'replication'@'%'
IDENTIFIED BY 'blah'
The first two existed harmoniously for many months. Today I wanted to add
the second slave. It refused to LOAD DATA FROM MASTER, exclaiming:
Error connecting to master: Access denied for user ...
I changed the network on mysql-slave2 to use the 172.25.x.x network, and it
was able to load the data from the master. I subsequently changed it back
to the 192.168.7.x network, and was able to start the slave, which is
happily consuming binary logs from the master.
My goal was to determine the feasibility of using a second NIC for
replication, which apparently I can, although apparently I cannot load data
from master. In production, this won't be a problem -- I am starting fresh
or I can copy the files noting the master log position(s).
Have I discovered a bug? Google and searching the lists.mysql.com don't
reveal this exact scenario...
Thank you for your time,
Tim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
