mysql
ann kok
oiyankok at yahoo.ca
Sat Dec 6 17:52:12 UTC 2008
Hi
Thank you so much
Now the warning has gone after adding two lines
I check the master with "show master status"
the file column record is changed from mysqld-bin.000002 to mysqld-bin.000001
The slave should have to make change
"change master to master_host = "192.168.0.2", master_user="user", master_password="password", master_log_file="mysqld-bin.000001", master_log_pos=98;"
Can you tell me why?
Do I need to change everytime in slave when I start and stop mysql in master?
Thank you
--- On Sat, 12/6/08, Gordon Messmer <yinyang at eburg.com> wrote:
> From: Gordon Messmer <yinyang at eburg.com>
> Subject: Re: mysql
> To: oiyankok at yahoo.ca, "Community assistance, encouragement, and advice for using Fedora." <fedora-list at redhat.com>
> Received: Saturday, December 6, 2008, 10:53 AM
> ann kok wrote:
> > I configure the mysql replication but got this warning
> > How can I fix this problem?
> ...
> > [Warning] No argument was provided to --log-bin, and
> --log-bin-index was not used; so replication may break when
> this MySQL server acts as a master and has his hostname
> changed!! Please use
> '--log-bin=/var/run/mysqld/mysqld-bin' to avoid this
> problem.
>
> Edit /etc/my.cnf and put a couple of lines in the [mysqld]
> section like:
>
> log-bin = mysqld-bin
> relay-log = mysqld-relay-bin
__________________________________________________________________
Instant Messaging, free SMS, sharing photos and more... Try the new Yahoo! Canada Messenger at http://ca.beta.messenger.yahoo.com/
More information about the fedora-list
mailing list