Very Encouraging

The last day of #OOW is here and MySQL events continue. Even after the big Sting concert last night. I am now sitting in a MySQL Crash Course talk given by Alexander Nozdrin and Dmitry Lenev. The room is packed (~100) ! A poll of the room  showed that the majority here are all new to MySQL. Very encouraging to see the MySQL community growing !

MySQL 5.6 Roadmap

The MySQL Roadamap session @ OOW was a wealth of information. 

Gier was able to talk some in-depth about the MySQL optimizer , ICP , Batched Key Access ("BKA") and Multi-Range Read ("MRR") , 'explain' updates, as well as traces. 

You can catch up on this as well with Rob Young's blog post available here.


Yoshinori also has a great blog post about 5.6.3: yoshinorimatsunobu.blogspot.com

Rob young also talked on MySQL Database Goals:

•   Re-factored architecture
• Pluggable feature set
• Deprecate legacy "baggage"
• Real data dictionary  (remove .frm files)
•   Better Cloud, Hosting, Saas features
• Auto-sharding, load balancing , automatic failover 
• Online operations
• Multi-tenancy, schema/catalogs, resource control, "elastic resources"
• Windows platforms
• Continue improvements

MySQL Cluster Goals

• Ease of use
• Enhanced API
• Performance & Capacity increases
• Wider Deployment options

Get MySQL 5.6.3 now and test out these great options !
MySQL 7.2.1 beta is available here.
Look for more blog posts on this topics as myself and the community tests and enjoys these features.

MySQL DAY @OOW

Today will be a busy day for MySQL @OOW.  The sessions today cover a wide range of MySQL users.

Sessions include:

• Advanced MySQL Replication 
• Getting to know the MySQL Enterprise Monitor
• MySQL Performance Tuning
• Introduction to InnoDB
• Getting the most out of MySQL on Windows
• MySQL for Beginners
• The MySQL Roadmap

Today also includes a MySQL WorkBench Hands on Lab and we then get to end the day with the MySQL Community Reception. 

The wealth of knowledge here from MySQL is outstanding.  We have even heard from attendees that are here only for MySQL.

Ok time to get started...!

MySQL Resources

So Sunday & Monday have been great! I was glad to be able to visit and talk with so many people from the MySQL community. While talking with the community, we often directed people to Sheeri's QR tag, which directed them to http://kimtag.com/MySQL. ( She posted about this here. ) This simple page is a great way to get a lot of resources in front of people with very few clicks. I was curious why mysql.com doesn't have something similar so we can help out. So, we made one.

So we took a quick look around and gathered some quick links for you. It is a simple list of resources that can be used to help direct people to top content about MySQL. Hopefully, you all find this page as useful as the QR tag was so far at OOW. You can find the new page here: http://dev.mysql.com/resources/ it is also labeled community resources in the devzone.

Topics include:

Scripts and Code

Tips and tricks

Recommended books

MySQL Events

MySQL User Groups

MySQL Oracle ACEs

Contribute Code

Subscribe to the Newsletter

Bugs Database

MySQL Technical Support

Training and Certification

MySQL Community Relations Team

We are looking forward to your help/links to update these pages. If, like Sheeri, you maintain your own list of helpful MySQL Resources, or, if you have a favorite book, or a favorite script, or a favorite tool, please let us know ! Put the MySQL Community Team to work, we are here to help you!

Oracle Open World Day 1

It was a good to put  face to the names today at day 1 of #oow11 .

Tried to spend most of the day supporting the MySQL Community Kiosk with Sherri, Sarah and Dave. I was able to step into a couple sessions to show support as well.

Day two the MySQL sessions will be at the Marriot Marquis Hotel. Moscone South will have MySQL demos at the Exhibition Hall and Moscone West will have the MySQL Community Kiosk. Come on down and support MySQL!

Focus on MySQL | Oracle OpenWorld 2011

Oracle OpenWorld is just a few days away now!

As a reminder, you can attend all of the Sunday MySQL sessions organized by IOUG and the MySQL community with a full OOW pass.

The MySQL community reception is also available to everyone on Tuesday .

See you soon !

Workbench Scripts

A was checking out the new Workbench today after I saw this blog post http://wb.mysql.com/?p=1169

It all worked great and very easy.  Nice clean code that helps out the PHP Developer.
example:
$host="localhost";
$port=3306;
$socket="";
$user="";
$password="";
$dbname="";

