I know I’m a little late to the discussion, but Brian Aker posted a thought-provoking piece on the imminent death of MySQL replication to scale reads.  His premise is that memcached is so cool and scales so much better, that read replication scaling is going to become a think of the past.  Other MySQL community people, like Arjen and Farhan, chimed in too.

Now, I love memcached.  We use it as a vital layer in our datacenters, and we couldn’t live without it.  But it’s not a total solution to all …

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

check it out:
the announcement

plugin documentation


o) Fast Index Creation in the InnoDB Storage Engine
o) InnoDB Data Compression
o) InnoDB File Format Management
o) InnoDB INFORMATION_SCHEMA tables


yay!! gonna test the compression immediately :)

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 …