Note that the webinar replay + transcript of the Questions and Answers is now available from here.

On Thursday 12th September I’ll be co-presenting a free webinar on how MySQL Cluster delivers the key benefits of NoSQL Data Stores without having to give up the features that people rely on from relational databases (consistency, SQL etc.). There will be particular focus on how to use the new node.js JavaScript API which was recently released as part of MySQL Cluster 7.3.  As usual the webinar is free but you should …

Row-based Replication was introduced in MySQL 5.1. It’s not the default (yet), but I really like it. I wanted to tell you what limitations you may face with statement-based, and why you should join me in making the switch.

Write scalability of certain statements

Statement based binary logging requires additional locking to ensure slave-consistency. To illustrate, here is a naive example:

CREATE TABLE users (
 user_id INT NOT NULL primary key,
 user_name varchar(60) NOT NULL,
 is_deleted TINYINT DEFAULT 0,
 UNIQUE KEY(user_name)
);

INSERT INTO users (user_id, user_name, is_deleted) VALUES
 (1, 'ted', 0),
 (2, 'bill', 0),
 (3, 'fred', 0),
 (4, 'mike', 1),
 (5, 'barry', 0);

session1> START TRANSACTION;
session1> DELETE FROM users WHERE is_deleted = 1; # 1 row matches (user_id 4), deleted.
session2> START TRANSACTION; …

Thanks to everyone who attended last week’s webinar, Running MySQL 5.6 on Amazon RDS.” If you weren’t able to attend, the recording and slides are available for viewing/download (or, if you were able to attend and just want to see it again). I’ve also answered the questions I didn’t have a chance to field during the event:

Q: Would you recommend Amazon RDS over manually setting up MySQL/Percona server on an EC2 instance?
A: This depends on many factors including your data set size, workload, uptime requirements, what the rest of your stack looks like, and many other factors.

Q: At Q&A time, can you go more into 5.6 InnoDB full text search vs the Amazon search offering? …

Check out the video!
Hey there everybody!

Coming up this Wednesday, September 4th, 2013 at 12:00pm pacific (19:00 GMT) take part in #DBHangOps to discuss:

• Data Dictionary Corruption
  • What is it?
  • How does it happen?
  • How did you fix it?
  • What about FRM file corruption?
• MySQL Utilities (requested by Sheeri Cabral!)
  • mysqlfrm — http://dev.mysql.com/doc/workbench/en/mysqlfrm.html
    • Read about it at Chuck Bell’s blog http://drcharlesbell.blogspot.com/2013/04/mysql-utilities-new-frm-reader-utility.html
    …

If you’re in the Washington, DC area on Sept 12th, be sure to attend Percona University. This is a free 1-day mini-conference to bring developers and system architects up to speed on the latest MySQL products, services and technologies. Some of the topics being covered include Continuent Tungsten; Percona XtraDB Cluster; MySQL Backups in the Real World; MariaDB 10.0; MySQL 5.6 and Percona Server 5.6; Apache Hadoop. I’ll be speaking about using MySQL with Go.

This week we continue our series on the MySQL Utilities. In this week's Ear Candy, we talk about a path problem installing MySQL Utilities on Ubuntu, and At the Movies is a preview of the SkySQL data suite.

Part 1 of MySQL Utilities
Part 3 of MySQL Utilities
Part 4 of MySQL Utilities
Part 5 of MySQL Utilities

Events
DB Hangops - every other Wednesay at noon Pacific time

Percona University is coming to Washington, DC on Thursday, September 12th.

…

Dear MySQL users,

The MySQL developer tools team at Oracle is excited to announce the availability of MySQL Workbench 6.0.7, a maintenance release for the new MySQL Workbench 6.0

MySQL Workbench 6.0 is the new major update of the GUI Development and Administration tool for MySQL. This version contains more than 30 new features and a redesigned, more modern UI. Over 200 enhancement requests and bugs filed by the community have been addressed since version 5.2.47. This release fixes over 20 bugs encountered since version 6.0.6

Improvements in MySQL Workbench 6.0:

• a new redesigned Home screen
• the SQL Editor and Server Administration UIs were merged into a single connection specific interface, allowing for quick access to administration features while simplifying the location of specific features
• improved model Synchronization, lets you compare and update your EER model or database with …

On 17th October I’ll be running a hands-on workshop on the various technologies available to provide High Availability using MySQL. The workshop is being held on 17th October (the day before the All Your Base conference) in Oxford (UK). The cost is £250 + VAT and you can register here.

This workshop provides an introduction to what High Availability (HA) is; what technology options are available to achieve it with MySQL and how to actually implement your own HA solutions. The session will be a mixture of presentations, demonstrations and (most importantly) hands-on tutorials.

We’ll start with an overview of High Availability – in general and in the context of MySQL and then a survey of the technologies to choose from:

• MySQL …

MySQL Connect is only slightly over 2 weeks away! Many sessions at the conference will offer you the chance to learn how to improve performance using the new features and enhancements of MySQL 5.6. You can see all sessions in our content catalog and pre-enroll in them with Schedule Builder. While the below list may not be exhaustive, performance tuning sessions include:

50 Tips for Boosting MySQL Performance - Arnaud Adant, Oracle
…

Well.. just wanted to share the more technical details I went into when preparing the “A MySQL Odyssey: A Blackhole crossover” for the OpenSUSE Conference in Thessaloniki, July 2013. There’s a youtube version as well, of the actual session, on the opensuse channel. http://youtu.be/Nt2w1UvKEp0. (Audio kicks in at minute 6:40 so enjoy my miming act).

Here goes:

5.6 Enterprise Edition -> edelivery.oracle.com
 Win:    mysql-5.6.11-MySQL Installer 5.6.11.0 Package-V38226-01.zip
 Linux:  mysql-5.6.11 TAR for Generic Linux (glibc2.5) x86 (32bit)-V38228-01.zip

 Windows         192.168.56.101
 Oracle Linux    192.168.56.102    …