Hi,
I have two production machines with mysql running, and I'd like to
set up a third on which does backups with replication.
As far as I know, one mysqld can not replicate from two different master.
But I need DB1 from HOST1 and DB2 from HOST2 to be replicated, so I've
used mysqld_multi to start two mysqld on one machine.
Now the problem is, that replication would not start, because of the missing
entries for the grou [mysqld] in my.cnf (if you are using mysqld_multi, you
have no [mysqld] group but one or more called [mysqld1], [mysqld2] and so
on).
A solution to this problem is to copy the section with the replication
information
from the [mysqld1] group to the [mysqld] group, start server 1, copy the
replication
information from the [mysqld2] group to the [mysqld] group, start server 2
and so on.
Is this an known problem, and is there better solution?
cheers,
Martin
--
..............................Martin Mrvka, Research & Development
..................................SMS Internet-Dienstleistung GmbH
.......................................Sporgasse 25/2, A-8010 Graz
......................Tel./Fax.: +43 316 81 33 80 DW 31, Fax DW 50
.................................http://www.sms.at - [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
