Enabling GTIDs for server replication in MariaDB 10.0
Replication has been one of the most popular MySQL features since it made its way into the application more than a decade ago. However, as replication implementations became more complex over time, some limitations of MySQL’s original replication mechanisms started…
[MariaDB]: HA with Multi-source Replication
The Basics The topology uses 3 servers: A is the active master, B a stand-by master set up to replicate from A and C a multi purpose slave replicating from A. I also set up A to replicate from…
Installing MariaDB 10 on CentOS 7 / RHEL 7
Installing MariaDB became very easy on the latest CentOS /RHEL Linux version 7. During initial setup MariaDB has a tick in the graphical setup environment which enables MariaDB and replaces MySQL. During installation the section allows enabling a MariaDB server….
How to reset a root password in MariaDB on Linux
You’ve lost the root password for your MariaDB database – now what do you do? You can’t recover your existing password, but you can get into your database to create a new root password. You just need root privileges on…
Best Linux filesystem for MariaDB ?
How do you choose the best Linux filesystem for your MariaDB server? The primary factors to look at are data integrity, performance, and ease of administration. Data integrity tops the list because fixing a corrupted database is even less fun…
MySQL to MariaDB Migration in 5 steps
How to migrate from MySQL to MariaDB on Linux in five steps You’ve decided to move from MySQL to MariaDB, but you’re a little nervous. The last thing you want is to become mired in a slough of brokenness. Don’t…
[MariaDB]: Replace command
How to search for and replace a text string in MariaDB on Linux There will come a time when you must search for a particular text string in a field in MariaDB, and you may not know what database or…
[MariaDB]: Four key client commands
It’s time to get to know four of the most commonly used administration commands for your MariaDB server: mysql,mysqladmin, mysqldump, and mysqlimport. The examples run these commands on the server rather than over the network. You’ll be prompted for your…
How to get rid of orphaned InnoDB temporary tables
If InnoDB or XtraDB in MySQL or MariaDB are interrupted while performing an ALTER TABLE, they’ll leave a temporary table sitting in your data directory. This thing will be taking up space, which is no good. If you’re usinginnodb-file-per-table, or…
[MariaDB]: Scale Out Reads With MaxScale 1.0
Let’s assume you want to start an automatically expanding and shrinking MySQL replication cluster with up-to seven database servers. This blog shows how to setup up and start MaxScale to work with a master and a single slave and, when…