Thanks, awesome site.

MySQL Cluster was first released in November 2004, in MySQL 4.1 - that’s a pretty mature nine-year old! There is a ton of information about it on the Internet, on topics like how to setup a good minimal cluster, how to distribute the nodes, the kind of hardware that is appropriate for each node type, etc. We published our MySQL Cluster training slides sometime back. However, despite all that information, we still see many testers who do not get the basics right.
In this blog, we will see what a good MySQL Cluster setup looks like.

MGM Node -  holds the configuration for MySQL Cluster in a file called config.ini. It also writes a cluster log, and takes part in arbitration to prevent split-brain or network partitioning.
You are recommended to have two MGM Nodes for redundancy. Since MGM hardly use any resources, and is not involved …

Percona Live London wrapped up last week to very positive reviews from attendees and sponsors like those from Johan De Meersman.

Percona was pleased to provide an engaging event for MySQL community members that featured engaging tutorials, highly rated breakout sessions, a very well-attended Tuesday community networking reception sponsored by Clustrix, and keynotes from a variety of industry experts:

• Peter Zaitsev, Percona
• Monty Widenius, Monty Program Ab
• Robert Hodges, Continuent
• Frank Terburg, Clustrix

We were pleased to see such a varied and all inclusive group of MySQL community members in attendance. A few facts about the attendees:

• 52% were from the United Kingdom and 35% were from other parts of Europe that included representatives from countries including Finland, The Netherlands, …

Screenings, shows, premieres and parties. Where the stars have been spotted this week? No not on the red carpet in LA, but in this Log Buffer Edition. In Log Buffer #299, stars of Oracle, SQL Server and MySQL are twinkling. Get mesmerized!!! Oracle: Pythian’s very own Marc Fielding is revealing the hints behind the Automatic...

It’s been a while since I posted about Day 1 and Day 2 of the MySQL for Beginners online Training on Demand course offered by Oracle (http://education.oracle.com).  Yesterday was 90 days from the first posting, so that’s how long you would have had to use this course!  I finished up and will post about day 3 and day 4 (including extras) separately.

Day 3 is a whirlwind tour of some further aspects of SQL.  Here’s what it covers:

Introduction to Data Manipulation Language (DML) in SQL
- introduces INSERT, REPLACE, UPDATE and DELETE statements and their syntax and uses

Intro to Functions
- string functions, temporal, numeric, control flow and aggregate functions

Intro to Joins
- describes cartesian, inner, and outer joins – their syntax and uses

Intro to Subqueries
- types and placements of …

The new MySQL 5.6.5 Development Milestone Release (DMR) introduces a much anticipated feature - Global Transaction Identifiers (GTIDs) for MySQL replication. GTIDs make it simple to track and compare replication progress between the master and slave servers. This enables much simpler recovery from failures of the master, while also introducing great flexibility in the provisioning and on-going management of multi-tier or ring (circular) replication topologies.

The MySQL 5.6 Release Candidate is an aggregation of the previous MySQL 5.6 Development Milestone Releases ("DMR") and provides a true functional image of what we hope will soon be the generally available ("GA"), production-ready 5.6 product. At a glance, 5.6 is simply a better MySQL with across the board improvements that hit every functional area of the database kernel, bringing benefits whether you deploy on-premise or in the cloud.

Learn how easy it is to deploy a MySQL Cluster database that has been configured to best meet your application's needs within your environment. See how the installer automatically detects the resources available on your target hosts and then combines that with the application requirements that you specify in order to produce a tailored configuration. The tutorial will then demonstrate the installer pushing this configuration to the target machines and starting the process that make up the system.

Learn how to use MySQL 5.6 and the MySQL Utilities to setup, monitor and manage your MySQL replication topology. See how a single command can be used to add replication slaves. See for yourself how easy it is to use the utilities to continually monitor the replication master and then automatically promote the most appropriate slave in the event of a failure. For those who prefer more user control, the monitoring can run in an alert-only mode and you'll learn how you can manually initiate failover using a single command.

The momentum behind Galera is strong, as you can see on mailing lists1 or the standing room only lectures at Percona Live UK. If you follow the buzz you can also see that the discussion is increasingly turning from first time evaluations into people actually running Galera in production. This blog post is based on those experiences that people have shared on the Galera mailing list. I hope to provide some tips and best practices that will be helpful to you when migrating your existing MySQL database to a Galera Clustered HA setup.

MyISAM

MySQL got transactional storage engines in 2001, yet surprisingly many people still run with MyISAM tables. Well, it's …