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, …

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, …

Georg and his MySQL Connectors Team today surprised the MySQL Community and most of his Sun-MySQL colleagues by releasing a "Full House" of Connector releases.

• ODBC 5.1 GA
  
• ODBC 3.51.25 GA update 
  
• Connector/.NET 5.0.9 GA update 
  
• PDO MySQLND preview 
  
• Connector/OpenOffice.org preview 
  

The ODBC 5.1 GA marks a very important milestone for the MySQL …

A

Okay, so I have 2 distinct masters and each master has its own slave. I want to consolidate the data in both slaves but I don't want to have a multi-master replication. Since slaves cannot have dual masters, then I cannot do a multi-slave replication.

I spoke to Stewart Smith in the MySQL Conference and he confirmed that MySQL does not have a mulit-slave replication and he mentioned that I could just do change master to point to the other slave and then change master again... but there will be latency.

The 20 second summary from the Scaling MySQL - Up or Out? from our panel of experts at 2008 MySQL Conference and Expo.

• Paul Tuckfield from YouTube — The answers to everything is replication, you just have to rephrase the question.
• Jeff Rothschild from Facebook — Memory, the source of all problems is your developers.
• Domas for Wikipedia — You should be afraid that 10 min structural change may answer detailed problems.
• Fahan Mashraqi from Fotolog — Architect property, the most optimized schema may not be enough, what is the cost of serving the data, no just the …