In the thirty-second minute of a YouTube video featuring Oracle CEO Larry Ellison you can hear him say clearly "we compete against Microsoft SQL Server ... we never compete against MySQL".

The important thing is that he says "Microsoft SEQUEL Server" the way Microsoft people say it, but he says "My-ESS-CUE-ELL" the way the MySQL Reference Manual says is "official" pronunciation (for English). That is, for product names Mr Ellison respects the way the product makers say it. That settles that, but what about the word SQL in general?

Although SEQUEL was the earlier name, there are no English words where the letter Q alone is pronounced KW. So this can't be …

Today is Tutorial Day at MySQL Connect 2013 and yesterday was a blur. The Replication Road Map session started my day and it covered the long term development goals for MySQL Replication as well as more information on the Fabric sharding tool. Joro presented an amazing session on new security features along with some great tips for DBAs. Sadly I had to miss the other sessions as there was a meeting of the MySQL Storage Engine Partners (thanks to all the attendees) and the Oracle User Groups. Like many of you, I will be spending time going through presentations online to catch up on the session I missed.

And please let us have any feedback on MySQL Connect 2013 that you may have as we are already looking at the 2014 show.

http://www.oracle.com/us/dm/29127-emeafm13045970mpp014-oem-2019447.html

Come hear me talk about whats new with MySQL and loads of other interesting things.. come see the raspberry pi project in the flesh

Sign up today!

“The most valuable thing I’ve learned in this role is that judicious use of a little bit of knowledge can go a long way. I’ve seen colleagues and other companies get caught up in the “Big Data” craze by spend hundreds of thousands of pounds sterling on a Hadoop cluster that sees a few megabytes [...]

MySQL Fabric Presentation

MySQL 5.7 Fabric: Introduction to High Availability and Sharding from Ulf Wendel

Excellent presentation by Ulf Wendel 

Hi Sanjay

Thanks for the response.(It's a bit late but I know you would be busy). I understood the problem but How is it possible for multiple write threads while we backup without SBT (I mean, to disk)? When MEB can write in multiple threads to a folder on disk, I want to explore the possibility/hack to make it work with tape also? at least with the help of some buffering at the machine which has tape library installed.

Percona XtraDB Cluster (PXC) is different enough from async replication that it can be a bit of a puzzle how to do things the Galera way.  This post will attempt to illustrate the basics of setting up 2 node PXC cluster from scratch.

Requirements

Two servers (could be VMs) that can talk to each other.  I’m using CentOS for this post.  Here’s a dirt-simple Vagrant setup: https://github.com/jayjanssen/two_centos_nodes to make this easy (on Virtualbox).

These servers are talking over the 192.168.70.0/24 internal network for our example.

jayj@~/Src $ git clone https://github.com/jayjanssen/two_centos_nodes.git
jayj@~/Src $ cd two_centos_nodes
jayj@~/Src/two_centos_nodes $ vagrant up
 Bringing machine 'node1' up …

Introduction   For a long time there was a Bug#6295 in implementation of BEFORE triggers related to handling of NOT NULL column. The problem was that if a column is declared as NOT NULL, it wasn’t possible to do INSERT NULL (or UPDATE to NULL) even though there was associated trigger, setting NOT-NULL value.

For example:

• There is the table ‘t1′ with a NOT NULL column ‘c1′
• The table has BEFORE INSERT trigger which sets the ‘c1′ column to NOT NULL value (SET NEW.c1 = 1)
• User executes the SQL statement INSERT INTO t1 VALUES(NULL) that fails with the following error:     ERROR 1048 (23000): Column ‘c1′ cannot be null
• The user will get the same error if there is a BEFORE UPDATE trigger that sets the ‘c1′ column to NOT NULL …

As a leader of a technical operations team I often have to work on technical operations engineer hiring. This process involves a lot of interviews with candidates and during those interviews along with many challenging practical questions I really love to ask questions like “What are the most important resources you think an Operations Engineer should follow?”, “What books in your opinion are must-read for a techops engineer?” or “Who are your personal heroes in IT community?”. Those questions often give me a lot of information about candidates, their experience, who they are looking up to in the community, what they are interested in, and if they are actively working on improving their professional level.

Recently, one of the candidates asked me to share my lists with him and I thought this information could be valuable to other people so I have decided to share it here on my blog.

Must-Read Books List

First …

Today, while at Oracle's MySQL Connect conference in San Francisco, I had the opportunity to talk to Gerardo Narvaja and that inspired me to try using OQGraphv3 and TokuDB. Of course, the first challenge is to compile it on my MacBook which has MacOS Lion 10.7. I installed the Apple's latest XCode Command Line tools and eventually compiled a MariaDB which had both TokuDB and OQGraph available