Mirror

Can anyone describe to me, or point me perhaps to a link, to figure out how
to mirror a MySQL database real-time? I need to create redundancy somehow --
any ideas along these lines would be so appreciated.

Thank you. Ike
Ike [ Mo, 30 Oktober 2006 11:04 ] [ ID #1518082 ]

Re: Mirror

Ike wrote:
> Can anyone describe to me, or point me perhaps to a link, to figure out how
> to mirror a MySQL database real-time? I need to create redundancy somehow --
> any ideas along these lines would be so appreciated.
>
> Thank you. Ike
>
>
Add something like this to the mysqld section your my.ini file

[mysqld]
server-id=2
master-host=miniserver
master-user=account
master-password=apass
master-port=3306
report-host=hostname


Create an account on the master and put the user and password in the
section above and the correct servername.
You will also have to enable binary logging in the masters my.ini.
IanP [ Mo, 30 Oktober 2006 16:15 ] [ ID #1518085 ]
Datenbanken » mailing.database.mysql » Mirror

Vorheriges Thema: Same database name
Nächstes Thema: Question about schema