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:

• Gigaspaces Announces Extreme Scalability for MySQL Enterprise Customers
• Survival Guide for IT During this Economic Meltdown