This is the 8th installment in the rather long series that started with Part 1 about a month ago.

Back in 2006, we were in the situation where MySQL 5.0 had taken forever, and the first “GA” release was not suitable for production. Looking towards MySQL 5.1, it was also unlikely to be out any time soon. The MySQL Cluster team had customers that needed new features in a stable release. The majority of users didn’t use the MySQL server at all, they directly used the C++ NDB API for the vast majority of queries – so the vast majority of release blocker bugs in the MySQL server would not affect the production readiness of MySQL Cluster for these customers.

So, the decision was wisely made to do separate releases from a separate tree for MySQL Cluster. This was named MySQL Cluster: …

Lets start by considering a scenario where records are being inserted in a single auto-increment table via different nodes of a multi-master cluster. One issue that might arise is ‘collision’ of generated auto-increment values on different nodes, which is precisely the subject of this article.

As the cluster is multi-master, it allows writes on all master nodes. As a result of which a table might get same auto-incremented values on different nodes on INSERTs. This issue is discovered only after the writeset is replicated and that’s a problem!

Galera cluster suffers with the similar problem.

Lets try to emulate this on a 2-node Galera cluster :

1) On node #1:

MariaDB [test]> CREATE TABLE t1(c1 INT AUTO_INCREMENT PRIMARY KEY, c2 INT)ENGINE=InnoDB;
Query OK, 0 rows affected (0.07 sec)

MariaDB [test]> START TRANSACTION;
Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> INSERT INTO t1(c2) VALUES (1);
Query …

MySQL Cluster is a highly resilient and scalable database platform designed to deliver 99.999% availability with features such as self-healing and online operations, and capable of performing over 1,00,000,000 updates per minute. The full feature set includes development and management platforms alongside monitoring and administration tools, all backed by Oracle Premier Lifetime Support.

To learn more about MySQL Cluster, consider taking the MySQL Cluster training. Events already on the schedule for this 3-day instructor-led course include:

MySQL Cluster is a technology providing shared-nothing clustering and auto-sharding for the MySQL database management system. It is designed to provide high availability and high throughput with low latency, while allowing for near linear scalability.

To learn more about MySQL Cluster, take the 3-day MySQL Cluster training course. Below is a selection of events already on the schedule for this course.

Join Web and Telecom companies who have adopted MySQL Cluster to facilitate application in the following areas:

Web:

• High volume OLTP
• eCommerce
• User profile management
• Session management and caching
• Content management
• On-line gaming

Telecoms:

• Subscriber databases (HLR/HSS)
• Service deliver platforms
• VAS: VoIP, IPTV and VoD
• Mobile content delivery
• Mobile payments
• LTE access

To come up to speed on MySQL Cluster, take the 3-day MySQL Cluster training course. Events already on the schedule include:

The CONNECT Storage engine implement the concept of a table made of multiple tables. These underlying tables can be distributed remotely. For example the underlying remote tables can be of ODBC or MySQL table type. this allows to execute distributed queries. What is nice is that we can execute this distributed query with parallelism.

How [...]

Continuent is proud to sponsor The OpenStack Summit, November 5-8, at the AsiaWorld Expo in Hong Kong! Don't miss this presentation by Edward Archibald:

Deploying a Highly-Available Database-as-a-Service in OpenStack

In his talk, Edward Archibald, CTO at Continuent, will demonstrate the ease of deploying a multi-site, highly-available, scalable Database-as-a-Service across two OpenStack

MySQL Fabric is a very promising sharding framework. If I take Ulf Wendel definition of MySQL Fabric :

MySQL Fabric is an administration tool to build large “farms” of MySQL servers. In its most basic form, a farm is a collection of MySQL Replication clusters. In its most advanced form, a farm is a collection of [...]

Emphasis on clustering solutions comes up quite a lot when talking to customers about High Availability. The reason is because clustering is supposed to provide an easier solution for maintaining high availability and so that you do not have to rely on other tools and techniques outside of the database server. I thought it would be good to share the gist of many of my discussions around clustering, in the form of a blog post. So here I will be doing a high-level comparison between MySQL NDB Cluster and Percona XtraDB Cluster.

The post Percona XtraDB Cluster – A Drop-in-place Clustering Solution for MySQL appeared first on ovais.tariq.

For those looking for extreme real-time performance, high availability and speed, consider MySQL Cluster.

In the MySQL Cluster training, within 3 days, you learn to:

• Describe the different nodes in MySQL Cluster
• Install, start and stop nodes
• Understand and work with configuration files
• Upgrade a cluster
• Explain node failure and understand how restart works
• Configure the cluster for optimal performance

Here is a selection of the events currently scheduled for this live instructor-led course: