ProHoster > ื‘ืœืึธื’ > ืึทื“ืžื™ื ื™ืกื˜ืจืึทืฆื™ืข > ืฉืึทืคึฟืŸ ืึท MySQL ื‘ืึทืงืงื•ืคึผ ื ื™ืฆืŸ ื“ื™ XtraBackup ื ื•ืฆืŸ

ืฉืึทืคึฟืŸ ืึท MySQL ื‘ืึทืงืงื•ืคึผ ื ื™ืฆืŸ ื“ื™ XtraBackup ื ื•ืฆืŸ

Percona XtraBackup ืื™ื– ืึท ื ื•ืฆืŸ ืคึฟืึทืจ ื”ื™ื™ืก ื“ืึทื˜ืึทื‘ื™ื™ืก ื‘ืึทืงืึทืคึผืก ืžื™ืกืงืœ.

ื•ื•ืขืŸ ืงืจื™ื™ื™ื˜ื™ื ื’ ืึท ื“ืึทื˜ืŸ ื‘ืึทืงืึทืคึผ, ืงื™ื™ืŸ ื˜ื™ืฉืŸ ื–ืขื ืขืŸ ืคืืจืฉืคืืจื˜, ืื•ืŸ ื“ื™ื™ืŸ ืกื™ืกื˜ืขื ื”ืืœื˜ ืฆื• ืึทืจื‘ืขื˜ืŸ ืึธืŸ ืจื™ืกื˜ืจื™ืงืฉืึทื ื–.

XtraBackup 2.4 ืงืขื ืขืŸ ืžืึทื›ืŸ ื‘ืึทืงืึทืคึผ ืงืืคื™ืขืก ืคื•ืŸ ื˜ื™ืฉืŸ InnoDB, XtraDB ะธ ืžื™ื™ืกืึทื ืื•ื™ืฃ ืกืขืจื•ื•ืขืจืก MySQL 5.11, 5.5, 5.6 ืื•ืŸ 5.7, ืื•ืŸ ืื•ื™ืš ืื•ื™ืฃ ื“ื™ ืกืขืจื•ื•ืขืจ ืคึผืขืจืงืึธื ืึท ืคืึทืจ ืžื™ืกืงืœ ั XtraDB.

ืฆื• ืึทืจื‘ืขื˜ืŸ ืžื™ื˜ MySQL 8.x ื•ื•ืขืจืกื™ืข ื–ืึธืœ ื–ื™ื™ืŸ ื’ืขื•ื•ื™ื™ื ื˜ XtraBackup 8.x. ื“ืขืจ ืึทืจื˜ื™ืงืœ ื•ื•ืขื˜ ื ืึธืจ ืจืขื“ืŸ ื•ื•ืขื’ืŸ XtraBackup 2.4.

ื“ื™ ื”ื•ื™ืคึผื˜ ืžื™ื™ึทืœืข XtraBackup ืื™ื– ืื– ื“ืืก ื’ืขืฆื™ื™ื’ ืื™ื– ืคืืกื™ื’ ืคืืจืŸ ืฉืืคืŸ ื‘ืขืงืืค ืงืืคื™ืขืก ืคื•ืŸ ืฉื˜ืืจืง ื’ืขืœืื“ืขื ืข ืกืขืจื•ื•ืขืจืก, ื•ื•ื™ ืื•ื™ืš ืคึฟืึทืจ ืกื™ืกื˜ืขืžืขืŸ ืžื™ื˜ ืึท ื ื™ื“ืขืจื™ืงืข ืฆืึธืœ ื˜ืจืึทื ื–ืึทืงืฆื™ืขืก.

