PlanetMysql.ru — информация о СУБД MySQL

Mark Callaghan of Facebook: “What Comes Next for MySQL” focus on Large, sharded deployments Interesting numbers from their deployment (MySQL with Innodb): 60M QPS and 1.5B rows read/second in production MySQL with InnoDB is “web scale” scaled to 10x more data on the same servers by: Start with MySQL 5.1, flashcache, find and fix stalls, [...]
PlanetMySQL Voting: Vote UP / Vote DOWN

An exciting and busy day yesterday – lots of good talks, good conversations and good beer! Back at the sessions this morning and the first keynote of the day by Sam Ghods of Box: “MySQL: Still the Best Choice for Mission-Critical Data” The usual story of a (file sharing) application that started out on one [...]
PlanetMySQL Voting: Vote UP / Vote DOWN

Here it is finally – the MySQL conference 2012 starts with the Keynote Sessions. The first keynote speech is by Peter Zaitsev, founder of Percona and a very smart guy and also by Baron Schwartz (Percona), another very smart guy, the brains behind a number of toolkits for MySQL. They’re talking about the MySQL Evolution [...]
PlanetMySQL Voting: Vote UP / Vote DOWN

A very well attended Pedro’s dinner – I didn’t count, but we had 9 tables of 8-10 people or so – dare I say almost a 100 people? Lots of beer, margaritas and good conversations! Here are a few pictures from the event
PlanetMySQL Voting: Vote UP / Vote DOWN

In case you live under a rock, the MySQL conference starts on Tuesday. There are 8 concurrent tracks of content. Aside from my own talks, here are the sessions I would most like to see.

On Tuesday:

• Tutorial: Innodb and XtraDB Architecture and Performance Optimization. Peter’s talks are always great, and this is a perennial favorite. If you have never been, you should go to this one. You will realize how little you really know about InnoDB/XtraDB, and how much it matters.
• Tutorial: Linux and H/W optimizations for MySQL. Last year I tweeted that Yoshinori’s tutorial was the 3rd edition of High Performance MySQL, and I really wasn’t exaggerating that much.
• BoF session: Percona XtraDB Cluster. I believe that this is one of the few truly groundbreaking changes to MySQL — right up there with “MySQL has transactions now” and “MySQL adds replication.”

On Wednesday:

• MySQL Plugins – why should I bother? Sergei is the co-author of a book on plugins. Their power is not to be underestimated.
• Getting InnoDB Compression Ready for Facebook Scale. Compression is very powerful — if we can just get the implementation to work better. Facebook, apparently, has done that.
• The 5 minute DBA: MySQL DBA 101 for Non DBA’s. Get started fast with Matt Yonkovit’s friendly, engaging and relevant talk. Spoiler: it’s longer than five minutes.
• MySQL Optimizer Standoff MySQL 5.6 and MariaDB 5.3. Peter at it again, this time digging into the advances in newer releases of the server, which make a huge difference on some common and important workloads.
• Scaling MySQL Databases for the Web. This is the “Vitess” talk, a technology I’m extremely keen to hear about. It’s now powering YouTube’s backend.
• BoF session: Tungsten User Fest. Tungsten has matured into a very interesting technology in the last couple of years.

On Thursday:

• Oracle to MySQL migration. Marco Tusa has actually implemented some of the most impressive migrations in MySQL’s history.
• Spil Games: Outgrowing an internet startup. This should be a great talk about running MySQL in a busy startup in the real world.
• Here I’m torn between MySQL and SSD: usage and tuning and Common Schema: a framework for MySQL server administration. (I’m always torn between at least 2 or 3 talks, but in this case especially so for some reason.)
• Verifying MySQL Replication Safely With pt-table-checksum 2.0. If you aren’t verifying that your replicas have the same data as their masters, you need to, and this is the tool to do it.

Further Reading:

• Sessions of interest at MySQL Conference and Expo 2009
• Sessions I want to see at the MySQL Conference
• My sessions at the O’Reilly MySQL Conference 2011
• Sessions of interest at the Percona Performance Conference
• Speaking at RubyNation 2012

