Hi Mohammed,
- (MySQL is installed on both servers.)
- On the master GRANT FILE ON .* TO replicater@<host> IDENTIFIED BY 'replicater';
- Stop MySQL on both servers.
- Be sure you have two identical databases on each server. (Copy from one to the other
if needed. - check all the access rights stuff.)
- Create or update my.cnf on master and slave. (On NT this file is in C:\. I don't know
for Linux.)
- On master my.cnf contains:
[mysqld]
server-id=37
log-bin
- On slave my.cnf contains:
[mysqld]
serverid=38
master-host=<master host name>
master-user=replicater
master-password=replicater
That's it. Start both deamons.
For more info look to chapter 11 of the manual.
Mohammed Ali wrote:
> Hi there,
> I was looking for the master and client source code but I was unable to
> find, I found the rpm but not source in tar format.
> I ma tiring to configure 2 linux server one master and one slave, can you
> tell me what's the best way to accomplish this and what settings I have to
> change.
>
> any help will be really appreciated.
> Thanks
>
> Ali, Mohammed
> Systems Administrator
> iWon.com
> One Bridge Street, Suite #42
> Irvington, NY 10533
> (914) 591-2000
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
