Get the most out of your use of MySQL Cluster by attending the MySQL Cluster training course. This three day course:

• Explains the concepts of MySQL Cluster in detail
• Describes the different nodes in MySQL Cluster and their purposes
• Explains how the data is distributed and replicated in the MySQL Cluster
• Installs all the different nodes used in the MySQL Cluster
• Starts and stop the different nodes as needed
• Shows how the different configuration files work and be able to configure all possible types of clusters
• Uses the cluster in single user mode, and explains when this is necessary
• Shows how to upgrade cluster components and configuration settings
• Explains how node failure is detected and …

Register for a Private Happy Hour and Food Event at Sfuzzi Las Colinas, Irving, TX

Please join us for our MySQL tech event hosted by Oracle and learn more about the continued investment in the world’s most popular open source database. MySQL expert Benjamin Wood will be on hand to discuss new features, commercial extensions, and provide details on MySQL 5.6.

MySQL 5.6 Introduction
MySQL Commercial Extensions Review (HA, Back Up, Security, Enterprise Monitor, Performance, Scalability)
Open Q&A

Monday, March 18, 2013
3:00 PM – 6:00 PM

Sfuzzi Las Colinas, Irving, TX
Sfuzzi Las Colinas
525 Meadow Creek Dr, Irving, TX, 75039

…

MySQL User Group meeting, Stockholm, Sweden - April 10, 2013
After some time the Swedish MySQL User Group is organizing and announcing the upcoming MySQL User Group meeting in Stockholm!!! Everyone who are around that area on April 10, 2013, please make sure that you do not miss this great opportunity to listen and ask questions the main guest Mats Kindahl, (the Senior Principal Software Developer MySQL) who will be talking on Replication news on MySQL 5.6.!!!  

Above this main topic and Q&A on MySQL Replication, you will also have an opportunity to suggest topics for the upcoming SMUG meetings as well as enjoy the food & mingle.

Date: April 10, 2013
Start: at 4pm
Where (address) : Emineo; Lilla Västerbron 20; 11219 Stockholm; Sweden
URL for registration & updates: LinkedIn; …

Galera Cluster for MySQL 5.5.29-23.7.3 has been released. This is a maintenance release with several important bug fixes. Downloads are available from our Launchpad download area: MySQL with Wsrep API 5.5.29-23.7.3 and Galera library 23.2.4.

This release includes RHEL/Centos 6 RPM binaries. The Galera library also introduces as experimental feature a preview from our Galera 3.x development work: weighted quorum calculation.

As usual, feedback and bug reports are welcome: Bug tracker, Mailing list.

Codership recommends …

Catch the webinar: “Learn How MySQL 5.6 Makes Query Optimization Easier” for more tips on the 5.6 optimizer

While preparing the webinar I will deliver this Friday, I ran into a quite interesting (although not very impacting) optimizer issue: a “SELECT *” taking half the time to execute than the same “SELECT one_indexed_column” query in MySQL 5.6.10.

This turned into a really nice exercise for checking the performance and inner workings of one of the nicest features of the newer MySQL optimizer: the Index Condition Pushdown Optimization, or ICP, which …

Following the success of its first MySQL Connect edition, Oracle will hold MySQL Connect 2013 on September 21-23 in San Francisco.

The Call for Papers is now open, and will be running until April 12. We highly encourage MySQL users, customers, partners and community members to submit session proposals now.

MySQL Connect represents a unique opportunity to learn about the latest features of the best MySQL product releases ever, discuss product roadmaps, and connect directly with the engineers driving MySQL innovation.

The Conference is chock-full with technical sessions, hands-on labs, Birds of a Feather (BOF) sessions and tutorials delivered by MySQL community members, users, customers, partners and Oracle’s MySQL engineers.

The event will include five tracks: Performance and …

While Spring is already arrived in mainland Europe, we still had some 10 cm snow that came down yesterday in Finland (in addition to the already accumulated snow). Still, the warm and bright sunshine can't be ignored: It is Spring and that means conferences and meetups are in full swing. There is a lot of interest in Galera, so you can expect to have a Galera talk at almost any event nowadays:

Percona Live MySQL Conference and Expo, Santa Clara, April 22-25

Did you catch the news that Tomas Ulin (who heads Oracle's MySQL engineering) will give the State of the Dolphin keynote talk! Even more reason to come to the main MySQL event of the year! As MySQL 5.6 is the big news of 2013, it is a good time to hear about it from Tomas and other engineers presenting at the conference. (For Galera we already are working on releasing …

One of the many reasons to switch from MyISAM to InnoDB (or NDB) is the support of foreign keys which helps to guarantee referential integrity.

This is how it's supposed to work:

mysql> CREATE TABLE parent (id INT AUTO_INCREMENT NOT NULL, 
    -> pname VARCHAR(100) NOT NULL, PRIMARY KEY(`id`));
Query OK, 0 rows affected (0.01 sec)

mysql> CREATE TABLE child (id INT AUTO_INCREMENT NOT NULL, cname VARCHAR(100) NOT NULL, 
    -> pid INT NOT NULL, PRIMARY KEY(`id`), FOREIGN KEY `fk_parent_child` (`id`) REFERENCES parent (`id`));
Query OK, 0 rows affected (0.01 sec)

mysql> SHOW CREATE TABLE child\G
*************************** 1. row ***************************
       Table: child
Create Table: CREATE TABLE `child` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cname` varchar(100) NOT NULL,
  `pid` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT …

The recently released MySQL 5.6 gets a lot of attention, but for those who are still on 5.5 there is also good news: There are two new features in 5.5.

The first feature is that there are more INFORMATION_SCHEMA tables for InnoDB. This means that it's possible to 'see' what's in the buffer pool. It also makes it possible to get more information about the LRU list.

From the 5.5.28 changelog:
InnoDB: Certain information_schema tables originally introduced in MySQL 5.6 are now also available in MySQL 5.5 and MySQL 5.1: INNODB_BUFFER_PAGE, INNODB_BUFFER_PAGE_LRU, and INNODB_BUFFER_POOL_STATS. (Bug #13113026)

This is in the "Bugs Fixed" section instead of the "Functionality Added or Changed" section, which is a bit weird in my opinion.

The second feature is a variable which makes it …

26 March 2013, MySQL Tech Tours comes to Paris, FRANCE, and I'm happy to cover MySQL Performance related topics during this event!

The full agenda is here: MySQL Tech Tour @Paris 

Of course, the timing will be pretty short to cover all topics ;-) - but there will be also lunch time and whole afternoon if you're willing to continue, because I'll stay there for a full day and will have all my time to answer any of your questions about MySQL Performance :-))

Note: the event is free, so places are limited.. (means: hurry up to subscribe ;-))

See you there! and my strong willing is to have such kind of MySQL events @Paris more and more often (and on more regular basis) - if you have some ideas about to share, just drop me an e-mail or leave a comment..

Rgds,
-Dimitri