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.

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.

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.

We spent today working on the last minute details for the mySQL conference. The important things: T shirts, pens, mugs, etc….

Seriously, I’m pretty excited about the conference. I think conferences have transmogrified since the days of Interop and Internet World ‘97-’00 and many have reemerged as events actually worth going to.

Back before the Internet, most people would go to conferences to actually learn about new products, trends, etc. Companies typically sent their best developers and product managers to meet with attendees. But sometime around ‘98, many attendees learned that they could find all the info they needed on the net and didn’t have to send anyone. Attendance dropped, and exhibitors stopped sending their best and brightest. The attendees at subsequent conferences were greeted by nit wits that didn’t know anything and attendance dropped further. The …