MySQL Scalability on Amazon RDS, EC2 and Other Public / Private Clouds
Are you experiencing MySQL scalability challenges?
ScaleBase delivers scalability to MySQL databases residing in the Cloud, with no changes to your existing MySQL ecosystem.
Whether in a private cloud, or on public clouds like Rackspace, Amazon EC2 or RDS, ScaleBase plugs into your MySQL ecosystem seamlessly, delivering linear scale and performance benefits without changes to applications, development tools, scripts, drivers, libraries, or back-up processes.
Elasticity, the core principle of provisioning IT services in the Cloud, can be delivered for application layers (such as web servers and app servers). But the database layer is not elastic in the same way. Traditionally, databases can only scale-up, to use ever-larger (and more expensive) hardware. Now with ScaleBase, standard MySQL databases can scale out on commodity, shared nothing, hardware.
ScaleBase software enables applications to cost-effectively leverage multiple MySQL instances and each MySQL instance manages a portion of the data. By doing this, everything is more efficient: indexes structure, cache buffers, row locks, isolation management, and more. Each instance runs faster as it manages only a portion of concurrent sessions, resulting in higher efficiency for commit traffic, row locks, and isolation management. Critically, all SQL and full ACID transactional capabilities are preserved. No installation is required on the application server or on the database. ScaleBase is agnostic to the database and application environment. No changes are required to the existing storage engine. ScaleBase is not a new storage engine or a new database.
ScaleBase Brings MySQL Scalability to Cloud-Based Application Platforms
- Requires no application code changes and no new code to maintain
- Reads run faster
- Writes run faster
- Enables better resource utilization and load balancing
- Improves data consistency and transaction isolation
- Built-in failover with high availability
- Database aware, replication state aware, replication lag aware
- Real-time monitoring and alerts
- Leverages your existing database services.
MySQL Scalability on Amazon RDS
ScaleBase’s software is specifically designed to scale out a single MySQL RDS instance into multiple MySQL instances. This unique capability allows you to scale write-intensive workloads beyond the capabilities of the largest available Amazon RDS MySQL instance.
Critically, this is accomplished with no changes to your application code. Your application continues to “see” one database. ScaleBase does all the work of managing and enforcing an optimized data distribution policy that creates multiple MySQL instances.
The result: now you can cost-effectively leverage multiple MySQL RDS instances to scale out write-intensive workloads to an unlimited number of users, transactions, and data.
Amazon RDS and ScaleBase – Simplicity and MySQL Scalability
1. Keep your application, unchanged – No changes to your application development life-cycle. Use your existing development tools, frameworks and libraries. Application quality assurance and testing cycles stay the same. And, critically, you stay with an ACID-compliant MySQL environment.
2. Keep your RDS value-added services – The value-added services that you rely on are all still available. Amazon will continue to handle database maintenance and updates for you. You can still leverage High Availability via Multi A-Z. And, if it benefits your application throughput, you can still use read replicas.
3. Keep your RDS administration – The RDS monitoring and provisioning tools you rely on work as they did before.
With your one large MySQL instance now split into multiple instances, you can actually use smaller available hardware and continue to see better database throughput and performance.
For more information, we have created a whitepaper, MySQL Scalability On Amazon RDS: Scale Out To Multiple RDS Instances, so you can learn how to achieve AWS/RDS MySQL scalability for write-intensive apps by creating a large, high capacity database comprised of multiple smaller MySQL RDS instances.