The MariaDB audit plugin is an audit plugin that is bundled with MariaDB server. However, even though it is bundled with MariaDB, the plugin is actually compatible with MySQL as well. For a step-by-step guide on how to use the plugin with MySQL, check out my blog post here
Transportable tablespaces for InnoDB tables is a very useful feature added in MySQL 5.6 and MariaDB 10.0. With this new feature, an InnoDB table’s tablespace file can be copied from one server to another, as long as the table uses a file-per-table tablespace.
Please save the date! M|17 is MariaDB’s inaugural annual user conference that will bring together developers, architects, administrators and business people to learn, collaborate and network around the latest innovations at MariaDB and infrastructure modernization.
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!
The details about two vulnerabilities affecting MariaDB (and MySQL) have been published. The two vulnerabilities are:
With the recent announcement of MariaDB ColumnStore, we get many questions on the architecture and functionality of MariaDB ColumnStore. This blog post describes the architecture of MariaDB ColumnStore.
Today, MariaDB ColumnStore, MariaDB's distributed columnar storage engine for analytics workload, is reaching its next major milestone – the availability of MariaDB ColumnStore 1.0.4 Beta software release.
From MariaDB 10.1 there is a feature where the InnoDB page size can be configured to be larger than the default 16K for normal, uncompressed tables. However, there has been little performance results that show whether the page size really effects the transaction performance or response time. In this blog, we study effects of page size on three different storage devices using the same benchmark(s). These devices are:
From the very beginning, a central feature of MariaDB MaxScale has been its ability to understand the SQL statements that flow through it. For that purpose, MaxScale is equipped with an SQL parser for parsing statements.
Today’s IT infrastructure is vulnerable to a range of attacks and threats. How do you safeguard your database against them? By learning and using best practices, and choosing a database with robust security tools built in.