[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: mysql



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 eburg com> wrote:

> From: Gordon Messmer <yinyang eburg com>
> Subject: Re: mysql
> To: oiyankok yahoo ca, "Community assistance, encouragement, and advice for using Fedora." <fedora-list 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/


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]