MySQL Forums
Forum List  »  Replication

Re: Update data from slave to master
Posted by: Ramon Sosa
Date: February 07, 2005 07:23PM

May be a replication solution is not what you need, because you need transactions using innodb. Because replication is only used to manage load balancer or as a mirror for main server fail. As you can see in replication any changes that you make to a master is make too to a slave.

May be you need to have only a ca,cb,cc jsp server that access to mysql server cm, cm could be replicating to another server.
You should consider this before using replication.

If you consider use replication:
You should read first the MySql Documentacion about Replication for a good knowleadge about this(Master, Slaves, Binary Logs,SQL Threads, IO-Threads,Server-id, mysqld, my.ini)

MySql only accept a One Master, Many Slaves replication.
Who is Master and who is a Slave?.
Master -> Receives directly SQL updates.
Slave ->Read binary log from Master (IO thread) and Execute same SQL instructions(SQl thread).

when you configure binary log in master you can specify what databases you want to log.

Whe you configure a slave you can specify too what databases you want to replicate. Should be in binary log logging.

Ramon Sosa

Options: ReplyQuote

Written By
February 01, 2005 03:35AM
February 02, 2005 08:09PM
February 03, 2005 07:33PM
Re: Update data from slave to master
February 07, 2005 07:23PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.