Difference between revisions of "MariaDB"

From InfiniteERP Wiki
Jump to: navigation, search
(Backup & Restore)
 
(3 intermediate revisions by the same user not shown)
Line 4: Line 4:
  
 
== Backup & Restore ==
 
== Backup & Restore ==
 +
 +
refer to https://mariadb.com/docs/recovery/backup-optimization/
 +
 +
* Take a full backup:
 
<pre>
 
<pre>
 
sudo mariabackup --backup \
 
sudo mariabackup --backup \
Line 9: Line 13:
 
       --password=P@ssw0rdINDO7Kali \
 
       --password=P@ssw0rdINDO7Kali \
 
       --target-dir=/home/backup/db
 
       --target-dir=/home/backup/db
 +
</pre>
 +
Confirm successful completion of the backup operation.
  
 +
* The backup must be prepared:
 +
<pre>
 
sudo mariabackup --prepare \
 
sudo mariabackup --prepare \
 
       --target-dir=/home/backup/db
 
       --target-dir=/home/backup/db
 
</pre>
 
</pre>
 +
Confirm successful completion of the prepare operation.
  
 
== Monitor Index status dan size for optimization ==
 
== Monitor Index status dan size for optimization ==

Latest 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/

  • 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