[...] Redis, Memcached, Tokyo Tyrant and MySQL comparision http://ruturaj.net/redis-memcached-tokyo-tyrant-and-mysql-comparision/ [...]

My tutorial at Percona Live London 2012.
Slides + Audio are now available on Youtube


Part One

• Introduction - 00:00
• Indexes - 3:40 
• Finding Bottlenecks - 20:04

Part Two - 42:25

• Partitioning - 43:40
• Intensive Table Optimization - 1:02:16

Part Three - 1:38:49

•  Read Cache - 1:38:58
• Summary Tables - 1:54:46
• Scaling Reads - 2:03:34
• Reporting - 2:07:53
• Write Buffers - 2:12:28
• Scaling Writes - 2:19:31
• Sharding - 2:21:42
• Ending - 2:26:40

What is the value of a seed? 
When I discussed the MariaDB Foundation with friends and colleagues, many said I was exaggerating. My believe is that the Foundation is important for MySQL and for the future of the IT industry - services and applications. Many agreed with me that the Foundation is important for the MySQL ecosystem, but involving the global economy and the whole IT industry is a bit of a stretch.

Fact is, the World Wide Web would not be as it is today without MySQL. MySQL was part of the LAMP stack. It powered - and still powers - some of the most successful web sites in the world. Without LAMP, companies like Facebook, Twitter or Google would have been developed in a completely different way or they would have not been developed at all.

The importance of MySQL for the Internet is pretty clear for many of us. What is perhaps less clear is what is the current situation of MySQL and the …

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 year.
The vote will begin in early next year, stay tuned…

Please, …

This week we discuss triggers in MySQL. Ear Candy is SQL in the Shell, and At the Movies is Project Triage and Recovery, by Keith Casey of Twilio, at the 2012 CodeConnexx conference.

FOSDEM 2013 is taking place in Brussels, Belgium Sat Feb 2 - Sun Feb 3rd. Call for papers for the MySQL & Friends room closes December 21st.

Northeast LinuxFest is happening at Harvard University, Cambridge MA Saturday March 16th and Sunday March 17th, 2013. Open Database Camp will be held there. Sponsors are needed, make sure to specify you …

I spoke last Friday at DevIgnition about what’s coming in the MySQL 5.6 release. My slides are embedded below.

Further Reading:

• Presentation uploaded for Maatkit talk at MySQL Conference
• Videos and slides for MySQL Conference 2010
• Surge 2011 slides, recap
• Slides for my MySQL Conference talks are online
• …

Learn about the MySQL Server and other MySQL products by taking the authentic MySQL for Beginners course. This course covers all the basics from MySQL download and installation, to relational database concepts and database design. This course is your first step to becoming a MySQL administrator.

You can take this course through one of the following delivery types:

• Training-on-Demand: Start the class from your desk, at your base and within 24 hrs of registering. Read Ben Krug on Day 3 of his experience taking the MySQL for Beginners course Training-on-Demand option.
• Live-Virtual Class: Attend this live class from your own office - no travel …

There are so many exciting new features in MySQL 5.6 that I almost don't know where to start. To mention a few, MySQL's multi-core scalability has been significantly improved to meet modern hardware, InnoDB has better index statistics, much better performance, and online ALTER, replication has multi-threaded slaves and …

Everybody knows the criticality of backup. You might have had your database dumped, data directory copied, flat files exported and even config and binary log files backed-up. But did you…

The post Is your backup complete? – backup MySQL users privileges / grants – pt-show-grants first appeared on Change Is Inevitable.

I spoke last Friday at DevIgnition about what’s coming in the MySQL 5.6 release. My slides are embedded below.