Archive for the ‘MySQL’ Category

Trip Report: OpenWest Conference

Look at those mountainsI attended the OpenWest Conference in Orem, Utah, and have to say its one of the best community organised conferences. There were over 840+ people at the conference (with more walk-in’s), representing a greater than 100% growth rate compared to last year’s conference.

I gave a talk about MariaDB, and its safe to say that we’ve got many new features that that it’s getting very hard to go in-depth in a span of an hour.

One of the highlights for me was attending talks. I give so many talks, and spend a lot of time talking to people about MariaDB and MySQL, that I very rarely get to see other talks or learn new things. So OpenWest was very welcome from that aspect.

On Thursday, I saw a wonderful presentation by Dave Wellman on Hadoop 101 and the Big Data Hype. That’s an excellent slide deck with lots of animations. Rasmus Lerdorf gave an excellent presentation on PHP in 2013 – very detail oriented, I learned a lot about PHP 5.4. 

The highlights for Friday were the two morning keynotes – both Rasmus Lerdorf and Mark Callaghan gave thoughtful speeches. I gave my talk (thanks for the nice words Mark), received lots of good questions and feedback (thanks to being right before lunch), attended Mark’s MySQL Q&A which was a great conversation for an hour. Many were interactive. I stuck around for Steve Meyers presentation Database Optimization for Web Developers, which was a 2hr tutorial and a good walkthrough. 

Overall, a great time at the conference. Not to forget all the social time chatting with Mark and Steve. I’ve enjoyed my trip to Utah (first time here), and thanks to Steve for having us speak about MariaDB, and the captive audience.

Testing Fedora 19

Today I downloaded Fedora 19 alpha to give it a spin. Some quick notes.

You can get MySQL by asking for the package community-mysql-server. This is 5.5.31. If you ask for stock “mysql” (i.e. yum install mysql-server), you automatically get MariaDB 5.5.30 (mariadb-server).

Fedora 19 runs systemd, so there is no longer /etc/init.d/mysql to start/stop/restart. So just do systemctl enable mysqld.service. Then perform: systemctl start mysqld.service. Replace start with: stop/status too. You can disable it too if you want.

MariaDB 10.0.2 compiles cleanly on Fedora 19 with gcc-4.8. Just perform: yum install bzr gzip tar gcc gcc-c++ make libtool bison ncurses-devel zlib-devel automake autoconf cmake. Get the source code (I just downloaded it). Do BUILD/compile-pentium64-max. Wait. Run make test. Enjoy. Refer to build environment setup, generic build instructions.

If running in a VM, set aside 15GB to ensure you always have sufficient space (I personally use 20GB as I like to test various upgrade scenarios too.

MHA & MariaDB Cassandra Interoperability talks

Together with Sergei Petrunia, we talked about MariaDB Cassandra Interoperability. Sergei has done wonderful work here and I plan to showcase more Cassandra integration going forward. It’s worth noting that Elena came up with the benchmarks for this talk as well.

Later, I gave a talk on MHA. Competing in a timeslot with Team Facebook‘s Q&A, I was surprised that we had a relatively good turnout in the talk. There were some interesting questions. I found many people still using MMM in production.

 

MariaDB 10.0 and What’s New With The Project

While we won’t be able to present an in-depth overview of MariaDB 10.0 & the project at the SkySQL Solutions Day, we did so at Percona Live Santa Clara 2013. Here are slides from our talk. We did a little show between Monty & me. Good thing we were right before lunch because we over-ran in terms of Q&A for quite some time.

Biggest MySQL related news in the last 24 hours, Day 2

Continuing on from yesterday, the biggest news that I’ve noted in the past 24 hours:

  1. The commitment from Oracle’s MySQL team to release a new GA about once every 24 months, with a Developer Milestone Release (DMR), with “GA quality” every 4-6 months. Tomas Ulin announced MySQL 5.7 DMR1 (milestone 11) [download, release notes, manual]. He also announced MySQL Cluster 7.3 DMR2 [download, article]. Needless to say, 5.7’s code isn’t pushed yet to lp:mysql-server/5.7. Of notable mention were the statistics around MySQL 5.6 of worklogs, bugs fixed, etc.
  2. The MySQL Applier for Hadoop which uses the binlog API to stream to HDFS.
  3. The media was all over the SkySQL-Monty Program merger, so today its just links: TechCrunch, ZDNet, ArsTechnica, Wall Street Journal (WSJ), PC World, The H, and in one of my favourite newspapers, The Financial Times (FT).

Did I miss any other important announcements/news bits?

Biggest MySQL related news in the last 24 hours

For me, the biggest news in the last 24 hours so far has been:

  1. SkySQL merges with Monty Program, developers of MariaDB. This of course affects me directly and leads to a change in affiliation in a few months.
  2. TokuDB goes opensource. I think this is really big news. Beyond just the fact that it can now be a storage engine in the main MariaDB tree, I love the work they’re doing to extend it to be an engine for MongoDB as well.
  3. Continuent Tungsten Replicator is now 100% opensource. Now you can extract data in real-time from Oracle, so think of this as Golden Gate without a price. I like this move.
  4. Wikipedia adopts MariaDB. Again, this is important and its also important that we have the MariaDB Foundation in place.

I expect a lot more interesting news to happen in the next 24-hours, so lets see if I wake up at 4am to postulate tomorrow.


i