This white paper provides insight on improving the scale, speed, and agility of MySQL so that it can support the digital transformation initiatives of today’s enterprises. New business needs and performance demands have pushed many applications beyond MySQL’s (and other RDBMSs) architectural limits. In many cases, the issues cannot be remedied by just fixing MySQL. The issues include:
- Scalability. The adoption of digital business, IoT, and other new technologies has increased query and transaction loads 10-1000 times.
- Speed. Customer-facing web and mobile apps, and their underlying APIs, all require sub-second roundtrip latencies.
- Agility. New business initiatives require inflexible applications to support new capabilities in days or weeks, rather than months or years.
This white paper examines different MySQL and third party options to address these issues, including: MySQL InnoDB Cluster, MySQL NDB Cluster, Galera Cluster, MariaDB, Percona Server for MySQL with XtraDB Cluster, Clustrix, Vitess, as well as cloud options such as Amazon RDS for MySQL and Amazon Aurora, and caching options such as memcached and Redis. It then discusses how in-memory computing (IMC) technology such as GridGain and Apache Ignite can dramatically add speed and horizontal scalability to existing infrastructure.
Download this white paper to understand which option best addresses your business needs.