Posts Tagged ‘Percona’

Tab Sweep – MySQL ecosystem edition

Tab housekeeping but I also realise that people seem to have missed announcements, developments, etc. that have happened in the last couple of months (and boy have they been exciting). I think we definitely need something like the now-defunct MySQL Newsletter (and no, DB Weekly or NoSQL Weekly just don’t seem to cut it for me!).

MyRocks

During @scale (August 31), Yoshinori Matsunobu mentioned that MyRocks has been deployed in one region for 5% of its production workload at Facebook.

By October 4 at the Percona Live Amsterdam 2016 event, Percona CEO Peter Zaitsev said that MyRocks is coming to Percona Server (blog). On October 6, it was also announced that MyRocks is coming to MariaDB Server 10.2 (note I created MDEV-9658 back in February 2016, and that’s a great place to follow Sergei Petrunia’s progress!).

Rick Pizzi talks about MyRocks: migrating a large MySQL dataset from InnoDB to RocksDB to reduce footprint. His blog also has other thoughts on MyRocks and InnoDB.

Of course, checkout the new site for all things MyRocks! It has a getting started guide amongst other things.

Proxies: MariaDB MaxScale, ProxySQL

With MariaDB MaxScale 2.0 being relicensed under the Business Source License (from GPLv2), almost immediately there was a GPLScale fork; however I think the more interesting/sustainable fork comes in the form of AirBnB MaxScale (GPLv2 licensed). You can read more about it at their introductory post, Unlocking Horizontal Scalability in Our Web Serving Tier.

ProxySQL has a new webpage, a pretty active mailing list, and its the GPLv2 solution by DBAs for DBAs.

Vitess

Vitess 2.0 has been out for a bit, and a good guide is the talk at Percona Live Amsterdam 2016, Launching Vitess: How to run YouTube’s MySQL sharding engine. It is still insanely easy to get going (if you have a credit card), at their vitess.io site.

CfP for Percona Live Santa Clara closes November 13!

At Percona Live Amsterdam recently, the conference expanded beyond just its focus areas of MySQL & its ecosystem and MongoDB to also include PostgreSQL and other open source databases (just look at the recent poll). The event was a sold out success.

This will continue for Percona Live Santa Clara 2017, happening April 24-27 2017 – and the call for papers is open till November 13 2016, so what are you waiting for? Submit already!

I am on the conference committee and am looking forward to making the best program possible. Looking forward to your submissions!

What’s next

I received an overwhelming number of comments when I said I was leaving MariaDB Corporation. Thank you – it is really nice to be appreciated.

I haven’t left the MySQL ecosystem. In fact, I’ve joined Percona as their Chief Evangelist in the CTO Office, and I’m going to focus on the MySQL/Percona Server/MariaDB Server ecosystem, while also looking at MongoDB and other solutions that are good for Percona customers. Thanks again for the overwhelming response on the various social media channels, and via emails, calls, etc.

Here’s to a great time at Percona to focus on open source databases and solutions around them!

My first blog post on the Percona blog – I’m Colin Charles, and I’m here to evangelize open source databases!, the press release.

MySQL related IRC discussion channels

There are many MySQL related IRC discussion channels as the ecosystem itself grows. I join the following. Are there any that I’m missing?

Freenode (irc.freenode.net):

  • #mysql – main channel for all kinds of end user MySQL related discussions (the noisiest of the lot, naturally)
  • #maria – main channel for all kinds of MariaDB related discussions
  • #webscalesql – for all kinds of WebScaleSQL discussions
  • #percona – main channel for all kinds of Percona related discussions
  • #tokutek – main channel for Tokutek discussions (TokuDB or TokuMX)
  • SkySQL-specific channels: #maxscale and #mariadb-mgr

OFTC (irc.oftc.net):

  • #debian-mysql – for all kinds of Debian MySQL related bits (packaging, bugs, etc.)

Percona has more MariaDB features now

Lately more people ask me for comparisons between Percona Server & MariaDB. There isn’t a definitive blow-by-blow feature comparison yet, but it’ll come soon.

All that said, its great to see new features from MariaDB make it into Percona Server. The features that I’ve managed to track: group commit for the binary log, threadpool and atomic write support for Fusion-io devices.

It started with the group commit for the binary log feature in Percona Server 5.5.18-23.0 (docs). 19 December 2011 is a long time ago, and before we made MariaDB 5.3 or 5.5 GA as well. 

The next feature that made it into Percona Server was the threadpool (different implementation compared to MySQL Enterprise). We had a threadpool since MariaDB 5.1 (libevent based), but improved it drastically in MariaDB 5.5. It made its debut in Percona Server 5.5.29-30.0 (26 February 2013 – so about 10 months after we included the feature), but was further improved in 5.5.30-30.2 to include priority connection scheduling.

The latest feature to be included? Fusion-io DirectFS atomic write support. It made its debut in Percona Server 5.5.31-30.3 (24 May 2013 – so about a month since we included the feature). I like this because Laurynas Biveinis provided some feedback on the maria-developers list.

Great opensource at work here. I look forward to more features making their way back & forth between the branches.

Upcoming talks in Santa Clara

I’m planning my calendar and thought I’d share what talks I’d be giving in Santa Clara in a couple of weeks for the Percona Live MySQL Conference & Expo 2013 and the MySQL & Cloud Database Solutions Day 2013. Its going to be a busy April 22-26 2013.

  1. MariaDB Cassandra Interoperability with Sergei Petrunia on 23 April 1:20pm – 2:10pm @ Ballroom D
  2. MariaDB BoF on 23 April 6:00pm – 7:00pm @ Ballroom F
  3. MariaDB 10.0 & What’s New With The Project with Monty Widenius on 24 April 11:10am – 12:00pm @ Ballroom C
  4. MHA: Getting started & moving past the quirks on 25 April 1:50pm – 2:40pm @ Ballroom B
  5. Why MariaDB, and what is new? panel with Rasmus Johansson, Sergei Gobubchik, Ivan Zoratti at 9.30am on 26 April
  6. MariaDB Galera Cluster Overview with Henrik Ingo, Max Mether at 11.15am on 26 April
  7. MySQL and Cassandra Integration with Sergei Petrunia at 1pm on 26 April

Percona Live MySQL Conference and Expo, April 22-25, 2013

Come along, use code SponsorSQL to get a 15% discount to Percona Live. The SkySQL Cloud day on the 26th is completely FREE so register now!


i