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!