Let’s try and google about how to make your MariaDB server faster. Most of the articles are telling you to increase the buffer pool to 80 % percent of your RAM memory, to keep the database server separated, add indexes to your queries, use SSD and other tips. IO scheduler For optimal IO performance use noop scheduler. …
You just installed a MariaDB server and want to set up a slave that can be used for backups, reports and other read-only tasks. Configuring the Master Enable binary logging if it’s not already enabled. Setup binlog format Give the master a unique server_id. Check that server is configured to allow remote connections Create a dedicated …
Master-slave replication on MariaDB 10.4 using mysqldump and binary log Read More »
We will learn how to install the latest MariaDB stable version on Debian 10, using apt. Be aware that currently, Debian sources don’t contain the latest version of the package mariadb-server. For this tutorial, we are using sudo privileges account. If sudo command is not found you have to run as root: Installation Step 1: …