More and more consumers are accessing websites and transacting while on-the-go, with mobile usage now overtaking the desktop 51 to 42 percent. Almost half of all consumers now expect a web page to load in two seconds or less, and 27 percent of cart abandonment occurs due to time constraints. These high expectations, coupled with high-transaction high-value workloads, are placing unprecedented demands on MySQL and other databases. In a recent survey, Analyst firm ESG noted database growth in excess of 40 percent per year, with nearly half of respondents citing increases in transactional workloads and the ability to continue to capture transactions efficiently as a database challenge leading to performance concerns.
And not even the big boys are immune from these problems! The recent, highly-visible snafus of Amazon Prime Day and the launch of Pokemon-Go can attest to that…
If you’re one of these companies facing performance and scale challenges, you might be considering using replication or sharding to address these issues. Don’t!
Using replication or sharding to extend MySQL is old-school
With these old-school approaches, you have to deal with added risks and costs. With both replication and sharding you’re dealing with manually managing data inconsistencies like slave lag. Plus with sharding, you have to deal with even more issues of complexity and fragility: There’s the complicated set-up and ongoing maintenance of manually adding/splitting shards as your data grows, and then having to change the application to point to where the data lies; and the fragility brought about by application downtime for server maintenance, security patches, or worse – unplanned failures without automatic recovery. These all translate to higher costs due to additional hardware required (double up to quadruple!), manpower and time to manage complexity, lost opportunity from application downtimes, and added business risk.
It’s time for the next-generation scale-out relational database
ClustrixDB is a drop-in replacement for MySQL built from the ground up to deliver true scale-out performance. Bypass the headaches of replication and sharding and move to the relational database for high-transaction, high-value workloads that scales in a near linear fashion — allowing it to handle workloads more than 10x faster than those running on MySQL or AWS Aurora. ClustrixDB is used today in an array of industries — including e-commerce, gaming, IoT, and adtech — for critical business applications that support massive transactional volume and real-time reporting of business performance metrics.
ClustrixDB’s distributed, shared-nothing architecture presents your application with a single-instance database that is made up of a cluster of commodity nodes. By simply adding or subtracting nodes to and from the cluster, you can easily Flex Up to meet extraordinary demand and Flex Down to save money. ClustrixDB is also the only ACID-compliant, scale-out SQL database that offers built-in high availability and self-management, reducing operational costs while ensuring mission-critical databases remain online with the performance you need.
ClustrixDB is architected for scaling both on premise and the cloud.
Designed to help your site grow fast, ClustrixDB takes the pain out of scaling by automating all of the complicated database operations traditionally performed to increase throughput, capacity, and high availability.
What’s New in ClustrixDB 8.0?
ClustrixDB 8.0 is the latest release of the only drop-in replacement for MySQL with true scale-out performance. Designed to help customers meet the challenge of explosive growth in transactional workloads, this latest version combines in-memory processing, containerization and encryption to improve performance, ease-of-use and security.
In-memory processing gives three-times performance boost
ClustrixDB now provides even faster performance, combining the speed of NoSQL with the relational benefits of SQL for:
- Performance improvements of up to 300 percent for in-memory bulk data ingest, in-memory streaming HTAP, and high-volume aggregate processing
- The ability to store in-memory or on-disk without separate coding requirements
- Automatic linear scalability to match growth by simply adding more servers
Full containerization for easy installation and deployment
It’s now even easier and faster to get up and running on ClustrixDB 8.0, which is:
- Fully containerized, making it easy to install and orchestrate ongoing deployments, on any cloud or data center
- Virtually plug-and-play, requiring minimal changes, if any, to your MySQL application
- Intuitive, with an easy-to-use GUI for monitoring and managing cluster performance
Heightened security with AES 256-bit encryption
Your data is now more secure with the industry’s most powerful cluster-aware encryption of data-at-rest. Leveraging the same worldwide standard adopted by the U.S. government, ClustrixDB 8.0 offers:
- Advanced Encryption Standard (AES) 256-bit encryption
- High-performance, partition-level encryption
- Performance optimized to meet big data scalability in distributed computing architectures
Handle Massive Transaction Volumes With Ease
ClustrixDB handles the massive transaction volume that large and fast-growing applications need, with ease. ClustrixDB scales near linearly as you add nodes, even with highly concurrent workloads.
ClustrixDB lets you handle the massive data and transaction needs of your application simply, without code changes and without replacing database or hardware as your application needs grow.
With ClustrixDB, every node can receive and process transactions. The database employs shared-nothing architecture, known to scale linearly with distributed fine-grained, row-level locking to minimize contention. The database also moves code to where the data is in the database cluster rather than moving data, allowing near-linear scale as cluster sizes grow.
Eliminate Headaches With Self-Managing Operations
ClustrixDB virtually eliminates DBA operations tasks because the management is built into the database itself. ClustrixDB is built with many points of instrumentation and ClustrixDB Rebalancer is always working in the background, keeping the cluster healthy with minimal overhead.
Our customers run deployments of hundreds of cores, and terabytes of data without a full-time operational DBA. ClustrixDB significantly reduces the work required for administration of the database, therefore significantly reducing the cost of ownership and allowing your engineers to focus on innovation.
With ClustrixDB, the data is automatically sliced and distributed across the cluster–the user does not need to pick shard keys. ClustrixDB Rebalancer is able to move data across the cluster while the data is being read and written. In case of imbalance, the Rebalancer will move data to restore balance. When new nodes are added, data is automatically moved to the new node. In case of node loss, some copies of the data are lost; to re-protect, lost copies are regenerated and moved to other nodes.
ClustrixDB is built with instrumentation that is always running, measuring multiple aspects of the database health constantly. In case the database cluster needs attention, it will send an e-mail to the administrator with the concern, such as when the database is reaching the capacity of storage or processing resources.
Rest Easy With High-Availability
Clustrix provides all the tools required to run business-critical production applications, helping our customers to get five-9s of availability.
Customers expect their services to be always available. Hardware, especially VMs in the cloud, fails often and entire geographical regions can become unavailable. The database, just like the application servers, needs to be able to recover from failures quickly and have disaster recovery features for events such as power outages.
ClustrixDB is built with simple and robust high availability. Within a cluster, we keep multiple consistent copies of each slice of your data. You get automated recovery in the face of disk or node failure, and your database stays available with no data loss. This capability is significantly more robust than local master-slave configurations, where slaves can lag.
You can deploy another cluster across geography with asynchronous replication. Clustrix uses the MySQL replication protocol. For disaster recovery Clustrix offers fast parallel backup that takes the same time irrespective of number of nodes in the database cluster.
Migrate Smoothly From MySQL
ClustrixDB allows you to continue to use your SQL code and SQL skills. For MySQL users, the code changes required are minimal. Clustrix can be set up as a slave to MySQL and promoted to master, while your database and application are running.
Migrating to ClustrixDB is significantly simpler than a move to NoSQL or sharded MySQL, which requires a lot more effort and precious engineer time upfront in the application, as well as ongoing operational costs thereafter.
ClustrixDB is built from scratch and does not include any MySQL code. However, ClustrixDB has a personality module that allows it to speak MySQL protocol with a few differences, mostly in corner cases as a result of its distributed nature. The list of differences is well documented and most customers are able to migrate with few or no code changes.