{"id":3828,"date":"2026-06-12T08:08:32","date_gmt":"2026-06-12T08:08:32","guid":{"rendered":"https:\/\/cloudsave.app\/?p=3828"},"modified":"2026-06-12T08:29:26","modified_gmt":"2026-06-12T08:29:26","slug":"faldnar-h%c3%a6ttur-vi%c3%b0-diy-gagnagrunnsvaraafritunarskr%c3%a1r-af-hverju-s%c3%a9rsni%c3%b0in-bash-skriftur-duga-ekki-%c3%ad-framlei%c3%b0sluumhverfi","status":"publish","type":"post","link":"https:\/\/cloudsave.app\/is\/knowledge-base\/faldnar-h%c3%a6ttur-vi%c3%b0-diy-gagnagrunnsvaraafritunarskr%c3%a1r-af-hverju-s%c3%a9rsni%c3%b0in-bash-skriftur-duga-ekki-%c3%ad-framlei%c3%b0sluumhverfi\/","title":{"rendered":"Faldnar h\u00e6ttur vi\u00f0 DIY gagnagrunnsvaraafritunarskr\u00e1r: Af hverju s\u00e9rsni\u00f0in Bash skriftur duga ekki \u00ed framlei\u00f0sluumhverfi"},"content":{"rendered":"

S\u00e9rhver gagnagrunnsstj\u00f3ri (DBA) og kerfisverkfr\u00e6\u00f0ingur hefur einhvern t\u00edmann \u00e1 ferlinum skrifa\u00f0 s\u00e9rsni\u00f0i\u00f0 skeljaforskrift (shell script) til a\u00f0 taka afrit af gagnagrunni. \u00dea\u00f0 er n\u00e1nast eins og v\u00edgsla. \u00c1 fyrstu stigum verkefnis vir\u00f0ist einf\u00f6ld cron-vinnsla sem keyrir mysqldump<\/code> e\u00f0a pg_dump<\/code> og sendir \u00fattaki\u00f0 \u00ed gegnum gzip<\/code> vera gl\u00e6sileg, l\u00e9tt og hagkv\u00e6m lausn.<\/p>\n

Hins vegar, eftir \u00fev\u00ed sem innvi\u00f0ir st\u00e6kka, gagnamagn eykst og kr\u00f6fur um uppit\u00edma (SLA) ver\u00f0a strangari, breytist \u00feessi 10 l\u00edna Bash-skrift hlj\u00f3\u00f0lega \u00ed t\u00edmasprengju. Framlei\u00f0sluumhverfi krefjast mikillar frambo\u00f0s (high availability), strangra markmi\u00f0a um endurheimtarpunkt (RPO) og skj\u00f3tra markmi\u00f0a um endurheimtart\u00edma (RTO). A\u00f0 treysta \u00e1 DIY-afritunarforskriftir \u00ed \u00feessu umhverfi skapar alvarlega \u00e1h\u00e6ttu tengda samr\u00e6mi gagna, hlj\u00f3\u00f0l\u00e1tum bilunum, \u00f6ryggisveikleikum og \u00f3vi\u00f0r\u00e1\u00f0anlegum endurheimtarferlum.<\/p>\n

\u00cd \u00feessari grein munum vi\u00f0 greina arkitekt\u00farsgalla og falin h\u00e6ttumerki DIY-afritunarforskrifta, kanna t\u00e6knilegar gildrur r\u00f6klegra (logical) vs. l\u00edkamlegra (physical) afrita og r\u00e6\u00f0a hvernig h\u00e6gt er a\u00f0 skipta yfir \u00ed lausnir \u00e1 fyrirt\u00e6kjastigi eins og CloudSave til a\u00f0 vernda mikilv\u00e6gustu g\u00f6gnin \u00fe\u00edn.<\/p>\n

T\u00e1lmynd einfaldleikans: Greining \u00e1 klass\u00edsku DIY-forskriftinni<\/h2>\n

Til a\u00f0 skilja h\u00e6ttuna ver\u00f0um vi\u00f0 fyrst a\u00f0 sko\u00f0a uppbyggingu d\u00e6miger\u00f0rar DIY-afritunarforskriftar. Hef\u00f0bundin n\u00e1lgun fyrir MySQL-gagnagrunn l\u00edtur oft svona \u00fat:<\/p>\n

#!\/bin\/bash\n# Einf\u00f6ld DIY MySQL afritunarforskrift\nBACKUP_DIR=\"\/mnt\/backups\"\nDATE=$(date +%F)\nDB_USER=\"admin\"\nDB_PASS=\"SuperSecret123!\"\n\nmysqldump -u $DB_USER -p$DB_PASS my_database | gzip > $BACKUP_DIR\/mydb_$DATE.sql.gz\n\n# Ey\u00f0a afritum eldri en 30 daga\nfind $BACKUP_DIR -type f -name \"*.sql.gz\" -mtime +30 -exec rm {} ;\n<\/code><\/pre>\n
Vi\u00f0 fyrstu s\u00fdn n\u00e6r \u00feessi skrift markmi\u00f0inu: h\u00fan dregur \u00fat g\u00f6gnin, \u00fejappar \u00feeim og st\u00fdrir var\u00f0veislu. En undir yfirbor\u00f0inu er h\u00fan full af alvarlegum g\u00f6llum sem munu a\u00f0 lokum lei\u00f0a til gagnataps \u00ed framlei\u00f0sluumhverfi.<\/p>\n
H\u00e6tta 1: Hlj\u00f3\u00f0l\u00e1tar bilanir og p\u00edpu-gildran<\/h2>\n
Ein af l\u00famskustu h\u00e6ttunum vi\u00f0 DIY-forskriftir er hlj\u00f3\u00f0l\u00e1ta bilunin. \u00cd skriftinni h\u00e9r a\u00f0 ofan er mysqldump<\/code> skipuninni beint (|<\/code>) \u00ed gzip<\/code>.<\/p>\n
\u00cd Bash er \u00fatg\u00f6ngusta\u00f0a p\u00edpu (pipeline) s\u00fa sama og \u00fatg\u00f6ngusta\u00f0a s\u00ed\u00f0ustu<\/em> skipunarinnar \u00ed p\u00edpunni. Ef gagnagrunns\u00fej\u00f3nninn ver\u00f0ur minnislaus, missir tenginguna e\u00f0a lendir \u00ed l\u00e6stri t\u00f6flu mi\u00f0ja vegu \u00ed afrituninni, mun mysqldump<\/code> mistakast og kasta villu. Hins vegar mun gzip<\/code> \u00fejappa \u00fev\u00ed sem \u00fea\u00f0 f\u00e9kk og skila \u00fatg\u00f6ngust\u00f6\u00f0u 0<\/code> (\u00e1rangur).<\/p>\n
V\u00f6ktunarkerfi\u00f0 \u00feitt, sem athugar \u00fatg\u00f6nguk\u00f3\u00f0a cron-vinnslunnar, mun tilkynna um \u00e1rangursr\u00edka afritun. \u00de\u00fa munt hafa gilda .gz<\/code> skr\u00e1 \u00e1 disknum, en inni \u00ed henni ver\u00f0ur afskorin, \u00f3n\u00fdt SQL-skr\u00e1. \u00de\u00fa munt ekki uppg\u00f6tva \u00feetta fyrr en \u00fe\u00fa reynir mikilv\u00e6ga endurheimt.<\/p>\n
\u00darb\u00e6tur (og takmarkanir \u00feeirra)<\/h3>\n
Verkfr\u00e6\u00f0ingar reyna oft a\u00f0 laga \u00feetta me\u00f0 \u00fev\u00ed a\u00f0 virkja stranga villume\u00f0h\u00f6ndlun \u00ed Bash:<\/p>\n
set -e\nset -o pipefail\n<\/code><\/pre>\n
\u00de\u00f3tt set -o pipefail<\/code> tryggi a\u00f0 skriftin mistakist ef einhver<\/em> skipun \u00ed p\u00edpunni mistekst, krefst \u00fea\u00f0 samt a\u00f0 \u00fe\u00fa byggir upp \u00f6fluga vi\u00f0v\u00f6run, skr\u00e1ningu (logging) og endurkeyrslukerfi \u00ed kringum skriftina. \u00deegar t\u00edmabundin netvilla veldur bilun klukkan 2:00 a\u00f0 n\u00f3ttu, deyr DIY-skriftin einfaldlega. Fyrirt\u00e6kjalausnir me\u00f0h\u00f6ndla \u00feessar t\u00edmabundnu villur me\u00f0 snj\u00f6llum endurkeyrslum.<\/p>\n
H\u00e6tta 2: Samr\u00e6mi gagna og l\u00e6singar-martra\u00f0ir<\/h2>\n
DIY-forskriftir rei\u00f0a sig miki\u00f0 \u00e1 r\u00f6kleg afrit (mysqldump<\/code>, pg_dump<\/code>). R\u00f6kleg afrit draga \u00fat g\u00f6gn me\u00f0 \u00fev\u00ed a\u00f0 keyra SELECT<\/code> skipanir yfir allar t\u00f6flur. \u00cd mj\u00f6g virkum framlei\u00f0slugagnagrunni breytast g\u00f6gn st\u00f6\u00f0ugt. Ef skrift tekur 45 m\u00edn\u00fatur a\u00f0 afrita 100GB gagnagrunn, ver\u00f0a g\u00f6gnin \u00ed upphafi afritunarinnar 45 m\u00edn\u00fatum eldri en g\u00f6gnin \u00ed lokin, sem br\u00fdtur gegn ACID-samr\u00e6mi.<\/p>\n
MySQL vi\u00f0skiptasamr\u00e6mi<\/h3>\n
Til a\u00f0 n\u00e1 samr\u00e6mdri skyndimynd \u00ed MySQL me\u00f0 InnoDB ver\u00f0ur \u00fe\u00fa a\u00f0 nota s\u00e9rstaka f\u00e1na:<\/p>\n
mysqldump --single-transaction --quick --routines --events -u user -p db > dump.sql\n<\/code><\/pre>\n
--single-transaction<\/code> f\u00e1ninn setur einangrunarstigi\u00f0 \u00e1 REPEATABLE READ<\/code> og byrjar f\u00e6rslu (transaction) \u00e1\u00f0ur en afritun hefst. Hins vegar, ef gagnagrunnurinn inniheldur enn eldri MyISAM-t\u00f6flur, mun \u00feessi f\u00e1ni ekki koma \u00ed veg fyrir a\u00f0 \u00fe\u00e6r l\u00e6sist, sem g\u00e6ti st\u00f6\u00f0va\u00f0 framlei\u00f0sluumfer\u00f0 \u00e1 me\u00f0an afritunin keyrir. Ennfremur munu allar ALTER TABLE<\/code>, DROP TABLE<\/code> e\u00f0a RENAME TABLE<\/code> skipanir sem forritarar keyra \u00e1 me\u00f0an afritunin stendur yfir rj\u00fafa REPEATABLE READ<\/code> skyndimyndina og valda \u00fev\u00ed a\u00f0 afritunin mistekst.<\/p>\n
PostgreSQL og WAL-skjalavistun<\/h3>\n
Fyrir PostgreSQL veitir pg_dump<\/code> samr\u00e6md r\u00f6kleg afrit, en r\u00f6kleg afrit ein og s\u00e9r geta ekki veitt endurheimt \u00e1 \u00e1kve\u00f0num t\u00edmapunkti (Point-in-Time Recovery – PITR). Ef gagnagrunnurinn hrynur klukkan 16:00 og s\u00ed\u00f0asta cron-skriftin \u00fe\u00edn keyr\u00f0i \u00e1 mi\u00f0n\u00e6tti, tapar\u00f0u 16 klukkustundum af g\u00f6gnum.<\/p>\n
Til a\u00f0 n\u00e1 PITR \u00fearf samfellda skjalavistun \u00e1 Write-Ahead Logs (WAL). \u00dea\u00f0 er mj\u00f6g erfitt a\u00f0 skrifa DIY-skrift til a\u00f0 me\u00f0h\u00f6ndla archive_command<\/code> \u00e1 \u00f6ruggan h\u00e1tt.<\/p>\n
# postgresql.conf\nwal_level = replica\narchive_mode = on\narchive_command = 'test ! -f \/mnt\/wal_archive\/%f && cp %p \/mnt\/wal_archive\/%f'\n<\/code><\/pre>\n
Ef geymslupl\u00e1ssi\u00f0 (\/mnt\/wal_archive\/<\/code>) fyllist e\u00f0a ver\u00f0ur \u00f3a\u00f0gengilegt, mun archive_command<\/code> mistakast. PostgreSQL mun \u00fe\u00e1 safna WAL-skr\u00e1m sta\u00f0bundi\u00f0 \u00fear til a\u00f0aldiskurinn fyllist, sem veldur algj\u00f6ru hruni gagnagrunnsins. DIY-skriftir hafa sjaldan \u00fe\u00e1 fjarm\u00e6lingu sem \u00fearf til a\u00f0 fylgjast me\u00f0 WAL-s\u00f6fnun og vara stj\u00f3rnendur vi\u00f0 \u00e1\u00f0ur en hrun ver\u00f0ur.<\/p>\n
H\u00e6tta 3: Var\u00f0veislu-r\u00falettan<\/h2>\n
L\u00edttu aftur \u00e1 var\u00f0veislu-skipunina \u00ed upphaflegu skriftinni okkar:<\/p>\n
find $BACKUP_DIR -type f -name \"*.sql.gz\" -mtime +30 -exec rm {} ;\n<\/code><\/pre>\n
\u00deetta er h\u00f6rmulegt gagnatap sem b\u00ed\u00f0ur \u00feess a\u00f0 gerast. \u00cdmynda\u00f0u \u00fe\u00e9r a\u00f0 breyting \u00e1 stillingum ey\u00f0ileggi au\u00f0kenningu mysqldump<\/code>. Skriftin mistekst vi\u00f0 a\u00f0 b\u00faa til n\u00fd afrit, en find<\/code> skipunin heldur \u00e1fram a\u00f0 keyra \u00e1 hverju kv\u00f6ldi og ey\u00f0ir dyggilega skr\u00e1m sem eru eldri en 30 daga.<\/p>\n
Eftir 30 daga af hlj\u00f3\u00f0l\u00e1tum afritunarbilunum mun find<\/code> skipunin ey\u00f0a s\u00ed\u00f0asta g\u00f3\u00f0a afritinu \u00fe\u00ednu. \u00de\u00fa stendur n\u00fa uppi me\u00f0 n\u00fall afrit.<\/p>\n
Fyrirt\u00e6kja-afritunarhugb\u00fana\u00f0ur eins og CloudSave notar r\u00edkisbundnar (stateful) var\u00f0veislustefnur. Hann skilur muninn \u00e1 \u201eey\u00f0a afritum eldri en 30 daga\u201c og \u201etryggja a\u00f0 a\u00f0 minnsta kosti 30 \u00e1rangursr\u00edkir endurheimtarpunktar s\u00e9u til sta\u00f0ar \u00e1\u00f0ur en g\u00f6mlum g\u00f6gnum er eytt.\u201c<\/p>\n
H\u00e6tta 4: \u00d6ryggi, dulk\u00f3\u00f0un og blindir blettir \u00ed samr\u00e6mi<\/h2>\n
\u00c1 t\u00edmum lausnarhugb\u00fana\u00f0ar (ransomware) og strangra samr\u00e6misramma (GDPR, HIPAA, SOC 2) eru afrit a\u00f0almarkmi\u00f0. DIY-skriftir brj\u00f3ta oft gegn bestu starfsvenjum \u00ed \u00f6ryggism\u00e1lum:<\/p>\n
    \n
  1. Har\u00f0k\u00f3\u00f0a\u00f0ir a\u00f0gangsk\u00f3\u00f0ar:<\/strong> A\u00f0 geyma lykilor\u00f0 gagnagrunna \u00ed skriftum e\u00f0a cron-skilgreiningum er gr\u00ed\u00f0arleg \u00f6ryggis\u00e1h\u00e6tta. \u00de\u00f3tt verkf\u00e6ri eins og mysql_config_editor<\/code> \u00ed MySQL e\u00f0a .pgpass<\/code> skr\u00e1in \u00ed PostgreSQL dragi \u00far \u00feessu, krefjast \u00feau samt stj\u00f3rnunar \u00e1 sta\u00f0bundnum lyklaskr\u00e1m \u00e1 \u00fej\u00f3ninum.<\/li>\n
  2. Skortur \u00e1 dulk\u00f3\u00f0un \u00ed hv\u00edld:<\/strong> A\u00f0 d\u00e6la hr\u00e1um SQL-g\u00f6gnum \u00e1 disk skilur vi\u00f0kv\u00e6mar pers\u00f3nuuppl\u00fdsingar eftir \u00f3var\u00f0ar.<\/li>\n
  3. Fl\u00f3knar dulk\u00f3\u00f0unarp\u00edpur:<\/strong> Tilraunir til a\u00f0 dulk\u00f3\u00f0a afrit \u00e1 flugi me\u00f0 GPG valda miklu \u00e1lagi \u00e1 \u00f6rgj\u00f6rva og fl\u00e6kja stj\u00f3rnun lykla.<\/li>\n<\/ol>\n
    # DIY dulk\u00f3\u00f0u\u00f0 afritunarp\u00edpa\npg_dump mydb | gzip | gpg --symmetric --cipher-algo AES256 --passphrase-file \/etc\/keys\/backup.key > backup.sql.gz.gpg\n<\/code><\/pre>\n
    Ef \u00fej\u00f3nninn er kominn \u00ed hendur \u00f3vi\u00f0komandi hefur \u00e1r\u00e1sarma\u00f0urinn a\u00f0gang a\u00f0 b\u00e6\u00f0i dulk\u00f3\u00f0u\u00f0u afrituninni og \/etc\/keys\/backup.key<\/code> skr\u00e1nni, sem gerir dulk\u00f3\u00f0unina gagnslausa. Ennfremur, ef DBA-inn sem bj\u00f3 til GPG-lykilinn h\u00e6ttir hj\u00e1 fyrirt\u00e6kinu og lykillinn t\u00fdnist, eru afritin \u00f3endurheimtanleg.<\/p>\n
    H\u00e6tta 5: RTO-raunveruleikinn (Endurheimt er erfi\u00f0ari en afritun)<\/h2>\n
    Fullkomi\u00f0 pr\u00f3f \u00e1 afriti er endurheimtin. R\u00f6kleg afrit sem DIY-skriftir b\u00faa til eru \u00feekkt fyrir a\u00f0 vera h\u00e6g \u00ed endurheimt. 500GB SQL-afrit g\u00e6ti teki\u00f0 15 m\u00edn\u00fatur a\u00f0 b\u00faa til, en endurheimt \u00feess krefst \u00feess a\u00f0 gagnagrunnsv\u00e9lin lesi SQL-k\u00f3\u00f0ann, endurbyggi v\u00edsanir (indexes) og endurreikni skor\u00f0ur (constraints). \u00deetta getur teki\u00f0 klukkustundir e\u00f0a jafnvel daga, sem ey\u00f0ileggur RTO-markmi\u00f0in \u00fe\u00edn.<\/p>\n
    Fyrir st\u00f3ra framlei\u00f0slugagnagrunna eru l\u00edkamleg afrit (afritun \u00e1 raunverulegum gagnaskr\u00e1m) nau\u00f0synleg. \u00de\u00f3tt verkf\u00e6ri eins og Percona XtraBackup e\u00f0a pg_basebackup<\/code> s\u00e9u til, er mj\u00f6g fl\u00f3ki\u00f0 a\u00f0 pakka \u00feeim inn \u00ed DIY Bash-skriftir. \u00de\u00fa ver\u00f0ur a\u00f0 stj\u00f3rna LVM-skyndimyndum, me\u00f0h\u00f6ndla st\u00f6\u00f0vun skr\u00e1arkerfa og tryggja a\u00f0 afritunin s\u00e9 flutt \u00fat af sta\u00f0num \u00e1n \u00feess a\u00f0 metta neti\u00f0.<\/p>\n
    LVM-skyndimyndagildran<\/h3>\n
    Margir verkfr\u00e6\u00f0ingar reyna \u201ezero downtime\u201c l\u00edkamlegar afritanir me\u00f0 LVM-skyndimyndum:<\/p>\n
    # B\u00faa til skyndimynd\nlvcreate --size 20G --snapshot --name db_snap \/dev\/vg0\/db_vol\n\n# Mounta og afrita\nmount \/dev\/vg0\/db_snap \/mnt\/snap\ntar -czf \/backups\/db_physical.tar.gz \/mnt\/snap\/mysql\n<\/code><\/pre>\n
    Ef gagnagrunnurinn upplifir skyndilega aukningu \u00ed skrif-I\/O, getur 20GB LVM-skyndimyndin fyllst samstundis. \u00deegar LVM-skyndimynd fyllist ver\u00f0ur h\u00fan \u00f3gild og afritunin mistekst. Verra er a\u00f0 miki\u00f0 nota\u00f0ar LVM-skyndimyndir geta dregi\u00f0 verulega \u00far I\/O-afk\u00f6stum a\u00f0algagnagrunnsins, sem veldur t\u00f6fum \u00ed forritum.<\/p>\n
    Skipt yfir \u00ed vernd \u00e1 fyrirt\u00e6kjastigi<\/h2>\n
    Skiptingin fr\u00e1 DIY-skriftum yfir \u00ed fyrirt\u00e6kjalausn er mikilv\u00e6gur \u00e1fangi \u00ed \u00feroska hvers innvi\u00f0ateymis. Markmi\u00f0i\u00f0 er a\u00f0 fara fr\u00e1 \u00fev\u00ed a\u00f0 \u201evona a\u00f0 skriftin hafi keyrt\u201c yfir \u00ed a\u00f0 hafa dulritunarlega s\u00f6nnun fyrir endurheimtanleika.<\/p>\n
    Vettvangar eins og CloudSave eru hanna\u00f0ir s\u00e9rstaklega til a\u00f0 \u00fatr\u00fdma blindum blettum DIY-skriftager\u00f0ar. Me\u00f0 \u00fev\u00ed a\u00f0 nota forritavitundar-umbo\u00f0smenn (agents), hefur CloudSave bein samskipti vi\u00f0 API-vi\u00f0m\u00f3t gagnagrunna (MySQL, PostgreSQL, MS SQL, Oracle) til a\u00f0 st\u00fdra samr\u00e6mdum l\u00edkamlegum og r\u00f6klegum afritum \u00e1n \u00feess a\u00f0 l\u00e6sa t\u00f6flum e\u00f0a draga \u00far afk\u00f6stum.<\/p>\n
    Helstu kostir \u00feess a\u00f0 h\u00e6tta me\u00f0 skriftir:<\/h3>\n
      \n
    1. Sj\u00e1lfvirk sta\u00f0festing:<\/strong> N\u00fat\u00edmalegir vettvangar taka ekki bara afrit; \u00feeir pr\u00f3fa \u00feau. CloudSave getur sj\u00e1lfkrafa r\u00e6st t\u00edmabundi\u00f0 gagnagrunnstilvik, endurheimt afriti\u00f0, keyrt samr\u00e6mispr\u00f3f (t.d. DBCC CHECKDB<\/code>) og eytt \u00fev\u00ed aftur, sem veitir sta\u00f0festa sk\u00fdrslu um a\u00f0 afriti\u00f0 s\u00e9 \u00ed raun noth\u00e6ft.<\/li>\n
    2. \u00d3breytanleg geymsla (Immutable Storage):<\/strong> Til a\u00f0 berjast gegn lausnarhugb\u00fana\u00f0i ver\u00f0a afrit a\u00f0 vera \u00f3breytanleg. DIY-skriftir geta ekki au\u00f0veldlega skrifa\u00f0 \u00ed WORM-geymslu (Write Once, Read Many). Fyrirt\u00e6kjalausnir sam\u00fe\u00e6ttast innbyggt vi\u00f0 S3 Object Lock og \u00f3breytanlega sk\u00fdjageymslu, sem tryggir a\u00f0 jafnvel \u00fe\u00f3tt \u00fej\u00f3nn s\u00e9 algj\u00f6rlega kominn \u00ed hendur \u00f3vi\u00f0komandi, geti \u00e1r\u00e1sarma\u00f0urinn ekki eytt e\u00f0a dulk\u00f3\u00f0a\u00f0 afritin.<\/li>\n
    3. Einfalda\u00f0 PITR:<\/strong> \u00cd sta\u00f0 \u00feess a\u00f0 sauma handvirkt saman grunn-afrit og hundru\u00f0 WAL-skr\u00e1a me\u00f0 fl\u00f3knum recovery.conf<\/code> e\u00f0a postgresql.auto.conf<\/code> breytum, bj\u00f3\u00f0a vettvangar upp \u00e1 sj\u00f3nr\u00e6nan t\u00edmal\u00edna. \u00de\u00fa velur einfaldlega n\u00e1kv\u00e6mlega \u00fe\u00e1 m\u00edn\u00fatu sem \u00fe\u00fa vilt endurheimta til, og hugb\u00fana\u00f0urinn s\u00e9r um endurspilun log-skr\u00e1a sj\u00e1lfkrafa.<\/li>\n
    4. Affj\u00f6lgun (Deduplication) og \u00fej\u00f6ppun:<\/strong> DIY-skriftir rei\u00f0a sig \u00e1 gzip<\/code>, sem \u00fejappar hverri skr\u00e1 fyrir sig. Fyrirt\u00e6kja-afritunarhugb\u00fana\u00f0ur notar al\u00fej\u00f3\u00f0lega affj\u00f6lgun \u00e1 blokkarstigi, sem dregur verulega \u00far geymslukostna\u00f0i og netbandbreidd \u00feegar afrit eru flutt \u00fat af sta\u00f0num.<\/li>\n<\/ol>\n
      Ni\u00f0ursta\u00f0a<\/h2>\n
      \u00dea\u00f0 er au\u00f0velt a\u00f0 skrifa s\u00e9rsni\u00f0na Bash-skrift til a\u00f0 taka afrit af gagnagrunni. A\u00f0 skrifa skrift sem me\u00f0h\u00f6ndlar hlj\u00f3\u00f0l\u00e1tar p\u00edpubilanir, tryggir ACID-samr\u00e6mi, st\u00fdrir dulritunarlyklum \u00e1 \u00f6ruggan h\u00e1tt, kemur \u00ed veg fyrir gagnatap vegna var\u00f0veislu og tryggir str\u00f6ng RTO\/RPO-markmi\u00f0 er n\u00e1nast \u00f3m\u00f6gulegt.<\/p>\n
      \u00cd framlei\u00f0sluumhverfi er gagnagrunnurinn mikilv\u00e6gasta eign fyrirt\u00e6kisins. A\u00f0 me\u00f0h\u00f6ndla vernd hans sem hli\u00f0arverkefni sem vi\u00f0haldi\u00f0 er af nokkur hundru\u00f0 l\u00ednum af skeljaforskrift er \u00e1h\u00e6tta sem ekkert fyrirt\u00e6ki hefur efni \u00e1. Me\u00f0 \u00fev\u00ed a\u00f0 endursko\u00f0a n\u00faverandi afritunarstefnur, skilja takmarkanir r\u00f6klegra afrita og flytja yfir \u00ed \u00f6fluga, sj\u00e1lfvirka vettvanga eins og CloudSave, geta DevOps- og DBA-teymi \u00fatr\u00fdmt \u201er\u00fatu-\u00fe\u00e6ttinum\u201c (bus factor) s\u00e9rsni\u00f0inna skrifta og tryggt a\u00f0 g\u00f6gn \u00feeirra s\u00e9u sannarlega \u00f6rugg.<\/p>\n","protected":false},"excerpt":{"rendered":"
      ** Discover the hidden dangers of DIY database backup scripts. Learn why custom Bash scripts fail in production, the risks of logical dumps, and how to secure your data with enterprise solutions.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_title":"Why DIY Database Backup Scripts Fail in Production","rank_math_description":"** Discover the hidden dangers of DIY database backup scripts. Learn why custom Bash scripts fail in production, the risks of logical dumps, and how to secure your data with enterprise solutions.","rank_math_focus_keyword":"DIY database backup scripts","footnotes":""},"categories":[479],"tags":[2615,976,2616,2617,2618,2619,980],"class_list":["post-3828","post","type-post","status-publish","format-standard","hentry","category-database-backup","tag-bash-scripts","tag-database-administration","tag-diy-backups","tag-mysqldump","tag-pg_dump","tag-production-backups","tag-rpo-and-rto"],"yoast_head":"\nWhy DIY Database Backup Scripts Fail in Production<\/title>\n<meta name=\"description\" content=\"** Discover the hidden dangers of DIY database backup scripts. Learn why custom Bash scripts fail in production, the risks of logical dumps, and how to secure your data with enterprise solutions.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cloudsave.app\/is\/knowledge-base\/faldnar-h%c3%a6ttur-vi%c3%b0-diy-gagnagrunnsvaraafritunarskr%c3%a1r-af-hverju-s%c3%a9rsni%c3%b0in-bash-skriftur-duga-ekki-%c3%ad-framlei%c3%b0sluumhverfi\/\" \/>\n<meta property=\"og:locale\" content=\"is_IS\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Faldnar h\u00e6ttur vi\u00f0 DIY gagnagrunnsvaraafritunarskr\u00e1r: Af hverju s\u00e9rsni\u00f0in Bash skriftur duga ekki \u00ed framlei\u00f0sluumhverfi\" \/>\n<meta property=\"og:description\" content=\"** Discover the hidden dangers of DIY database backup scripts. Learn why custom Bash scripts fail in production, the risks of logical dumps, and how to secure your data with enterprise solutions.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cloudsave.app\/is\/knowledge-base\/faldnar-h%c3%a6ttur-vi%c3%b0-diy-gagnagrunnsvaraafritunarskr%c3%a1r-af-hverju-s%c3%a9rsni%c3%b0in-bash-skriftur-duga-ekki-%c3%ad-framlei%c3%b0sluumhverfi\/\" \/>\n<meta property=\"og:site_name\" content=\"CloudSave\" \/>\n<meta property=\"article:published_time\" content=\"2026-06-12T08:08:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-06-12T08:29:26+00:00\" \/>\n<meta name=\"author\" content=\"shervinrv\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"shervinrv\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/knowledge-base\\\/faldnar-h%c3%a6ttur-vi%c3%b0-diy-gagnagrunnsvaraafritunarskr%c3%a1r-af-hverju-s%c3%a9rsni%c3%b0in-bash-skriftur-duga-ekki-%c3%ad-framlei%c3%b0sluumhverfi\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/knowledge-base\\\/faldnar-h%c3%a6ttur-vi%c3%b0-diy-gagnagrunnsvaraafritunarskr%c3%a1r-af-hverju-s%c3%a9rsni%c3%b0in-bash-skriftur-duga-ekki-%c3%ad-framlei%c3%b0sluumhverfi\\\/\"},\"author\":{\"name\":\"shervinrv\",\"@id\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/#\\\/schema\\\/person\\\/286beefe68281d868e87f46603a7ae4d\"},\"headline\":\"Faldnar h\u00e6ttur vi\u00f0 DIY gagnagrunnsvaraafritunarskr\u00e1r: Af hverju s\u00e9rsni\u00f0in Bash skriftur duga ekki \u00ed framlei\u00f0sluumhverfi\",\"datePublished\":\"2026-06-12T08:08:32+00:00\",\"dateModified\":\"2026-06-12T08:29:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/knowledge-base\\\/faldnar-h%c3%a6ttur-vi%c3%b0-diy-gagnagrunnsvaraafritunarskr%c3%a1r-af-hverju-s%c3%a9rsni%c3%b0in-bash-skriftur-duga-ekki-%c3%ad-framlei%c3%b0sluumhverfi\\\/\"},\"wordCount\":1752,\"publisher\":{\"@id\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/#\\\/schema\\\/person\\\/286beefe68281d868e87f46603a7ae4d\"},\"keywords\":[\"bash scripts\",\"Database Administration\",\"DIY backups\",\"mysqldump\",\"pg_dump\",\"production backups\",\"RPO and RTO\"],\"articleSection\":[\"Database Backup\"],\"inLanguage\":\"is\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/knowledge-base\\\/faldnar-h%c3%a6ttur-vi%c3%b0-diy-gagnagrunnsvaraafritunarskr%c3%a1r-af-hverju-s%c3%a9rsni%c3%b0in-bash-skriftur-duga-ekki-%c3%ad-framlei%c3%b0sluumhverfi\\\/\",\"url\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/knowledge-base\\\/faldnar-h%c3%a6ttur-vi%c3%b0-diy-gagnagrunnsvaraafritunarskr%c3%a1r-af-hverju-s%c3%a9rsni%c3%b0in-bash-skriftur-duga-ekki-%c3%ad-framlei%c3%b0sluumhverfi\\\/\",\"name\":\"Why DIY Database Backup Scripts Fail in Production\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/#website\"},\"datePublished\":\"2026-06-12T08:08:32+00:00\",\"dateModified\":\"2026-06-12T08:29:26+00:00\",\"description\":\"** Discover the hidden dangers of DIY database backup scripts. Learn why custom Bash scripts fail in production, the risks of logical dumps, and how to secure your data with enterprise solutions.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/knowledge-base\\\/faldnar-h%c3%a6ttur-vi%c3%b0-diy-gagnagrunnsvaraafritunarskr%c3%a1r-af-hverju-s%c3%a9rsni%c3%b0in-bash-skriftur-duga-ekki-%c3%ad-framlei%c3%b0sluumhverfi\\\/#breadcrumb\"},\"inLanguage\":\"is\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/cloudsave.app\\\/is\\\/knowledge-base\\\/faldnar-h%c3%a6ttur-vi%c3%b0-diy-gagnagrunnsvaraafritunarskr%c3%a1r-af-hverju-s%c3%a9rsni%c3%b0in-bash-skriftur-duga-ekki-%c3%ad-framlei%c3%b0sluumhverfi\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/knowledge-base\\\/faldnar-h%c3%a6ttur-vi%c3%b0-diy-gagnagrunnsvaraafritunarskr%c3%a1r-af-hverju-s%c3%a9rsni%c3%b0in-bash-skriftur-duga-ekki-%c3%ad-framlei%c3%b0sluumhverfi\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Faldnar h\u00e6ttur vi\u00f0 DIY gagnagrunnsvaraafritunarskr\u00e1r: Af hverju s\u00e9rsni\u00f0in Bash skriftur duga ekki \u00ed framlei\u00f0sluumhverfi\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/#website\",\"url\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/\",\"name\":\"CloudSave\",\"description\":\"CloudSave\",\"publisher\":{\"@id\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/#\\\/schema\\\/person\\\/286beefe68281d868e87f46603a7ae4d\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"is\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/#\\\/schema\\\/person\\\/286beefe68281d868e87f46603a7ae4d\",\"name\":\"shervinrv\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"is\",\"@id\":\"https:\\\/\\\/cloudsave.app\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/Logo_Name-2.png\",\"url\":\"https:\\\/\\\/cloudsave.app\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/Logo_Name-2.png\",\"contentUrl\":\"https:\\\/\\\/cloudsave.app\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/Logo_Name-2.png\",\"width\":859,\"height\":150,\"caption\":\"shervinrv\"},\"logo\":{\"@id\":\"https:\\\/\\\/cloudsave.app\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/Logo_Name-2.png\"},\"sameAs\":[\"http:\\\/\\\/cloudsave.app\"],\"url\":\"https:\\\/\\\/cloudsave.app\\\/is\\\/knowledge-base\\\/author\\\/shervinrv\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Why DIY Database Backup Scripts Fail in Production","description":"** Discover the hidden dangers of DIY database backup scripts. Learn why custom Bash scripts fail in production, the risks of logical dumps, and how to secure your data with enterprise solutions.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cloudsave.app\/is\/knowledge-base\/faldnar-h%c3%a6ttur-vi%c3%b0-diy-gagnagrunnsvaraafritunarskr%c3%a1r-af-hverju-s%c3%a9rsni%c3%b0in-bash-skriftur-duga-ekki-%c3%ad-framlei%c3%b0sluumhverfi\/","og_locale":"is_IS","og_type":"article","og_title":"Faldnar h\u00e6ttur vi\u00f0 DIY gagnagrunnsvaraafritunarskr\u00e1r: Af hverju s\u00e9rsni\u00f0in Bash skriftur duga ekki \u00ed framlei\u00f0sluumhverfi","og_description":"** Discover the hidden dangers of DIY database backup scripts. Learn why custom Bash scripts fail in production, the risks of logical dumps, and how to secure your data with enterprise solutions.","og_url":"https:\/\/cloudsave.app\/is\/knowledge-base\/faldnar-h%c3%a6ttur-vi%c3%b0-diy-gagnagrunnsvaraafritunarskr%c3%a1r-af-hverju-s%c3%a9rsni%c3%b0in-bash-skriftur-duga-ekki-%c3%ad-framlei%c3%b0sluumhverfi\/","og_site_name":"CloudSave","article_published_time":"2026-06-12T08:08:32+00:00","article_modified_time":"2026-06-12T08:29:26+00:00","author":"shervinrv","twitter_card":"summary_large_image","twitter_misc":{"Written by":"shervinrv","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cloudsave.app\/is\/knowledge-base\/faldnar-h%c3%a6ttur-vi%c3%b0-diy-gagnagrunnsvaraafritunarskr%c3%a1r-af-hverju-s%c3%a9rsni%c3%b0in-bash-skriftur-duga-ekki-%c3%ad-framlei%c3%b0sluumhverfi\/#article","isPartOf":{"@id":"https:\/\/cloudsave.app\/is\/knowledge-base\/faldnar-h%c3%a6ttur-vi%c3%b0-diy-gagnagrunnsvaraafritunarskr%c3%a1r-af-hverju-s%c3%a9rsni%c3%b0in-bash-skriftur-duga-ekki-%c3%ad-framlei%c3%b0sluumhverfi\/"},"author":{"name":"shervinrv","@id":"https:\/\/cloudsave.app\/is\/#\/schema\/person\/286beefe68281d868e87f46603a7ae4d"},"headline":"Faldnar h\u00e6ttur vi\u00f0 DIY gagnagrunnsvaraafritunarskr\u00e1r: Af hverju s\u00e9rsni\u00f0in Bash skriftur duga ekki \u00ed framlei\u00f0sluumhverfi","datePublished":"2026-06-12T08:08:32+00:00","dateModified":"2026-06-12T08:29:26+00:00","mainEntityOfPage":{"@id":"https:\/\/cloudsave.app\/is\/knowledge-base\/faldnar-h%c3%a6ttur-vi%c3%b0-diy-gagnagrunnsvaraafritunarskr%c3%a1r-af-hverju-s%c3%a9rsni%c3%b0in-bash-skriftur-duga-ekki-%c3%ad-framlei%c3%b0sluumhverfi\/"},"wordCount":1752,"publisher":{"@id":"https:\/\/cloudsave.app\/is\/#\/schema\/person\/286beefe68281d868e87f46603a7ae4d"},"keywords":["bash scripts","Database Administration","DIY backups","mysqldump","pg_dump","production backups","RPO and RTO"],"articleSection":["Database Backup"],"inLanguage":"is"},{"@type":"WebPage","@id":"https:\/\/cloudsave.app\/is\/knowledge-base\/faldnar-h%c3%a6ttur-vi%c3%b0-diy-gagnagrunnsvaraafritunarskr%c3%a1r-af-hverju-s%c3%a9rsni%c3%b0in-bash-skriftur-duga-ekki-%c3%ad-framlei%c3%b0sluumhverfi\/","url":"https:\/\/cloudsave.app\/is\/knowledge-base\/faldnar-h%c3%a6ttur-vi%c3%b0-diy-gagnagrunnsvaraafritunarskr%c3%a1r-af-hverju-s%c3%a9rsni%c3%b0in-bash-skriftur-duga-ekki-%c3%ad-framlei%c3%b0sluumhverfi\/","name":"Why DIY Database Backup Scripts Fail in Production","isPartOf":{"@id":"https:\/\/cloudsave.app\/is\/#website"},"datePublished":"2026-06-12T08:08:32+00:00","dateModified":"2026-06-12T08:29:26+00:00","description":"** Discover the hidden dangers of DIY database backup scripts. Learn why custom Bash scripts fail in production, the risks of logical dumps, and how to secure your data with enterprise solutions.","breadcrumb":{"@id":"https:\/\/cloudsave.app\/is\/knowledge-base\/faldnar-h%c3%a6ttur-vi%c3%b0-diy-gagnagrunnsvaraafritunarskr%c3%a1r-af-hverju-s%c3%a9rsni%c3%b0in-bash-skriftur-duga-ekki-%c3%ad-framlei%c3%b0sluumhverfi\/#breadcrumb"},"inLanguage":"is","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cloudsave.app\/is\/knowledge-base\/faldnar-h%c3%a6ttur-vi%c3%b0-diy-gagnagrunnsvaraafritunarskr%c3%a1r-af-hverju-s%c3%a9rsni%c3%b0in-bash-skriftur-duga-ekki-%c3%ad-framlei%c3%b0sluumhverfi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/cloudsave.app\/is\/knowledge-base\/faldnar-h%c3%a6ttur-vi%c3%b0-diy-gagnagrunnsvaraafritunarskr%c3%a1r-af-hverju-s%c3%a9rsni%c3%b0in-bash-skriftur-duga-ekki-%c3%ad-framlei%c3%b0sluumhverfi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cloudsave.app\/is\/"},{"@type":"ListItem","position":2,"name":"Faldnar h\u00e6ttur vi\u00f0 DIY gagnagrunnsvaraafritunarskr\u00e1r: Af hverju s\u00e9rsni\u00f0in Bash skriftur duga ekki \u00ed framlei\u00f0sluumhverfi"}]},{"@type":"WebSite","@id":"https:\/\/cloudsave.app\/is\/#website","url":"https:\/\/cloudsave.app\/is\/","name":"CloudSave","description":"CloudSave","publisher":{"@id":"https:\/\/cloudsave.app\/is\/#\/schema\/person\/286beefe68281d868e87f46603a7ae4d"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cloudsave.app\/is\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"is"},{"@type":["Person","Organization"],"@id":"https:\/\/cloudsave.app\/is\/#\/schema\/person\/286beefe68281d868e87f46603a7ae4d","name":"shervinrv","image":{"@type":"ImageObject","inLanguage":"is","@id":"https:\/\/cloudsave.app\/wp-content\/uploads\/2026\/02\/Logo_Name-2.png","url":"https:\/\/cloudsave.app\/wp-content\/uploads\/2026\/02\/Logo_Name-2.png","contentUrl":"https:\/\/cloudsave.app\/wp-content\/uploads\/2026\/02\/Logo_Name-2.png","width":859,"height":150,"caption":"shervinrv"},"logo":{"@id":"https:\/\/cloudsave.app\/wp-content\/uploads\/2026\/02\/Logo_Name-2.png"},"sameAs":["http:\/\/cloudsave.app"],"url":"https:\/\/cloudsave.app\/is\/knowledge-base\/author\/shervinrv\/"}]}},"_links":{"self":[{"href":"https:\/\/cloudsave.app\/is\/wp-json\/wp\/v2\/posts\/3828","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cloudsave.app\/is\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cloudsave.app\/is\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cloudsave.app\/is\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cloudsave.app\/is\/wp-json\/wp\/v2\/comments?post=3828"}],"version-history":[{"count":3,"href":"https:\/\/cloudsave.app\/is\/wp-json\/wp\/v2\/posts\/3828\/revisions"}],"predecessor-version":[{"id":4023,"href":"https:\/\/cloudsave.app\/is\/wp-json\/wp\/v2\/posts\/3828\/revisions\/4023"}],"wp:attachment":[{"href":"https:\/\/cloudsave.app\/is\/wp-json\/wp\/v2\/media?parent=3828"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cloudsave.app\/is\/wp-json\/wp\/v2\/categories?post=3828"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cloudsave.app\/is\/wp-json\/wp\/v2\/tags?post=3828"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}