Category Archives: NDB Cluster

Heterogeneous replication with NDB cluster

Posted on April 16, 2009 by Yves Trudeau

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

Social networking type queries with NDB (part 3)

Posted on April 2, 2009 by Yves Trudeau

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

Upcoming webinar on NDB Cluster 7.0 new features

Posted on April 1, 2009 by Yves Trudeau

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

The upcoming MySQL UC 2009

Posted on March 24, 2009 by Yves Trudeau

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!

Posted on March 19, 2009 by Yves Trudeau

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)

Posted on March 16, 2009 by Yves Trudeau

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

Posted on March 13, 2009 by Yves Trudeau

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)

Posted on March 11, 2009 by Yves Trudeau

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

Posted on March 11, 2009 by Yves Trudeau

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

Using local tables and replication in a clever way with NDB

Posted on March 2, 2009 by Yves Trudeau

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