The latest from the MySQL community

If you were quick you may have noticed at the MySQL Conference 2007 keynote Welcome and State of MySQL AB talk this morning, Robin Schumacher in his quick demo of MySQL Monitoring & Advisory Service showed the MySQL Network Enterprise Dashboard, you would have noticed the MySQL Version 6.

It’s an early start this morning at 8:20am at MySQL Conference 2007 with CEO Mårten Mickos keynote talk Welcome and State of MySQL AB. His spirit is evident with his opening slide “The Participatory & Disruptive spirit of the Dolphin.

Listening to Guy Kawasaki speaking on the Art of Innovation at the 2007 MySQL Conference. Guy worked for Steve Jobs as the Macintosh software evangelist from 84 to 87 (in the Macintosh division) trying to help people build software. Apple II was making all of the money and Mac spending it all.

Guy is now a VC, trying to find folks running great companies in their garage.

Top 10 format for being innovative:

1. Make meaning. The greatest motivator. Steve Wozniak was motivated by the desire to change the world. Do not tell VCs you want to "make money." You attract the wrong kind of people. [cool Nike ad about woman and how she is measured]
2. Make a mantra (not a mission statement). A mission statement is made at a fancy …

Tuesday morning at the 2007 MySQL Conference kicks off with Marten Mikos.

Marten talks about the shift from packaged, closed-source software running on commodity hardware. Today the most advanced companies are providing on-demand service, built with open source software, running on commodity hardware.

Open source disrupts inefficient models and produces new wealth (don't kill the messenger, open source is just a response to the market). It attracts the brightest developers, serves the fastest growing businesses, venture capital, and more.

Marten talks about amateurs vs. professionals and that the historical context of amateurs. The original meaning of the term amateurs

MySQL (the company) must be aware of innovation...both from internal and external sources.

Robin Schumaker steps up for a few minutes to demonstrate the MySQL Monitoring and Advisory …

My good buddy and very smart individual Tim Ellis better known as Time, gave a talk on the site he help scale, digg.com.

Major technology used is

Memcache - used in a way to cache certain chunks of content.
mySQL - used for dynamic content
PHP to join the content in memory.


mySQL Portion:

- single master -> seperate searches out
-> primary pool
-> batch pool
-> dataware house pool

Sharding:

Table based - make slaves of certain tables
Date based - split data out by date
Range Base - split data out by a increment id
Hashed - split data out by a arbitrary column mod the number of servers
Partial Sharding - not clear what this is.

Basically the method is a partitioning + sharding method.

I am sitting in the session "Getting Best out of MySQL on Solaris 10" by Yufei Zhu (yufei.zhu at sun.com)

She is going to focus on InnoDB performance tips and how to monitor performance on Solaris using Dtrace examples.

When we try to use mysqldump to backup in zones, it ends prematurely.

MySQL is single process, multi-threaded application. Thousands of user connections means thousands of threads and this becomes a problem for some customers. MySQL and Sun Microsystems are close partners (I really doubt the "close" part).

She is now going over the characteristics of InnoDB like the storage of data in primary key order physically. You don't want your primary key too long (haha, come to my session for a different point of view).

When MySQL is first started, 10 threads are created.

thread 1 handles network connections and creates new threads for new user …

We (me and Michelle) arrived late Sunday night in Santa Clara to attend the MySQL Conference and already it's so much fun that I haven't been blogging at all.

Yesterday night we had dinner with some friends including Mark Atwood, Marc Simony, Ronald Bradford, Sheeri Kritzer, Mr and Mrs. Cole, Eric Bergen, Pascal and Christine.

Sheeri also got an award for being the top community advocate.

Marten and Guy Kawasaki's keynotes were very interesting. Ronald has done a good job of jotting the interesting points from Guy Kawasaki's keynote.

More to follow...

So, I asked in #mysql on feenode about an IRC channel for the 2007 MySQL Conference.  Some folks said that #mysqluc had been used before.  So, we started it.  If you wanna join, hop in.  If you hear of a more official channel, drop by and let us know.

First day's over — *phew*

I got to meet a lot of nice people, some of which I haven't seen in years (Heya Lukas and Damien S. :-) and it was great. There was a lot to talk about during the breaks and at dinner so it practically didn't get boring for a solid 12 hours today. I expect 14 to 16 of that tomorrow, maybe more.

The first tutorial I went to was Jeremy's and Eric's MySQL Scaling and High Availability. There are already two decent summaries up, so I won't repeat what written there. I just want to emphasize …

For those of you attending my JDBC 4.0 and MySQL session, you can find the sample code I'll be using in the Connector/J subversion repository

http://svn.mysql.com/svnpublic/connector-j/trunk/jdbc-4-0-examples/

I'll have it up on the projector, but it's often easier to follow along locally.