This time, I’d like to focus on ScaleDB—a pluggable storage engine for MySQL—deployed in a typical Business Environment.
ScaleDB is a pluggable storage engine for MySQL that ensures dynamic scaling of MySQL applications in a public cloud, private cloud, or on premises. ScaleDB delivers shared-disk clustering in the form of a plug-in storage engine for MySQL. Shared-disk, also known as “shared-everything,” works on the principle that you have one array of disks—typically a Storage Area Network (SAN) or Network Attached Storage (NAS)—that holds all of the data in that database. Each server or node in the cluster acts on that single collection of data in real-time. In a shared-disk architecture, any node can satisfy any request, because they all have access to all of the data. So, instead of going to a specific node for specific data, shared-disk can simply route the request to the next available node. Since each node can address any database request, the load is inherently balanced across the nodes in the cluster.