Mysql CLUSTER BROCHURE

MYSQL CLUSTER

A

THE LEADING OPEN SOURCE,

HIGH-AVAILABILITY DATABASE FOR

REAL-TIME, MISSION-CRITICAL

PPLICATIONS

HIGHLIGHTS

!"

Five 9s availability

!"

Subsecond failover

!"

Self-healing recovery

!"

High throughput, real-time read
and write performance

!"

Dynamic, online scalability

!"

Automatic load balancing

!"

Flexible data access

!"

Low TCO

“MySQL Cluster Carrier Grade
Edition is a product of high
quality, extremely robust and
meets our demands in terms of
performance and high
availability. We evaluated
shared-disk clustered databases
but the cost would have been at
least 10 times more.”

—Alain Chastagner,

Systems Manager,

Alcatel-Lucent

Whether you’re racing to introduce a new service or trying to manage an avalanche of data in

real time, your database has to be scalable, fast, and highly available to meet ever-changing

market conditions and stringent service-level agreements (SLAs).

MySQL Cluster is the industry’s only true real-time database that combines the flexibility of a

high-availability relational database with the low total cost of ownership (TCO) of open

source. It features a shared-nothing distributed architecture with no single point of failure to

ensure five 9s availability, allowing you to meet your most demanding mission-critical

application requirements. Its real-time design delivers consistent millisecond response latency

with the ability to service tens of thousands of transactions per second. Support for in-memory

and disk-based data, automatic data partitioning with load balancing, and the ability to add

nodes to a running cluster with zero downtime enables almost unlimited database scalability to

handle your most unpredictable workloads.

Low Total Cost of Ownership

MySQL Cluster requires no additional infrastructure, such as shared storage, and runs on a

range of commodity hardware and operating system (OS) platforms, making it the most open

and cost-effective database solution for mission-critical applications anywhere.

Proven Deployments

The benefits of MySQL Cluster have been realized in the most demanding data management

environments in the finance, telecommunications, Web, and government sectors, for

companies and organizations such as Alcatel-Lucent, Cisco, Ericsson, Juniper, Shopatron,

Telenor, UTStarcom, and the United States Navy.

Together with Oracle’s global training, consulting, and technical support services, MySQL

Cluster can help ensure the success of your next mission-critical service with greater speed,

lower cost, and less risk.

Figure 1. The MySQL Cluster architecture has been designed for five 9s availability and delivers
massive read/write scalability.

ORACLE DATA SHEET

ORACLE DATA SHEET

KEY FEATURES OF MYSQL CLUSTER
CARRIER GRADE EDITION

!"

Real-time transactional database

!"

ACID compliant

!"

Distributed shared-nothing design

!"

Multi-master database with parallel
architecture

!"

Online addition of nodes

!"

Online maintenance and schema
updates

!"

Automatic synchronous replication

!"

Geographic replication

!"

In-memory and disk-based data storage

!"

Online backup

!"

Data and index cache

!"

Configurable checkpoints

!"

SQL access

!"

Native C++, Java, OpenJPA, LDAP, and
HTTP interfaces

!"

Automatic and user-defined partitioning

TARGET APPLICATIONS

!"

Authentication, Authorization, and
Accounting (AAA) / RADIUS / Diameter
data stores

!"

Application servers

!"

Data stores for LDAP directories

!"

Domain Name System (DNS) / Dynamic
Host Configuration Protocol (DHCP) for
broadband access

!"

E-commerce databases

!"

IP Multimedia Subsystem (IMS) services

!"

Intelligent network nodes

!"

Location-based services

!"

Message stores and queues

!"

Mobile content delivery

!"

Online application stores and portals

!"

Online gaming

!"

Payment gateways

!"

Presence management

!"

Service delivery platforms

!"

Softswitches

!"

Subscriber databases (Home Location
Register (HLR) / Home Subscriber
Server (HSS)

!"

VoIP, IPTV, and video on demand

!"

Web session management

Five 9s Availability

The architecture of MySQL Cluster is designed for five 9s availability, eliminating both

planned and unplanned downtime. It achieves this via a distributed, shared-nothing

architecture and synchronous replication of data that automatically propagates transaction

information to all appropriate database nodes and replicas.

Subsecond Failover and Recovery

Any failures are detected instantly and control is automatically failed over to other nodes in

the cluster, without interrupting service to the clients. Plus, MySQL Cluster database nodes

can automatically restart, recover, and dynamically reconfigure themselves in case of failures.

The MySQL Cluster self-healing features are completely transparent to all applications.

To further support continuous operation, MySQL Cluster enables the dynamic addition of

nodes to running clusters, online updates to live database schema, and upgrades and

maintenance of the cluster’s underlying hardware and software infrastructure.

Geographic Replication

The ability to withstand site failures by replicating clusters across multiple remote locations is

an important capability for many deployments. Geographic replication is available as part of

MySQL Cluster Carrier Grade Edition and is ideally suited to those organizations with

multiple datacenters.

Figure 2. Geographic replication delivers five 9s cluster availability across remote locations and can be
used to replicate data to in real time to other MySQL storage engines for reporting applications.

Real-Time, High-Throughput Performance

With its real-time design, MySQL Cluster provides the response time needed to meet the

needs of demanding applications. MySQL Cluster limits I/O bottlenecks by asynchronously

writing transaction logs to disk, thereby achieving predictable response times in just a few

milliseconds. As a multi-master database with a parallel architecture, MySQL Cluster ensures

write requests are distributed across all data nodes#delivering the very high levels of write

throughput and scalability demanded by transactional workloads. In addition, MySQL Cluster

can leverage many MySQL or Application nodes running in parallel, with each node handling

multiple connections, thus providing support for high-concurrency transactional applications.

2