If Your MySQL Application Runs in the Cloud, Consider ClustrixDB — a Cloud Database You Can Bet Your Business On
A Fault Tolerant and Resilient Cloud Database
ClustrixDB protects you from many of the vagaries of the cloud. The cloud, unlike the datacenter, is unpredictable. For instance, you may not get the full performance from the instances, the neighbors to your environment might be noisy and cause instability, or your cloud provider may move your instance without notice. Cloud database ClustrixDB has built-in technology specifically designed to mitigate problems from these potential interferences. Features like self-managing operations, automated recovery within a cluster, asynchronous replication across geographies, multi-availability zone support, and fast parallel back-ups allow Clustrix customers to build applications in the cloud with enterprise-grade fault tolerance and resiliency.
Designed to support the DevOps mantra of simplifying and automating overhead, cloud database ClustrixDB is built to be self-managing. ClustrixDB is instrumented to collect over 5,000 data points on all aspects of database functionality, and uses this data to anticipate, calculate and automate most DBA tasks with precision.
As a cloud-native RDBMS, ClustrixDB automates data distribution across the cluster. The database maintains good health by evenly distributing data and query load across the cluster. Adding a node to the cluster requires a single command, the data and load automatically moves to the new cluster. Under heavy load or if any issues needs attention, the cluster e-mails the administrator requesting attention.
Automated Recovery within a Cluster
The Clustrix cloud RDBMS automatically maintains multiple copies of all data within a cluster. In case a node fails, the lost copies are automatically regenerated and redistributed across the cluster. Without lifting a finger, the cluster will recover from the failure and stay available throughout–all while being transparent to the application.
The Only Cloud Database on the Market Designed to Handle Multi-node Failure
The patented ClustrixDB nResiliency feature allows you to set up your Clustrix cluster to be fault tolerant up to n number of nodes failing at the same time by simply setting a parameter. The Clustrix Rebalancer will optimize data distribution for that number, and gracefully handle multi-node failures while maintaining availability. Of course, the Rebalancer can also deploy replacement nodes to replace the lost capacity immediately, letting you gracefully survive potentially catastrophic outages without lifting a finger.
Metro Area Clustering Across Data Centers and AWS Availability Zones
ClustrixDB supports deploying a single database across multiple metro area clusters in private data centers or the cloud — including AWS Availability Zones (AZ) — for scalability without sacrificing availability or data integrity. No database-specific logic is required in the application to handle multiple read-write nodes, because the database has the intelligence to handle them automatically.
Data Integrity — each node can be a read-write node, regardless of which zone it’s in, so the data stays consistent across nodes, clusters and zones - no master and slave configurations
Availability and Data Protection — automatically keeps the database online and the data consistent if there is a complete zone failure, without DBA or application intervention — no replication required
Scalability and Performance — more write-power with multiple read-write nodes in each zone for better performance and lower latency than with replication or single write-nodes in each zone
Fast Parallel Backup in a Cloud Database
Cloud database ClustrixDB is built with fast parallel backup for disaster recovery. This feature takes a consistent snapshot of the database controlled by MVCC, and the backup time does not increase with size of the database. The ClustrixDB native-cloud RDBMS accomplishes this by spawning multiple datastreams from each node in parallel, allowing for up to 10x faster backups than on a similarly-sized MySQL dataset. For compatibility and migration, ClustrixDB also supports Mysqldump backup. Truly a database built for deployment in the cloud.
How ClustrixDB RDBMS Scales Writes & Reads
Scaling out a SQL RDBMS while maintaining ACID guarantees in realtime is a very large challenge. Most scaling DBMS solutions relinquish one or many realtime transactionality requirements. ClustrixDB achieves near-linear scaling of both write and read queries with full ACID compliance, by a combination of ‘bringing the query to the data’ and automatically distributing the data across all nodes in the cluster. Read this white paper for more information including how ClustrixDB leverages a Cascades Planner, MVCC, 2 Phase Locking, and the Paxos consensus protocol.
A New Approach to Scale-Out RDBMS
ClustrixDB is a scale-out SQL database that is designed to scale horizontally—by adding cores and servers. The shared-nothing architecture provides an entirely new approach to query resolution by moving the query to the data—not the data to the query. Learn how this revolutionary technology makes it possible to scale a single database across nodes, and still support massive concurrency while delivering high performance, full relational functionality, transactional consistency (ACID), and seamless deployment.
Why Traditional SQL Databases Fail to Scale Writes & Reads Effectively
Traditional OLTP database scaling is a major polarizing issue with both database administrators (DBAs) and application developers. Many people refer to relational databases as being a SQL database and say that SQL databases fundamentally cannot scale. They say it’s just not possible because SQL databases were not designed to truly scale, especially writes, and definitely not to cloud scale. Others will assert that those who believe SQL databases cannot scale lack the knowledge, experience, and expertise to actually scale SQL databases. Some DBAs say that’s why there are now NoSQL databases.