Blog Author

Geoff Montee

Support Engineer, MariaDB

Geoff Montee is a Support Engineer with MariaDB. He has previous experience as a Database Administrator/Software Engineer with the U.S. Government, and as a System Administrator and Software Developer at Florida State University.

Automatic Partition Maintenance in MariaDB

A MariaDB Support customer recently asked how they could automatically drop old partitions after 6 months. MariaDB does not have a mechanism to do this automatically out-of-the-box, but it is…

Read More

Using the MariaDB Audit Plugin with MySQL

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…

Read More

Importing InnoDB Partitions in MariaDB 10.0/10.1

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…

Read More

Configuring LDAP Authentication and Group Mapping With MariaDB

Enterprise users who have a large number of MariaDB servers often want to centralize their MariaDB user account administration — especially for the user accounts of the database administration team.…

Read More

Configuring PAM Group Mapping with MariaDB

Several months ago, I wrote a blog post about configuring PAM authentication and user mapping in MariaDB. While it is useful to map a system user account to a MariaDB…

Read More

Forcing a Slave Server to Recreate Temporary Tables After an…

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…

Read More

Protect Your Data #2: A Row-level Security Walkthrough in MariaDB…

My last row-level security blog post got a few questions, so I decided that it would be good to follow up with more detail. The last blog post described some…

Read More

Optimizing Conservative In-order Parallel Replication with MariaDB 10.0

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…

Read More

Protect Your Data: Row-level Security in MariaDB 10.0

Most MariaDB users are probably aware of the privilege system available in MariaDB and MySQL. Privileges control what databases, tables, columns, procedures, and functions a particular user account can access.…

Read More

Optimizing Out-of-order Parallel Replication with MariaDB 10.0

Out-of-order parallel replication is a great feature in MariaDB 10.0 that improves replication performance by committing independent transactions in parallel on a slave. If slave_parallel_threads is greater than 0, then…

Read More

Configuring PAM Authentication and User Mapping with MariaDB

User accounts in MariaDB have traditionally been completely separate from operating system accounts. However, MariaDB has included a PAM authentication plugin since version 5.2.10. With this plugin, DBAs can configure…

Read More

MariaDB Galera Cluster: A Quirk of Bootstrapping

MariaDB Galera Cluster is part of the easily deployed High Availability product MariaDB Enterprise Cluster. This blog raises a question about the behaviour of the bootstrapping method. Old Bootstrapping Method…

Read More

MariaDB DevOps: Installing MariaDB with SaltStack

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…

Read More