ืื•ื™ื‘ ื“ื™ ื’ืึทื ืฅ ื’ืจื™ื™ืก ืคื•ืŸ ื“ื™ื™ืŸ MySQL ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื– ืื™ื– ื‘ืึทื˜ื™ื™ื˜ื™ืง (ื˜ืขื ืก ืคื•ืŸ ื’ื™ื’ืื‘ื™ื™ื˜), ื“ืขืจ ื ืึธืจืžืึทืœ ื ื•ืฆืŸ ืžื™ืกืงืœื“ื•ืžืคึผ ื•ื•ืขื˜ ื ื™ืฉื˜ ืœืึธื–ืŸ ืื™ืจ ืฆื• ื’ืขืฉื•ื•ื™ื ื“ ืžืึทื›ืŸ ืึท ื‘ืึทืงืึทืคึผ ืงืึธืคึผื™ืข, ืื•ืŸ ืจื™ืกื˜ืึธืจื™ื ื’ ื“ื™ ื“ืึทืžืคึผ ื•ื•ืขื˜ ื ืขืžืขืŸ ืึท ืคึผืœืึทืฅ ืคื•ืŸ ืฆื™ื™ื˜.

ื™ื ืกื˜ืึทืœื™ืจื•ื ื’

ื™ื ืกื˜ืึทืœื™ืจื•ื ื’ XtraBackup ืคื•ืŸ ื“ื™ ืจื™ืคึผืึทื–ืึทื˜ืึธืจื™ ืคื™ื™ื™ืง ืคึผืขืจืงืึธื ืึท.

ืคืึทืจืขื ื“ื™ืงืŸ ื“ื™ ืคืืœื’ืขื ื“ืข ื‘ืึทืคึฟืขืœ:

wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb

sudo dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb

sudo apt-get update 

sudo apt-get install percona-xtrabackup-24

2. ื ืึธืš ื™ื ืกื˜ืึทืœื™ืจื•ื ื’, ืœื•ื™ืคืŸ ื“ื™ ื‘ืึทืคึฟืขืœ xtrabackup -v. ื–ื™ื ื˜, ืขืก ืื™ื– ื•ื•ื™ื›ื˜ื™ืง ืฆื• ืžืึทื›ืŸ ื–ื™ื›ืขืจ ืึทื– ื“ื™ ื ื•ืฆืŸ ืึทืจื‘ืขื˜ ืจื™ื›ื˜ื™ืง ืื•ื™ืฃ ื“ื™ ืกืขืจื•ื•ืขืจ. ื•ื•ื™ ืึท ืจืขื–ื•ืœื˜ืึทื˜, ืขืคึผืขืก ื•ื•ื™ ื“ืึธืก ื•ื•ืขื˜ ื–ื™ื™ืŸ ื’ืขื•ื•ื™ื–ืŸ ืื•ื™ืฃ ื“ืขื ืขืงืจืึทืŸ:

xtrabackup: ื“ืขืจืงืขื ื˜ืข ืกืขืจื•ื•ืขืจ ืืจื’ื•ืžืขื ื˜ืŸ: - datadir=/var/lib/mysql - tmpdir=/tmp - server-id=1 - logbin=/var/log/mysql/mysql-bin.log - innodbbufferpoolsize=16384M - innodbfilepertable=1 - innodbflushmethod=Odirect - innodbflushlogattrxcommit=0xtrabackup ื•ื•ืขืจืกื™ืข 2.4.20 ื‘ืื–ื™ืจื˜ ืื•ื™ืฃ MySQL ืกืขืจื•ื•ืขืจ 5.7.26 Linux (x8664) (ืจืขื•ื•ื™ื–ื™ืข ืื™ื“ืขื ื˜ื™ืคื™ืงืืฆื™ืข: c8b4056)

ืฉืึทืคึฟืŸ ืึท MySQL ื‘ืึทืงืงื•ืคึผ ื ื™ืฆืŸ ื“ื™ XtraBackup ื ื•ืฆืŸ

ืึทืงืกืขืก ืจืขื›ื˜, ืคึผืขืจืžื™ืฉืึทื ื– ืื•ืŸ ืคึผืจื™ื•ื•ื™ืœืึทื“ื–ืฉืึทื– 

