Incremental VDS tergum cum situs in 1C-Bitrix in Yandex.Cloud

Mihi opus est ut tergum situs in "2C-Bitrix: Site Management" (lima et mysql database) bis in die condere historiam mutationum per XC dies.

Situm in VDS currentem CentOS 7 OS cum 1C-Bitrix situm est: Interretialis Ambitus inauguratus est. Accedit, exemplum tergum fac occasus tui OS.

requisita:

  • Frequentia - 2 times in day;
  • Codices proximis XC diebus servant;
  • Facultas obtinendi singulas tabulas ad certum diem, si opus sit;
  • Tergum reponendum est in centrum datae praeter VDS;
  • Facultas ad tergum alicunde accedere (alicui servo, locali computatori, etc.).

Magni momenti erat facultas tergum creandi cum minima consummatione spatii accessionis et subsidiorum systematis.

Hoc non est de snapshot cito systema totum restituendi, sed de files et datorum et historiarum mutationum.

Notitia initialis:

  • VDS on XEN virtualization;
  • OS CentOS 7;
  • 1C-Bitrix: Ambitus interreti;
  • Site based on "1C-Bitrix: Site Management", Standard version;
  • Tabella magnitudo 50 GB et crescet;
  • Magnitudo datorum 3 GB est et crescet.

Vexillum tergum in 1C-Bitrix constructum statim exclusi. Exiguis locis idoneus est, quod;

  • Plenum exemplum situs omni tempore facit, uterque exemplar tantumdem spatii capiet quantum tabulae sumendae, in casu meo 50 GB.
  • Tergum factum est utens PHP, quod cum talibus voluminibus imaginum impossibile est, hoc servo onerare et numquam finire potest.
  • Et sane non potest esse sermo de ullis XC diebus in pleno exemplari actarum.

Solutio hostiarius offert orbis tergum in eodem centri notitia posito quod VDS est, sed in alio servo. Cum disco per FTP laborare potes et scriptis tuis utere, aut si ISPManager in VDS inauguratus est, per eius moduli tergum. Haec optio non convenit ex usu centri eiusdem notitiae.

Ex omnibus supradictis, optima electio mihi est incremental tergum utens scripto proprio in Yandex.Cloud (Object Storage) vel Amazon S3 (Amazon Simple Storage Service).

Hoc postulat;

  • radix aditum VDS;
  • inauguratus est duplicitatis utilitas;
  • rationem apud Yandex.Cloud.

Incremental tergum - methodus in qua sola notitia quae mutata est cum novissimum tergum scrinium est.

fallaciaeque - utilitas tergum, qua rsync algorithmis utitur et cum Amazonibus S3. operari potest.

Yandex.Cloud vs Amazon S3

Nihil interest inter Yandex.Cloud and Amazon S3 in hoc casu pro me. Yandex Amazonum S3 API molem sustinet, ut cum ea operari potes utens solutionibus quae ad operandum cum S3 existunt. In me, haec est utilitas duplicitatis.

Praecipua utilitas Yandex mercedem in rublis esse potest, si data est sors, nulla nexus erit ad commutationem rate. Secundum velocitatem, Amazonum centra Europaea data operant comparabiles cum centris Russicis in Yandex, exempli gratia, Francofurto uti potes. Ego antea ad similia opera S3 Amazonia usus sum, nunc Yandex experiri decrevi.

Yandex.Cloud eriges

1. In Yandex.Cloud mercedem rationem creare debes. Hoc facere, debes Yandex.Cloud per tuum Yandex rationem vel novam creare.

2. Nubes crea.
Incremental VDS tergum cum situs in 1C-Bitrix in Yandex.Cloud

3. In "Nube" creo "Catalogus".
Incremental VDS tergum cum situs in 1C-Bitrix in Yandex.Cloud

4. Nam "Catalogus" creare "Servitium rationem".
Incremental VDS tergum cum situs in 1C-Bitrix in Yandex.Cloud

5. Nam "Ratio Muneris" claves creant.
Incremental VDS tergum cum situs in 1C-Bitrix in Yandex.Cloud

6. Serva claves, eas in futuro indigebis.
Incremental VDS tergum cum situs in 1C-Bitrix in Yandex.Cloud

7. Pro "Catalogo" creare "Situla", fasciculi in illud cadent.
Incremental VDS tergum cum situs in 1C-Bitrix in Yandex.Cloud

