Do I jsut need to monitor better and manually add it should the log
and pos change?
-Bryan
On Wed, Mar 11, 2009 at 7:05 PM, Baron Schwartz ba...@xaprb.com wrote:
That's deprecated too :-)
On Wed, Mar 11, 2009 at 9:17 PM, Cui Shijun rancp...@gmail.com wrote:
hi,
#2. try adding the
When you start up replication the data should be recorded in the
master.info in your data dir.
[r...@someserver ~]# cat /var/lib/mysqldata/master.info
14
MASTERHOST-bin.01
MASTERPOS
192.168.0.2
REPLICATION_USER
REPLICATION_PASSWORD
3306
60
0
I am not familiar with any setups where the
The information is there and the replica can connect on a reboot but
only if that information has not changed correct?
e.g. I reboot the slave, and on the master just run reset master;
the bin.01 could change to bin.02 and the pos change from 98
to 15443 or some such. If I do that do I
:S
Hi Bryan
Actually changing the slave setup after a reboot is a very bad
idea, you will have inconsistent data on your slave because every
transaction made from when you rebooted the server to when you reset
the position will not be copied from the master. Thats the point of
the
BTW there is a list specially dedicated to replication configurations:
http://lists.mysql.com/replication
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
If you are finding replication stops after a reboot then I think you have a
serious problem, but don't know what that might be. Post some more info and
someone on the list can probably help,
just a 'skip-slave-start' in my.cnf does the trick.
2 Is there a way to get a slave to
I've got 2 questions about my newly set up master-slave replica.
1 When I run load data from master; I get an error that I do not
have RELOAD privileges and then it boots the slave offline.
I've run GRANT SELECT, PROCESS, FILE, SUPER, REPLICATION CLIENT,
REPLICATION SLAVE, RELOAD ON *.* TO
On Wed, Mar 11, 2009 at 4:03 PM, Bryan Irvine sparcta...@gmail.com wrote:
I've got 2 questions about my newly set up master-slave replica.
1 When I run load data from master; I get an error that I do not
have RELOAD privileges and then it boots the slave offline.
I've run GRANT SELECT,
hi,
#2. try adding the information of master into my.cnf then restart the server.
thanks
2009/3/12 Bryan Irvine sparcta...@gmail.com:
I've got 2 questions about my newly set up master-slave replica.
1 When I run load data from master; I get an error that I do not
have RELOAD privileges
That's deprecated too :-)
On Wed, Mar 11, 2009 at 9:17 PM, Cui Shijun rancp...@gmail.com wrote:
hi,
#2. try adding the information of master into my.cnf then restart the
server.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
10 matches
Mail list logo