A Horizontal Approach to Scale Out your MySQL database
ScaleBase’s software, Data Traffic Manager™, enables applications to cost-effectively leverage multiple MySQL instances to scale out to an unlimited number of users, transactions and data.
Data Traffic Manager sits between your application and database layers and automatically partitions the database data into an array of multiple MySQL instances, without requiring any changes to your application or MySQL database schema.
Your entire MySQL ecosystem continues to “see” one database. Applications, ETL scripts, BI reports, ad-hoc queries and backups using mysqldump will continue to work without any changes.
Optimized, Scalable MySQL – 100% ACID Compliant
Based on analysis of your database schema and queries (identifying relationships: foreign keys, joins, column names, etc.) Data Traffic Manager automates execution of optimized data distribution policies for your applications’ workloads. In this way Data Traffic Manager aligns with your data schema and application to provide the most efficient and scalable MySQL scale out solution that anticipates future application requirements and growth assumptions
Data Traffic Manager routes SQL commands to the correct database in the array, according to the declared data distribution policy. In cases when data is required from several databases, requests are run in parallel across all instances, and the results are aggregated automatically. The client is then presented with a single unified view of the requested data — the same result-set that would have been returned from a single database, Data Traffic Manager will automatically perform any cross-db joins, groups, orders and aggregations, required to obtain unified results.
Data Traffic Manager is transparent to the application, so the application continues to “see” one database, but can leverage the power of multiple MySQL instances.
Data Traffic Manager uses a shared-nothing database architecture where each database and instance is independent. There is no single point of failure across the system. Data Traffic Manager itself is also never a bottleneck or a single point of failure as you can include as many controllers as you wish.
- Keep your MySQL – keep your InnoDB
- MySQL ecosystem compatibility, preserve skills
- 100% application compatibility
- No down-time, no forklift
- Your data stays safe in an ACID-compliant database
- No “in-memory” magic
- No “in-memory” size limit
The ScaleBase solution serves as both a database front end and a database manager, as depicted below
On the front-end, the Data Traffic Manager mimics the behavior of a single-instance MySQL database by supporting the same network protocol as your existing server.
On the back-end, Data Traffic Manager distributes data between multiple MySQL database servers.