MySQL High Availability Architectures

Depending on your requirements there are various  architectures or ways that you can configure MySQL and MySQL Cluster. Below is just a summary of some of the most frequently used architectures to achieve high availability. MySQL Master/Slave(s) Replication MySQL master to slave(s) configuration is the most popular setup. In this design One(1) server acts as… Continue reading

MySQL Cluster 101

What is MySQL Cluster [blockquote source=”Wikipedia”]MySQL Cluster is a technology providing shared-nothing clustering and auto-sharding for the MySQL database management system. It is designed to provide high availability and high throughput with low latency, while allowing for near linear scalability.[2] MySQL Cluster is implemented through the NDB or NDBCLUSTER storage engine for MySQL (“NDB” stands… Continue reading

MySQL Cluster Getting Started [Redhat/Centos 6]

Installing 1.Download the RPM from MySQL.com [syntax type=”bash”]wget http://dev.mysql.com/get/Downloads/MySQL-Cluster-7.3/MySQL-Cluster-gpl-7.3.5-1.el6.x86_64.rpm-bundle.tar [/syntax] 2.Install the RPM  and dependencies [syntax type=”bash”]yum groupinstall ‘Development Tools'[/syntax] [syntax type=”bash”]yum remove mysql-libs[/syntax] [syntax type=”bash”]yum install libaio-devel[/syntax] [syntax type=”bash”]rpm -Uhv MySQL-Cluster-server-gpl-7.3.5-1.el6.x86_64.rpm[/syntax] This installs all the binaries that will be required to configure each component of the MySQL Cluster.