Parallel replication is a much-expected feature of MySQL. It’s available in MariaDB 10.0 and in MySQL 5.7. Yet, both lose efficiency when replicating through intermediate masters. In this post, we’ll explain how parallel replication works and why it does not play well with intermediate masters. We’ll also offer a solution (hint: it involves Binlog Servers).
A rapidly increasing number of large, high traffic sites are using MariaDB Galera for their database needs. This makes sense since it works so well. Administrators will connect asynchronous slaves to Galera for reporting, back-ups and disaster recovery.
MariaDB Galera is a very dependable system, involving the coupling of MariaDB with Galera. Nevertheless, Galera administrators need to check regularly the consistency of their slaves. An excellent tool for doing this is the pt-table-checksum. Read this blog for more about using it.
Members of Team MariaDB have now all made it home from SCALE13X, held in LA. This year we had three talks. Max, talked about Advanced Query Routing and Proxying with MaxScale, and Sharding Your Data With Spider, while Colin Charles talks about MySQL in the Hosted Cloud. The talks will be available online shortly via the SCALE13X Website - we will tweet out links to our talks once they are posted.
Team MariaDB is touring across several European regions again with the theme "Scaling at its Best!". Join us for product pitches, new features and enhancements, and what is next for MariaDB, MaxScale and the MariaDB ecosystem.
We will start next week Tuesday in Helsinki where Patrik Sallner (MariaDB CEO), Michael "Monty" Widenius (MySQL inventor and MariaDB Board Member) and Rasmus Johansson (MariaDB VP Engineering) are among the listed speakers. On Thursday we will continue in Stockholm. More dates and locations are listed below.
The conference season has begun for us here at MariaDB. It seems like the almost all linux and MySQL shows are in the next four months. This is the time of year that we get to collect those airline points, have our beds made for us, eat out a few times a day and put on a few pounds! I have been practicing for this all year. Check out our Events Section to see all of our upcoming events.
I have been thinking about how I could streamline my deployment and configuration of MariaDB with salt for a while now. When I decided to give it a shot, I didn't find any formulas that I liked, so I decided to start writing my own. Currently, my salt formula can deploy MariaDB 5.5, MariaDB Galera Cluster 5.5, MariaDB 10.0, or MariaDB Galera Cluster 10.0 to a CentOS 6 or 7 server.