XtraBackup ื–ืึธืœ ื–ื™ื™ืŸ ื‘ื™ื›ื•ืœืช ืฆื•:

  • ืคืึทืจื‘ื™ื ื“ืŸ ืฆื• ื“ื™ื™ืŸ MySQL ืกืขืจื•ื•ืขืจ.

  • ื”ืึธื‘ืŸ ืึทืงืกืขืก ืจืขื›ื˜ ืฆื• ื“ืขืจ ื•ื•ืขื’ื•ื•ื™ื™ึทื–ืขืจ ืื™ื– ื“ืึทื˜ืŸ. 

  • ื•ื•ืขืŸ ืงืจื™ื™ื™ื˜ื™ื ื’ ืึท ื‘ืึทืงืึทืคึผ ืงืึธืคึผื™ืข, ื”ืึธื‘ืŸ ืฉืจื™ื™ึทื‘ืŸ ืจืขื›ื˜ ืฆื• ื“ื™ ืกืคึผืขืกืึทืคื™ื™ื“ ืคึผืึทืจืึทืžืขื˜ืขืจ ืฆื™ืœ-ื“ื™ืจ ืงืึทื˜ืึทืœืึธื’.

ื•ื•ืึธืก ืื™ื– ื“ืึทื˜ืึทื“ื™ืจ?

ืื™ื– ื“ืึทื˜ืŸ ืื™ื– ื“ืขืจ ื•ื•ืขื’ื•ื•ื™ื™ึทื–ืขืจ ื•ื•ื• ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก ืกืขืจื•ื•ืขืจ ืžื™ืกืงืœ ืฉืคึผืึธืจื˜ ื“ืึทื˜ืŸ. ืึทืœืข ื“ืึทื˜ืึทื‘ื™ื™ืกืขืก, ืึทืœืข ื˜ืึทื‘ืขืœืขืก ื’ืขืคื™ื ืขืŸ ื–ื™ืš ื“ืึธืจื˜. ืื™ืŸ ืจื•ื‘ึฟ ืคืึทืจืฉืคึผืจื™ื™ื˜ื•ื ื’ืขืŸ Linux ื“ื•ืจืš ืคืขืœื™ืงื™ื™ื˜, ืื™ื– ื“ืึธืก ื“ื™ืจืขืงื˜ืึธืจื™ /var/lib/mysql.

ื•ื•ืึธืก ืื™ื– ืฆื™ืœ-ื“ื™ืจ ื•ื•ืขื’ื•ื•ื™ื™ึทื–ืขืจ?

ืฆื™ืœ-ื“ื™ืจ - ื“ืึธืก ืื™ื– ื“ืขืจ ื•ื•ืขื’ื•ื•ื™ื™ึทื–ืขืจ ื•ื•ื• ื“ื™ ื‘ืึทืงืึทืคึผ ื•ื•ืขื˜ ื–ื™ื™ืŸ ื’ืขืจืื˜ืขื•ื•ืขื˜.

ื“ืขืจ ื“ืึทื˜ืึทื‘ื™ื™ืก ื‘ืึทื ื™ืฆืขืจ ื“ืึทืจืฃ ื“ื™ ืคืืœื’ืขื ื“ืข ืึทืงืกืขืก ืจืขื›ื˜ ืฆื• ื“ื™ ื˜ื™ืฉืŸ ืื•ืŸ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื– ืฆื• ื–ื™ื™ืŸ ื‘ืึทืงื˜:

  • ืจื™ืœืึธื•ื“ ืื•ืŸ ืฉืœืึธืก ื˜ื™ืฉืŸ

  • ืจืขืคึผืœื™ืงืึทื˜ื™ืึธืŸ ืงืœื™ืขื ื˜

  • ืฉืึทืคึฟืŸ ื˜ื™ืฉ ืคึผืœืึทืฅ

  • ืคึผืจืึธืฆืขืก

  • ื™ื‘ืขืจ

  • CREATE

  • ืึทืจื™ื™ึทื ืœื™ื™ื’ืŸ

  • ืื•ื™ืกืงืœื™ื™ึทื‘ืŸ

ืงืึธื ืคื™ื’ื•ืจืึทื˜ื™ืึธืŸ 

ืงืึธื ืคื™ื’ื•ืจืึทื˜ื™ืึธืŸ XtraBackup ื’ืขื˜ืืŸ ืžื™ื˜ ืึธืคึผืฆื™ืขืก ื•ื•ืึธืก ื‘ื™ื›ื™ื™ื•ื•ื– ื“ื™ ื–ืขืœื‘ืข ื•ื•ื™ ื ืึธืจืžืึทืœ MySQL ืึธืคึผืฆื™ืขืก.

