Users Conference 2011 - Cluster Tutorial

Tweet I will be at the MySQL UC representing Severalnines AB. Together with my friends at SkySQL (Max and Joffrey) we will have have a joint tutorial on MySQL Cluster. You will learn MySQL Cluster and we will do hands-on examples and present best practices to make your deployment easier. This also provides an excellent opportunity to discuss your requirements and get input and feedback on your database design.

Also, if you are in the area and want to discuss MySQL Cluster, high availability, scalability issues, email me at johan@severalnines.com and we can organize a meeting.

Web and Telco mode Cluster Configuration

Tweet The Core Scripts (aka Configurator) for MySQL Cluster has now been updated with a new feature that allows you to tune cluster for a particular workload.
Currently there are two types of workloads supported:

• Web
• Telco/Realtime

The Web workload is suitable for applications:

• with long running transactions (scans, joins and/or large updates)
• reading and especially writing of large chunks (BLOBs) of data where an "innodb" like behavior is wanted.
  

The Telco workload is suitable for realtime applications with:

• requirements on response times
• requirements on failover times
• short but many parallel request primarily on PK
  

Buffers and timeouts are geared towards each workload. Some of it you can read more about here.

The Telco workload is also suitable for many kinds of applications in for example the following domains:

• Finance,
• Online gaming
• Subscriber databases
• Session management

If you don't know what is most suitable for you, please contact Severalnines and we help you.