I wasn’t at the MySQL Conference this year but it was very nice to follow this event from Paris.
Of course I didn’t feel the general atmosphere by visiting booths or met fabulous people.
But it was a great opportunity to offer you a live post about the conference with an external point of view.

Twitter, RSS feeds (yes Google, I still use RSS), Planet MySQL and infiltrators were my best friends during this crazy week.

I would like to summarize the major announcements and events occurs during this tenth edition.
 

Oracle at Percona Live!

 
Yes, Oracle was at Percona Live 2013 and it was for the best.
I invite you to watch this

LIVE BLOG!

This year again, the MySQL Conference and Expo, hosted by Percona, smells like a wonderful event.
I haven’t the chance to attend this event but I would like to share with you the soul of this one.
I’ll try to share latest news, tweets and slides from the event in this live post.

Stay tuned and come back!

Breaking news!

• LATEST : See you next year!
• MySQL 5.7 is coming… : http://bit.ly/11zENgT
• SkySQL Merges With MariaDB : 

A few years ago, I asked to check with me in the long (very long) change history of MySQL 5.5 documentation what are the changes in relation to the SQL syntax.
Chris Calender helped me to retrieve a list of the main changes, thanks again Chris.

Today, I would like to share this list with you.
It is simply a curated transcript of what you might find in the documentation but I’m sure it can help some of you.
 

INTO clause in nested SELECT statements

 
Previously, the parser accepted an INTO clause in nested SELECT statements, which is invalid because such statements must return their results to the outer context. As of MySQL 5.5.3, this syntax is no longer permitted and statements that use it must be changed.
 

Table aliases in DELETE statements

As a former Oracle DBA, I know how the system and the database are linked.
The first one who told me that the installation of Oracle has never been a problem is a liar!
Yes, your database and your system are the best of friends, you must respect that.

I’d make a list of linux system settings to configure a MySQL databases server and share my sources with you.
In return, I would like you to share your sources with the community by publishing your tips in the comments.

swappiness

• This parameter allows to specify how the kernel must manage the memory swap
• Default value : 60 (Range 0 to 100)
• Value to set : 0 (it will swap only to avoid an out of memory condition)
• How to set a new non-persistent value :  sysctl -w vm.swappiness=0
• How to store a new persistent

FOSDEM is a free event that offers open source communities a place to meet, 
share ideas and collaborate.
It is renowned for being highly developer-oriented 
and brings together 5000+ geeks from all over the world.

 
This year again, be sure that FOSDEM will be the place to be in February!

Do you have any doubts? Really ? Dude, repeat after me :

Ok, that sounds good?

Well, here are the informations to attend this terrific event :

• How to register? : Are you kidding me?
• When : 2 & 3 February 2013 (Hurry up guys!)
• Where : Brussels (beers!!!)

2012 was again a great year for MySQL and for the community.
Many events, tools, features were released this year and more to come next year.

So, it’s time to tell us what services and tools you used this year in these different categories :

• MySQL Monitoring tools
• MySQL GUI tools
• Other MySQL tools
• MySQL Blogs
• MySQL backup tools
• Operating systems for MySQL databases
• Replication tools
• MySQL Distributions
• NoSQL Distributions
• MySQL events

Send an email at cedric@mysqlplus.fr or write a comment with your nominees before the end of this

Percona Live London 2012 was again a great event.
You can find some of the slides on [Plus], enjoy! :

If you would like to add your slides, post a comment with the link.

There will be at least 3 MySQL events that you shouldn’t miss by the end of the year :

• MySQL Connect 2012 : September 29 & 30, 2012, San Francisco
• Percona live New York : October 1st & 2nd, 2012, New York
• Percona live London : December 3rd & 4th, 2012, London

I suggest you to register right now to gain a super saver registration discounts.
And it is also time to book your hotel/flight to take advantage of cheaper rates.

I don’t want to (re)write a detailled post about these great conferences, see my last post about Percona Live London 2011 : 

Hi everybody,

I’m sure you’re all listening about what is happening at the MySQL annual conference (no ? really ?)
So, you can find bellow all the slides from the MySQL Conference & Expo 2012 :

Source : https://www.box.com/perconalive2012

Find some videos  : http://www.percona.tv/2012/04

• My slides of MySQL Meetup Viadeo / LeMUG Paris
• [UPDATED] Why you should go to Percona Live (London) ?
• Upcoming MySQL events that you should not miss

Let me tell you a very touching story about these awards.
As I said in the comments : Sometimes we think about something and the next minute we did it…
And it exactly what happened, I took my inspiration from the TUAW Best Of 2011 (Yes, I’m also an Apple fan boy, sorry :-)), and a few minutes later, MySQL[plus] awards 2011 were live !

I thought I could have 50 voters, perhaps 100 voters, in my wildest dreams…

But more than 300 voters and more than 4000 views later, the reality is there : You are amazing !

But, no, it wasn’t perfect !

You have until Jan. 31 to vote for your favorites tools and services, so, vote now !

Thanks again all folks for your keen interest and your involvement, it was a big surprise to see so many contributors

Follow this link to vote : http://www.mysqlplus.net/2012/01/05/vote-mysqlplus-community-awards-2011/

And come february the 1st for the final results…

• [RELOADED] Vote for MySQL+ community awards 2011 !

First of all, I wish you a happy new year.
Many things happened last year, it was really exciting to be involved in the MySQL ecosystem.
I hope this enthusiasm will be increased this year, up to you !

To start the year, I propose the MySQL[plus] Awards 2011
It will only take 5 minutes to fill out these polls.
Answer with your heart first and then with your experience with some of these tools or services.

Polls will be closed January 31, so, vote now !
For “other” answers, please,  let me a comment with details.

Don’t hesitate to submit proposal for tools or services in the comments.

I was glad to present how to schedule and monitor mysqldump with ZRM community last week in Paris as part of the MySQL Meetup Viadeo / LeMUG

You can find my slides below, enjoy ! :

• Slides from MySQL

Percona Live London 2011 is over and it was a wonderfull event. Thanks to Percona for this quality event in Europe.
And thanks to all speakers for their outstanding performances.

I just want to share with you some words about PLUK2011, these few words reflect my technical feelings after the event :
(This is the live transcript of my notes during the conference in random order)

• MySQL is not dead !
• Sharding is a good way for write scalability
• It’s difficult to find a real HA solution for MySQL
• MHA rocks !
• IO are more than ever our enemies (and we must get into their privacy)
• Where is Oracle ?!
• Glad to see SkySQL there
• We probably need new références for SSD
• Keep in mind the operability of the proposed

[ UPDATED 2011-09-22 ] :
For French attendees : Vous participez ou souhaitez participer à cette conférence, rejoignez le groupe de la communauté francophone pour partager autour de cet évènement
For All : Download the take away PDF of the conference here : PLL2011.pdf
For All : Download the schedules : Percona_Live_London2011.ics

I don’t want to debate about the next MySQL Conference here, you can find a great summary post here :