If you are attending Chicago Tech Week this weekend, be sure to drop by the MySQL Hands On Lab Saturday (3:00pm – 4:45pm @ 4 – 7 A/B (222 Merchandise Mart Plaza, Chicago, IL)) as I have some promotional items that I need to give away. Or catch me at Lone Star PHP, June 20 & 30th, where Oracle is sponsoring the second year of this event.

Come join the Los Angeles MySQL Users group on August 1st for a look at MySQL 5.6 and help make some pizza disappear. The presentation will start at 7PM and all are welcome. I will be speaking earlier in the day at the LA Moodle Moot and then heading down Highway 5 the next day for the San Diego Users Group.

200 N. Sepulveda Blvd.
Suite 400
El Segundo, CA 90245

Do not forget to register for the free Webcast of MySQL Innovation Day.

Abstracts

Better Availability with InnoDB Online Operations
Calvin Sun, Sr. Development Manager for InnoDB, Oracle Many top Web properties rely on MySQL as a critical piece of infrastructure to serve millions of users. Therefore, database availability has become increasingly important. One way to enhance availability is to allow users full access to the database during DDL operations. The online DDL operations in recent MySQL releases offer users the flexibility to perform schema changes while allowing users full access to the database, that is, with minimal delay for operations on the table, and without rebuilding the entire table. Those enhancements provide better responsiveness and availability …

The South East Linux Fest is next week in Charlotte, North Carolina and will feature a MySQL day on Friday with two FULL tracks.

MySQL Tracks for SELF

This will be followed on Sunday by the Open Database Unconference. And did I mention this is all free? Plus there will be other tracks on Linux, FOSS, and many vendors present.  This is an amazing show and you really need to be there.

This is a great opportunity to hear from some of the best and the brightest presenters in the MySQL Community. We managed to get a few MySQL Engineers to head East after MySQL Innovation Day to present.

And if you know anyone who needs a real …

The Roucky Mountain Oracle Users Group’s MySQL Special Interest Group met today for four presentations.

Effective MySql’s Ronald Bradford explaining Explain

Ronald Brafdord explaining Explain[/caption] Ronald Bradford started the day on backup and recovery and then had a second session on optimizing queries. George Trujillo had a session on demystifying MySQL for Oracle DBAs and Developers. Lastly, I preseted on SQL and NoSQL. If you live in the greater Dener area, you shoudl make sure you take part in the next RMOUG meeting.
…

The MySQL Connect conference call for papers is closed and the response was amazing. Now the problem is that we have a few hundred great session and only two days and nights to get everything presented. The submissions range from the big companies to private individuals and old, familiar faces in the MySQL Community to some new folks with top notch material.

Database as a service, cloud computing, tuning, InnoDB secrests, cluster implementation, Oracle/MySQL data transfers, replication tricks, query enhancement, big data, stored routines, J2ee, server refactoring, backups, NoSQL/SQL, and other subjects are covered — and those were just the first few submissions!

So thank you if you submitted and please do not forget to register!

…

The Rocky Mountain Oracle User Group MySQL SIG is meeting May 18th in Building 1 of the Oracle Broomfield Campus. Speakers include Ronald Bradford, Dan Hotka, Donald Schaefer, David Peake, and George Trujillo.

The South East Linux Fest is happening June 8th through the 10th and will feature Beginner MySQl Training Day, Advanced MySQl Training Day, the Open Database Camp, as well as Free & Open Source software based topics. Registration is FREE and I hope to see you in Charlotte!

SELF Schedule

…

MySQL Connect will be held this September before Oracle Open World and time is running out for you to submit your presentation. There are tracks on Application Development, Architecture and Design, Cloud Computing, Database Administration, High Availability, and Performance & Scaling.

You’ll need between 15-40 slides for an hour presentation (sixty minute session, leave ten or so minutes for Q&A). The submission software lets you stop and save before submission, just in case you need to do some research while create your submission. And once you submit, you can go back and edit so that you can include the latest and greatest information. But May 6th is the last day submissions will be accepted.

…

Collaborate 12 is in Vegas and Collaborate 13 will be in Denver. Mark your calendars now!

The last MySQL session for this year’s Collaborate is over. There is another day of sessions to go but they will go on without MySQL-centric topics. The majority of those the MySQL Community Team have talked to are Oracle professionals looking to expand their support for existing MySQL instances in their organizations or those looking to move some aspect of their data over to MySQL. Many use Collaborate for obtaining technical information as they feel Oracle Open World is too frenzied to get niyty gritty details. Attendance at MySQL sessions were much larger than last year and demo pod booth action was heavy with those seeking specific answers to their questions. And they were seeking details on the NoSQL/SQL InnoDB/NDB interface, operational …