What We Do
We provide top quality services and best solutions based on your requirements and needs.
Share

MXAE and MySQL Cluster

In one of our current project with a client, we have managed to successfully deploy MXAE using the latest MySQL Cluster 7.1. The advantage of using MySQL Cluster solution is that it provides the necessary scalability and high availability that's required for a high traffic and demanding portal. Best of all, it is available for FREE. The deployment was based on a standard architecture recommended by MySQL where it consists of a network load balancer, 1 management node, 2 data nodes and 2 SQL nodes as illustrated in the diagram below.

 

 

Description
1. Management Node and Network Load Balancer (NLB) reside on the same physical server since the Management Node does not need to be up all the time and it is not resource hungry.
2. SQL Nodes are load balanced by the NLB. If NLB is not available, DNS round robin to the SQL nodes is a workable solution too.
3. Each SQL Node has been configured to be able to access to any Data Node to eliminate single point of failure at this level.
4. To eliminate single point of failure at the NLB, it is always possible to add another box to perform an active-passive NLB with automatic failover.

As you can see from the diagram above, to add a disaster recovery site is a matter doing a standard master-slave replication from the production site to the disaster recovery site. 

Hardware specifications for the above architecture are as follows:

Network Load Balancer + Management Node
• 1 x 2.4GHz Intel Xeon Quad Core
• 8GB RAM
• 2 x Gigabit Ethernet Ports
• 2 x 146GB SAS HDD RAID1

SQL Node
• 2 x 2.4GHz Intel Xeon Quad Core
• 16GB RAM
• 2 x Gigabit Ethernet Ports
• 2 x 146GB SAS HDD RAID1

Data Node
• 2 x 2.4GHz Intel Xeon Quad Core
• 16GB RAM
• 2 x Gigabit Ethernet Ports
• 2 x 400GB SAS HDD RAID1

The operating system used is CentOS 5.5 and the network load balancer is deployed based on one of the packages that comes with CentOS called Cluster Suite.

Click here to learn more about MySQL Cluster.



MXAE Release News

MXAE 2.7.5 Released
We would like to announce the immediate availability of MXAE 2.7.5. This release focuses on...




Tips & Tricks

The "nocache" attribute
The nocache attribute is usually used in conjunction with article selector in order to...




MXAE Free Hosting

We are offering FREE hosting on MXAE platform with no string attached. You can use it as a development or demo hosting for your company. You can also use it to build your own website or host your client website.