Monday, March 26, 2012

Opscode's Chef, MySQL, Best Practices

If Chef manages a CNF file, please have it put a comment in the top of the file that it is managed by Chef. Do not assume that everyone will believe that every file is being managed by Chef. In general, you should have Chef leave a comment in every file that it manages (and someone at Opscode should make this a default feature in Chef).

Do not have Chef reboot the database. Databases are designed to run for years at a time. Many parameters can be set while the databases is running in such a way that it does not need to be bounced in order to make the parameter work. There are exceptions to this in non-production environments.

Need to change the schema? Do not have the Chef create a table, and then do alter table after alter table to install a new system. This is very painful to watch.

* Thanks to Alex Howells for the idea of always putting a comment in the top of the Chef script.

Wednesday, March 7, 2012

MySQL Conference, Percona, the Ecosystem...

This year O'Reilly isn't running the MySQL conference, Percona is doing it. Santa Clara, April 10-12. The usual time and place.

This is great news. They run a great conference. They always get rave reviews.

This isn't the first one they've done. They've done San Francisco, New York, London, more.

What's different about Santa Clara?

This isn't their typical 300-person one-day conference. They're picking up the annual MySQL users conference and carrying the torch forward. This is a 1000+ person, huge expo hall, 8 concurrent tracks, several days conference.

This year is a banner year for the MySQL ecosystem.  Why?

Because now the conference is focused on MySQL again. This is the central conference for the ecosystem. And now it's managed by a company that understands both the community and business side.


And the MySQL Ecosystem? Thanks to cloud vendors it continues to grow.
The sessions? Better than ever. In the past there was a lot of auxiliary content. Take a look. This year it's easily the best technical content I've ever seen. And I've led the selection committee for years.

The sponsors and exhibitors? Pretty much anyone who's anyone will be there.  Looking for solutions to your MySQL problems? You'll meet the folks who can help you. Visit the expo hall. There is great sponsor support for this year's event. HPCloud, Facebook, Clustrix, Google, et cetera.

The keynotes are nothing to sneeze at too. There will be talks from Marten Mickos, Mark Callaghan, myself, and more of the old gang.

Is there more? Yes there is.

There are the community awards, BOFs, lightning talks. There is a Tuesday welcome reception, Wednesday community networking.

More? Yes. There is not one, not two, but three follow-on events. Stay an extra day and on Friday you can attend Drizzle Day, SkySQL and MariaDB Day, or Sphinx Search Day.  Three awesome technologies for MySQL users.

This is a really big deal. If you are even slightly interested in MySQL, this is the event of the year. Don't miss it. By the way, early-bird pricing is almost expired. Register before March 12th or you'll pay more for the ticket and the hotel.