Monday, April 30, 2012

MySQL Utilities webinar replay

In case you missed the MySQL Utilities webcast, a replay is available:  http://t.co/7bFAV083

This webcast is a nice overview of all the MySQL utilities including examples. Check it out and see how the MySQL community is going to get automatic failover backup from Oracle.

Thursday, April 26, 2012

SELF 2012 Preliminary Schedule

The SELF 2012 Preliminary Schedule is now available.

Just 43 days left until SELF and it looks like a great MySQL Lineup! A wide array of presenters from the MySQL community will be present, including Oracle Engineers.
On top of that.... You can get in for FREE if you wanted too!
Register here

Join us and support Linux, MySQL and open source technologies over all.


SELECT COUNT(sessions) FROM self_mysql_speakers WHERE year=2012;
20+ rows

My First Collaborate

This has been an interesting week. I have been told over the past year that the Collaborate conference was more Oracle focused and little interest in MySQL. While the conference is Oracle focused, MySQL and open source technologies do have people's interest. I was informed that the MySQL sessions all had larger attendees than last year overall. I did meet some great people here and a big thank you to the IOUG, OAUG, QUEST for this event.

Some typical comments I heard from attendees about MySQL while at Collaborate:
“SQL Server just does not have the throughput, I know MySQL can do it.”
“Depending on what your application is, MySQL is just better and faster.


The biggest hurdle for MySQL this week was how to pronounce it: “MySQL” is “My Ess Que Ell” (not “my sequel”), otherwise MySQL was well received.

Collaborate will be in Denver next year so I am surely to attend. I look forward to presenting how impressive MySQL 5.6 is and having more MySQL sessions or a track.

Below are some links for Oracle DBAs looking at MySQL, I hope you find them helpful.

50 things to know before migrating Oracle to MySQL
http://www.xaprb.com/blog/2009/03/13/50-things-to-know-before-migrating-oracle-to-mysql/
http://www.xzilla.net/blog/2009/Apr/Taking-a-stab-at-50-things-to-know-before-migrating-MySQL-to-Oracle.html
http://scale-out-blog.blogspot.com/2009/04/overcoming-mysql-to-oracle-culture.html

MySQL for Oracle DBAs, Oracle Developers:
http://mysqluc.com/presentations/mysql06/bradford_ronald.pdf
http://www.markleith.co.uk/dl/MySQL_for_Oracle_DBAs.pdf
http://mysql-dba-journey.blogspot.com/2009/07/differences-between-oracle-and-mysql.html

Pythian:
http://www.pythian.com/news/17895/mysql-troubleshooting-for-the-obsessive-oracle-dba/
http://www.pythian.com/news/13369/notes-on-learning-mysql-as-an-oracle-dba/

MySQL for Oracle DBAs (I, II):
http://marist89.blogspot.com/2005/09/mysql-to-oracle-dba-part-i.html
http://marist89.blogspot.com/2005/09/mysql-to-oracle-dba-part-ii.html

MySQL: An Introduction for Oracle DBAs
http://patrickhurley.wordpress.com/mysql-for-oracle-dba/

Monday, April 23, 2012

#CLV12 Day 1

A good day for MySQL at COLLABORATE 12. Most of the sessions had good attendance.  Dave and I also got the pleasure of meeting Michael McLaughlin of BYU. He is also an Oracle ACE in Database App Development.

Michael is a support of Oracle and MySQL and I have just recently added his blog to the Planet site.

Tuesday, April 17, 2012

The Road to MySQL CONNECT


Things are going to be busy over the next few months. I look forward to meeting many of you from the MySQL community over the next few months. I would also like to pass along my thanks for the MySQL Community Award, we (not just Dave and I but everyone here) are just getting started...

April 22nd -26th - starts things off for the MySQL Community Team. Dave Stokes and I will be presenting at different two sessions and available in the demo grounds at Collaborate in Vegas.

May 2nd -- MySQL heads to the big apple for an OTN Developer Day in NYC. Ronald Bradford as well as Calvin Sun are among some of the speakers for this event.

May 7th -11th - MySQL will be attending the Ubuntu Developer Summit in Oakland Calif. Tuesday looks to be a full day of MySQL and Ubuntu talks. I am sure many of the topics will be related to MySQL 5.5, MySQL 5.6 DMR , the db forks, and how we can support the Linux Distros in the future.

May 18th, the Rocky Mountain Oracle Users Group (RMOUG) has included MySQL to take part in their quarterly meetings. The MySQL Community team as well as Ronald Bradford (MySQL Oracle ACE Director )and George Trujillo (Oracle ACE in two different categories one being MySQL) will be in attendance and presenting.

June 5th and 6th -- MySQL will be at the International PHP Conference in Berlin.  Ulf Wendel will be presenting 2 great MySQL sessions.

June 5th -- will also be the MySQL Innovation Day at Oracle headquarters. Get a sneak peak of what’s new and what’s coming from leading Oracle MySQL engineers. If you cannot attend a live webcast will be available for some sessions.

