This is, of course, about Pessimistic and Optimistic--the two concurrency control interfaces used in database products. The idea is simple--or not, depending whether you confuse it with something else or not. Very often it is being confused with another pair of alternative choices in concurrency control: single-version (update-in-place) or multiversion concurrency control (MVCC). This is because of some natural predisposition: the pessimistic approach is typically used with update-in-place methods, while MVCC leans towards the optimistic approach. However, it does not have to be that way always because, for example, in the Solid's native product, solidDB, the choice of Pessimistic and Optimistic is given with both the mutiversioning disk-based engine and update-in-place in-memory engine. And, because the Solid's disk-based engine is available now under MySQL, the choice is extended to MySQL users, too.

So, what is Pessimistic? That is very …

So by now you know about the DB2 storage engine for MySQL....

http://www-03.ibm.com/press/us/en/pressrelease/21430.wss

I'm getting questions on how this can possibly work.

The answer is that MySQL Storage Engine layer is flexible, and most databases are designed around a stack that can work with it.

Databases parse, optimize, and fetch data. We have integrated engines at all levels of this stack. Some engines even work with a combination of layers.

Let us take Innodb for example. It has its own, though small, stored procedure language. We integrate for most queries with what is the optimizer layer in Innodb. We open up cursors inside of Innodb and then read those cursors. What happens when you do a rename table on an Innodb table? It executes a stored procedure to update Innodb's own …

Day 2 Photos

I gave my Intro to Cluster talk and then a Design and Internals of MySQL Cluster.

Also some photos from the DRBD BoF in the evening (which was really good). So was the BLOB streaming BoF earlier (but I didn’t take my camera out).

Currently in Eben’s keynote on Wednesday morning. As always, insightful and thought provoking.

World of awesome.

mysqlconf mysqlconf07

“What societies value is what they memorize. And how they memorize it and who has access to its memorized form determines who has power.”

We’re starting to become a society that “memorizes” private facts — not just public records being written down, but private thoughts, dreams and wishes.

“Living largely in a world of expensive written material and seeking to build a private database of things experienced and learned, early modern Europeans built in their minds memory palaces — imaginary rooms furnished with complex bric-a-brac and decorations. . . By walking through the rooms of the memory palace in their minds, [they] remembered things they needed to know.”

Photographs took a factual and emotional snapshot of experience …

Day 1 Photos

This is the day of the MySQL Cluster Tutorial that I gave… which seemed to go down rather well.

(btw, those photos are served out of a gallery instance running on top of MySQL Cluster) .

This morning as I was driving over to the MySQL conference I thought about something Guy Kawasaki said yesterday. He said that one indicator of a sketchy VC-seeking group is if their proposal includes a large chunk of money for database licenses ("a million dollars"). The idea was that if you're building a new product there's a better chance of funding if you use something like MySQL and don't have to spend a lot of the investment on your database.

Flash back to mid to late 90s. From my limited experience this was opposite. The company I worked for was using Oracle for one reason, because it made them look serious when talking to funders. It meant that we were serious about scalability and poised to handle the heavy click loads. (The ironic thing is that we weren't. The application fell flat on it's face during even minimal …

Listening to Bdale Garbee, the Open Source & Linux Chief Technologist at HP, at the 2007 MySQL Conference.

Bdale helps HP pick the clever things to do the maximize how they can help open source software.

What is community? Might be towns, schools, churches, sports teams, volunteer organizations. The internet made a new type of community. Folks with common interest but are dispersed geographically can now be a community.

Bdale talks a lot about the Linux community and contributions and how things have evolved over the years.

HP sells and ships a new server every 11 seconds. Based on they percentate of Linux servers that sell, they ship a Linux server every minute.

The second "keynote" of Wednesday morning at the 2007 MySQL Conference is Kaj Arno refereeing a conversation between a number of "database egos." Since MySQL has a number of storage engines there are a handful of folks who have founded major database technology efforts that can be used from MySQL.

Monty Widenius: Co-founder of MySQL [answers a lot of the typical quesitons about how MySQL started].

Heikki Tuuri: created InnoDB. Worked for Solid and then went to University and decided to start with something new. Monty convinced him to open source.

Mikael Ronstrom: Father of 5 children and creator of MySQL Cluster. Came from Ericcson.

Jim Starkey: Father of many databases, most recently the Falcon storage engine.

Ari Valtanen: CTO of Solid Information Technology.

Paul Whittington: Father of NitroDB. …

mysql 5.2 is now mysql 6.0:

6.0 is basically the falcon release with subquery optimizer additions.


6.1 Online backup, more subquery optimizations, foreign keys for main engines, and more performance diagnostics.


Online Backup Detail:
Cross Engine Support
Non-blocking for DML, ie. INSERT UPDATE not blocking
Blocking on DDL still
SQL command driven
Full server database and point in time recovery

Nitro Engine:
Extreme insertion rates
Linear CPU rates

PBXT

In beta
Not ACID complient but sort - of
Very fast rollbacks
Very few config tweaks


MYSQL Enterprise (Paid use Server)

• 
  
• Support, Server, and tools
  
  
  • Monitoring Tools:
    
    
  • New Replication …

The first keynote of Wednesday morning at MySQL Conf 2007 is Even Moglen, a professor at Columbia currently on leave, serving as the Chairman of the Software Freedom Law Center.

Eben describes some of the very early ways that information and experiences were captured. He talks about the mind as the place where experiences were stored. Pictures in the mind are kept as a part of our memory.

Privacy is not just the big secret you have that you don't want anyone to know. Identity theft is not just someone knowing four pieces of information. The loss of privacy people looking at your data and inferring what you will do next. The powerful organizations of the future will be able to aggregate.

Your browsing history used to be in the browser. Now it is a service. You give all of your browsing history to someone …