Those are the topics we cover in the latest episode of our “Meet The MySQL Experts” podcast.
Mat Keep and Bernd Ocklin talk about new database requirements, and walk us through what's new in the second Development Milestone Release of MySQL Cluster 7.2, including impressive performance improvements, new NoSQL access via memcached, cross data center scalability, and more...
Those are the topics we cover in the latest episode of our “Meet The MySQL Experts” podcast.
Mat Keep and Bernd Ocklin talk about new database requirements, and walk us through what's new in the second Development Milestone Release of MySQL Cluster 7.2, including impressive performance improvements, new NoSQL access via memcached, cross data center scalability, and more...
In my previous posts I introduced two new conflict detection
functions, NDB$EPOCH and NDB$EPOCH_TRANS without explaining how
these functions actually detect conflicts? To simplify the
explanation I'll initially consider two circularly replicating
MySQL Servers, A and B, rather than two replicating Clusters, but
the principles are the same.
Commit ordering
Avoiding conflicts requires that data is only modified on one
Server at a time. …
In my last post I described the motivation for the new NDB$EPOCH
conflict detection function in MySQL
Cluster. This function detects when a row has been
concurrently updated on two asynchronously replicating MySQL
Cluster databases, and takes steps to keep the databases in
alignment.
With NDB$EPOCH, conflicts are detected and handled on a row
granularity, as opposed to column granularity, as this is the
granularity of the epoch metadata used to detect conflicts.
Dealing with conflicts on a …
70x Higher Performance, Cross Data Center Scalability and New NoSQL Interface
Its been an exciting week for all involved with MySQL Cluster, with the announcement of the second Development Milestone Release (7.2.1) at Oracle Open World. Highlights include:
- Enabling next generation web services: 70x higher complex query performance, native memcached API and integration with the latest MySQL 5.5 server
- Enhancing cross data scalability: new multi-site clustering and enhanced active/active replication
- Simplified provisioning: consolidated user privileges.
You can download the DMR for evaluation now from: http://dev.mysql.com/downloads/cluster/ (select Development Milestone Release tab).
You …
[Read more]70x Higher Performance, Cross Data Center Scalability and New NoSQL Interface
Its been an exciting week for all involved with MySQL Cluster, with the announcement of the second Development Milestone Release (7.2.1) at Oracle Open World. Highlights include:
- Enabling next generation web services: 70x higher complex query performance, native memcached API and integration with the latest MySQL 5.5 server
- Enhancing cross data scalability: new multi-site clustering and enhanced active/active replication
- Simplified provisioning: consolidated user privileges.
You can download the DMR for evaluation now from: http://dev.mysql.com/downloads/cluster/ (select Development Milestone Release tab).
You …
[Read more]
Well actually….no. The second Development Milestone Release of MySQL Cluster 7.2 introduces support for what we call “Multi-Site Clustering”. In this post, I’ll provide an overview of this new capability, and considerations you need to make when considering it as a deployment option to scale geographically dispersed database services.<?xml:namespace prefix = o />
You can read more about MySQL Cluster 7.2.1 in the article posted on the MySQL Developer Zone.
MySQL Cluster has long offered Geographic Replication, distributing clusters to remote data centers to reduce the affects of geographic latency by pushing data closer to the user, as well as providing a capability for disaster recovery.
…
[Read more]
Well actually….no. The second Development Milestone Release of MySQL Cluster 7.2 introduces support for what we call “Multi-Site Clustering”. In this post, I’ll provide an overview of this new capability, and considerations you need to make when considering it as a deployment option to scale geographically dispersed database services.<?xml:namespace prefix = o />
You can read more about MySQL Cluster 7.2.1 in the article posted on the MySQL Developer Zone.
MySQL Cluster has long offered Geographic Replication, distributing clusters to remote data centers to reduce the affects of geographic latency by pushing data closer to the user, as well as providing a capability for disaster recovery.
…
[Read more]
tl;dr : New 'automatic' optimistic conflict detection functions
available giving the best of both optimistic and pessimistic
replication on the same data
MySQL replication supports a number of topologies, and one of the
most interesting is an active-active, or master-master topology,
where two or more Servers accept read and write traffic, with
asynchronous replication between them.
This topology has a number of attractions, including :
…
[Read more]Databases are the center of today’s web, enterprise and embedded applications, storing and protecting an organization’s most valuable assets and supporting business-critical applications. Just minutes of downtime can result in significant lost revenue and dissatisfied customers. Ensuring database highly availability is therefore a top priority for any organization.
The new MySQL Guide to High Availability solutions is designed to navigate users through the HA maze, discussing:
- The causes, effects and impacts of downtime;
- Methodologies to select the right HA solution;
- Different approaches to delivering highly available MySQL services;
- Operational best practices to meet Service Level Agreements (SLAs).
As discussed in the new Guide, selecting the high availability solution …
[Read more]