A robust and scalable MySQL powered by GigaSpaces XAP
A growing class of applications faces scalability and performance challenges. Such applications include Web 2.0, SaaS, Real-Time and transactional applications in a range of industries. The need to scale these applications on-demand, handling unexpected spikes and growth, while maintaining a superior user experience, becomes a complex challenge with existing centralized architectures.
Solution Overview
MySQL and GigaSpaces provide an integrated solution that combines MySQL’s wide adoption and cost-effectiveness with GigaSpaces' scale-out application server. The solution introduces GigaSpaces transactional and reliable in-memory data grid as a front-end to the database. The data grid acts as the "system of record" for the application, i.e. handles all updates, queries and “runtime logic”. The database acts as in-sync persistence storage in the background. To improve performance, the database is kept in sync with the data grid in an asynchronously manner.
Solution Benefits
- Near Linear Scalability and unparalleled performance
- Seamless database clustering
- Complex in-memory data manipulation is easily achieved by through Java, .Net and C++ code, or SQL queries.
- Parallel aggregated queries are executed across multiple machines in the cloud leveraging the full CPU and memory power of those machines.
- Decoupling the database and the application providing more options for optimization.
- Simplicity - reduce the need for O/R mapping
Blogs: Benchmark Results of GigaSpaces-MySQL on Amazon EC2, Challenges and ways to scale MySQL
Download GigaSpaces XAP
Contact us today to find out how we can help with your company's needs.
Related Resouces:
