Here are my liveblogging notes from MySQL Sandbox: Easily Using Multiple Database Servers in Isolation by Giuseppe Maxia

Giuseppe has been a community member since 2001, and in the past year or so, a MySQL Employee.

He likes to give things away for free — he gave away T-shirts to the early arrivers to the workshop, and that’s why he’s giving away the sandbox as well. The sandbox is NOT an official MySQL product. It is released from GPL, available from http://sf.net/projects/mysql-sandbox.

Why the sandbox? To be able to set up 1 server in under 10 seconds. And to be able to set up multiple MySQL instances very quickly, and to use them quickly.

The sandbox untars in seconds, for …

Today there are a lot of presentations that stand out. They include:Roland Bouman - Information_schema presenations.Tobias Asplund and Jay Pipes - MySQL Performance.Tom Hanlon - Benchmarking and Monitoring.Balint - Deadlocks, Wait Timeouts and Other Transactional Issues.Grimmer - MySQL Backups using LVM Snapshots.

Monday I gave a presentation at the MySQL User Conference in Santa Clara.  I uploaded my presentation materials as a PDF to my website.  It's available under the Creative Commons 2.0 license for non-commercial, no derivative use.Download the PDF at http://www.karwin.com/downloads/SQL_Antipatterns_MySQLUC2008.pdf

Here is the quick notes from the session Scaling MySQL - Up or Out ? moderated by Kaj Arno as part of the todays keynote.

Here is the list of panelists are ordered by Alexa ranking.

1. Monty Taylor (MySQL)
2. Matt Ingerenthron (Sun)
3. John Allspaw (Flickr)
4. Farhan Mashraqi (Fotolog)
5. Domas Mituzas (Wkipedia)
6. Jeff Rotheschild (Facebook)
7. Paul Tuckfield (YouTube)

…

FYI, I changed two parameters on Planet MySQL to accomodate the current flood of postings coming from the MySQL Conference attendees: we now display the last 25 posts (instead of 10) on the front page, the RSS feed now includes the latest 100 posts (instead of 50). This should make sure that posts actually make it to the front page for at least some time, before they fall off again.

Please keep up the good blogging!

It's great seeing all the excitement and enthusiasm at the MySQL conference. From my perspective some of the key highlights from the first two days include:Monday - Memcache - A big hit with a lot of interest.Tuesday: Top Highlights Mårten and Jonathan's keynotes.New features in InnoDB - Ken Jacobs showed a number of new features in the new alpha release of InnoDB that really stood out. It's a

• Robert Hodges from Continuent presents
• About Continuent
  • leading provider of open source database availability and scaling solutions
• solutions
  • uni/cluster - multi-master database clustering that replicates data across multiple databases and load balances reads
  • uses "database virtualization"
• scale-out design motivation
  • protection from db and site failures
  • continuous operation during upgrades
• how come not everyone has it already?
• creating identical replicas across different hosts is hard
  • Brewer's conjecture
• trade-offs
  • DDL support
  • inconsistent reads between replicas
  • deadlocks
  • sequences …

MySQL Sandbox 1.20 was released yesterday.
The new feature, as suggested by Ronald Bradford, is the ability of creating a group of servers from different versions. So now you can have a group of N servers in a group, each one having a distinct version. The cool thing is that using the Sandbox built-in scripts you can send a command to all the servers at once, thus being able to check the answer from different versions.

Need to know more? I will be speaking about the Sandbox at the MySQL Users Conference and Expo. TODAY! 2007-04-16 at 10:50

ebizApril 16, 2008Kickfire and Open Source Partners Team to Deliver BI Solutions on MySQL Database Appliance (http://www.ebizq.net/news/9416.html?grss)

Keynotes

The conference committee managed to get Rick Falkvinge of the Swedish Pirate Party to speak. I heard him speak at OSCON 2007. What I took away from his talk is copyright is evil. Copyright is the excuse industries (i.e. the music industry) are using as a tool to justify monitoring all of your communications. Not only do they want to monitor you, but prohibit certain kinds of communications. What it comes down to is your privacy vs. copyright. It's scary stuff.

The second part of the keynote was a panel consisting of a representative from MySQL, Sun, flickr, …