Difference between revisions of "MariaDB"
(Created page with "= Introduction = = Database Maintenance and Monitoring script = == Monitor Index status dan size for optimization == == Monitor Cache Hit Ratio == == Monitoring Database...") |
(→Backup & Restore) |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
= Database Maintenance and Monitoring script = | = Database Maintenance and Monitoring script = | ||
| + | |||
| + | == Backup & Restore == | ||
| + | |||
| + | refer to https://mariadb.com/docs/recovery/backup-optimization/ | ||
| + | |||
| + | * Take a full backup: | ||
| + | <pre> | ||
| + | sudo mariabackup --backup \ | ||
| + | --user=root \ | ||
| + | --password=P@ssw0rdINDO7Kali \ | ||
| + | --target-dir=/home/backup/db | ||
| + | </pre> | ||
| + | Confirm successful completion of the backup operation. | ||
| + | |||
| + | * The backup must be prepared: | ||
| + | <pre> | ||
| + | sudo mariabackup --prepare \ | ||
| + | --target-dir=/home/backup/db | ||
| + | </pre> | ||
| + | Confirm successful completion of the prepare operation. | ||
== Monitor Index status dan size for optimization == | == Monitor Index status dan size for optimization == | ||
== Monitor Cache Hit Ratio == | == Monitor Cache Hit Ratio == | ||
| − | |||
== Monitoring Database Query Performance == | == Monitoring Database Query Performance == | ||
| − | == Locks held by Open Transactions | + | == Locks held by Open Transactions == |
== Check Trigger Status == | == Check Trigger Status == | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Latest revision as of 05:36, 17 April 2022
Contents
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.
