The MySQL clustering technology is a shared nothing architecture which allows for the clustering of databases. As no single application, hardware or other component is shared by two or more platform components, the risk of a being vulnerable to a single point of failure is entirely eliminated. The entire solution can be installed on default and cost-effective hardware components; translating into an attractive proposal from a budgetary point-of-view.
As MySQL clustering is designed to eliminate single points of failure, each component operates self-sufficiently with its own hard drives, RAM and software. The technology is strictly and entirely stripped of shared storage solutions such as network shares or network file systems.
The MySQL cluster solution integrates the default MySQL server technology with a NDB storage engine which is specifically designed to support the storage segment. The MySQL cluster solution therefore operates on a combination of both MySQL technology and the NDB storage engine. The entire MySQL cluster consists out of several servers, including SQL servers, data notes and one or more management servers.
All clustered servers cooperate within the same MySQL cluster. Whenever data is received by the NDB storage engine, all tables are saved into the data nodes. These tables are then directly accessible from each SQL server within the platform. In a practical example this could mean that if the monthly wage of an employee is adjusted within a payroll administration, the newly determined amount is directly accessible for each of the individual SQL servers.
All data saved to the data nodes can be fully mirrored, guaranteeing an uninterrupted continuation of services if an individual data node would ever be disrupted. The only noticeable consequence on the exact moment would be a reset of transactions being processed at that time. However, the majority of applications are developed to handle these situations, allowing for completion of these transactions, albeit on a different data node.
Add value of the MySQL cluster:
Platform independent solution
Large storage capacity
Extremely fast response time
Very high order throughput (>10,000 transactions per second)
Shared nothing architecture
Fully scalable platform
Application, MySQL Server, data storage layer
Allows for usage of cost-effective / factory state hardware
Fast and automated fail-over (milliseconds)
MuntInternet: Your MySQL cluster partner:
Our proven track record in the design, architecture and operational maintenance of both MySQL clusters as other complex hosting technology, allows us to work with you on filling in your cluster needs. Cost-effective, always available and technologically advanced, that’s MuntInternet.
Please contact us to share your clustering case with us, we’re always available to provide you with a personal advice.