>
>
> 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 auto
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
: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 posi
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
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 master.
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 wrote:
> That's deprecated too :-)
>
> On Wed, Mar 11, 2009 at 9:17 PM, Cui Shijun wrote:
>> hi,
>> #2. try adding the information of master into my.cnf t
That's deprecated too :-)
On Wed, Mar 11, 2009 at 9:17 PM, Cui Shijun 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:http://lists.mysql.com/mysql?un
hi,
#2. try adding the information of master into my.cnf then restart the server.
thanks
2009/3/12 Bryan Irvine :
> 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 b
On Wed, Mar 11, 2009 at 4:03 PM, Bryan Irvine 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, PROCESS, FILE, S
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 roo
10 matches
Mail list logo
