I had an interesting conversation with Sheeri (who I’ve known for many years, so consider this friendly banter) on Twitter about my recent blog post titled: once again, a split in events.

Disclaimer/Bias Warning: For those that don’t know me, I write this as a perspective of a community member. I was the first ever Community Engineer at MySQL, followed by being a Community Relations Manager right up till I left Sun Microsystems. I now work on MariaDB which is a branch of MySQL, so naturally we are in competition for user base. But I’m writing this as a community member at large who cares about MySQL & the ecosystem.

First of, this is a focus on the user ecosystem. I think the MySQL …

MySQL is the world's number one open source database and the number one database for the Web. Join top companies by developing your MySQL Database Administrator skills.

The MySQL for Database Administrators course is for DBAs and other database professionals who want to install the MySQL Server, set up replication and security, perform database backups and performance tuning, and protect MySQL databases.

You can take this 5 day course as

• Training on Demand: Start training within 24 hours of registration. You will follow the lecture material via streaming video and perform hands-on activities at a date and time that suits you.
• Live-Virtual Event:  Take this instructor-led course from your own desk. Choose from the 19 events currently on the schedule and find an event that suits you in terms of timezone and date.
• In-Class Event: Travel to an education center. Here is a sample of events on …

MySQL 5.6 adds support for EXPLAIN UPDATE. This is a useful feature, so we want to have it in MariaDB 10.0, too. Besides that, MariaDB 10.0 has SHOW EXPLAIN feature, and we want it work for UPDATE commands, too.

Now, a bit of code history. Why didn’t MySQL have EXPLAIN UPDATE from the start, like other database systems? To the uninformed, lack of EXPLAIN UPDATE looks like simple lazyness. After all, everyone who has read a database textbook can imagine that the code should have this form:

run_update_query(UpdateQuery q) {
   QueryPlan qp= optimize_query(q);
   run_query_plan(qp);
}

and adding EXPLAIN UPDATE is a matter of adding another function:

run_explain_update(UpdateQuery q) {
   QueryPlan qp= optimize_query(q);
   print_update_query_plan(qp);
}

print_update_query_plan(QueryPlan qp)
{
  // print the plan for …

I have a pleasure to deliver Webinar on Industrial-Strength MySQL Applications Using Percona and Continuent together with Robert Hodges next week, Nov 28.

We will talk about how you can use technologies from Percona and Continuent to build Highly Performance and Highly Available Applications utilizing
MySQL Replication. I’ve been interesting in doing this Webinar for long time as we have a lot of great feedback from our customers using Continuent Tungsten and Percona software very successfully to implement advanced filtering, achieve much higher replication performance with parallel replication as well as make failover a lot more painless and easy to use. If you’re using MySQL Replication in highly demanding environment you would want to learn what these technologies have to offer.

Enjoy! …

One of the great things about the MassTLC unConference is the spontaneity of the ideas. In the morning I ran into an old colleague whose startup was looking at switching databases and struggling with the options. Hence, “Scalable Databases for Startups” seemed like a great topic, so I proposed it, and then was off and running full steam after lunch.

The session brought in a wide variety of firms. While there were several vendors there – Basho, Calpont, InterSystems, ParElastic, and …

Recently, I found myself involved in the migration of a large read-only InnoDB database to MyISAM (eventually packed). The only issue was that for one of the table, we were talking of 5 TB of data, 23B rows. Not small… I calculated that with something like insert into MyISAM_table… select * from Innodb_table… would take about 10 days. The bottleneck was clearly the lack of concurrency on the read part from InnoDB and then the key management for MyISAM. The server has many dozen drives so it was easy to add more concurrency so I kicked off, from a script, insertions into 16 identical MyISAM files for distinct parts of the table. That was much faster and would complete within a day.

Then, while the Innodb extraction was running at a nice pace, I thought about the next phase. My first idea was simply to do insert into MyISAM_table select * from MyISAM_table1 and so on for the 16 files. Since MyISAM are flat files, that …

Just a quick note to send a big thank you to Davi Arnaut from Twitter. He has continued to support and contribute bug fixes for MySQL and the following bugs have all been accepted.

Bug #65469 Infinite loop when opening a corrupted table
Bug #65692 Deadlock between START SLAVE and setting a system variable
Bug #65715 Wrong connection ID (thread ID) in the general and slow query logs
Bug #56240  please write proper dates to the error log
Bug #67156 Sporadic query cache related crash in pthread_rwlock_init()

A big thank you …

Codership, SkySQL und weitere Top-Experten rund um das Thema ‘MySQL Datenbanken” in Nürnberg versammelt

Unser Kollege Ralf Gebhardt ist dieses Jahr mit einem Vortrag zum Thema ‘Hochverfügbarkeitslösungen für die MySQL Datenbank’ auf der DOAG Konferenz zu hören und zu sehen. Weitere Interessante Themen sind z.B. ein Vortrag von Coderships Seppo Jaakola zu ‘Galera Cluster - synchronous multi-master replication for MySQL’.

Wir freuen uns auf Ihren Besuch beim MySQL-Stream der DOAG 2012 Konferenz!

read more

Another Percona Live event is coming up, this time in London on the 3rd and 4th of December. I’m sure it is going to be as awesome as it was last year.

This year, I will talk about ‘Choosing Hardware For MySQL‘.

Of course, the most important hardware components will be covered: CPU, Memory, Network, Disk Subsystem and also the Cloud.
I will try to help attendees better understand how MySQL uses hardware (and how it does not), how it optimizes random IO operations on disk, what scalability means for MySQL, what it’s limitations are and so on…
Want more? Just attend!

 
You can register …

Percona Live London 2012 happens December 3-4 2012. Naturally Oracle has decided to back UKOUG in Birmingham with interesting talks as well, happening December 3-5 2012. This is akin to the recent San Francisco/New York split for MySQL Connect & Percona Live NYC 2012.

Lucky for us, Birmingham’s “MySQL day” seems to be December 5 2012, and by estimates, it takes about 1.5 hours for one to attend both events and see 3 days of MySQL related content.

That aside, I’m hoping this doesn’t happen in 2013. Splitting the community is never a good idea.

Related posts:

1. …