Setting up MySQL Linux slave with a Windows master
Posted
by
philwilks
on Server Fault
See other posts from Server Fault
or by philwilks
Published on 2011-01-05T09:35:20Z
Indexed on
2011/01/05
9:55 UTC
Read the original article
Hit count: 297
I'm running a MySQL 5.0 database server on Windows Server 2008. The total size of the database is about 1Gb.
I make daily backups, but I'd like to step up to having a slave server for extra protection. My thinking was that I wouldn't need the expense of a Windows machine to do this, and a Linux "cloud server" from RackSpace would do the job well for quite a low cost.
However I have little experience with Linux, so I have a few questions...
- Does this sound like a good idea? Is there anything wrong with linking Windows and Linux MySQL servers?
- Does Linux have the equivalent of Remote Desktop Connection? If so can I use this from a Windows machine?
- Would a particular Linux distro be well suited to this task? RackSpace offer ArchLinux, CentOS, Debian, Fedora and Ubuntu. My immediate thinking is to go with Ubuntu as I've heard it's more friendly for people coming from a Windows background.
Any comments you have would be very appreciated!
Phil
© Server Fault or respective owner