The beta version of the upcoming MaxScale 2.1 has been released. This new release takes MaxScale to the next level by introducing functionality that makes it possible to configure parts of MaxScale’s configuration at runtime.
SQLyog is included in MariaDB Enterprise and it helps DBAs, developers and database architects save time writing queries visualized with syntax checking, designing visually complex queries, and many other powerful features for visualization, synchronization and management. This 12.4 release introduces ‘read-only’ connections as well as support for the MariaDB auth_gssapi (Kerberos) plugin.
Join us for one of our full-day roadshows coming to a city near you! MariaDB is hosting educational roadshows across North America to showcase exciting new products and solutions, and share best practices for enabling critical enterprise features such as high availability and security. MariaDB experts will lead content-rich sessions on open source, product features, architecture and security.
Ready for the holiday shopping season? 20 tips to prepare your MariaDB database environment for Black Friday and Cyber Monday!
With all the excitement surrounding the perfect Thanksgiving meal, it's often easy to overlook how to prep your database environment for the biggest online shopping day of the year! Each year, more and more shoppers opt for online holiday deals, instead of the more traditional mall experience, which means that retailers must prepare for multiple days of high online traffic to their e-commerce sites. This year you’ll be prepared as I’m passing along a few tips to tune your database environment for some of the biggest online holiday shopping days - Black Friday and Cyber Monday!
This is a follow-up blog post that expands on the subject of highly available cluster, discussed in MariaDB MaxScale High Availability: Active-Standby Cluster.
MariaDB Replication Manager is a tool that manages MariaDB 10 clusters. It supports both interactive and automated failover of the master server.
High availability is one of the most important aspects of running a business. Whether it is a simple app for a small group of users or a large service used by millions, downtime costs a lot of money and ruins everyone’s day. No matter how hard we try, downtime is inevitable.
Team MariaDB is touring across several European regions again. The theme for 2016 is "Data Management for Mission Critical Applications". Beside valuable presentations around database security, Big Data analysis and better scalability and high availability 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.1, MariaDB MaxScale 1.4 and other MariaDB solutions. They will share tips & tricks to help you get the most out of your database.
Losing temporary tables on a slave when
binlog_format is not set to
ROW is a well-known problem, and there is even a way to avoid it, as described by the safe slave shutdown procedure in the MySQL documentation. However, the documentation doesn't describe how to fix your slave if you accidentally shut it down while it has temporary tables open. In this blog post, I'll describe how to do that.
Conservative in-order parallel replication is a great feature in MariaDB 10.0 that improves replication performance by using knowledge of group commit on the master to commit transactions in parallel on a slave.
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 MariaDB Replication Manager. The following use case is exposed using three MariaDB servers (one master, two slaves) and a MaxScale server.