MariaDB

From InfiniteERP Wiki
Jump to: navigation, search

Introduction

Database Maintenance and Monitoring script

Backup & Restore

refer to https://mariadb.com/docs/recovery/backup-optimization/

  • Take a full backup:
sudo mariabackup --backup \
      --user=root \
      --password=P@ssw0rdINDO7Kali \
      --target-dir=/home/backup/db

Confirm successful completion of the backup operation.

  • The backup must be prepared:
sudo mariabackup --prepare \
      --target-dir=/home/backup/db

Confirm successful completion of the prepare operation.

Monitor Index status dan size for optimization

Monitor Cache Hit Ratio

Monitoring Database Query Performance

Locks held by Open Transactions

Check Trigger Status

How to