ื•ื•ืึธืก ื˜ื•ื˜ ื“ืึธืก ืžื™ื™ื ืขืŸ?

ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืคึผืึทืจืึทืžืขื˜ืขืจืก ืงืขื ืขืŸ ื–ื™ื™ืŸ ืกืคึผืขืกื™ืคื™ืขื“ ืึธื“ืขืจ ืื•ื™ืฃ ื“ื™ ื‘ืึทืคึฟืขืœืŸ ืฉื•ืจื” ืึธื“ืขืจ ืื™ืŸ ื“ื™ DBMS ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ื˜ืขืงืข, ืœืžืฉืœ ืื™ืŸ /etc/my.cnf.

XtraBackup ื ื•ืฆืŸ ืœื™ื™ืขื ื˜ ืคึผืึทืจื˜ื™ืฉืึทื ื– ื ืึธืš ืงืึทื˜ืขืจ [mysqld] ะธ [ืงืกื˜ืจืึทื‘ืึทืงืงื•ืคึผ] ืคึฟื•ืŸ MySQL ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ื˜ืขืงืขืก. ื“ืึธืก ืื™ื– ื’ืขื˜ืืŸ ืึทื–ื•ื™ ืึทื– ื“ื™ ื ื•ืฆืŸ ืงืขื ืขืŸ ื ื•ืฆืŸ ื“ื™ ืกืขื˜ื˜ื™ื ื’ืก ืคื•ืŸ ื“ื™ื™ืŸ DBMS ืึธืŸ ืฆื• ืกืคึผืขืฆื™ืคื™ืฆื™ืจืŸ ื“ื™ ืคึผืึทืจืึทืžืขื˜ืขืจืก ืžืึทื ื™ื•ืึทืœื™ ื‘ืขืฉืึทืก ื™ืขื“ืขืจ ื‘ืึทืงืึทืคึผ.

ืคึฟืึทืจ ื‘ื™ื™ึทืฉืคึผื™ืœ, ื“ื™ ื•ื•ืขืจื˜ ืื™ื– ื“ืึทื˜ืŸ ืื•ืŸ ืขื˜ืœืขื›ืข ืคึผืึทืจืึทืžืขื˜ืขืจืก InnoDB ืžื™ืจ ื‘ืึทืงื•ืžืขืŸ XtraBackup ืคึฟื•ืŸ ื“ื™ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ืคื•ืŸ ื“ื™ื™ืŸ DBMS.

ืื•ื™ื‘ ืคึฟืึทืจ XtraBackup ืฆื• ืึทืจื‘ืขื˜ืŸ, ืื™ืจ ื•ื•ื™ืœืŸ ืฆื• ืึธื•ื•ื•ืขืจืจื™ื™ื“ ื“ื™ ืคึผืึทืจืึทืžืขื˜ืขืจืก ืื™ืŸ ื“ืขืจ ืึธืคึผื˜ื™ื™ืœื•ื ื’ [mysqld], ื“ืขืžืึธืœื˜ ื ืึธืจ ืกืคึผืขืฆื™ืคื™ืฆื™ืจืŸ ื–ื™ื™ ืื™ืŸ ื“ื™ ืงืึทื ืคื™ื’ื™ืขืจื™ื™ืฉืึทืŸ ื˜ืขืงืข ืื™ืŸ ื“ื™ ืึธืคึผื˜ื™ื™ืœื•ื ื’ [ืงืกื˜ืจืึทื‘ืึทืงืงื•ืคึผ]. ื–ื™ื ื˜ ื–ื™ื™ ื•ื•ืขืœืŸ ื–ื™ื™ืŸ ืœื™ื™ืขื ืขืŸ ืฉืคึผืขื˜ืขืจ, ื–ื™ื™ืขืจ ื‘ื™ืœื›ืขืจืงื™ื™ึทื˜ ื•ื•ืขื˜ ื–ื™ื™ืŸ ื”ืขื›ืขืจ.

