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 …

Yesterday I presented “Best Practices for Database Administrators” at the MySQL User Conference and Expo. I was successful in streaming the live video on www.ustream.tv, and you can see it in totality at http://www.ustream.tv/recorded/352479.

The slides are available in pdf form. And here are some of the links I spoke about:

cacti
nagios
rt

MySQL 5.0 manual
…

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

MySQL Sandbox - More of a demo.

Applied Partitioning Scaling Your Database System - Sucks! I can find the commands in the manual.

MySQL Performance Under a Microscope - Nice and entertaining. Comparison of different techniques.

Query Cache Session - Interesting. Nice and clear presentation to a topic I usually misunderstood.

Benchmarking / Monitoring Session - So-so. Nice to see the different tools out there and speaker tries to give pro and cons.

Jonathan Schwartz’s Keynote at the 2008 MySQL Conference can be played directly in your browser or you can download the 147MB .wmv file. (Please do not download the movie on the conference wireless system!)

I finally realized who Jonathan Schwartz reminds me of:

That’s right, comedian and magician Penn Jillette.

Schwartz started by saying, “enough of this free software stuff!” It got lots of laughs. He started to talk about Sun’s agenda, and mentioned that MySQL and Sun had similar values, as well as similar dysfunctions as well — particularly that each engineer has his/her own opinion.

But Schwartz goes on in earnest to say “The …

There’s quite a bit of buzz on the blogosphere from people I respect a great deal, like Jeremy Cole at Proven Scaling and Vadim at Percona, about MySQL’s new Enterprise backup plans.  

The big deal?  They’re releasing a Community version that doesn’t have all the same features as the Enterprise version of Online Backup, including compression and encryption.  The Community version is open-sourced under GPL, the Enterprise version is not.

Personally, I think this is awesome. Don’t get me wrong – I love open source.  We couldn’t have built our business without it, and we love it when we get a chance to contribute back to the community.

But …

Firstly, I finally realized who Jonathan Schwartz reminds me of:

That's right, comedian and magician Penn Jillette.

Schwartz started by saying, "enough of this free software stuff!" It got lots of laughs. He started to talk about Sun's agenda, and mentioned that MySQL and Sun had similar values, as well as similar dysfunctions as well -- particularly that each engineer has his/her own opinion.

read more

It is annoying when bloggers would write 'notes' about a presentation in the conference when all they are doing is just copying the presentation slides.

That is not note-taking since copying the slides doesn't make sense. Note-taking is giving insights to the presentation or adding / deleting information to certain parts of the slides.

My ears are tingling when I hear people typing on their keyboard and then later on would upload their 'notes' regarding the presentation. Instead they should stop what they are doing and just listen to the speaker and try to digest what he is saying.