8. Commendo terminum constituendum et "Cold Repono".
Incremental VDS tergum cum situs in 1C-Bitrix in Yandex.Cloud

Occasus tergum sursum profecta in calculonis servi

Hic dux basic artes administrationis assumit.

1. Instrue in VDS duplicitatis utilitatem

yum install duplicity

2. Facere folder pro mysql dumps, in casu meo est /backup_db in radice VDS

3. Facere folder pro bash scriptorum /backup_scripts et fac primum scriptum quod faciet tergum /backup_scripts/backup.sh

Scriptor contentus:

#!`which bash`


# /backup_scripts/backup.sh

# Π­Ρ‚ΠΎ условиС провСряСт Π½Π΅ ΠΈΠ΄Ρ‘Ρ‚ Π»ΠΈ Π² Π΄Π°Π½Π½Ρ‹ΠΉ ΠΌΠΎΠΌΠ΅Π½Ρ‚ процСсс Ρ€Π΅Π·Π΅Ρ€Π²Π½ΠΎΠ³ΠΎ копирования, Ссли ΠΈΠ΄Ρ‘Ρ‚, Ρ‚ΠΎ Π½Π° email отправляСтся сообщСниС ΠΎΠ± ошибкС (этот Π±Π»ΠΎΠΊ ΠΌΠΎΠΆΠ½ΠΎ Π½Π΅ ΠΈΡΠΏΠΎΠ»ΡŒΠ·ΠΎΠ²Π°Ρ‚ΡŒ)
if [ -f /home/backup_check.mark ];
then

DATE_TIME=`date +"%d.%m.%Y %T"`;

/usr/sbin/sendmail -t <<EOF
From:backup@$HOSTNAME
To:<Π’Π°Ρˆ EMAIL>
Subject:Error backup to YANDEX.CLOUD
Content-Type:text/plain; charset=utf-8
Error backup to YANDEX.CLOUD

$DATE_TIME
EOF

else

# Основной Π±Π»ΠΎΠΊ ΠΎΡ‚Π²Π΅Ρ‡Π°ΡŽΡ‰ΠΈΠΉ Π·Π° Ρ€Π΅Π·Π΅Ρ€Π²Π½ΠΎΠ΅ ΠΊΠΎΠΏΠΈΡ€ΠΎΠ²Π°Π½ΠΈΠ΅
# Если Π½Π΅Ρ‚ ΠΎΡ‰ΠΈΠ±ΠΊΠΈ ставим ΠΌΠ΅Ρ‚ΠΊΡƒ ΠΈ запускаСм backup

echo '' > /home/backup_check.mark;


# УдаляСм Ρ„Π°ΠΉΠ»Ρ‹ с Π΄Π°ΠΌΠΏΠ°ΠΌΠΈ Π±Π°Π·Ρ‹ ΠΎΡΡ‚Π°Π²ΡˆΠΈΠ΅ΡΡ ΠΎΡ‚ ΠΏΡ€Π΅Π΄Ρ‹Π΄ΡƒΡ‰Π΅Π³ΠΎ backup

