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 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.