Showing entries 31 to 40 of 266
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: cluster (reset)
Auto increments in Galera

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); …
[Read more]
MySQL Cluster is a Resilient and Scalable Database Platform

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:

 Location

 Date

 Delivery …

[Read more]
MySQL Cluster, Shared-Nothing Clustering and Auto-Sharding

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.

 Location

 Date

 Delivery Language

 Berlin, Germany

 10 …

[Read more]
Join Companies in Web and Telecoms by Adopting MySQL Cluster

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:

[Read more]
MariaDB CONNECT Storage Engine and parallelism

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 Tungsten at The OpenStack Summit HK

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 with MariaDB Galera Cluster ?

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 [...]

Percona XtraDB Cluster – A Drop-in-place Clustering Solution for MySQL

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.

Extreme Real-Time Performance With MySQL Cluster

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:

 Location

 Date

[Read more]
How Marketo solved key data management challenges with Continuent Tungsten

Marketo provides the leading cloud-based marketing software platform for companies of all sizes to build and sustain engaging customer relationships. Marketo's SaaS platform runs on MySQL and has faced data management challenges common to all 24x7 SaaS businesses:

Keeping data available regardless of DBMS failures or planned maintenance Utilizing hardware optimized for multi-terabyte MySQL

Showing entries 31 to 40 of 266
« 10 Newer Entries | 10 Older Entries »