Category Archives: HA

MySQL High availability with VCS cluster

At MySQL/Sun we do a lot of high availability setup using Heartbeat but recently I was involved, along with Harold Mayfield (a VCS expert), in project using Symantec VCS on Solaris. Of course, MySQL works perfectly well with VCS, here … Continue reading

Posted in HA, mysql, yves | Comments Off on MySQL High availability with VCS 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)

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 realtime options, choosing CPU and balancing interrupts

With the NDB realtime options, you can choose on which CPU the execution thread and the maintenance will be running. The point is, which CPUs to use. The output of “cat /proc/interrupts” will help you determine which CPU to use. … Continue reading

Posted in HA, mysql, NDB Cluster, yves | Comments Off on NDB realtime options, choosing CPU and balancing interrupts

Waffle Grid: Testing Waffle With Dolphin Interconnects

Let’s grab your attention with a shameless marketing ploy:  How would you like up to a 14X performance boost in your Mysql database performance? Now your hooked who wouldn’t want a 14x boost?  Well we got that using Dolphin interconnects … Continue reading

Posted in HA, hardware, mysql, performance, Waffle Grid | 1 Comment

Active-Active MySQL ( Microsoft Style )…

For those unfamiliar with SQL Server clustering let me give you a quick blurb.  Microsoft markets SQL Server as having active-active clustering.  When most people hear active/active or clustering in the database they generally immediately think of features like Oracle … Continue reading

Posted in HA, linux, mysql | Comments Off on Active-Active MySQL ( Microsoft Style )…

Heartbeat, Debug and SIGXCPU

Had a frantic email from a client today. We deployed a complex custom Heartbeat/replication solution several months ago. Recently the master server was failing over to slave. Bad news all around. Take a look here at the lovely log: heartbeat[23799]: … Continue reading

Posted in HA, linux | Comments Off on Heartbeat, Debug and SIGXCPU