On Thursday 17th July I’ll be hosting a webinar which explains what MySQL Clusrter is, what it can deliver and what the latest developments are. As always the webinar is free but please register here.

Details:

Join this technical webinar to learn how MySQL Cluster 7.3, the latest GA release, enables developer agility by making it far simpler and faster to build your products and web-based applications with MySQL Cluster. You’ll also learn how MySQL Cluster and its linear scalability, 99.999% uptime, real-time responsiveness, and ability to perform over 1 BILLION Writes per Minute can help your products and applications meet the needs of the most demanding markets. MySQL Cluster combines these …

The binary and source versions of MySQL Cluster 7.3.6 have now been made available at http://www.mysql.com/downloads/cluster/.

Release notes

MySQL Cluster NDB 7.3.6 is a new release of MySQL Cluster, based
on MySQL Server 5.6 and including features from version 7.3 of the
NDB storage engine, as well as fixing a number of recently
discovered bugs in previous MySQL Cluster releases.

Obtaining MySQL Cluster NDB 7.3. MySQL Cluster NDB 7.3 source
code and binaries can be obtained from
http://dev.mysql.com/downloads/cluster/.

For an overview of changes made in MySQL Cluster NDB 7.3, see
MySQL Cluster Development in MySQL Cluster …

InfiniDB High Performance Analytic Query Engine for MySQL and SQL-on-Hadoop Powers Faster Data Access and Insights with Tableau Software

Get the best from both worlds with bundled packages: a training course and a certification exam voucher. You save 20% when you buy training and certification in discount packages.

Training helps you acquire product expertise. Certification proves this expertise to your future employers.

There are two MySQL Discount Packages: MySQL Database Administration and MySQL Developer.

For more information about the authentic MySQL curriculum, go to …

Mon, 2014-07-14 08:30anderskarlssonIntroduction

This is an introduction to MariaDB Replication and to why we need a binlogs server and what this is. The first part is an introduction to replication basics, and if you know this already, then you want want to skip past the first section or two.

MariaDB Replication

MySQL and MariaDB has a simple but very effective replication system built into it. The replication system is asynchronous and is based on a pull, instead of a push, system. What this means in short is that the Master keeps track of the DML operations and other things that might change the state of the master database and this is stored in what is called the binlog. The slave on the other hand is responsible for getting the relevant information from the master to keep up to speed. The binlogs consist of a number of files that the master generates, and the traditional way of dealing with slaves is to point them to …

Presentations/VideosConferencesGeneral

At the 2008 MySQL Conference and Expo, the closing keynote was Jacek Becla speaking on The Science and Fiction of Petascale Analysis. See the slides on the O'Reilly Conference Site, and the Official Conference Description

MySQL's support of the BINARY and VARBINARY data type is good, and the BINARY and VARBINARY data types are good things. And now the details. What applies here for MySQL applies for MariaDB as well.

Who supports VARBINARY

There's an SQL:2008 standard optional feature T021 "BINARY and VARBINARY data types". Our book has a bigger description, but here is one that is more up to date:

Call for papers for Percona Live London 2014 is open. For the fourth consecutive year, PLUK is going to be one of the best community event in Europe.
I have the honour of being conference committee chairman and the hard task to reviewing the talks with my colleagues of the committee.

First, let me introduce the committee members:

• Art van Scheppingen (Spil Games)
• Nicolai Plum (Booking.com)
• Luis Motta Campos (Ebay Classifieds Group)
• Colin Charles (MariaDB)
• David Busby (Percona)
• Morgan Tocker (Oracle)
• Cédric PEINTRE (Dailymotion)

Amazing, isn’t it?! I think we couldn’t have a better committee for a community event.
I’m very glad to take part in the adventure with you guys!

And if you wonder what the committee does, …

Three useful little tidbits for using Ansible that I’ve come across.

1. How to use with_items on lists of multiple types

With a little jinja-fu you can iterate a list of strings and dicts to template the action in more elaborate ways than the typical use.

I was configuring the installation of some Python packages and wanted to fix the version of Django, but not the version of MySQL-python, since any updates to it are likely to be for security/compatability. Typically, with_items would be used to iterate over a list with dicts, like {name: package1, version: something}, but it’s tiresome to write when you often don’t care about one of the keys. Also, providing version="" won’t work with the pip module, since it would get converted to pip install package==, which pip doesn’t interpet as ‘latest’, so there would already …

There is a decent chance that I can guess one thing you are not monitoring on your server. And it is something that can stop insertions to a table. Guess what it is yet? 

The majority of tables in a database typically use what is called an "auto_increment" column. This means that when you insert a row into a table a column will be automatically populated with a number that is a fixed increment from the previously incremented column. The amount of increment can be configured by the auto_increment_increment variable. The problem is that these auto_increment columns have maximum values that they may hold. Once a auto_increment column reaches this maximum value it won't insert any more until the situation is resolved.

A good DBA is planning ahead -- averting problems before they ever happen. And this can be done here. Information about the auto_increment columns for a table are stored in …