$con = new mysqli($host, $user, $password, $dbname, $port, $socket)
    or die ('Could not connect to the database server' . mysqli_connect_error());

//$con->close();


$query = "SELECT * FROM exampledb";


if ($stmt = $con->prepare($query)) {
    $stmt->execute();
    $stmt->bind_result($field1, $field2);
    while ($stmt->fetch()) {
        //printf("%s, %s\n", $field1, $field2);
    }
    $stmt->close();
}

While this is a simple example it is a fantastic way for new developers to get started and learn how things are done.

A DBA can easily write a complex query and hand over PHP code to the developer. Nice work!

The ability to then write your own plugins really opens it up for some advanced developers. 

This is a step in the right direction and supports working together between DBA and developer.

MySQL Oracle Open World Session Calendar

With 47 MySQL sessions at Oracle Open World this year we are going to be busy. Keeping updated on them in a easy fashion will be best for all of us.

Sheeri has a matrix here: http://technocation.org/files/doc/2011_OOW_MySQL_Content.html  

Oracle as a PDF here : http://www.oracle.com/openworld/oow11-focuson-mysql-486114.pdf

I went ahead and made public calendars so we can sync this information across our phones and etc....  I will update them when I find out  about any changes and then of course it should sync out to all of you who use them.


SESSIONS

XML https://www.google.com/calendar/feeds/pj443o2ojeggqfofr82p08jqo0%40group.calendar.google.com/public/basic

ICAL https://www.google.com/calendar/ical/pj443o2ojeggqfofr82p08jqo0%40group.calendar.google.com/public/basic.ics

HTML https://www.google.com/calendar/embed?src=pj443o2ojeggqfofr82p08jqo0%40group.calendar.google.com

DEMOs

XML - https://www.google.com/calendar/feeds/irv222fjo1mqo7neukv6dqfuto%40group.calendar.google.com/public/basic

ICAL https://www.google.com/calendar/ical/irv222fjo1mqo7neukv6dqfuto%40group.calendar.google.com/public/basic.ics

HTML https://www.google.com/calendar/embed?src=irv222fjo1mqo7neukv6dqfuto%40group.calendar.google.com

Come Swim with the Dolphins !

An Oracle Open World blog post for us ! It has highlights and links for you to see all the great MySQL content at Open World.

http://blogs.oracle.com/oracleopenworld/entry/come_swim_with_the_dolphins

Oracle Open World MySQL Sessions

Just ten days until Oracle Open World and MySQL is going to have a big presence! 
“Focus on MySQL” overall schedule is available here: http://www.oracle.com/openworld/oow11-focuson-mysql-486114.pdf

Here are a couple thoughts of mine about the week:

Support and visit the MySQL Community Kiosk at Moscone West Hall Level 2 as much as possible.

Sunday @ Moscone West 

A great line-up of presentations by the IOUG/MySQL Community itself. It will be hard to pick which sessions to see. MySQL ACE members Ronald Bradford and Giuseppe Maxia are some examples of the experts talking on Sunday.

Monday @ Marriot Marquis

The MySQL keynote by Tomas Ulin, of course, should not be missed.

Catch sessions by Oracle engineers and MySQL ACE members such as Sherri Cabral, Sarah Novotny, and Yoshinori Matsunobu.

Tuesday @ Marriot Marquis

Looks to have great sessions on MySQL replication, MySQL for Oracle DBAs, MySQL on Windows, as well as InnoDB and the MySQL roadmap. All look to be good to see.

Also take note of the hands on labs and learn from the expert himself.

MySQL Workbench: Developing MySQL Applications on Windows

- Mike Zinner, Software Development Director, Oracle

Tuesday at 11:45am – Marriott Marquis Salon 10/11

The MySQL Community Reception is also open to everyone,  space is limited so register today.

Wednesday @ Marriot Marquis

NoSQL, backup,monitor, data recovery and protection, scalability and Oracle integration talks from the experts. Mat Keep, Andrew Morgan, Rob Young, Lars Thalmann just to name a few.

Thursday @ Marriot Marquis

NoSQL Interfaces to MySQL Cluster, by Craig Russell, and What causes MySQL downtime, by Baron Schwartz a MySQL ACE member,  both look like good sessions. Cloud Computing solutions for MySQL is another good one by Charles Bell.

These are just a few of the 47 MySQL Sessions. All of the sessions are going to be loaded with knowledge from MySQL experts and it will be tough to pick  which expert you want to listen and learn from.