June 8th – 10th The MySQL Community team again will join forces at the Southeast LinuxFest (SELF). This time for a MySQL Day and this is looking like it will have a great lineup of MySQL presenters.

June 26th – 29th – I will be attending Edmedia, a World Conference on Educational Media and Technology,  in support of MySQL.

July 14th – 15th – The Community Leadership summit in Portland Oregon

July 16th – 20th -- OSCON 

September 29th & 30thMySQL CONNECT in San Francisco !
The call for papers is open until May 6, submit your sessions now!

September 30th to October 4thOracle Open World.

Tuesday, April 10, 2012

MySQL 5.6.5-m8 DMR Table-of-contents

In the spirit of supporting the community, Baron asked for a table-of-contents blog post that encapsulated all of the recent Oracle 5.6 DMR posts.

I agree with Baron, a huge amount of information came out today, and this Development Milestone Release (DMR) does have some great features. So below is a list of all of the related blog posts around the 5.6.5-m8 DMR. Hopefully this makes it easier for everyone to find their related information.

Replication goodies in 5.6 posted in the DevZone

Multi-Threaded Slave benchmarks posted by Mat Keep

MySQL Utilities and Global Transaction Identifiers posted by Chuck Bell

New Replication, Optimizer and High Availability features in MySQL 5.6.5! posted by Rob Young 

Global Transaction Identifiers are in MySQL 5.6.5 DMR posted by Luís Soares

MySQL Workbench 5.2.39 GA Released posted by Michael Zinner  

MySQL Performance: 5.6-labs is opening a new era..  posted by Dimitri Kravtchuk 

On queries with many values in the IN clause  posted by Jorgen Loland

DATETIME DEFAULT NOW() finally available posted by Martin Hansson

MySQL team increases scalability by >50% for Sysbench OLTP RO in MySQL 5.6 labs release april 2012 posted by Mikael Ronström

Improvements for many-table joins in MySQL 5.6 posted by Jorgen Loland

Choose the Location of your InnoDB File-per-Table Tablespace posted by InnoDB Team

Semi-join in MySQL 5.6 posted by Roy Lyseng

InnoDB 2012 Spring Labs Release posted by InnoDB Team

Faster subqueries with materialization posted by Guilhem Bichot

Improved DBT-3 Results with MySQL 5.6.5 - posted by Øystein Grøvlen


April 2012 Labs Release – Online DDL Improvements  posted by InnoDB Team

Friday, April 6, 2012

RMOUG SIG

A big thanks to the Rocky Mountain Oracle User Group (RMOUG). They have just added MySQL as a new Special Interest Group (SIG).

The first official meeting will be held at the Quarterly Education Workshop on May 18th. This will be at the Colorado Oracle Broomfield offices. We plan on having Ronald Bradford, Dave Stokes, George Trujillo and myself all attending and presenting.

More information about RMOUG can be found here - www.rmoug.org

Thursday, April 5, 2012

MySQL Innovation Day

I will be attending the MySQL Innovation Day.  Don't just listen to a speech, come and interact with the engineers and the MySQL community!

The event will be featuring multiple “lightning” talks, BOFs with the Oracle’s MySQL Engineers.  If you cannot attend please join us via a live webcast.Some members of the MySQL community will also be invited to give presentations.

This event is being hosted at Oracle’s Conference Center in Redwood Shores, CA on June 5th, 2012.

Register information will be coming soon! This will be a great opportunity to preview some of the content that will be delivered during MySQL Connect Conference in September.

MySQL Connect Conference


MySQL Connect Conference --  September 29 and 30, 2012

Learn about the latest MySQL features, discuss product roadmaps, and ask questions directly to the Oracle engineers behind the latest MySQL code this year at the MySQL Connect Conference.

While you will see some Oracle OpenWorld umbrella branding around it, MySQL Connect is a different event. It is taking place just before Oracle OpenWorld and will have a separate pricing. Registration will open on April 16.

The Call for Papers will also be opening April 16th and the MySQL Community is encouraged to submit. It will only be open for approximately three weeks.

The MySQL Connect Conference will be jam-packed with technical sessions across these six tracks : Performance and Scalability, High Availability, Cloud Computing, Architecture and Design, Database Administration, and Application Development.

As Sarah Novotny was quoted saying in our press release “To have our own 2 day MySQL-focused event in conjunction with this year's Oracle OpenWorld is a testament to Oracle's commitment to listen to, support and foster the MySQL Community."  -- The Press Release for this event is available here.

Wednesday, April 4, 2012

International PHP Conference -- CODES

Early bird registration for the International PHP Conference might be over but Oracle has just received discounts. 

If you register for a 2 days with the code "Oracle 1" it will only cost you 499€ instead of 699€ +VAT. 
If you register for a 3 days with the code "Oracle 2" it will only cost you 699€ instead of 899€ +VAT.

Ulf Wendel from Oracle is going to be presenting 2 different sessions on MySQL:

The International PHP Conference will be held at the Maritim proArte Hotelin Berlin June 3 - 6 2012.