{"id":30280,"date":"2019-10-31T21:34:38","date_gmt":"2019-10-31T18:34:38","guid":{"rendered":"https:\/\/prohoster.info\/blog\/potochnaya-konvertatsiya-baz-firebird-2-5-v-format-ods12-firebird-3-0\/"},"modified":"2019-10-31T21:34:38","modified_gmt":"2019-10-31T18:34:38","slug":"potochnaya-konvertatsiya-baz-firebird-2-5-v-format-ods12-firebird-3-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/potochnaya-konvertatsiya-baz-firebird-2-5-v-format-ods12-firebird-3-0","title":{"rendered":"Konvertimi n\u00eb rrjedh\u00eb i bazave Firebird 2.5 n\u00eb formatin ODS12 (Firebird 3.0)","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

\u00c7do version i Firebird ka versionin e tij t\u00eb formatit t\u00eb strukturave t\u00eb diskut t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave \u2013 O(n)D(isk)S(tructure). Deri n\u00eb versionin 2.5 p\u00ebrfshir\u00eb, motorri Firebird mund t\u00eb punonte me ODS t\u00eb versioneve t\u00eb m\u00ebparshme, dometh\u00ebn\u00eb, bazat nga versionet e vjetra hapeshin nga versioni i ri dhe punonin n\u00eb modin e kompatibilitetit, por motorri Firebird 3.0 punon vet\u00ebm me DB n\u00eb versionin e tij ODS 12.0.<\/p>\n

P\u00ebr t\u00eb kaluar n\u00eb 3.0, baza e t\u00eb dh\u00ebnave nga 2.5 duhet t\u00eb konvertohet n\u00eb formatin e ri p\u00ebrmes backup\/restore. Sigurisht, ne supozojm\u00eb se DB \u00ebsht\u00eb p\u00ebrgatitur paraprakisht p\u00ebr konvertimin - dmth. metadatet dhe pyetjet jan\u00eb kontrolluar p\u00ebr kompatibilitet me Firebird 3.0.<\/p>\n

N\u00ebse ndjekim qasjen standarde, kjo do t\u00eb thot\u00eb se duhet t\u00eb b\u00ebhet nj\u00eb backup n\u00eb versionin 2.5, pastaj t\u00eb instalojm\u00eb 3.0 dhe t\u00eb kryejm\u00eb nj\u00eb restaurim. Kjo procedur\u00eb \u00ebsht\u00eb e pranueshme n\u00ebse ka mjaft koh\u00eb, por gjat\u00eb migrimit t\u00eb bazave t\u00eb m\u00ebdha t\u00eb t\u00eb dh\u00ebnave, ose gjat\u00eb migrimit t\u00eb disa dhjet\u00ebra DB-ve nj\u00ebkoh\u00ebsisht, kur koha \u00ebsht\u00eb e kufizuar, mund t\u00eb p\u00ebrdoret konvertimi n\u00eb rrjedh\u00eb, i cili \u00ebsht\u00eb 30-40% m\u00eb i shpejt\u00eb. Si t\u00eb b\u00ebhet kjo (n\u00eb Windows dhe Linux), lexoni m\u00eb posht\u00eb.
\n<\/a><\/noindex>
\nIdeja e p\u00ebrgjithshme \u00ebsht\u00eb se p\u00ebr t\u00eb acceleruar, ne do t\u00eb p\u00ebrdorim nj\u00eb pipeline:<\/p>\n

gbak -b \u2026 baza25 stdout | gbak -c \u2026 stdin baza30<\/code><\/pre>\n
\nGbak nga 2.5 gjeneron nj\u00eb backup n\u00eb formatin linear dhe e d\u00ebrgon at\u00eb n\u00eb stdout, i cili dhembje nga stdin merr direkt gbak nga 3.0 dhe krijon nj\u00eb DB t\u00eb re.<\/p>\n
Organizimi i k\u00ebtij pipeline duhet t\u00eb b\u00ebhet detyrimisht me metod\u00ebn lokale (file access), sepse qasja n\u00eb rrjet (edhe p\u00ebrmes localhost) do ta ngadal\u00ebsoj\u00eb duksh\u00ebm procesin.<\/p>\n
M\u00eb posht\u00eb shqyrtojm\u00eb detajet p\u00ebr Windows dhe Linux.<\/p>\n
Windows<\/b><\/p>\n
N\u00eb rastin e Windows, m\u00eb e thjesht\u00eb \u00ebsht\u00eb t\u00eb b\u00ebsh nj\u00eb nd\u00ebrtim t\u00eb plot\u00eb autonom t\u00eb Firebird. P\u00ebr k\u00ebt\u00eb, marrim arkivin embed t\u00eb Firebird 2.5<\/a><\/noindex>, e riem\u00ebrojm\u00eb fbemded.dll n\u00eb fbclient.dll, shtojm\u00eb nga arkivi \u2018i zakonsh\u00ebm\u2019 2.5 utilitetet gbak.exe dhe (jo domosdoshm\u00ebrisht) - isql.exe. <\/p>\n
Firebird 3.0 p\u00ebrdor nd\u00ebrtimin e vet\u00ebm<\/a><\/noindex> dhe nuk k\u00ebrkon asnj\u00eb p\u00ebrmir\u00ebsim.<\/p>\n
Varianti minimal (pa nevoj\u00ebn p\u00ebr t\u00eb instaluar bibliotekat runtime t\u00eb VS2008\/VS2010 n\u00eb sistemin e synuar) p\u00ebrmban skedar\u00ebt e m\u00ebposht\u00ebm:<\/p>\n
25\/gbak.exe\n25\/fbclient.dll\n25\/firebird.conf\n25\/firebird.log\n25\/firebird.msg\n25\/ib_util.dll\n25\/icudt30.dll\n25\/icuin30.dll\n25\/icuuc30.dll\n25\/Microsoft.VC80.CRT.manifest\n25\/msvcp80.dll\n25\/msvcr80.dll\n\n30\/fbclient.dll\n30\/firebird.conf\n30\/firebird.msg\n30\/gbak.exe\n30\/ib_util.dll\n30\/icudt52.dll\n30\/icudt52l.dat\n30\/icuin52.dll\n30\/icuuc52.dll\n30\/msvcp100.dll\n30\/msvcr100.dll\n30\/intl\/fbintl.conf\n30\/intl\/fbintl.dll\n30\/plugins\/engine12.dll<\/code><\/pre>\n
\nNj\u00eb administrator i st\u00ebrvitur mund t\u00eb v\u00ebrej\u00eb se n\u00eb 2.5 nuk jan\u00eb p\u00ebrfshir\u00eb skedar\u00ebt intl\/fbintl.dll dhe intl\/fbintl.conf. Kjo \u00ebsht\u00eb e v\u00ebrtet\u00eb, pasi gbak nuk p\u00ebrdor charset-in e lidhjes dhe nuk konverton t\u00eb dh\u00ebnat midis charset-eve, por n\u00eb an\u00ebn e \u2018pranimit\u2019 Firebird 3.0 k\u00ebta skedar\u00eb jan\u00eb t\u00eb nevojsh\u00ebm gjat\u00eb krijimit t\u00eb indekseve.<\/p>\n
N\u00eb firebird.conf Firebird 3.0 rekomandohet t\u00eb shtohet:<\/p>\n
MaxUnflushedWrites = -1\nMaxUnflushedWriteTime = -1<\/code><\/pre>\n
\nPo ashtu, \u00ebsht\u00eb e preferueshme t\u00eb vendosni edhe nj\u00eb vler\u00eb t\u00eb ndryshme t\u00eb IpcName p\u00ebr 2.5 dhe 3.0. <\/p>\n
Kur zgjidhim vlerat e parametrave t\u00eb tjer\u00eb n\u00eb firebird.conf, ne nxjerrim nga nj\u00eb logjik\u00eb t\u00eb thjesht\u00eb: n\u00eb faz\u00ebn e kalimit t\u00eb t\u00eb dh\u00ebnave n\u00eb nj\u00eb proces gbak punon 2.5, nd\u00ebrsa n\u00eb tjetrin \u2013 3.0, pastaj 2.5 p\u00ebrfundon pun\u00ebn, nd\u00ebrsa 3.0 fillon nd\u00ebrtimin e indekseve.<\/p>\n
P\u00ebr t\u00eb acceleruar faz\u00ebn e nd\u00ebrtimit t\u00eb indekseve n\u00eb 3.0, rekomandohet t\u00eb rritet madh\u00ebsia e parametrave TempCacheLimit deri n\u00eb ~40% RAM (n\u00ebse ky \u00ebsht\u00eb nj\u00eb server i dedikuar, natyrisht).<\/p>\n
P\u00ebr shembull, n\u00ebse serveri ka 16 GB RAM, at\u00ebher\u00eb mund t\u00eb vendoset <\/p>\n
TempCacheLimit=6G<\/code><\/pre>\n
\nSigurisht, nj\u00eb vler\u00eb e till\u00eb mund t\u00eb vendoset vet\u00ebm tek Firebird 3 64-bit, pasi \u00e7do proces 32-bit nuk mund t\u00eb alokoj\u00eb m\u00eb shum\u00eb se 2 gigabajt memorie.<\/i><\/p>\n
N\u00eb 2.5 nuk \u00ebsht\u00eb e nevojshme t\u00eb ndryshohet ky parameter - ai gjithashtu nuk mund t\u00eb jet\u00eb m\u00eb shum\u00eb se 2 gigabajt dhe nuk ka ndikim n\u00eb shpejt\u00ebsin\u00eb gjat\u00eb backup-it.<\/p>\n
Para se t\u00eb kryhet operacioni, duhet t\u00eb kontrolloni q\u00eb cache-i i faqeve n\u00eb header-in e databaz\u00ebs t\u00eb jet\u00eb vendosur n\u00eb 0 (komanda gstat -h databasename<\/code>, shihni rreshtin Page buffers). <\/p>\n
N\u00ebse cache-i \u00ebsht\u00eb caktuar qart\u00eb n\u00eb header-in e DB, at\u00ebher\u00eb ai e mbulon vler\u00ebn e firebird.conf (dhe databases.conf n\u00eb 3.0), dhe n\u00eb rastin e vlerave t\u00eb pap\u00ebrshtatshme t\u00eb m\u00ebdha, mund t\u00eb \u00e7oj\u00eb n\u00eb konsum t\u00eb tepruar t\u00eb memories dhe dalje n\u00eb swap.<\/p>\n
M\u00eb pas, kopjojm\u00eb skedar\u00ebt n\u00eb sistemin e synuar. <\/p>\n
Konvertimi b\u00ebhet pas ndalimit t\u00eb sh\u00ebrbimit 'sistemor' Firebird 2.5, n\u00eb terminalin e komandave me privilegje t\u00eb larta deri n\u00eb administratorin lokal (shembuj):<\/p>\n
set ISC_USER=gazmend\n\"25\/gbak\" -z -b -g -v -st t -y 25.log baza25 stdout|^\n\"30\/gbak\" -z -c -v -st t -y 30.log stdin baza30<\/code><\/pre>\n
\nN\u00eb k\u00ebt\u00eb shembull p\u00ebrdoret 'shigjeta e drejtp\u00ebrdrejt\u00eb' n\u00eb thonj\u00ebza (e lejuar 'unix-style'), nd\u00ebrsa 'kapaku' (simboli '^') e escapeton simbolin e kthimit t\u00eb linj\u00ebs, q\u00eb \u00ebsht\u00eb e p\u00ebrshtatshme gjat\u00eb shkruarjes s\u00eb komandave t\u00eb gjata. Opsioni -st(atus) u shfaq n\u00eb Firebird 2.5.8 dhe lejon t\u00eb regjistrohen n\u00eb protokoll t\u00eb dh\u00ebnat p\u00ebr koh\u00ebzgjatjen e procesit gbak (detajet - n\u00eb dokumentacion).<\/p>\n
Linux<\/b><\/p>\n
N\u00eb Linux Firebird 3 varf\u00ebrohet nga biblioteka tommath. N\u00eb CentOS (RHEL) kjo bibliotek\u00eb gjendet n\u00eb repo-n e epel, n\u00eb Ubuntu (Debian) n\u00eb \u2013 sistemike.<\/p>\n
P\u00ebr CentOS, s\u00eb pari duhet t\u00eb lidhni repo-n e epel dhe pastaj t\u00eb b\u00ebni <\/p>\n
yum install libtommath<\/code><\/pre>\n
\nUbuntu nuk ka nevoj\u00eb t\u00eb lidhen depozita shtes\u00eb, por n\u00eb Ubuntu 16 dhe n\u00eb Ubuntu 18 instalohen versione t\u00eb ndryshme t\u00eb pakove \u2013 libtommath0 dhe libtommath1, p\u00ebrkat\u00ebsisht.<\/p>\n
Firebird 3.0 k\u00ebrkon tommath.so.0 dhe p\u00ebr Ubuntu 18 nevojitet gjithashtu t\u00eb krijohet nj\u00eb lidhje (symlink) nga tommath.so.0 n\u00eb tommath.so.1. P\u00ebr k\u00ebt\u00eb, s\u00eb pari duhet t\u00eb gjendet tommath.so.1. <\/p>\n
Rruga e k\u00ebrkuar n\u00eb Ubuntu \u00ebsht\u00eb \/usr\/lib\/x86_64-linux-gnu\/<\/code>, por n\u00eb distribucione t\u00eb tjera t\u00eb bazuara n\u00eb Debian mund t\u00eb jet\u00eb ndryshe.<\/p>\n
Problemi i dyt\u00eb \u00ebsht\u00eb se deri n\u00eb Firebird 3.0.1, p\u00ebrfshir\u00eb, nuk kishte nj\u00eb m\u00ebnyr\u00eb t\u00eb thjesht\u00eb p\u00ebr t\u00eb instaluar dy versione t\u00eb ndryshme t\u00eb serverit. Opcioni \"kompilo nga burimet me prefiksin e nevojsh\u00ebm\" nuk po shqyrtohet p\u00ebr shkak t\u00eb pun\u00ebs s\u00eb tij relative t\u00eb r\u00ebnd\u00eb.<\/p>\n
P\u00ebr Firebird 3.0.2 dhe m\u00eb lart \u00ebsht\u00eb realizuar nd\u00ebrtimi me \u2013enable-binreloc<\/a><\/noindex> dhe nj\u00eb opsion t\u00eb ve\u00e7ant\u00eb t\u00eb instaluesit (-path rruga).<\/p>\n
Duke supozuar se biblioteka tommath dhe, n\u00ebse \u00ebsht\u00eb e nevojshme, lidhja p\u00ebr tommath.so.0 jan\u00eb shtuar n\u00eb sistem, mund t\u00eb instalohet distribucioni aktual (n\u00eb momentin e shkruarjes s\u00eb k\u00ebtij artikulli) Firebird 3.0.4 n\u00eb, p.sh., \/opt\/fb3:<\/p>\n
.\/install.sh -path \/opt\/fb3<\/code><\/pre>\n
\nPas k\u00ebsaj, mund t\u00eb ndalet sh\u00ebrbimi sistemor Firebird dhe t\u00eb fillohet konvertimi n\u00eb rrjedh\u00eb. <\/p>\n
Kur ndalohet Firebird, duhet t\u00eb merret parasysh se proceset Firebid 2.5 n\u00eb modin Classic zakonisht aktivizohen nga xinetd \u2013 prandaj, duhet ose t\u00eb ndalohet sh\u00ebrbimi firebird p\u00ebr xinetd ose t\u00eb ndalohet t\u00ebr\u00ebsisht xinetd.<\/i><\/p>\n
N\u00eb firebird.conf p\u00ebr 3.0 n\u00eb Linux nuk \u00ebsht\u00eb nevoj\u00eb t\u00eb caktohen parametrat MaxUnflushed (ato funksionojn\u00eb vet\u00ebm n\u00eb Windows) dhe t\u00eb ndryshohen cil\u00ebsimet e Firebird 2.5. <\/p>\n
N\u00eb Linux, akses lokal (file) i Firebird 2.5 nuk \u00ebsht\u00eb ekuivalent me variantin embedded n\u00ebn Windows \u2013 serveri 2.5 do t\u00eb funksionoj\u00eb n\u00eb procesin gbak (pa pjes\u00ebn rrjetore), por t\u00eb drejtat e aksesit do t\u00eb verifikohen p\u00ebrmes baz\u00ebs s\u00eb p\u00ebrdoruesve, dhe k\u00ebshtu do t\u00eb nevojitet jo vet\u00ebm nj\u00eb p\u00ebrdorues, por edhe nj\u00eb fjal\u00ebkalim: <\/p>\n
export ISC_USER=username ISC_PASSWORD=password\n\/opt\/firebird\/bin\/gbak -b \u2026 baza25 stdout\n|\/opt\/fb3\/bin\/gbak -c \u2026 stdin baza30<\/code><\/pre>\n
\nPas konvertimit t\u00eb suksessh\u00ebm, duhet t\u00eb hiqet fillimisht Firebird 3.0 \"shtes\u00eb\", pastaj Firebird 2.5 \"t\u00eb r\u00ebnd\u00ebsish\u00ebm\" dhe vet\u00ebm pas k\u00ebsaj t\u00eb kryhet nj\u00eb instalim i past\u00ebr i Firebird 2.5 \u2013 dhe \u00ebsht\u00eb m\u00eb mir\u00eb t\u00eb b\u00ebhet nga instaluesi standard tar.gz, dhe jo p\u00ebrmes depozitave, sepse versioni n\u00eb depozita mund t\u00eb jet\u00eb pas.<\/p>\n
Gjithashtu, pas rikuperimit t\u00eb DB n\u00eb Linux dhe riinstalimit duhet t\u00eb kontrolloni q\u00eb DB e re t\u00eb ket\u00eb pronar p\u00ebrdoruesin firebird.<\/p>\n
N\u00ebse nuk \u00ebsht\u00eb k\u00ebshtu, at\u00ebher\u00eb do t\u00eb nevojitet t\u00eb korrigjohet<\/p>\n
chown firebird.firebird database<\/code><\/pre>\n
\nP\u00ebrfundimi<\/b><\/p>\n
P\u00ebrve\u00e7 kursimit t\u00eb koh\u00ebs dhe hap\u00ebsir\u00ebs n\u00eb disk, konvertimi n\u00eb rrjedh\u00eb ka nj\u00eb avantazh t\u00eb r\u00ebnd\u00ebsish\u00ebm tjet\u00ebr \u2013 transformimi i baz\u00ebs b\u00ebhet pa fshir\u00eb Firebird 2.5 ekzistues, gj\u00eb q\u00eb e thjeshton ndjesh\u00ebm rikthimin n\u00eb rast t\u00eb d\u00ebshtimit t\u00eb konvertimit (m\u00eb shpesh \u2013 p\u00ebr shkak t\u00eb munges\u00ebs s\u00eb hap\u00ebsir\u00ebs ose rikthimit t\u00eb papritur gjat\u00eb procesit t\u00eb migrimit).<\/p>\n
Kursimi i koh\u00ebs \u00ebsht\u00eb i lidhur me faktin se \"konvertimi klasik\" \u00ebsht\u00eb \"koha e backup-it\" plus \"koha e rikuperimit\". Rikuperimi p\u00ebrb\u00ebhet nga dy pjes\u00eb: leximi i t\u00eb dh\u00ebnave nga skedari i backup-it dhe nd\u00ebrtimi i indeksit.<\/p>\n
N\u00eb konvertimin n\u00eb rrjedh\u00eb, koha totale del si \"koha e backup-it plus pes\u00eb deri n\u00eb dhjet\u00eb p\u00ebrqind\" dhe \"koha e nd\u00ebrtimit t\u00eb indekseve\".<\/p>\n
Rezultatet specifike varen nga struktura e baz\u00ebs, por mesatarisht, koha e rikuperimit \u00ebsht\u00eb af\u00ebrsisht e barabart\u00eb me dyfishin e koh\u00ebs s\u00eb backup-it. Prandaj, n\u00ebse e marrim si nj\u00ebsi koh\u00ebn e backup-it, at\u00ebher\u00eb \"konvertimi klasik\" i shkon tre nj\u00ebsi koh\u00eb, kurse ai n\u00eb rrjedh\u00eb dy nj\u00ebsi koh\u00eb. Shtes\u00eb, zvog\u00eblimi i koh\u00ebs ndihmon rritja e TempCacheLimit.<\/p>\n
N\u00eb p\u00ebrgjith\u00ebsi, konvertimi n\u00eb rrjedh\u00eb n\u00eb praktik\u00eb lejon kursimin e 30-40% t\u00eb koh\u00ebs s\u00eb backup-it dhe rikuperimit sekuencial.<\/p>\n
Pyetje?<\/b><\/p>\n
Ju lutemi, d\u00ebrgoni t\u00eb gjitha pyetjet n\u00eb komentet, ose d\u00ebrgoni autorit t\u00eb metodik\u00ebs dhe bashk\u00ebautorit t\u00eb k\u00ebtij artikulli \u2013 Vasili Sidori, inxhinierin kryesor t\u00eb sistemeve n\u00eb kompanin\u00eb \"iBase\", n\u00eb adres\u00ebn bs at ibase ru.<\/p>\n
Vet\u00ebm p\u00ebrdoruesit e regjistruar mund t\u00eb marrin pjes\u00eb n\u00eb anket\u00eb. Hyni<\/a><\/noindex>, ju lutemi.<\/p>\n
Cil\u00ebs versione t\u00eb Firebird po i p\u00ebrdorni?<\/h2>\n