ืื™ืจ ื˜ืึธืŸ ื ื™ื˜ ื”ืึธื‘ืŸ ืฆื• ืœื™ื™ื’ืŸ ืงื™ื™ืŸ ืคึผืึทืจืึทืžืขื˜ืขืจืก ืฆื• ืžื™ื™ืŸ.ืงื ืฃ. ืึทืœืข ืคืืจืœืื ื’ื˜ ืคึผืึทืจืึทืžืขื˜ืขืจืก ืงืขื ืขืŸ ื–ื™ื™ืŸ ืกืคึผืขืกื™ืคื™ืขื“ ืื•ื™ืฃ ื“ื™ ื‘ืึทืคึฟืขืœ ืฉื•ืจื”. ื™ื•ื–ืฉืึทื•ื•ืึทืœื™ ื“ืขืจ ื‘ืœื•ื™ื– ื–ืึทืš ื•ื•ืึธืก ืงืขื ืขืŸ ื–ื™ื™ืŸ ืงืึทื ื•ื•ื™ื ื™ืึทื ื˜ืœื™ ืฉื˜ืขืœืŸ ืื™ืŸ ื“ื™ ืึธืคึผื˜ื™ื™ืœื•ื ื’ [ืงืกื˜ืจืึทื‘ืึทืงืงื•ืคึผ] ื“ื™ื™ืŸ ืžื™ื™ืŸ.ืงื ืฃ ืื™ื– ืึท ืคึผืึทืจืึทืžืขื˜ืขืจ target_dir, ื•ื•ืึธืก ื“ื•ืจืš ืคืขืœื™ืงื™ื™ึทื˜ ืกืคึผืขืฆื™ืคื™ืฆื™ืจืŸ ื“ื™ ื•ื•ืขื’ื•ื•ื™ื™ึทื–ืขืจ ื•ื•ื• ื‘ืึทืงืึทืคึผืก ื•ื•ืขื˜ ื–ื™ื™ืŸ ื’ืขืฉื˜ืขืœื˜. ืึธื‘ืขืจ ื“ืึธืก ืื™ื– ืึทืคึผืฉืึทื ืึทืœ.

ื ื‘ื™ื™ืฉืคึผื™ืœ ืคื•ืŸ ืกืคึผืขืฆื™ืคื™ืฆื™ืจืŸ ื“ืขื ื“ืจืš ืฆื• ื“ืขืจ ื•ื•ืขื’ื•ื•ื™ื™ึทื–ืขืจ ืžื™ื˜ ืึท ื‘ืึทืงืึทืคึผ ืงืึธืคึผื™ืข ืื™ืŸ ืžื™ื™ืŸ.ืงื ืฃ:

[xtrabackup]
target_dir = /data/backups/mysql/

ื‘ืึทืงืงื•ืคึผ ืฉืจื™ืคื˜

ืื™ืจ ืงืขื ื˜ ื ื•ืฆืŸ ื“ื™ ืคืืœื’ืขื ื“ืข ืฉืจื™ืคื˜ ืฆื• ืฉืึทืคึฟืŸ ืึท ื‘ืึทืงืึทืคึผ:

#!/bin/bash

# ะฃะดะฐะปัะตะผ ะดะฐะฝะฝั‹ะต ะฒ ะบะฐั‚ะฐะปะพะณะต ะฑะตะบะฐะฟะฐ
rm -rf /mysql/backup

# Cะพะทะดะฐั‘ะผ ะฑะตะบะฐะฟ
xtrabackup --user=xtrabackup 
 --password=xxxx_SECRET_xxxx 
 --backup 
 --target-dir=/mysql/backup

# ะ’ั‹ะฟะพะปะฝัะตะผ ะฟะพะดะณะพั‚ะพะฒะบัƒ ะฑะตะบะฐะฟะฐ ะดะปั ั€ะฐะทะฒั‘ั€ั‚ั‹ะฒะฐะฝะธั
xtrabackup --prepare --target-dir=/mysql/backup

# ะกะพะทะดะฐั‘ะผ ะฐั€ั…ะธะฒ
tar -zcvf /home/developer/dumps/xtrabackup-all-dbs-"$(date +%F-%H:%M:%S)".gz /mysql/backup

ื•ื•ืึธืก ื›ืึทืคึผืึทื ื– ื‘ืขืฉืึทืก ืฉืจื™ืคื˜ ื“ื•ืจื›ืคื™ืจื•ื ื’?

