Hello.
On Mon 2002-07-29 at 10:06:50 -0400, [EMAIL PROTECTED] wrote:
> Hello everyone,
>
> The mysql documentation about replication is great at describing
> how to replicate fomr one master server.
>
> If i want to replicate many db servers to one replication server is
> there a way I can edit the my.cnf file to do this. Or would it be
> better to have another conf file for the other master running under
> another mysql instance??
I am not sure, whether I understand you correctly, therefore I try to
rephrase that in my words:
1) You have serveral database servers with independend databases, which
you want to replicate to a common slave for back-up/fall-back
purposes or something like this.
or
2) You have serveral database servers with the same databases and want
updates to go to one common master in order distribute load.
> Has anyone had any experience with this? What would be the best way to
> handle this? I am going to eventually replicate 10 masters on 1 db..
In case you mean 1), it seems you have to run a MySQL instance for
every master you want to replicate from. At least I cannot see any way
to specify more than one master per slave.
Case 2) with MySQL requires your application to handle this. I.e. you
set up each database server as slave, replicating from your
"replication server" alias master. You application must handle to send
updates to the master and selects to one of the slaves.
Greetings,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
