A day with MySQL5
For the upcoming time on the road, I have prepared my iBook today with the latest releases of PHP5 and MySQL5. While on it, I tried to figure out, what the new cluster functionality really offers and have spent quite an amount of time reading the the new manual pages.
Two things are obvious: finally a real cluster solution for MySQL, it was about time! Real big sites with just the replication service always ran into the problem, that the replication slave went out of sync sooner or later. I have had this phenomenon on tradebit about 3 times already and needed a manual fix then. Now it looks better.
The major difference is, that MySQL5 has now a so called “management node”, which is responsible for load balancing and distributing your data to single database nodes in your cluster. Good is, that these interactions with that management node are not very different to the standard mysql clients in the earlier versions. It looks like a few entries in the my.cnf and that setting up additional servers can really solve some load issues. As soon as we got time here, tradebit will move on to MySQL5.
Also worth a note is, that the installation packages for rather Linux oriented products like PHP5 install fine and easy on OS X. Kudos to Marc, who did a great job with gathering these packages! Now I have a mini iBook fully featured with tradebit and other projects running!
(0)