Hello, Vlad! >> To update offline copy of the database over WAN we use the following >> procedure in a shall script: >> - obtain baseline GUID of the database using GSTAT -h >> - pull changes using SSH+NBACKUP using baseline GUID > What is the file format where changes are stored ?
The same NBK file format as any non-zero level incremental backup. To indicate that we have GUID based change set (and not level based) we put zero into inc_header.level field. > >> - if pull is successful apply changes to a local copy > How changes are applied ? We implemented nbackup -i option that applies changes "in-place". It takes exclusive lock on the database to ensure that nobody uses it. Nbackup -i clears backup mode flag and marks resulting database "read-only" to protect it from inadvertent changes by the user. > No principal objections from me. But i would like to have answers about > changes first. > And it will be good to make procedure more user-friendly, i think. For user friendliness I propose we include our replication script as an example. It looks perfectly user friendly to us :-) Ok, I ask Dmitry Starodubov to create a patch for FB3.0 and publish it for review. Nikolay ------------------------------------------------------------------------------ Try New Relic Now & We'll Send You this Cool Shirt New Relic is the only SaaS-based application performance monitoring service that delivers powerful full stack analytics. Optimize and monitor your browser, app, & servers with just a few lines of code. Try New Relic and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
