Mysql Cluster
MySQL Cluster
The Leading Open Source, High Availability Database
for Real-Time, Mission Critical Applications
“MySQL Cluster Carrier Grade
Whether you’re racing to introduce
a new service, or trying to manage
H I G H L I G H T S
Edition is a product of high
an avalanche of data in real time,
quality, extremely robust and
your database has to be scalable,
99.999% Availability
meets our demands in terms of
fast and highly available to meet
Sub-Second Fail-Over
ever-changing market conditions
performance and high availability.
and stringent SLAs.
Self Healing Recovery
We evaluated shared-disk clus-
MySQL Cluster is the industry’s
Real-Time Performance
tered databases but the cost would
only true real-time database that
Dynamic, On-Line Scalability
combines the flexibility of a high
have been at least 10x more.”
availability relational database
Automatic Load Balancing
Alain Chastagner
with the low TCO of open source.
Systems Manager, Alcatel-Lucent
It features a “shared-nothing”
Flexible Data Access
distributed architecture with no
Low TCO
single point of failure to assure
“Since deploying MySQL Cluster
99.999% availability, allowing
as our eCommerce database, we
you to meet your most demanding
mission-critical application require-
and cost-effective database solution
have had continuous uptime with
ments. Its real-time design delivers
for mission critical applications
linear scalability enabling us to
consistent, millisecond response
anywhere.
exceed our most stringent SLAs”
latency with the ability to service
tens of thousands of transactions
Proven Deployments
Sean Collier
per second. Support for in-memory
CIO & COO, Shopatron Inc.
and disk based data, automatic data
The benefits of MySQL Cluster have
partitioning with load balancing
been realized in the most demand-
and the ability to add nodes to a
ing data management environments
running cluster with zero downtime
in the telecommunications, web,
allows almost unlimited database
finance and government sectors,
scalability to handle your most
for the likes of Alcatel-Lucent,
unpredictable workloads.
Cisco, Ericsson, Juniper, Shopatron,
Telenor, UTStarcom and the United
States Navy.
Low TCO
Together with Sun’s global training,
MySQL Cluster requires no addi-
consulting and technical support
tional infrastructure, such as shared
services, MySQL Cluster can help
storage, and runs on a range of
ensure the success of your next
commodity hardware and OS
mission-critical service with greater
platforms, making it the most open
speed, lower cost, and less risk.
M y S Q L
C L U S T E R
99.999% Availability
To further support continuous
TARGET APPLICATIONS
The architecture of MySQL Cluster
operation, MySQL Cluster allows
is designed for 99.999% availabili-
nodes to be added dynamically to
AAA / RADIUS / Diameter
ty, eliminating both planned and
running clusters, on-line updates to
Data Stores
unplanned downtime. It achieves
live database schema, in addition
Application Servers
this via a distributed, shared-noth-
to upgrades and maintenance of the
Data Stores for LDAP
ing architecture and synchronous
underlying hardware & software
Directories
replication of data which auto-
infrastructure of the cluster.
matically propagates transaction
DNS/DHCP for Broadband
information to all appropriate
Geographic Replication
Access
database nodes and replicas.
The ability to withstand site failures
eCommerce Databases
by replicating clusters across multi-
IMS Services
Sub-Second Failover & Recovery
ple remote locations is an important
capability for many deployments.
Intelligent Network Nodes
Any failures are detected instantly
Geographic Replication is available
Location Based Services
and control is automatically failed
as an option with MySQL Cluster
over to other nodes in the cluster,
Carrier Grade Edition (CGE), and
Message Stores and Queues
without interrupting service to the
ideally suited to those organizations
Mobile Content Delivery
clients. Plus, MySQL Cluster data-
with multiple data centers.
base nodes are able to automatical-
On-Line Application Stores
ly restart, recover, and dynamically
Through these capabilities, MySQL
and Portals
reconfigure themselves in case of
Cluster is able to eliminate both
On-Line Gaming
failures. The MySQL Cluster self-
planned maintenance and
Payment Gateways
healing features are completely
unplanned downtime in order
transparent to all applications.
to support your most mission
Presence Management
critical applications.
Service Delivery Platforms
Soft-Switches
Subscriber Databases
(HLR / HSS)
VoIP, IPTV & Video on
Demand
Web Session Management
The MySQL Cluster architecture has been designed for 99.999%
availability and delivers massive read/write scalability
Key Features of MySQL
Cluster Carrier Grade Edition
Real-Time Transactional Database
ACID Compliant
Distributed Shared Nothing
Architecture
Online Addition of Nodes
On-Line Maintenance &
Geographic Replication delivers 99.999% cluster availability across remote locations
Schema Updates
Automatic Synchronous
Replication
Real-Time Performance
To further enhance scalability,
Sub-Second Fail-Over and
With its real time design, MySQL
MySQL cluster lets developers and
Self Healing Recovery
Cluster provides the response time
DBAs refine access through user-
In-Memory and Disk-Based
and throughput needed to meet
defined partitioning, thus allowing
Data Storage
the needs of the most demanding
data to be efficiently accessed on
telecommunications, web and
a single node, without the need for
Online Backup
enterprise applications. MySQL
inter-communication within the
Data and Index Cache
Cluster limits I/O bottlenecks by
cluster to perform a transaction
asynchronously writing transaction
or a look-up.
Configurable Checkpoints
logs to disk, thereby achieving
Using these capabilities, organiza-
SQL Access
predictable response times in just
tions have been able to quickly
Native NDB API Access (C/C++)
a few milli-seconds, while also
and cost effectively achieve linear
handling tens of thousands of
scalability to support the rapid
User-Defined Partitioning
transactions per second, without
adoption of new services, without
Geographical Replication
compromising reliability or
having to re-architect the under-
availability.
lying database solution.
Data Store for LDAP Directories
Dynamic, Linear Scalability
Flexible Data Access
To support growth in users, data
Application developers can easily
and transactions, MySQL Cluster
integrate new and legacy applica-
provides a cost-effective way to
tions using their preferred database-
scale both processing and data
independent method. MySQL
storage. With support for up to 255
Cluster CGE provides multiple data
nodes, MySQL Cluster users can
access methods that work together.
start small and make incremental
These include SQL, native APIs
investments as services scale up
(C and C++), Java, LDAP, and
and requirements increase. Simply
Web Services.
add cluster nodes on-line to support
This allows developers to select the
increases in concurrent users and
data access method that best fits
transactions, or to expand data
there development and application
capacity. Plus MySQL Cluster
requirements. It also allows a single
enhances flexibility by supporting
instance of MySQL Cluster to
disk-based data for space-intensive
service a range of applications that
objects such as BLOBs.
previously would have required
their own local database.
The World’s Most Popular Open Source Database
M y S Q L
C L U S T E R
Open Source Economics
Sample List of MySQL Cluster Customers
MySQL Cluster is an open source
high availability database solution
Alcatel-Lucent
Paggo
that allows developers to down-
AT&T Wireless
Plusnet
load and start building their next
Cisco
Shopatron
generation services without the
Deutsche Telekom
SPEECH DESIGN
usual costs and time-to-market
Ericsson
T-Mobile
delays associated with adopting
France Telecom
Telenor
proprietary clustered databases.
HP
Toto-Lotto Niedersachsen
24x7 technical support services,
Italtel
University of California Berkeley
consulting services and affordable
Juniper Networks
US Navy
licensing for MySQL Cluster are all
M1
UTStarcom
available at a fraction of the cost
Mapion
Zillow
of proprietary solutions.
Motorola
8x8 Inc
Services and Support
System Requirements per MySQL Cluster Data Node
MySQL provides extensive consult-
(Recommended)
ing, training and technical support
services to ensure the success of
OS
Linux (Red Hat, SuSE), Solaris
any mission-critical database proj-
Note: Mac OS X & Microsoft Windows for Development Only
ect. Through millions of successful
CPU
Intel & AMD x86, Sun UltraSPARC
customer deployments, MySQL
Memory
16GB+ RAM (1GB Minimum)
has established a proven track
HDD
18GB+ (3GB Minimum)
record of supporting its customers,
lowering risks and maximizing
Network
Gigabit Ethernet. For 8 nodes or more, dedicated MySQL Cluster
return on investment. Our support
Interconnect, e.g. SCI, recommended for maximum scalability
teams are ready to assist in the
development, deployment,
and management of MySQL
Learn More
applications.
Visit www.mysql.com/cluster for additional resources, including
whitepapers, on-demand webinars and customer case studies.
To learn more about how MySQL Cluster is used by Network Equipment
Manufacturers, ISVs and Communications Service Providers, visit
www.mysql.com/communications
About MySQL
MySQL is the most popular open source database software in the world. Many of the
world’s largest and fastest-growing organizations use MySQL to save time and money
powering their high-volume Web sites, critical business systems, communications
networks, and commercial software. At www.mysql.com, Sun provides corporate
users with premium subscriptions and services, and actively supports the large
MySQL open source developer community.
The World’s Most Popular Open Source Database
Copyright © 2009, Sun Microsystems. Sun, Sun Microsystems, the Sun logo, Java, MySQL, MySQL Enterprise, and The Network Is The Computer are trademarks or registered trademarks of Sun Microsystems, Inc. or its subsidiaries in the United States and other countries.
