Scalable Cluster for MySQL

Benefits

  • 100% AWS compatible with no additional compute cycle costs
  • More control at greater scale than AWS RDS
  • Multi-zone redundancy at AWS for High Availability and Disaster Recovery
  • Users can add storage capacity and performance on demand
  • No new server costs or bottlenecks with distributed-agent architecture
  • Command-line console and web console
  • Many MySQL databases appear as a single database
  • Streaming agents for offline analytics, zone replication, and backup processes with data backup and migrate functions
  • AgilData’s proprietary low latency replication engine does all the work
  • Supports parallel MySQL queries
  • Auto-increment capability for all sharded MySQL databases
  • Supports applications written in Java, PHP, Python, Perl and Ruby

^ Back To Top    |    Contact Us

How It Works

AgilData Scalable Cluster for MySQL is an agent based sharding solution that makes the application see many database instances as one database. It is the industry’s first software product that allows database sharding to be applied to existing applications and databases with little or no modification to existing application code.

MySQL Scaling and Sharding Example

The following diagram provides an overview of an application using AgilData Scalable Cluster for MySQL. Each application server provides database drivers for popular languages including Java, PHP, Python and Ruby. Each shard server (S1 through S4) is running a MySQL database server as well as replication agents and query agents (to support parallel query functionality). In this example, data is partitioned using customer ID as a shard key. A modulus algorithm is used to determine which shard each customer ID belongs to.

Database Scaling and Sharding

Sizing MySQL Cluster

How big of a cluster do I need?

Scalable Cluster for MySQL cluster starts with four servers. Beyond that, sizing a cluster requires careful planning and technical knowhow. AgilData has years of experience helping customers scale out MySQL and can help you develop the right Data Distribution strategy to meet the demands of your users today and for years to come.

The right data distribution strategy will include a deep understand of applications and the data behind them. It’s not just about capacity planning, it also is about performance, resilience and recovery from unforeseen events. AgilData will evaluate your needs based on a ten point plan.

  1. Data volume
  2. Data growth
  3. Data lifespan
  4. User concurrency
  5. Request volume
  6. Read vs. Writes
  7. Query optimization
  8. Application reliability
  9. Business continuity
  10. Risk tolerance

^ Back To Top    |    Contact Us

Remote Managed MySQL Service

Why do you need a remote managed MySQL service?

Good Database Administrators (DBAs) are expensive and you often don’t need one full-time. Applications based on MySQL need a low-cost reliable solution to immediately scale existing MySQL databases without impacting the application. Business without enough skilled database specialists suffer more downtime, run higher risks of software glitches and are more susceptible to security breaches.

AWS RDS doesn’t scale to meet growing demands for 24/7, High Availability (HA) service for business critical applications and services.

Users can self-select from our transparent pricing for the model that fits their needs.

MODELS

PICK YOUR MODEL

ENTERPRISE SOFTWARE SUPPORT

REMOTE MANAGED SCALABLE CLUSTER

OnDEMAND SERVICES

Product Releases and Bug Fixes

X

X

Database Architecture Support

X

X*

Performance Tuning and Database Optimization

X

X*

Implement Sharded Cluster Architecture

X

X

Develop and Setup Stream Agents

X

Manage Stream Agents

X

Troubleshooting and Fixing Cluster Problems

X (Tier 2)

X (Tier 1-3)

X

Database Backups and Restore/Recovery

X

X

Troubleshooting and Fixing Database Problems

X

X

Perform Database Upgrades and Migration

X

X

Disaster Recovery Solutions/Operations

X

X

Automate Database Operations

X

X

Security Audits

X

Implementing Security for Cluster

X

X

Remote Hands Managed Services Support

X

Integration with Customer Ticketing System (Jira, Assembla, etc.)

X

X

Projects/Development work using MySQL

X

24x7 Monitoring and Notification Services

X

Database Audits/Assessments

X

Upgrades and Migrations

X

X

Database Development Projects

X

X

Manage Data Integrations

X

X

Root Cause Analysis and Problem Resolution

X

X

Find out more how AgilData Scalable Cluster can solve your MySQL scale and capacity problems for good.





^ Back To Top    |    Contact Us

How To Buy

AgilData Scalable Cluster for MySQL is available as an Enterprise Subscription Support License and with Remote Managed Services. To get pricing now, fill out the form.

  • (all fields are required)

^ Back To Top    |    Contact Us


Find out more about sharding or our fully managed MySQL

Get the Scalable Cluster for MySQL Whitepaper

Got a MySQL performance issues?  Try our new Gibbs MySQL Advisor service for FREE

Gibbs-logo-lowres

Top