469,925 Members | 1,442 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,925 developers. It's quick & easy.

problem in mysql replication

hai i have problem with mysql replication.
master -slave replication

and

two way replication


please can any one tell me step by step solution

thanks & regards

barrathi
Nov 29 '06 #1
5 3695
sashi
1,754 Expert 1GB
hai i have problem with mysql replication.
master -slave replication

and

two way replication


please can any one tell me step by step solution

thanks & regards

barrathi
Hi there,

Kindly refer to below attached link for further reading & understanding, hope it helps. Good luck & Take care.

MYSQL Replication Step by step guide
Nov 29 '06 #2
Hi there,

Kindly refer to below attached link for further reading & understanding, hope it helps. Good luck & Take care.

MYSQL Replication Step by step guide
thank u sashi
Nov 30 '06 #3
hai sashi i have one main problem.

problem is master - slave replication is working fine but it works 30 mins to 1 hr
then it is not working.
why because is MASTER_LOG_FILE='mysql-bin.000001' this file is changing frequently

like 1hr
it shows MASTER_LOG_FILE='mysql-bin.000001'

after that
MASTER_LOG_FILE='mysql-bin.000002'

after some time it shows

MASTER_LOG_FILE='mysql-bin.000099'

this is the main problem

how do fix the master_log_file?

and if possible u can see following website


http://docs.hp.com/en/5991-7431/ar01s05.html


these are the one of the steps.

mysql> CHANGE MASTER TO
-> MASTER_HOST='master_host_name',
-> MASTER_USER='replication_user_name',
-> MASTER_PASSWORD='replication_password',
-> MASTER_LOG_FILE='recorded_log_file_name',
-> MASTER_LOG_POS=recorded_log_position;


For this example, enter the following commands:

mysql> CHANGE MASTER TO
-> MASTER_HOST='master.test',
-> MASTER_USER='osmusr',
-> MASTER_PASSWORD='osmpass',
-> MASTER_LOG_FILE='mysql-bin.000001',
-> MASTER_LOG_POS=1678;

thanks
Nov 30 '06 #4
angst
1
Hello,

I've just setup my first mysql replication this week.
and this is what i've found.

replication works prefectly *IF*, you do not add/edit/delete any thing on the slave server.
you don't need to worrie about the bin-log changing, after the first time that you point it to the log that SHOW MASTER STATUS; displays. the salve can fallow along and keep up.

what I've found is that mysql does not currently support any really two-way replication. so the solution that i've found is that, you can read from both servers, and only insert/update/delete from the master. this will keep both server sync'd up correctly.

unless any one else has a better idea, this is the best i was able to find.

hope this helps,
cheers,
-Ken
Dec 8 '06 #5
thanks for your replay angst





Hello,

I've just setup my first mysql replication this week.
and this is what i've found.

replication works prefectly *IF*, you do not add/edit/delete any thing on the slave server.
you don't need to worrie about the bin-log changing, after the first time that you point it to the log that SHOW MASTER STATUS; displays. the salve can fallow along and keep up.

what I've found is that mysql does not currently support any really two-way replication. so the solution that i've found is that, you can read from both servers, and only insert/update/delete from the master. this will keep both server sync'd up correctly.

unless any one else has a better idea, this is the best i was able to find.

hope this helps,
cheers,
-Ken
Dec 21 '06 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by unplug | last post: by
reply views Thread by Ganbold | last post: by
reply views Thread by ed | last post: by
reply views Thread by ed | last post: by
reply views Thread by I.P. | last post: by
2 posts views Thread by Beda Christoph Hammerschmidt | last post: by
13 posts views Thread by Jim Hubbard | last post: by
3 posts views Thread by Juan Antonio Villa | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.