Parallel replication is a much-expected feature of MySQL. It is available in MariaDB 10.0 and in MySQL 5.7. In this 3rd post of the series, we present benchmark results from Booking.com production environments.
Note: Replication Manager is developed and maintained by community members. It can be used with MariaDB Server, but it is not supported with an enterprise subscription.
MaxScale 1.2.0 and above can call external scripts on monitor events. In the case of a classic Master-Slave setup, this can be used for automatic failover and promotion using Replication Manager. The following use case is exposed using three MariaDB servers (one master, two slaves) and a MaxScale server.
In the last two releases of MariaDB Enterprise, we have provided enhanced performance with the introduction of certified MariaDB binaries for POWER8 and optimized binaries for the x86 platform. This Summer we make it more efficient and automated for developers and DBAs to use our high performance MariaDB binaries.
Recently, I asked Colt Engine to help us with the MaxScale Beta Testing process. They agreed to do this, but they had to find the best way to test a new environment, with MaxScale on top and with as little impact as possible on their datacenter. The traditional approach would be to create as many virtual machines as needed and configure them for the designed test environment. This is a valid approach, but it requires some time to setup and the unnecessary use of resources. Instead, they decided to use an “Application Container”; they decided to use Docker.
When we first announced MariaDB Enterprise last year in March of 2014, our goal was to deliver superior performance and customer experience in addition to a hardened and certified version of open source MariaDB Server. In the first release we delivered hardened and certified binaries, and with the second release in December 2014 we raised the bar in performance. At that time, we announced MariaDB Enterprise for the IBM POWER8 platform, with a 2.2x performance gain over the x86 platform.
Last week we continued the MariaDB Roadshow in Europe and visited Paris, Brussels and Amsterdam. We have now completed 5 out of 10 events from this tour. The interest in this roadshow is overwhelming - in Amsterdam we even needed to put extra chairs into the room! So far attendees of the roadshow series especially liked topics around MariaDB MaxScale, security features in MariaDB as well as the MariaDB roadmap session. Monty was among the speakers in Helsinki and Amsterdam.
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).
Team MariaDB is touring across several European regions again with the theme "Scaling at its Best!". Beside product pitches our technical experts will help you understand how to take advantage of the wide range of new features and enhancements available now in MariaDB 10, MaxScale and other MariaDB solutions.
MaxScale’s filter system is very flexible and enables a new way of interacting with queries. The upcoming firewall filter shows just one of the many ways that you can control and manage the flow of queries through MaxScale.
When I started my career in early nineties, the Internet, the open source software movement and the Linux operating system were in their infancy and MariaDB and MySQL did not exist. Today open source is a mainstream software delivery mechanism, and web applications are built upon open source stacks which include Linux and MariaDB. Sybase was the first relational database I worked with - a then leading relational technology in early nineties.