/bin/rm -f /backup_db/*


# Π”Π΅Π»Π°Π΅ΠΌ Π΄Π°ΠΌΠΏ всСх mysql Π±Π°Π·, прСдполагаСтся Ρ‡Ρ‚ΠΎ доступ Π΄ΠΎΠ±Π°Π²Π»Π΅Π½ Π² Ρ„Π°ΠΉΠ»Π΅ /root/.my.cnf

DATETIME=`date +%Y-%m-%d_%H-%M-%S`;

`which mysqldump` --quote-names --all-databases | `which gzip` > /backup_db/DB_$DATETIME.sql.gz


# ДобавляСм Π΄Π°Π½Π½Ρ‹Π΅ для ΠΎΡ‚ΠΏΡ€Π°Π²ΠΊΠΈ Π² ЯндСкс.

export PASSPHRASE=<ΠŸΡ€ΠΈΠ΄ΡƒΠΌΠ°ΠΉΡ‚Π΅ ΠΏΠ°Ρ€ΠΎΠ»ΡŒ для ΡˆΠΈΡ„Ρ€ΠΎΠ²Π°Π½ΠΈΡ Π°Ρ€Ρ…ΠΈΠ²Π°>
export AWS_ACCESS_KEY_ID=<Π˜Π΄Π΅Π½Ρ‚ΠΈΡ„ΠΈΠΊΠ°Ρ‚ΠΎΡ€ ΠΊΠ»ΡŽΡ‡Π° ΠΏΠΎΠ»ΡƒΡ‡Π΅Π½Π½Ρ‹ΠΉ Ρƒ ЯндСкса>
export AWS_SECRET_ACCESS_KEY=<Π‘Π΅ΠΊΡ€Π΅Ρ‚Π½Ρ‹ΠΉ ΠΊΠ»ΡŽΡ‡ ΠΏΠΎΠ»ΡƒΡ‡Π΅Π½Π½Ρ‹ΠΉ Ρƒ ЯндСкса>


# ЗапускаСм duplicity для рСзСрвирования Π½Π΅ΠΎΠ±Ρ…ΠΎΠ΄ΠΈΠΌΡ‹Ρ… ΠΏΠ°ΠΏΠΎΠΊ Π½Π° сСрвСрС.
# Данная ΠΊΠΎΠΌΠ°Π½Π΄Π° Π±ΡƒΠ΄Π΅Ρ‚ ΡΠΎΠ·Π΄Π°Π²Π°Ρ‚ΡŒ ΠΏΠΎΠ»Π½Ρ‹ΠΉ backup Ρ€Π°Π· Π² мСсяц ΠΈ Π΄ΠΎ ΡΠ»Π΅Π΄ΡƒΡŽΡ‰Π΅Π³ΠΎ мСсяца Π΄ΠΎΠ±Π°Π²Π»ΡΡ‚ΡŒ ΠΈΠ½ΠΊΡ€Π΅ΠΌΠ΅Π½Ρ‚Π°Π»ΡŒΠ½Ρ‹Π΅ ΠΊ Π½Π΅ΠΌΡƒ
# -- exclude это ΠΏΠ°ΠΏΠΊΠΈ, ΠΊΠΎΡ‚ΠΎΡ€Ρ‹Π΅ Π½ΡƒΠΆΠ½ΠΎ ΠΈΡΠΊΠ»ΡŽΡ‡ΠΈΡ‚ΡŒ, я ΠΈΡΠΊΠ»ΡŽΡ‡Π°ΡŽ всС ΠΏΠ°ΠΏΠΊΠΈ с кСшСм битрикса
# --include ΠΏΠ°ΠΏΠΊΠΈ ΠΊΠΎΡ‚ΠΎΡ€Ρ‹Π΅ Π½ΡƒΠΆΠ½ΠΎ Ρ€Π΅Π·Π΅Ρ€Π²ΠΈΡ€ΠΎΠ²Π°Ρ‚ΡŒ Π² ΠΌΠΎΡ‘ΠΌ случаС это:
# - /backup_db
# - /home
# - /etc
# s3://storage.yandexcloud.net/backup , backup это имя созданного Π²Ρ‹ΡˆΠ΅ Π±Π°ΠΊΠ΅Ρ‚Π°

# ВСхничСская ΠΎΡΠΎΠ±Π΅Π½Π½ΠΎΡΡ‚ΡŒ ΠΈ значСния Π½Π΅ΠΊΠΎΡ‚ΠΎΡ€Ρ‹Ρ… ΠΏΠ°Ρ€Π°ΠΌΠ΅Ρ‚Ρ€ΠΎΠ²:
# Π”Π²Π΅ строки "--exclude='**'" ΠΈ "/" Π½ΡƒΠΆΠ½Ρ‹, Ρ‡Ρ‚ΠΎΠ±Ρ‹ ΠΌΠΎΠΆΠ½ΠΎ Π±Ρ‹Π»ΠΎ Π²Ρ‹ΡˆΠ΅ ΠΎΠΏΠ΅Ρ€ΠΈΡ€ΠΎΠ²Π°Ρ‚ΡŒ --include ΠΈ --exclude для Ρ€Π°Π·Π½Ρ‹Ρ… ΠΏΠ°ΠΏΠΎΠΊ. Π­Ρ‚ΠΈ Π΄Π²Π΅ строчки сначала Π΄ΠΎΠ±Π°Π²Π»ΡΡŽΡ‚ Π² бэкап вСсь сСрвСр "/", ΠΏΠΎΡ‚ΠΎΠΌ ΠΈΡΠΊΠ»ΡŽΡ‡Π°ΡŽΡ‚ Π΅Π³ΠΎ "--exclude='**'"
# --full-if-older-than='1M' - ΡΠΎΠ·Π΄Π°Π²Π°Ρ‚ΡŒ ΠΏΠΎΠ»Π½ΡƒΡŽ копию ΠΊΠ°ΠΆΠ΄Ρ‹ΠΉ мСсяц
# --volsize='512' - ΠΌΠ°ΠΊΡΠΈΠΌΠ°Π»ΡŒΠ½Ρ‹ΠΉ Ρ€Π°Π·ΠΌΠ΅Ρ€ ΠΊΠ°ΠΆΠ΄ΠΎΠ³ΠΎ ΠΈΠ· Ρ„Π°ΠΉΠ»ΠΎΠ² Π² бэкапС Π² ΠΌΠ΅Π³Π°Π±Π°ΠΉΡ‚Π°Ρ…
# --log-file='/var/log/duplicity.log' - ΠΊΡƒΠ΄Π° ΠΏΠΈΡΠ°Ρ‚ΡŒ Π»ΠΎΠ³ Ρ„Π°ΠΉΠ»

`which duplicity` 
    --s3-use-ia --s3-european-buckets 
    --s3-use-new-style 
    --s3-use-multiprocessing 
    --s3-multipart-chunk-size='128' 
    --volsize='512' 
    --no-print-statistics 
    --verbosity=0 
    --full-if-older-than='1M' 
    --log-file='/var/log/duplicity.log' 
    --exclude='**/www/bitrix/backup/**' 
    --exclude='**/www/bitrix/cache/**' 
    --exclude='**/www/bitrix/cache_image/**' 
    --exclude='**/www/bitrix/managed_cache/**' 
    --exclude='**/www/bitrix/managed_flags/**' 
    --exclude='**/www/bitrix/stack_cache/**' 
    --exclude='**/www/bitrix/html_pages/*/**' 
    --exclude='**/www/bitrix/tmp/**' 
    --exclude='**/www/upload/tmp/**' 
    --exclude='**/www/upload/resize_cache/**' 
    --include='/backup_db' 
    --include='/home' 
    --include='/etc' 
    --exclude='**' 
    / 
    s3://storage.yandexcloud.net/backup



# Данная ΠΊΠΎΠΌΠ°Π½Π΄Π° Π½ΡƒΠΆΠ½Π° для чистки.
# Она оставляСт 3 послСдних ΠΏΠΎΠ»Π½Ρ‹Ρ… backup ΠΈ ассоциированных с Π½ΠΈΠΌΠΈ ΠΈΠ½ΠΊΡ€Π΅ΠΌΠ΅Π½Ρ‚Π°Π»ΡŒΠ½Ρ‹Ρ… backup.
# Π’.ΠΎ. Ρƒ мСня ΠΎΡΡ‚Π°ΡŽΡ‚ΡΡ backup Π·Π° 3 мСсяца, Ρ‚.ΠΊ. пСрвая ΠΊΠΎΠΌΠ°Π½Π΄Π° ΠΊΠ°ΠΆΠ΄Ρ‹ΠΉ мСсяц Π΄Π΅Π»Π°Π΅Ρ‚ Π½ΠΎΠ²Ρ‹ΠΉ ΠΏΠΎΠ»Π½Ρ‹ΠΉ backup

`which duplicity` remove-all-but-n-full 3 --s3-use-ia --s3-european-buckets --s3-use-new-style --verbosity=0 --force s3://storage.yandexcloud.net/backup



unset PASSPHRASE
unset AWS_ACCESS_KEY_ID
unset AWS_SECRET_ACCESS_KEY

# УдаляСм ΠΌΠ΅Ρ‚ΠΊΡƒ ΠΎΠ± ΠΈΠ΄ΡƒΡ‰Π΅ΠΌ backup

/bin/rm -f /home/backup_check.mark;

fi

4. Scriptum primum curre et eventum deprime, lima in "Situla" apparebit.

`which bash` /backup_scripts/backup.sh

Incremental VDS tergum cum situs in 1C-Bitrix in Yandex.Cloud

5. Scriptum cron addere pro usuario radicis ad currendum 2 vicibus in die, vel cum frequentia debes.

10 4,16 * * * `which bash` /backup_scripts/backup.sh

Recuperandae notitia ex Yandex.Cloud

1. Fac restituo folder / backup_restore

2. Fac vercundus restituet litteras /backup_scripts/restitue.sh

Gratiam maxime do exemplo limae specificae restituendae:

#!`which bash`

export PASSPHRASE=<ΠŸΠ°Ρ€ΠΎΠ»ΡŒ для ΡˆΠΈΡ„Ρ€ΠΎΠ²Π°Π½ΠΈΡ Π°Ρ€Ρ…ΠΈΠ²Π° ΠΈΡΠΏΠΎΠ»ΡŒΠ·ΡƒΠ΅ΠΌΡ‹ΠΉ ΠΏΡ€ΠΈ бэкапС>
export AWS_ACCESS_KEY_ID=<Π˜Π΄Π΅Π½Ρ‚ΠΈΡ„ΠΈΠΊΠ°Ρ‚ΠΎΡ€ ΠΊΠ»ΡŽΡ‡Π° ΠΏΠΎΠ»ΡƒΡ‡Π΅Π½Π½Ρ‹ΠΉ Ρƒ ЯндСкса>
export AWS_SECRET_ACCESS_KEY=<Π‘Π΅ΠΊΡ€Π΅Ρ‚Π½Ρ‹ΠΉ ΠΊΠ»ΡŽΡ‡ ΠΏΠΎΠ»ΡƒΡ‡Π΅Π½Π½Ρ‹ΠΉ Ρƒ ЯндСкса>

# 3 ΠΏΡ€ΠΈΠΌΠ΅Ρ€Π°, Ρ€Π°ΡΠΊΠΎΠΌΠΌΠ΅Π½Ρ‚ΠΈΡ€ΠΎΠ²Π°Ρ‚ΡŒ Π½ΡƒΠΆΠ½Ρ‹ΠΉ

# ΠŸΠΎΠ»ΡƒΡ‡ΠΈΡ‚ΡŒ статус backup
#`which duplicity` collection-status s3://storage.yandexcloud.net/backup

# Π’ΠΎΡΡΡ‚Π°Π½ΠΎΠ²ΠΈΡ‚ΡŒ index.php ΠΈΠ· корня сайта
#`which duplicity` --file-to-restore='home/bitrix/www/index.php' s3://storage.yandexcloud.net/backup /backup_restore/index.php

# Π’ΠΎΡΡΡ‚Π°Π½ΠΎΠ²ΠΈΡ‚ΡŒ index.php ΠΈΠ· корня сайта 3Ρ… Π΄Π½Π΅Π²Π½ΠΎΠΉ давности
#`which duplicity` --time='3D' --file-to-restore='home/bitrix/www/index.php' s3://storage.yandexcloud.net/backup /backup_restore/index.php

unset PASSPHRASE
unset AWS_ACCESS_KEY_ID
unset AWS_SECRET_ACCESS_KEY

3. Curre scriptum et expecta exitum.

`which bash` /backup_scripts/backup.sh

In /backup_restore/ folder invenies index.php lima quae antea subnixa erat.

Recommodationes melius facere potes ad usus tuos aptandos.

minus duplicitate

Duplicitas unum incommodum habet - modus non est modus ut canalis usus. Cum canali regulari hoc problema non creat, sed cum canali DDoS protecto utens velociter per diem incurrens, limes 1-2 megabitarum imponere posse velim.

Conclusio

Tergum in Yandex.Cloud or Amazon S3 praebet exemplar sui iuris situs et OS occasus qui accedere possunt ab aliquo alio servo vel computatrum locali. Hoc autem exemplum non apparet vel in panelli potestate obnoxius vel in tabula admin Bitrix, quae securitatem tutiores praebet.

Pessimo in casu missionis, convenire potes novum cultorem et quovis tempore locum explicas. Quamvis popularis functionis facultas erit accessurum fasciculum ad certum diem.

Hac arte uti potes cum quibusvis VDS vel Dedicatis servitoribus ac sitibus in quibusvis machinis, non 1C-Bitrix. Potest etiam esse OS alius quam CentOS, ut Ubuntu vel Debian.

Source: www.habr.com