IT Pros

Setting up MySQL Cluster in the cloud

Richard Benson09 August 2010IT Pros, Webcomments

Before embarking on a MySQL Cluster installation, it is important to remember that MySQL Cluster is 'just' a storage engine for your existing MySQL database servers.  It stores data at the table level, not the whole database, it is therefore on the same functional level as MyISAM or INNODB.  You still need a standard MySQL server to access the table data and store the database information.  This has the fringe benefit that you can target specific tables to be saved to the cluster, rather than the whole database, if you have some tables that are either more important, or more heavily used.

In this article we are going to cover MySQL Cluster, it's installation on Debian (Lenny), Master-Master replication and how to tie all this together with HAProxy for a very high availability solution.

Continue reading Setting up MySQL Cluster in the cloud

Create a Load Balanced Web Service on Rackspace Cloud

Richard Benson30 April 2010IT Pros, Webcomments
When we first wanted to load balance web servers, we initially followed Rackspace Cloud's articles on the subject. They recommended using mod_proxy with Apache.  This took a little while to set up and even with countless amounts of config changes, every now and then requests would get lost and you'd have to refresh your browser to get connected again.  This was not a problem in a development environment, but is unacceptable when we wanted to go live with the service.  So we looked for a different solution and found HAProxy, which was not only easier to set up than mod_proxy_balancer, but is tonnes more reliable and quicker too.

Continue reading Create a Load Balanced Web Service on Rackspace Cloud
PreviousPage 2 of 2
Support Ticket
Remote Support
Support
clever girl