Jump to content


Photo

Replication in MySQL???


  • Please log in to reply
3 replies to this topic

#1 wtech

wtech
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 23 January 2006 - 12:40 PM

Hi

Am using

Windows-2000
Apache-2.0.52
Mysql-4.0.20
PHP-4.3.8

Versions in two servers. I would like to synchronize the my local database to the remote database server.

for that We need to add some lines to the my.cnf file. /mysql/etc/my.cnf(path).

Master

1) I created one user for replication with file permissions. like
GRANT FILE ON *.* TO repl@"%" IDENTIFIED BY '<password>';

2) Added these lines to my.cnf file of server

log-bin
server-id=1

Slave

1)

master-host=myhost
master-user=myuser
master-password=****
master-port=3306
server-id=2

After restarting the both mysql servers actually replication should start.

But replication is not wokring. I have checked the log files on both the systems.

No errorl messages r thr. I could not understand wts the problem here.

Can anybody please suggest me...


thanks

Regards

ShashiKumar Bandari







#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 24 January 2006 - 07:15 PM

Not sure why you chose the FILE permission -- you need the REPLICATION permission. I suggest you re-read [a href=\"http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html\" target=\"_blank\"]this tutorial[/a] on getting replication up and running.

Hope that helps.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 wtech

wtech
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 25 January 2006 - 04:14 AM

[!--quoteo(post=339508:date=Jan 24 2006, 02:15 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Jan 24 2006, 02:15 PM) View Post[/div][div class=\'quotemain\'][!--quotec--]
Not sure why you chose the FILE permission -- you need the REPLICATION permission. I suggest you re-read [a href=\"http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html\" target=\"_blank\"]this tutorial[/a] on getting replication up and running.

Hope that helps.
[/quote]


Hi

Thanks for ur reply.


Replication is working fine in both the servers.

If there is any problem in one server. replication will stop.

logging following error into log file

resumed in log 'wtjobser-bin.003' at position 16380

how can i replicate the data from this position.

Shashi Kumar


#4 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 25 January 2006 - 07:45 AM

Sorry -- my experience with replication is rather limited; if it's not in the man pages, I'm not sure.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users