Ideas, releases, practical guides, and perspectives from the people building with MySQL.
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.
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.
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:
[Read more]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 …
[Read more]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 …
[Read more]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.