Posts Tagged ‘MariaDB’

Rackspace Cloud High Availability Databases for MariaDB, MySQL, Percona Server

Continuing on with the cloud theme, I think its worth noting that since mid-2014, Rackspace has offered MariaDB (as well as MySQL and Percona Server) in the cloud, as part of their Cloud Databases offering. It’s powered by OpenStack.

Now there is an additional “High Availability instance” being offered – this gives you up to two replicas per database instance, you have the ability to load balance reads across all replicas (pretty standard), but the cool thing to try out: failover is automatic. It’s not just that if the master fails, you get a new slave being the master; you get a replacement node being added, so as to ensure that your load keeps up with the traffic. These instances don’t cost much more (the higher the memory size, the cheaper it gets – 1.5% extra for something production ready, down to 7.7% more expensive for something to kick around the tires with)

There is also scheduled backups (daily incremental, weekly full) and you can specify the backup window.

Previously on Rackspace, you not only had to spin up a cloud database, but also a compute instance to access your databases. Now, they’re allowing you to get a public IP address, via an ACL.

In another post, I’ll go thru these services with the intention to update my deck and also share the results here. Have you tried or do you use Rackspace Cloud Databases?

3 Big Announcements from MariaDB (my take for Oct 2015)

Today I received about five emails with the subject: 3 Big Announcements from MariaDB. Maybe you did as well (else, read it online). October has brought on some very interest announcements, and I think my priority for the big announcements vary a little:

  1. MariaDB Server is now available on Amazon RDS – you wouldn’t believe how many people ask for this, as many now deploy using Amazon Web Services (AWS), so now that it is available, I consider this to be extremely amazing. You get 10.0.17 today, and within 3-5 months of a GA, you get the next release (the docs are a work of art – read them!).
  2. MariaDB Server 10.1 is now a stable GA – this is a milestone. Our last stable GA came out in March 2014. There are plenty of new features and we had a developer meeting to plan what comes in 10.2 as well. Remember to read: What is MariaDB 10.1?
  3. New XAMPP with MariaDB – The new XAMPP does not ship with MySQL any longer but MariaDB Server 10.0.17. This is going to help distribution tremendously as many people use XAMPP as a development environment (it is after all the most popular PHP development environment out there). Remember to get your downloads for Windows/Linux/OSX. 

I think the above are my highlights of 3 big announcements from the MariaDB world. What are you waiting for, download it now! And remember to report bugs/feature requests to our Jira instance.

Mark Callaghan at the Korean MySQL Power User Group

The Korean MySQL Power User Group gets a special guest speaker next weekend (Oct 31 2015 – 4pm – 4:33’s offices in Gangnam – nearest train stop is Samseong station, Line 2 – post requires Cafe Naver login) – Mark Callaghan (Small Datum, @markcallaghan, and formerly High Availability MySQL). I’ve been to many of their meetups, and I think this is a great opportunity for many DBAs to learn more about how Mark helps make MySQL and MongoDB better for users at Facebook. I’m sure he’ll also talk about RocksDB.

After that, as usual, there will be a DBA Dinner. This time the tab gets picked up by OSS Korea. See you next Saturday – Halloween in Seoul will have added spice!

MySQL NL Community Meetup with MariaDB speakers summary

Last week we had the MySQL Meetup with MariaDB Developers in Amsterdam, which went on easily for about 3.5 hours. Thanks to all for listening (these were lightning talks, not with a strict 5 minute clock with Q&A thrown in), and Daniël van Eeden for organising this at the eBay offices (whom kindly provided pizza, beer and soft drinks as well). We had many talks, and I’ve managed to put up most of the slides into a Google Drive folder, so feel free to access the bucket.

  1. How is the MariaDB sausage made? by Rasmus Johansson covers how MariaDB Server gets made from an engineering standpoint
  2. An inside look at the MariaDB restaurant by Daniel Bartholomew covers how MariaDB Server gets released
  3. ANALYZE for statements by Sergei Petrunia
  4. Data at Rest Encryption in MariaDB 10.1 by Sergei Golubchik (HTML presentation so will prompt a download for you to view in the browser)
  5. Cool MariaDB Plugins by Colin Charles
  6. Passwordless login with unix auth_socket by Otto Kekäläinen
  7. InnoDB in MariaDB 10.1 by Jan Lindström
  8. PCRE Regular Expressions in MariaDB by Alexander Barkov
  9. MaxScale by Massimiliano Pinto
  10. Overview of failover handling in the MariaDB Java Connector by Diego Dupin
  11. Profile Guided Optimization by Axel Schwenke
  12. MariaDB Server in Docker by Kolbe Kegel
  13. Systemd by Dan Black (there were no slides, and the work was being pushed into 10.1, so the crowd got to see svoj come up with his laptop, and Dan made the commit by hitting the Enter key. IIRC, the commit was 20c2ae39db3dd0ec4c337a9b0bd2bf4481b61e49)
  14. Engine Independent Table Statistics including Histograms by Sergei Petrunia

Georg Richter had prepared a presentation but decided not to give it, since we already had quite a lot of talks and discussion throughout the sessions. If you’re interested in MariaDB Connectors, the presentation is worth a read.

Thanks again to Daniël van Eeden and Jean-François Gagné whom really helped get this stuff going.

P/S: for some pictures, I live tweeted them:

LinuxCon North America in Seattle

I’m excited to be at LinuxCon North America in Seattle next week (August 17-19 2015). I’ve spoken at many LinuxCon events, and this one won’t be any different. Part of the appeal of the conference is being able to visit a new place every year.

MariaDB Corporation will have a booth, so you’ll always be able to see friendly Rod Allen camped there. In between talks and meetings, there will also be Max Mether and quite possibly all the other folk that live in Seattle (Kolbe Kegel, Patrick Crews, Gerry Narvaja).

For those in the database space, don’t forget to come attend some of our talks (represented by MariaDB Corporation and Oracle Corporation):

  1. MariaDB: The New MySQL is Five Years Old & Everywhere by Colin Charles
  2. MySQL High Availability in 2015 by Colin Charles
  3. Handling large MySQL and MariaDB farms with MaxScale by Max Mether
  4. The Proper Care and Feeding of a MySQL Database for a Linux Administrator by Dave Stokes
  5. MySQL Security in a Cloudy World by Dave Stokes

See you in Seattle soon!

#PerconaLive Amsterdam – schedule now out

The schedule is out for Percona Live Europe: Amsterdam (September 21-23 2015), and you can see it at: https://www.percona.com/live/europe-amsterdam-2015/program.

From MariaDB Corporation/Foundation, we have 1 tutorial: Best Practices for MySQL High Availability – Colin Charles (MariaDB)

And 5 talks:

  1. Using Docker for Fast and Easy Testing of MariaDB and MaxScale – Andrea Tosatto (Colt Engine s.r.l.) (I expect Maria Luisa is giving this talk together – she’s a wonderful colleague from Italy)
  2. Databases in the Hosted Cloud Colin Charles (MariaDB)
  3. Database Encryption on MariaDB 10.1 Jan Lindström (MariaDB Corporation), Sergei Golubchik (Monty Program Ab)
  4. Meet MariaDB 10.1 Colin Charles (MariaDB), Monty Widenius (MariaDB Foundation)
  5. Anatomy of a Proxy Server: MaxScale Internals Ivan Zoratti (ScaleDB Inc.)

OK, Ivan is from ScaleDB now, but he was the SkySQL Ab ex-CTO, and one of the primary architects behind MaxScale! We may have more talks as there are some TBD holes to be filled up, but the current schedule looks pretty amazing already.

What are you waiting for, register now!


i