Configure ZCS to run with external MariaDB

notes.md

Configure ZCS to run with external MariaDB

Introduction

For this test I decided to start with a clean MariaDB install and initialize it with a backup from a current ZCS server. In the steps that follow:

• ubuntu-test-1 will be the service that has a full ZCS install.
• ubuntu-test-2 will be the database server.

ubuntu-test-1

Do a basic single-node install. Follow the instructions in MySQL Backup and Restore to enable binary logging and running a backup. They are summarized below.

ubuntu-test-2

Install and initialize MariaDB. Make note of the root password that you assign; however, it will change once we import the data from the ZCS backup.

sudo apt install mariadb-server
sudo /usr/bin/mysql_secure_installation

Update the following in /etc/mysql/mariadb.conf.d/50-server.cnf

• Change port to 7306
• Comment out bind-address

A note regarding starting and stopping MariaDB with a standard Ubuntu install. By default it will start MariaDB via the mysqld_safe command. This will require the use of the mysqladmin shutdown command to stop it, which the mysql script in /etc/init.d does do. However, the mysqladmin script requires the (MariaDB) root password to work. If you want this to work properly, update /etc/mysql/debian.cnf and add the root password, remembering that it will change once we restore from the backup of the ZCS database.

Restart the database.

ubuntu-test-1

Stop ZCS and copy the log-bin directory (/opt/zimbra/backup in our example) to the database server. I unpacked it to the same location on ubuntu-test-2.

Update localconfig to point to the new database server.

zmlocalconfig -e mysql_bind_address=ubuntu-test-2.local

Edit /opt/zimbra/bin/zmstorectl and remove mysql.server from START_ORDER and STOP_ORDER.

ubuntu-test-2

Restore the backup from the ZCS server:

sudo chmod -R a+r /opt/zimbra/backup
sudo mysql --user=root --password=ROOT-PW < /opt/zimbra/backup/full-backup.sql

Restart MariaDb. Remember that the root password is now the same as it was on the ZCS server.

ubuntu-test-1

Start ZCS.

MySQL Backup and Restore

Add the following config to /opt/zimbra/conf/my.conf. You can choose a different log-bin path if you like.

log-bin = /opt/zimbra/backup/mariadb
binlog-format = MIXED

Restart the store (zmstorectrl restart) and verify that binary logs are being created by listing the contents of the log-bin directory:

ls -l /opt/zimbra/backup
-rw-rw---- 1 zimbra zimbra 311 Jul 10 13:34 mariadb.000001
-rw-rw---- 1 zimbra zimbra  34 Jul 10 13:34 mariadb.index

Now run a full backup of the database:

source /opt/zimbra/bin/zmshutil
zmsetvars
/opt/zimbra/common/bin/mysqldump --user=root \
  --password=$mysql_root_password \
  --socket=$mysql_socket --all-databases \
  --single-transaction --master-data \
  --flush-logs > /opt/zimbra/backup/full-backup.sql