Percona XtraBackup — he taputapu mō te tārua wera o ngā pātengi raraunga MySQL.
I a koe e hanga ana i tētahi tārua raraunga, kāore he ripanga e maukatihia, ā, ka haere tonu te mahi a tō pūnaha me te kore he here.
Pūrua-X 2.4 ka taea te hanga tārua tārua o ngā ripanga InnoDB, XtraDB и TakuISAM i runga i ngā tūmau MySQL 5.11, 5.5, 5.6, me te 5.7, me te tūmau anō hoki percona ki MySQL с XtraDB.
Hei mahi tahi MySQL 8.x me whakamahi te putanga XtraBackup 8.x. Ka kōrero noa tēnei tuhinga mō XtraBackup 2.4.
Ko te tino painga Pūrua-Xtra he pai tēnei taputapu mō te hanga tārua o ngā mea kua utaina rawatia tūmau, tae atu ki ngā pūnaha he iti te maha o ngā tauwhitinga.
Mena he nui te rahi katoa o ō pātengi raraunga MySQL (tekau kigabytes), kāti ko te taputapu paerewa Tuhinga o mua e kore e tuku i a koe ki te hanga tere i tētahi tārua tārua, ā, ka roa te wā e whakahokia mai ai te puranga.
tāutanga
tāutanga Pūrua-Xtra mai i te putunga pai Percona.
Whakahaerehia ngā whakahau e whai ake nei i te raupapa:
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-242I muri i te tāutanga, whakahaerehia te whakahau xtrabackup -vHe mea nui kia tika te whakahaere o te taputapu i runga i te tūmau. Nō reira, ka puta mai tētahi mea pēnei i te mata:
xtrabackup: ngā tautohe tūmau kua mōhiotia: - datadir=/var/lib/mysql - tmpdir=/tmp - server-id=1 - logbin=/var/log/mysql/mysql-bin.log - innodbbufferpoolsize=16384M - innodbfilepertable=1 - innodbflushmethod=Odirect - innodbflushlogattrxcommit=0xtrabackup putanga 2.4.20 i runga i te tūmau MySQL 5.7.26 Linux (x8664) (tautuhinga whakahou: c8b4056)
Ngā mana uru, ngā whakaaetanga me ngā painga
Me taea e XtraBackup te:
Hono atu ki tō tūmau MySQL.
Whai mana uru ki te whaiaronga raraunga.
I te wā e hanga ana i tētahi tārua tārua, me whai mana tuhi ki te tawhā kua tohua ūnga-aratohu rārangi pukapuka
He aha te datadir?
raraunga - Koinei te whaiaronga kei reira te tūmau pātengi raraunga. MySQL e rongoa ana i ngā raraunga. Kei reira ngā pātengi raraunga katoa, ngā ripanga katoa. I te nuinga o ngā tohatoha Linux Mā te taunoa, ko tēnei whaiaronga /var/lib/mysql.
He aha te whaiaronga target-dir?
ūnga-aratohu — koinei te kōpaki ka tiakina ai te tārua.
Me tāruatia ngā mana uru e whai ake nei ki ngā ripanga me ngā pātengi raraunga e te kaiwhakamahi pātengi raraunga:
UTAINA ANŌ, RAHIA HOKI NGĀ TĒPU
KAITUKU TĀRUA
Waihangahia he wāhi tēpu
PROCESS
Super
FA'U
WHAKAMAHI
Tīpakohia
Hōutuutu
Hōutuutu Pūrua-Xtra ka tutuki mā te whakamahi i ngā kōwhiringa e mahi ana i ngā tawhā paerewa o MySQL.
He aha te tikanga o tenei?
Ka taea te tohu i ngā tawhā whirihoranga i runga i te raina whakahau, i roto rānei i te kōnae whirihoranga DBMS, hei tauira i roto i /etc/my.cnf.
Ka pānuihia e te taputapu XtraBackup ngā wāhanga i muri i te whakarewatanga [mysqld] и [tārua-anō] mai i ngā kōnae whirihoranga MySQL. Ka mahia tēnei kia taea ai e te taputapu te whakamahi i ō tautuhinga DBMS me te kore e hiahiatia kia tohua ā-ringa mō ia tārua.
Hei tauira, ko te tikanga raraunga me ētahi tawhā InnoDB Ka whiwhi mātou i a XtraBackup mai i te whirihoranga o tō DBMS.
Ki te hiahia koe ki te whakakore i ngā tautuhinga i te wāhanga XtraBackup [mysqld], kātahi ka tohua noa i roto i te kōnae whirihoranga i te wāhanga [tārua-anō]Nā te mea ka pānuitia ā muri ake nei, ka nui ake tō rātou kaupapa matua.
Kāore koe e hiahia ki te tāpiri i tētahi tawhā ki taku.cnfKa taea te tohu i ngā tawhā katoa e hiahiatia ana i runga i te raina whakahau. I te nuinga o te wā, ko te mea anake ka taea te whakanoho pai ki te wāhanga [tārua-anō] ou taku.cnf - he tawhā tēnei ūnga_dir, e tohu ana i te whaiaronga ka waiho ngā tārua mā te taunoa. Heoi, kāore e hiahiatia ana tēnei.
He tauira mō te tohu i te ara ki te whaiaronga me te tārua tārua i roto i taku.cnf:
[xtrabackup]
target_dir = /data/backups/mysql/Hōtuhi waihanga tārua
Hei waihanga i tētahi tārua, ka taea e koe te whakamahi i te hōtuhi e whai ake nei:
#!/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/backupHe aha te mea ka tupu ina whakahaerehia he tuhinga?
Ko te mea tuatahi ka mahia e mātou ko te horoi (muku) i te kōpaki ka tiakina e mātou te tārua:
rm -rf /mysql/backup.
Kātahi ka whakamahi i te taputapu Pūrua-Xtra hanga he tārua tārua, ā, tiakina ki roto i /mysql/tārua/:
xtrabackup --user=xtrabackup --password=xxxxz1cYf95550Gc6xxxxxxxpE3rB03xxxx --backup --target-dir=/mysql/backupI hangaia e mātou he kaiwhakamahi MySQL i mua. xtrabackup me ngā mana e hiahiatia ana. Mā te whakamahi i te tawhā target-dir Ka tohua e mātou te kōpaki hei penapena i te tārua.
He take nui!
Kia mahara ki te rārangi tuhinga:
xtrabackup --prepare --target-dir=/mysql/backup
Ngā raraunga i roto i te putumōhio /mysql/tārua kāore e pumau tae noa ki te wā e rite ai rātou.
Ko te mea kē, tera pea kua puta ngā huringa i te wā e tāruatia ana ngā kōnae. Te mahi xtrabackup --prepare --target-dir=/mysql/backup ka tino ōrite ngā raraunga tārua i roto i te wā.
Ka taea e koe te mahi i te mahi whakarite raraunga i runga i tētahi mīhini. Kāore he take ki te mahi i tēnei i runga i te tūmau e manaaki ana i te pūtake o te DBMS. Ka taea e koe te tārua i te tārua ki te tūmau ūnga me te whakarite i reira.
Ko tā mātou mahi whakamutunga ko te waihanga i tētahi pūranga hei whakanoho i tā mātou tārua tārua:
tar -zcvf /home/developer/dumps/xtrabackup-all-dbs-«$(date % F% H% M% S)».gz /mysql/backupTe whakaora i tētahi tārua
I mua i te whakahokinga mai i tētahi tārua ki te tūmau ūnga, me whai wā whakarite ngā raraunga. Tirohia i runga ake nei ngā tohutohu mō te mahi i tēnei.
He tino māmā te tukanga whakaora raraunga. Me tango noa e koe te tārua mai i te pūranga ka whakakapi i ngā raraunga ki roto raraunga.
Me pēhea te whakakapi i ngā raraunga i roto i te datadir?
Kia whakaarohia ngā kōwhiringa e rua.
Kōwhiringa 1
Whakamahia te taputapu Pūrua-XtraMe tohu e koe te kōwhiringa —tārua-whakamuri.
Mā te whakahau i raro nei ka nukuhia te tārua ki raraunga tūmau ūnga:
xtrabackup --copy-back --target-dir=/mysql/backupKōwhiringa 2
Ka taea e koe te mahi i tēnei i tētahi atu huarahi, me te kore e whakamahi i te whaipainga. Pūrua-Xtra.
Ko tāu noa he tārua i te tārua ki raraungaKa taea e koe tēnei mā te āwhina o cp ranei rsync.
He mea nui kia mārama ko te tukanga whakaora tārua he mea noa iho te whakakapi i ngā ihirangi o te whaiaronga. raraunga.
I mua i te tīmatanga o te whakahoki mai i tētahi tārua ki te tūmau ūnga, me:
Whakamutua te tūmau MySQL.
Ūkui kōpaki raraunga nekehia rānei ōna ihirangi ki tētahi atu wāhi raraunga me takoto kau.
Kia oti te whakawhiti raraunga, raraunga Ka taea te tīmata i te tūmau MySQL.
Ngā rauemi e whakamahia ana
.
Source: will.com