ืขืจืฉื˜ืขืจ ืคื•ืŸ ืึทืœืข, ืžื™ืจ ื•ื™ืกืžืขืงืŸ (ื•ื™ืกืžืขืงืŸ) ื“ื™ ื•ื•ืขื’ื•ื•ื™ื™ึทื–ืขืจ ืื™ืŸ ื•ื•ืึธืก ืžื™ืจ ื•ื•ืขืœืŸ ืจืึทื˜ืขื•ื•ืขืŸ ื“ื™ ื‘ืึทืงืึทืคึผ ืงืึธืคึผื™ืข:

rm -rf /mysql/backup.

ื“ืขืจื ืึธืš, ื ื™ืฆืŸ ื“ื™ ื ื•ืฆืŸ XtraBackup ืฉืึทืคึฟืŸ ืึท ื‘ืึทืงืึทืคึผ ืงืึธืคึผื™ืข ืื•ืŸ ืจืึทื˜ืขื•ื•ืขืŸ ืขืก ืื™ืŸ /mysql/backup/:

xtrabackup --user=xtrabackup --password=xxxxz1cYf95550Gc6xxxxxxxpE3rB03xxxx --backup --target-dir=/mysql/backup

ื‘ื™ื– ืึทื”ืขืจ, ืžื™ืจ ื‘ืืฉืืคืŸ ืึท ื‘ืึทื ื™ืฆืขืจ ืื™ืŸ MySQL xtrabackup ืžื™ื˜ ื“ื™ ืคืืจืœืื ื’ื˜ ืคึผืจื™ื•ื•ื™ืœืึทื“ื–ืฉืึทื–. ื ื™ืฆืŸ ื“ื™ ืคึผืึทืจืึทืžืขื˜ืขืจ target-dir ืžื™ืจ ืกืคึผืขืฆื™ืคื™ืฆื™ืจืŸ ื“ื™ ื•ื•ืขื’ื•ื•ื™ื™ึทื–ืขืจ ื•ื•ื• ื“ื™ ื‘ืึทืงืึทืคึผ ื–ืึธืœ ื–ื™ื™ืŸ ื’ืขืจืื˜ืขื•ื•ืขื˜.

ืึท ื•ื•ื™ื›ื˜ื™ืง ืคื•ื ื˜!

ื‘ืึทืžืขืจืงื•ื ื’ ื“ื™ ืฉืจื™ืคื˜ ืฉื•ืจื”:

xtrabackup --prepare --target-dir=/mysql/backup

ืงืึทื˜ืึทืœืึธื’ ื“ืึทื˜ืŸ /mysql/backup ื–ืขื ืขืŸ ื ื™ืฉื˜ ืงืึธื ืกื™ืกื˜ืขื ื˜ ื‘ื™ื– ื–ื™ื™ ื–ืขื ืขืŸ ื”ืึทืœื‘. 

ื“ืขืจ ืคืึทืงื˜ ืื™ื– ืึทื– ืขื ื“ืขืจื•ื ื’ืขืŸ ืงืขืŸ ืคึผืึทืกื™ืจืŸ ื‘ืฉืขืช ืงืึทืคึผื™ื™ื ื’ ื˜ืขืงืขืก. ืึธืคึผืขืจืึทืฆื™ืข xtrabackup --prepare --target-dir=/mysql/backup ืžืื›ื˜ ื‘ืึทืงืึทืคึผ ื“ืึทื˜ืŸ ื‘ื™ืฉืœื™ื™ืžืขืก ืงืึธื ืกื™ืกื˜ืขื ื˜ ืื™ื‘ืขืจ ืฆื™ื™ึทื˜.

ืื™ืจ ืงืขื ืขืŸ ื“ื•ืจื›ืคื™ืจืŸ ื“ื™ ื“ืึทื˜ืŸ ืฆื•ื’ืจื™ื™ื˜ื•ื ื’ ืึธืคึผืขืจืึทืฆื™ืข ืื•ื™ืฃ ืงื™ื™ืŸ ืžืึทืฉื™ืŸ. ืขืก ืื™ื– ื ื™ื˜ ื“ืึทืจืคึฟืŸ ืฆื• ื˜ืึธืŸ ื“ืึธืก ืื•ื™ืฃ ื“ื™ ืกืขืจื•ื•ืขืจ ื•ื•ื• ื“ื™ ืžืงื•ืจ DBMS ืื™ื– ืœื™ื’ืŸ. ืื™ืจ ืงืขื ืขืŸ ื ืึธื›ืžืึทื›ืŸ ื“ื™ ื‘ืึทืงืึทืคึผ ืฆื• ื“ื™ ืฆื™ืœ ืกืขืจื•ื•ืขืจ ืื•ืŸ ืฆื•ื’ืจื™ื™ื˜ืŸ ืขืก ื“ืึธืจื˜.

