Monday, June 25, 2012

EdMedia 2012

I will be attending the EdMedia 2012 conference this week.

This is a World Conference on Educational Media and Technology, so I look forward to seeing how we can help expand the use of MySQL for educational purposes.

The conference will be in Downtown Denver this year, I look forward to seeing everyone.

Friday, June 15, 2012

MySQL Innovation Day Presentations

Thanks to the MySQL Community for all of the support around the past MySQL Innovation Day.  We had a great turnout on-line and in-person. It was exciting to hear about all the features coming in MySQL 5.6. The community and engineers also had time to interact about some of the new features at the BOFs afterwards.

If you missed anything.. all the slides are now available for you to download. If you watched the webcast of the AM sessions, do not forget the afternoon had great sessions as well. All of the sessions slides and some video are now available here.

Look forward to seeing everyone at MySQL Connect so we can continue supporting MySQL.

MySQL Connect Content

While the agenda is still subject to change and some updates are certainly coming, we have a first look at the great content at the MySQL Connect Conference this year.

Oracle's is sending some of their talented MySQL engineers and they will have sessions on Backups, Performance Schema, InnoDB, Replication, Utilities, PHP, Python, the new Optimizer and etc etc...

We also have some talks from the MySQL Oracle ACEs :
The MySQL community has also provided some great technical sessions.

Take advantage of this great line-up ! The early bird discount of $500 is available until July 13th! Register Here

Friday, June 8, 2012

SELF 2012 Begins

The week started with MySQL Innovation Day , which included some great presentations for the Oracle engineers and the MySQL community.

Today though is MySQL Day at SELF and it is packed with top MySQL presentations from Oracle and the MySQL Community including: Sheeri Cabral, Ronald Bradford, Peter Zaitsev, Baron Schwartz, Jeff Mace, Charles Bell, Craig Sylvester,  David Stokes and even myself.

If your in the area we hope to see you !

Tuesday, June 5, 2012

MySQL Innovation Day Highlights

Today was a great day. The MySQL Innovation Day had a great turn out. The  room was packed and numerous others watching the webcast. Many thanks to the MySQL community for coming out to support this event. 

Here is a few quick highlights from MySQL Innovation Day:

The GPL Community version of the MySQL server will have:

    -- MySQL Replication has a lot of different enhancements, the most ever in a release.
         -- High Availability and Fail-over
            -- Global Transaction Ids
            -- Replication Administration and Fail-over Utilities
         -- Better Data Integrity
           -- Crash-Safe Slaves, Replication Checksums,  Crash-Safe Binlog
         -- Better Performance, Scale
            -- Multi-threaded slaves
            -- Reduced Binlog size for RBR
         -- Extra flexibility
            -- Time-delayed replication
         -- Simpler troubleshooting
            -- Row-based repl. logging of original query
         -- Enhanced Monitoring/Management

    -- New optimizer enhancements
         -- Subquery Optimizations
         -- File sort optimizations with small limit
         -- Index Condition Pushdown
         -- Batched Key Access and Multi Range Read
         -- Postpone Materialization of views/subqueries 
             --Update, Insert and Delete
             --JOSN output options
    -- MySQL Performance Schema in MySQL 5.6 will monitor and track everything in your MySQL server with very little overhead!  
    -- InnoDB enhancements
         -- Better Performance, Scale
         -- Improved performance on multi-core/CPU servers
         -- Improved thread scheduling
         -- Reduced contention during file extension
         -- Deadlock detection now non-recursive
         -- Improve LRU flushing
         -- Increase max redo log size
         -- Separate tablespaces for undo log
         -- Fast checksum
         -- Better recovery
         -- Dump and restore buffer pool
         -- Better Usability
         -- Full-text Search
         -- Variable page sizes – 4k, 8k
         -- Larger limit of index key prefixes (3072 bytes)‏

News on MySQL Cluster 7.3:
         -- Will have Foreign Keys!
         -- Automate configurations and provisioning ( )
   Reasons for Cluster:
         -- 1.2 Billion UPDATES ACID compliant transactions per minute.
         -- Elastic Cluster growing in minutes
         -- Online Scale-out and Schema changes
         -- Shared nothing with no single point of failure 

"We believe that NoSQL and MySQL should work side by side". Why have different sets of data when you can take advantage of the same data in different ways. Look for NoSQL and MySQL to work together in Cluster and InnoDB (

Some nice quotes :

Why does Twitter use MySQL? "InnoDB does not loose data!"

"PostgreSQL is a great option, if MySQL didn't exist"

The day ended with a packed BOF with top community members of MySQL providing MySQL excellent feedback and ideas.

Again thanks to the MySQL for attending and supporting MySQL. 

Saturday, June 2, 2012

MySQL Community Reception

Don't forget to join us Tuesday for the MySQL Community Reception.
While the webcast users will have to miss you those who attend will have a great afternoon packed with great sessions , BOFs, a keynote by Jeremy Cole, DBA Team Manager, Twitter and of course the MySQL Community Reception.

You can still register to attend the event in-person !

Friday, June 1, 2012

MySQL Innovation Day

MySQL Innovation Day is just a few short days way and it has a great agenda this year. Be sure to take advantage of this free event, you can register to attend the event in-person or register to attend the event on-line. 

The agenda will include some great content regardless of how you attend.

Opening Keynote: What’s New and Cool in MySQL 

Lightning Talks:

Better Availability with InnoDB Online Operations
  • Calvin Sun, Sr. Development Manager for InnoDB, Oracle
MySQL Replication HA: Global Transaction IDs for Failover & Self Healing
  • Lars Thalmann, Director of MySQL Replication, Backup and Connector Development, Oracle
  • Luis Soares, Sr. Software Engineer, MySQL Replication, Oracle
Pinterest: Growing from 0 to Billions of Page Views per Month in a Year on MySQL
Overview of New Optimizer Features in MySQL 5.6
  • Manyi Lu, Sr. Engineering Manager, MySQL Optimizer, Oracle
MySQL 5.6 Performance Schema
MySQL Cluster: What's New, What's Coming
  • Bernd Ocklin, Director of MySQL Cluster Engineering, Oracle
Best of Both Worlds: NoSQL Access to MySQL
MySQL Master Failover Solution

The webcast will unfortunately end here because of lunch. We will however have additional in-person sessions available after lunch. 

Lightning Talks:

MySQL Replication High Performance: Multi-Threaded Slaves and Group Commit
  • Lars Thalmann, Director of MySQL Replication, Backup and Connector Development, Oracle
  • Luis Soares, Sr. Software Engineer, MySQL Replication, Oracle
The Power of MySQL EXPLAIN
  • Manyi Lu, Sr. MySQL Staff Engineer, Oracle
InnoDB: a New Era for Read-Only Workloads
  • Calvin Sun, Sr. Development Manager for InnoDB, Oracle
Best Practices for Using MySQL in the Cloud
  • Luis Soares, Sr. Software Engineer, MySQL Replication, Oracle 
  • Chuck Bell, Sr. MySQL Software Developer, Oracle

Closing Keynote: Scaling Twitter with MySQL

BoF Sessions
  • MySQL 5.6 - InnoDB
  • MySQL Utilities
  • MySQL Cluster: Deliver 4 Billion Queries per Minute
  • MySQL 5.6 - Replication
  • MySQL Optimizer
MySQL Community Reception

Remember, it doesn't stop here...  Join us at MySQL Connect so you can learn, share, and network with the MySQL community in a conference jam-packed with technical sessions, hands-on labs, birds-of-a-feather sessions, exhibits, demos and networking events.