How is Clustrix MySQL Compatible?
I’m Christine, and I’m a program manager at Clustrix. In my job, I’m constantly explaining what Clustrix does, and in doing so, I’ve found myself using the metaphor that “Clustrix is like MySQL on steroids.” What that means is that Clustrix is MySQL compatible — if you’re currently on MySQL and are experiencing problems with scale, performance, or complex operations, you can switch to Clustrix with no code changes.
Clustrix offers support for the following:
- MySQL query syntax
- MySQL replication
- mysqldump (as well as our own Fast Parallel Backup)
- Foreign keys (Clustrix is fully relational)
- ACID-compliant transactions (as with InnoDB)
- Fault tolerance and crash recovery
- Stored procedures
- Temporary tables
- Information schema views
In addition to these offerings, we provide online schema changes (meaning no more downtime for DDL), linear scalability (something that sharded options such as MySQL cluster don’t offer), and a fully distributed architecture, including redundant data stores, distributed computing, and distributed query planning and execution.
So Why Use Clustrix Over MySQL?
While MySQL is “free” and Clustrix has an initial cost, the hidden costs of MySQL soon become painfully apparent and can cause unforeseen difficulties as a company grows.
Our customers switch to Clustrix because they want to scale without worrying about whether their database can keep pace. Instead of sharding, Clustrix let’s them concentrate on building their application, not dealing with the overhead of handling sharding logic. Because of this, our customers can get to market faster and retain their competitive edge. For instance, read how Clustrix helped Twoo scale to become one of the largest dating sites in the world.
Other customers use the added capacity and simplified operations of Clustrix to consolidate hundreds of MySQL boxes onto a single Clustrix database. AOL was able to simplify their replication strategy and remove issues with replication lag as part of their consolidation.
And don’t worry if you’ve already sharded your data. Many of our customers who have sharded still choose Clustrix because of our simplified operations and better performance.
How Easy is it to Migrate from MySQL to Clustrix?
It’s as simple as choosing a method, such as mysqldump and Replication. Then, you’re ready to go. Clustrix can act as either a Master, a Slave, or work in a Master-Master configuration with MySQL.
We’ve also helped companies move from SQL Server, and Postgres to Clustrix.
Why was Clustrix Designed to be MySQL Compatible?
Here’s a bit of trivia for you: early on in Clustrix history, we actually built a Postgres replacement. However, we decided to focus on MySQL when we noticed more and more companies experience problems with scale. A survey posted on Hacker News shows that most fast moving, innovative companies use MySQL, both this year and last. The overwhelming popularity of the rapid development frameworks like Ruby on Rails and Django confirm this.
Clustrix is known for its simplicity, something that has always driven the design and strategy of our company. With Clustrix, any company can scale their database, and as load grows, simply add more capacity. As I’ve seen time and again during my interactions with our customer base, it really is as simple and straightforward.
If you want to learn more about Clustrix and MySQL, check out our blog post on Key Differences between Clustrix and MySQL.
Learn more about how Clustrix is a MySQL replacement.