ื“ื™ ืœืขืฆื˜ืข ื–ืึทืš ืžื™ืจ ื˜ืึธืŸ ืื™ื– ืฉืึทืคึฟืŸ ืึทืŸ ืึทืจืงื™ื™ื•ื• ืื™ืŸ ื•ื•ืึธืก ืžื™ืจ ืฉื˜ืขืœืŸ ืื•ื ื“ื–ืขืจ ื‘ืึทืงืึทืคึผ:

tar -zcvf /home/developer/dumps/xtrabackup-all-dbs-ยซ$(date % F% H% M% S)ยป.gz /mysql/backup

ืจื™ืกื˜ืึธืจื™ื ื’ ืึท ื‘ืึทืงืึทืคึผ 

ืื™ื™ื“ืขืจ ืื™ืจ ืงืขื ืขืŸ ื•ืžืงืขืจืŸ ืึท ื‘ืึทืงืึทืคึผ ืฆื• ื“ื™ ืฆื™ืœ ืกืขืจื•ื•ืขืจ, ื“ื™ ื“ืึทื˜ืŸ ืžื•ื–ืŸ ื“ื•ืจื›ื’ื™ื™ืŸ ืึท ืฆื•ื’ืจื™ื™ื˜ื•ื ื’ ืคืึทืกืข. ื–ืขืŸ ืื•ื™ื‘ืŸ ืคึฟืึทืจ ื•ื•ื™ ืฆื• ื˜ืึธืŸ ื“ืึธืก.

ื“ื™ ื“ืึทื˜ืŸ ืึธืคึผื–ื•ืš ืคึผืจืึธืฆืขืก ืื™ื– ื–ื™ื™ืขืจ ืคึผืฉื•ื˜. ืื™ืจ ื“ืึทืจืคึฟืŸ ืฆื• ืขืงืกื˜ืจืึทืงื˜ ื“ื™ ื‘ืึทืงืึทืคึผ ืคื•ืŸ ื“ื™ ืึทืจืงื™ื™ื•ื• ืื•ืŸ ืคืึทืจื‘ื™ื™ึทื˜ืŸ ื“ื™ ื“ืึทื˜ืŸ ืื™ืŸ ืื™ื– ื“ืึทื˜ืŸ.

ื•ื•ื™ ืฆื• ืคืึทืจื‘ื™ื™ึทื˜ืŸ ื“ืึทื˜ืŸ ืื™ืŸ ื“ืึทื˜ืึทื“ื™ืจ?

ื–ืืœ ืก ื‘ืึทื˜ืจืึทื›ื˜ืŸ ืฆื•ื•ื™ื™ ืึธืคึผืฆื™ืขืก.

Option 1

ื ื™ืฆืŸ ื“ื™ ื ื•ืฆืŸ XtraBackup. ืื™ืจ ื“ืึทืจืคึฟืŸ ืฆื• ืกืคึผืขืฆื™ืคื™ืฆื™ืจืŸ ืึทืŸ ืึธืคึผืฆื™ืข --ืงืึธืคึผื™-ืฆื•ืจื™ืง. 

ื“ืขืจ ื‘ืึทืคึฟืขืœ ืื•ื ื˜ืŸ ื•ื•ืขื˜ ืึทืจื™ื‘ืขืจืคื™ืจืŸ ื“ื™ ื‘ืึทืงืึทืคึผ ืฆื• ืื™ื– ื“ืึทื˜ืŸ ืฆื™ืœ ืกืขืจื•ื•ืขืจ:

xtrabackup --copy-back --target-dir=/mysql/backup

Option 2

