Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 1st July 2010, 12:34
black_magik black_magik is offline
Junior Member
 
Join Date: Jul 2010
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default MySQL Database Replication Problem

I've read the article of Falko Timme at:

http://www.howtoforge.com/mysql_database_replication

and i've follow all the instruction to make a MySQL replication between
two servers, one with Centos 5.5, MySQL 5.0.77 and one with Gentoo Base
System release 1.12.13 and MySQL 5.0.84
i want to replicate 5 different databases and i've added them in my.cnf
in this way on the master:

log-bin = /var/log/mysql/mysql-bin.log
binlog-do-db=database1
binlog-do-db=database2
binlog-do-db=database3
binlog-do-db=database4
binlog-do-db=database5
server-id=1

and on the slave:

server-id=2
master-host=XXX.XXX.XXX.XXX (the master address)
master-user=slave_user
master-password=pwd
master-connect-retry=60
replicate-do-db=database1
replicate-do-db=database2
replicate-do-db=database3
replicate-do-db=database4
replicate-do-db=database4

for the rest i've follow step-by-step all the instruction on the guide
and i didn't receive any error.
But doesn't work anything!!!!

The db doesn't replicate

Can you help me please

Thanks
Reply With Quote
Sponsored Links
 

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail -Ubuntu 8.04 c4rdinal HOWTO-Related Questions 112 23rd August 2011 10:49
Mysql replication problem lano Server Operation 6 1st February 2010 18:56
BIG Problem Postfix issue admins Installation/Configuration 11 13th November 2009 10:05
phpmyadmin error lifeisboost Installation/Configuration 9 14th August 2008 19:19
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 15:10.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.