This is just a quick run down on getting replication going as a mild form of backup. It WILL NEVER ever replace a good backup strategy, but it at least ensures that most of your SQL data is in two places.
The many configurations of MySQL Servers can be tricky. A real problem can arise when a development database server is not identical to the production one. Obviously, one can’t cater for every possible deployment environment; especially when you use other ISPs servers.
If you are like us and like a good stable build of Debian (Etch 4.0), you may have had trouble locating a recent build of MySQL as a DEB package. Arjen and the kids over at OurDelta have rolled a magic build of MySQL (Release 5.0.67.d7).
[Read more →]