ืื™ืจ ืงืขื ืขืŸ ื˜ืึธืŸ ืขืก ื“ื™ืคืขืจืขื ื˜ืœื™, ื˜ืึธืŸ ืึธืŸ ื“ื™ ื ื•ืฆืŸ XtraBackup.

ื›ืœ ืื™ืจ ื“ืึทืจืคึฟืŸ ืฆื• ื˜ืึธืŸ ืื™ื– ืฆื• ื ืึธื›ืžืึทื›ืŸ ื“ื™ ื‘ืึทืงืึทืคึผ ืื™ื– ื“ืึทื˜ืŸ. ืื™ืจ ืงืขื ืขืŸ ื˜ืึธืŸ ื“ืึธืก ืžื™ื˜ cp ืึธื“ืขืจ rsync.

ืขืก ืื™ื– ื•ื•ื™ื›ื˜ื™ืง ืฆื• ืคึฟืึทืจืฉื˜ื™ื™ืŸ ืึทื– ื“ืขืจ ืคึผืจืึธืฆืขื“ื•ืจ ืคึฟืึทืจ ืจื™ืกื˜ืึธืจื™ื ื’ ืึท ื‘ืึทืงืึทืคึผ ืื™ื– ื ืึธืจ ืจื™ืคึผืœื™ื™ืกื™ื ื’ ื“ื™ ืื™ื ื”ืึทืœื˜ ืคื•ืŸ ื“ื™ ื•ื•ืขื’ื•ื•ื™ื™ึทื–ืขืจ. ืื™ื– ื“ืึทื˜ืŸ.

ืื™ื™ื“ืขืจ ืื™ืจ ืึธื ื”ื™ื™ื‘ืŸ ืจื™ืกื˜ืึธืจื™ื ื’ ืึท ื‘ืึทืงืึทืคึผ ืื•ื™ืฃ ื“ื™ ืฆื™ืœ ืกืขืจื•ื•ืขืจ, ืื™ืจ ืžื•ื–ืŸ:

  • ื”ืึทืœื˜ืŸ MySQL ืกืขืจื•ื•ืขืจ.

  • ืงืœืึธืจ ื˜ืขืงืข ืื™ื– ื“ืึทื˜ืŸ ืึธื“ืขืจ ืžืึทืš ื–ื™ื™ึทืŸ ืื™ื ื”ืึทืœื˜ ืฆื• ืืŸ ืื ื“ืขืจ ืึธืจื˜. ืงืึทื˜ืึทืœืึธื’ ืื™ื– ื“ืึทื˜ืŸ ืžื•ื– ื–ืฒืŸ ืœืฒื“ื™ืง.

ื ืึธืš ืงืึทืžืคึผืœื™ื˜ื™ื ื’ ื“ื™ ื“ืึทื˜ืŸ ืึทืจื™ื‘ืขืจืคื™ืจืŸ ืฆื• ืื™ื– ื“ืึทื˜ืŸ MySQL ืกืขืจื•ื•ืขืจ ืงืขื ืขืŸ ื–ื™ื™ืŸ ืกื˜ืึทืจื˜ืขื“.

ืžืึทื˜ืขืจื™ืึทืœืก ื’ืขื ื™ืฆื˜

ื‘ืึทืึทืžื˜ืขืจ ื“ืึทืงื™ื•ืžืขื ื˜ื™ื™ืฉืึทืŸ ืคึผืขืจืงืึธื ืึท XtraBackup.

ืžืงื•ืจ: www.habr.com

ืงื•ื™ืคืŸ ืคืึทืจืœืึธื–ืœืขืš ื”ืึธืกื˜ื™ื ื’ ืคึฟืึทืจ ื–ื™ื™ื˜ืœืขืš ืžื™ื˜ DDoS ืฉื•ืฅ, VPS VDS ืกืขืจื•ื•ืขืจืก ๐Ÿ”ฅ ืงื•ื™ืคื˜ ืคืึทืจืœืขืกืœืขื›ืข ื•ื•ืขื‘ื–ื™ื™ื˜ืœ ื”ืึธืกื˜ื™ื ื’ ืžื™ื˜ DDoS ืฉื•ืฅ, VPS VDS ืกืขืจื•ื•ืขืจืก | ProHoster