The 2.1 version of MaxScale introduced a new concept of module commands. This blog post takes a look at what they are, why they were implemented and where you see them when you use MaxScale.
Performance has been a central goal of MariaDB MaxScale’s architecture from the start. Core elements in the drive for performance is the use of asynchronous I/O and Linux’ epoll. With a fixed set of worker threads, whose amount is selected to correspond to the number of available cores, each thread should either be working or be idle, but never be waiting for I/O. This should provide good performance that scales well with the number of available CPUs. However, benchmarking revealed that was not entirely the case. The performance of MaxScale did not continuously increase as more worker threads were added, but after a certain point the performance would actually start to decrease.
When we started working on MariaDB MaxScale 2.1 we decided to investigate what the actual cause for that behaviour was and to make modifications in order to improve the situation.
We are happy to announce that MariaDB MaxScale 2.1.0 beta is released today. MariaDB MaxScale is the next generation database proxy for MariaDB. Beta is an important time in our release and we encourage you to download this release today!
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.
MariaDB announced BSL 1.0 together with MariaDB MaxScale 2.0 in August 2016. After having the license “in the wild” for a few months we’ve been reaching out to Open Source advocates to get feedback on the BSL. We’ve gotten some great responses, including from Bruce Perens and Heather Meeker of O’Melveny & Myers LLP. Our next MariaDB MaxScale release will use BSL 1.1.
MariaDB ColumnStore is a massively parallel scale out columnar database. Query execution behaves quite differently from how a row-based engine works. This article outlines how queries are executed, optimized, and how performance can be influenced.
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. If you’re a DBA, architect, or developer, you won’t want to miss this event! Check out the locations and dates here.
MariaDB monitoring tool, Monyog, provides insights into server performance with a customizable dashboard. Webyog just announced the launch of the new Monyog v7.0! With this new release, MariaDB customers will get access to a completely revamped Monyog user interface and industry-leading feature additions to uncover valuable server performance insights.
Rasmus Johansson provides an update on CVE-2016-6662 and CVE-2016-6663 vulnerabilities which were both fixed in the fall.
In this second blog post on temporal datatypes Anders Karlsson explores the effects of Daylight Savings Time and how TIMESTAMP datatypes are affected by DST.