Category Archives: NDB Cluster

Heterogeneous replication with NDB cluster

Recently, I was asked if it is possible to replicate an NDB cluster to a non-NDB MySQL database. So, I tried! I created the following table on the MySQL master: Create Table: CREATE TABLE `testrepl` ( `id` int(11) NOT NULL, … Continue reading

Posted in mysql, NDB Cluster, yves | Comments Off on Heterogeneous replication with NDB cluster

Social networking type queries with NDB (part 3)

In the previous 2 posts of this series, we basically talked about how to execute social networking type queries using SQL IN clause and how handle multiple columns IN clause. In this last post on the topic, I will introduce … Continue reading

Posted in HA, mysql, NDB Cluster, yves | Comments Off on Social networking type queries with NDB (part 3)

Upcoming webinar on NDB Cluster 7.0 new features

I just learned that there will be a Webinar “What’s New in the Next Generation of MySQL Cluster?”, April 30th. From what I know, the webinar is supposed to be at a good technical level, it is not a marketing … Continue reading

Posted in mysql, NDB Cluster, yves | Comments Off on Upcoming webinar on NDB Cluster 7.0 new features

The upcoming MySQL UC 2009

The MySQL UC 2009 is coming and it is time for my own little marketing. As Matt already annonced it a few months ago we (Matt and I) are doing a WaffleGrid presentation, Distributed InnoDB caching with Memcached, Tuesday at … Continue reading

Posted in mysql, NDB Cluster, Waffle Grid, yves | 1 Comment

NDB Cluster one step closer to become a DB killer app!

If you have been following the development of the NDB Cluster storage engine lately, you are probably as excited as I am. NDB Cluster is becoming a kind of large database killer app. Look at all the nice features that … Continue reading

Posted in HA, mysql, NDB Cluster, yves | 2 Comments

Social networking type queries with NDB (part 2)

Recently, I talked about how to optimize social networking type queries for the NDB storage engine using IN clause statements. In clauses are great but they have one fundamental limitation, they work only on one column (Actually, this is not … Continue reading

Posted in HA, mysql, NDB Cluster, yves | 4 Comments

High performance replacement of the MySQL Memory storage engine with NDB

People often wants to use the MySQL memory engine to store web sessions or other similar volatile data. There are good reasons for that, here are the main ones: Data is volatile, it is not the end of the world … Continue reading

Posted in HA, mysql, NDB Cluster, yves | 10 Comments

Social Networking type queries with NDB (part 1)

NDB Cluster is the only integrated sharding framework that I know of (educate me if I am wrong) but it is known to have issues with large joins. These days, large databases that would benefit from a sharding framework are … Continue reading

Posted in HA, mysql, NDB Cluster, performance, yves | 6 Comments

NDB cluster and Max_connections

NDB cluster is a strange beast. Usually, performance wise, it is a good idea to limit the number of threads inside MySQL, that’s why there are parameters like thread_concurrency and innodb_thread_concurrency. MySQL is known to show mutexes contention with a … Continue reading

Posted in mysql, NDB Cluster, yves | Comments Off on NDB cluster and Max_connections

Using local tables and replication in a clever way with NDB

Tuning queries for MySQL NDB cluster is way trickier than tuning for any other storage engines. This is especially true for highly normalized schema. Look at the following query trying to retrieve all male account from a given city. Since … Continue reading

Posted in mysql, NDB Cluster, yves | Comments Off on Using local tables and replication in a clever way with NDB