Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Berkely DB > DB Migration Is...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 1754 of 1804
Post > Topic >>

DB Migration Issues

by Kiran Kumar M R <kiranmr@[EMAIL PROTECTED] > May 30, 2007 at 08:00 AM

Hi,

I have several homogeneous SUSE 9 Nodes. I am running BDB4.3.28  with
following configuration parameters.

DB Flags = DB_CREATE| DB_AUTO_COMMIT|DB_THREAD;
Env Flags = DB_RECOVER |DB_CREATE |  DB_INIT_LOG | DB_INIT_MPOOL |
DB_INIT_TXN|DB_THREAD;

I have configured transaction subsystem with DB_TXN_WRITE_NOSYNC|
DB_LOG_AUTOREMOVE options.

I want to copy the DB from one machine to another machine. Suggested
method is using db_dump and db_load. But this transfer has to be done
every 5 minutes, so using db_dump and db_load is not possible as it
takes lot of time.

The DB File, Region Files and Log files are present in the same
directory. I want to copy this whole directory and start the new
node.   Out of following 4 options which is best and guaranteed to
work. I have tried option 1 and it failed.

1. copy only db file ( This method failed some times. I am performing
dbsync() before transferring the db file). )
2. copy db file and region files only - no logfile
3. copy  db file and log files only -  no region files)
4. copy all files.

Please give your suggestions.


Regards,
Kiran
 




 1 Posts in Topic:
DB Migration Issues
Kiran Kumar M R <kiran  2007-05-30 08:00:28 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 20 0:22:25 CDT 2008.