Difference between revisions of "MariaDB"

From InfiniteERP Wiki
Jump to: navigation, search
(Backup & Restore)
(Backup & Restore)
Line 7: Line 7:
 
refer to https://mariadb.com/docs/recovery/backup-optimization/
 
refer to https://mariadb.com/docs/recovery/backup-optimization/
  
Take a full backup:
+
# Take a full backup:
 
<pre>
 
<pre>
 
sudo mariabackup --backup \
 
sudo mariabackup --backup \
Line 16: Line 16:
 
Confirm successful completion of the backup operation.
 
Confirm successful completion of the backup operation.
  
The backup must be prepared:
+
# The backup must be prepared:
 
<pre>
 
<pre>
 
sudo mariabackup --prepare \
 
sudo mariabackup --prepare \

Revision as of 05:36, 17 April 2022

Introduction

Database Maintenance and Monitoring script

Backup & Restore

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

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

Confirm successful completion of the backup operation.

  1. 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