mysql

[ann kok]

Hi 
 
I configure the mysql replication but got this warning
How can I fix this problem?
 
Thank you
 
 [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.

__________________________________________________________________
Yahoo! Canada Toolbar: Search from anywhere on the web, and bookmark your favourite sites. Download it now at
http://ca.toolbar.yahoo.com.

[Gordon Messmer]

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

[ann kok]

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  wrote:
> From: Gordon Messmer 
> Subject: Re: mysql
> To: [e-mail], "Community assistance, encouragement, and advice for using Fedora." 
> 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/