Ideas, releases, practical guides, and perspectives from the people building with MySQL.
First 10 to register this week will benefit from a 40% discount
The Percona Live MySQL Conference: London 2012 is just around the corner and we’ll be present both with talks as well as in the exhibition hall alongside other sponsors of the conference.
Talks & Hot Topics
Our very own Ivan Zoratti has the following two talks on Tuesday December 4th:
Hot backups are important for high availability, they can run
without blocking the application. Percona Xtrabackup is a great
tool for backing up InnoDB data.
We have created a backup tool called s9s_backup that makes
Xtrabackup really easy to use, and is fully integrated with
ClusterControl, which means that you can schedule backups with
ease and view the backups that you have taken, and also restore
the backups with no pain.
s9s_backup is available in the lastest version of ClusterControl
or you can download it here.
Is mysqldump totally useless
then?
No. If you would like to isolate and load only one table,
mysqldump is great, or if you want to …
We’ve recently implemented Galera clustering and have been pleased with the relatively easy install and implementation. A quick description of galera is the joining of individual mysql dbs as nodes to create a cluster that features multi-threaded synchronous replication, which allows for true high availability while still using your original db and engine (innodb). Likewise, [...]
Attached are the slides for my MySQL Connect talk Evaluating MySQL High-availability alternatives, which I will present today at 14:30 at the MySQL Connect conference.
A bit unusually I'm posting the material ahead of the talk. The point of the talk is about evaluating each alternative from your own perspective. With that in mind, if you're at the talk with your own laptop, feel free to browse the slides at your own pace from here.
Infor announced this week, that they will provide open source database alternatives to some of their products. MariaDB has been chosen, tested, and certified by Infor to be the open source database of choice (together with MySQL) for the Infor LN and ION products. Infor LN is Infor’s flagship ERP and is sometimes better known by its former name, Baan. It has 25 years of manufacturing know-how built into it and is used by more than 5,000 companies worldwide in a wide range of industries. These include automotive, industrial equipment and machinery, high tech and electronics, and aerospace and defense. This is a big stamp of approval that even the most critical systems can be run on MariaDB.
In other news, there are currently several really interesting paths coming together into some important milestones. The rest of this post …
[Read more]In the Matrix movie there is a scene where the heroes visit a spiritual councelor, and amongst the people in her waiting room they see a little boy, dressed like a buddhist monk, who can bend a spoon just by looking at it. When they ask him what he does to bend the spoon, the boy's answer is: "There is no spoon". And if you watch the movie to the end, you will see that he is right. (In that spirit, if this post is too long to read for you, just skip to the last paragraph for the answer.)
The title for this blog post is of course inspired by Baron's "Is automated failover the root of all evil?", which is a commentary on GitHub's detailed explanation of their recent Pacemaker-induced downtime. Baron makes a good question, but the …
[Read more]We’re delighted to share the news that our friends at MariaDB today announced the availability of MariaDB Galera Cluster!
We’ve been talking a good bit about MariaDB in the past few months and it’s great to see the MariaDB & Codership partnership result in today’s announcement.
Today we’re pleased to announce the availability of MariaDB Galera Cluster!
With this release, we’re addressing the numerous requests we’ve received over the past few months for a MariaDB-based Galera Cluster. MariaDB, the more reliable, performant, feature-complete & backwards compatible MySQL database becomes even more attractive by making it available for Galera Cluster.
What is it?
…
[Read more]My three previous blog posts I already wrote from Froscon. In this post I still want to go back and mention some people I met and discussions I had.
The MySQL side
There were of course many MySQL people, with both SkySQL and Oracle sponsoring. It was great to meet Carsten from Oracle, who has joined the MySQL Sales Engineer team in Europe (he moved from an OpenOffice position). That's my former team, so it was great to see a new face!
Going there the person I was most looking forward to meet was Hana Hütter, formerly a MySQL account manager for Central Europe, and now doing the same at SkySQL. My first ever MySQL sales gig was with Hana, and Ralf Gebhart who is also now with SkySQL but was not at Froscon. While Ralf was there only that first time to teach me how to be a Sales Engineer, with Hana we then continued to sell MySQL into telecom companies in many European cities. I had not met Hana since I left Sun. It was …
[Read more]People often assume the reason I talk at conferences is because I like to teach them about Galera, MySQL and other cool, open source things. That's of course true to some extent. But for me personally, another reason is even more important: It happens almost always that the audience teaches me something. Thus the process of public speaking has increasingly become my way to learn new insights. Low level details that aren't easy to learn by just RTFM.