PlanetMySQL Voting: Vote UP / Vote DOWN

This week we give an overview of Percona Live and what we think are the highlights, including which sessions we recommend for beginners and which we cannot wait to see for ourselves.

On Tuesday June 5th, 2012, a MySQL Innovation Day is being hosted at Oracle’s Conference Center in Redwood Shores, California. The MySQL Innovation day will feature multiple “lightning” talks by Oracle’s MySQL Engineers, If you cannot make it out to California, the lightning talks will be available via a live webcast, too - so either way, save the date! Unfortunately there's no link yet.

MariaDB 5.5 beta announcement

read more

PlanetMySQL Voting: Vote UP / Vote DOWN

We’re running Birds of a Feather (BoF) sessions and lightning talks this year at the MySQL conference, similarly to previous years. You can help by submitting proposals ASAP. The deadline is Monday, and it is a hard deadline.

Submit a BoF Session • Submit a Lightning Talk

Why is this a big deal? Why the hard deadline? It turns out that this is one of the things I always underestimated. Planning for these is actually quite difficult and they are very expensive. That’s because we have to ensure that there is room for them to take place, doors are unlocked, and the lights are turned on. This really surprised me — I always thought it was simple to let people gather together in the evening. Well, nothing is simple at a big conference venue. If you want to have a BoF session at a bar, that’s simple, but that’s not what this conference has typically done, and we are trying to continue the conference as it’s always been.

Further Reading:

• Slides for my MySQL Conference talks are online
• Submit your proposals for MySQL conference 2010
• I’m a MySQL Conference and Expo advocate again
• How to write a good MySQL conference proposal
• O’Reilly MySQL Conference CfP ends today

PlanetMySQL Voting: Vote UP / Vote DOWN

This year, I have the pleasure of returning to the MySQL Conference & Expo as a speaker. Percona have picked up the torch that O’Reilly had held as the conference organizers, and they’re putting together a 3-day conference this year. I am co-presenting a tutorial with Yves Trudeau from Percona.

Read more

PlanetMySQL Voting: Vote UP / Vote DOWN

Want a free copy of High Performance MySQL, Third Edition? If you register before the early-bird pricing expires for the MySQL Conference in April, and use the discount code PL-Book, you’ll get to take a free copy home from the conference!

And now, a status update: I’m currently proofing the QC2 (quality control #2) revision of the book; after this, the book goes to manufacturing. The PDF is now 820 pages, which is a lot of work to proofread. You can imagine how much more in-depth we’ve been able to go with so many more pages.

The free sample online is Chapter 8, on optimizing MySQL configuration. Liz van Dijk just tweeted this about it:

The sample chapter of High Perf MySQL 3rd Ed is both amazingly to the point and hilarious at times. Instant buy for me.

If you haven’t yet, I encourage you to take a look at the sample. Then go register for the conference to get your free copy, and I’ll see you in Santa Clara! We’re also arranging a book-signing at the conference, so you can get some scribbles on your copy if you want!

Further Reading:

• Get a free sample chapter of High Performance MySQL Second Edition
• Free webinar on MySQL performance this Thursday
• Grab your High Performance MySQL sample content
• High Performance MySQL Second Edition Schedule
• High Performance MySQL, Second Edition: Query Performance Optimization

PlanetMySQL Voting: Vote UP / Vote DOWN

Over the last few weeks I had been quite silent, but that's about to change: Over the next few weeks I'll give a few presentations. Feel free to join any of those.

• January, 18th: Erstellung hochperformanter PHP-Anwendungen mit MySQL (German)
  MySQL Webinar, Online
• February, 9th: MySQL Konnectoren (German)
  OTN Developer Day: MySQL, Frankfurt, Germany
• February 24th/25th: PHP under the hood (English)
  PHP UK Conference, London, UK

PlanetMySQL Voting: Vote UP / Vote DOWN