Hello,
I have two db2 box here, running a vrrp daemon to provide IP failover...
The two nodes are perfectly identical (same os, users, and db2 setup
(instances, db, tables...)).
[DB2_node1] <---- Common Virtual IP Addr ----> [DB2_node2]
MASTER (working) BACKUP (standby)
I know nearly nothing about db2 internals...
The only way I know to keep them in sync is to stop db2 on both nodes,
then run rsync on instances, fenced and admin home directories... then
restart db2.
Is it enough to keep nodes in sync ?
Is there a risk of data corruption ?
I know I should use some smart realtime replication, using db2 internals
and so on, but I can't afford working on this direction :(
Bye,
Mat. 2 6315
M.L. wrote: Hello,
I have two db2 box here, running a vrrp daemon to provide IP failover... The two nodes are perfectly identical (same os, users, and db2 setup (instances, db, tables...)).
[DB2_node1] <---- Common Virtual IP Addr ----> [DB2_node2] MASTER (working) BACKUP (standby)
I know nearly nothing about db2 internals...
The only way I know to keep them in sync is to stop db2 on both nodes, then run rsync on instances, fenced and admin home directories... then restart db2.
Is it enough to keep nodes in sync ? Is there a risk of data corruption ?
This is not supported by IBM, although it will work until someone
changes the physical database configuration and moves something
out of the instance owner home directory.
I know I should use some smart realtime replication, using db2 internals and so on, but I can't afford working on this direction :(
There are lots of options,
DB2 Replication
Standby database using Log Shipping
HADR (new in Stinger)
Hardware HA (using Sun Cluster / Veritas Cluster / HACMP / etc.)
Probably the easiest is #2 (log shipping). There are some articles on
this at the DB2 Developer Domain.
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
There are multiple options for this - log shipping, replication or HADR
which in new in FP7.
HADR would be the best way to keep 2 DB2 databases in sync. When used with
the new client re-route it will minimise any possible downtime.
Cheers,
"M.L." <m.l@no_sP_am_oceanfree.net> wrote in message
news:ch**********@news-reader2.wanadoo.fr... Hello,
I have two db2 box here, running a vrrp daemon to provide IP failover... The two nodes are perfectly identical (same os, users, and db2 setup (instances, db, tables...)).
[DB2_node1] <---- Common Virtual IP Addr ----> [DB2_node2] MASTER (working) BACKUP (standby)
I know nearly nothing about db2 internals...
The only way I know to keep them in sync is to stop db2 on both nodes, then run rsync on instances, fenced and admin home directories... then restart db2.
Is it enough to keep nodes in sync ? Is there a risk of data corruption ?
I know I should use some smart realtime replication, using db2 internals and so on, but I can't afford working on this direction :(
Bye, Mat. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Josef Sachs |
last post by:
Is Andrew Kuchling's regex-to-re HOWTO available anywhere?
I've found the following (dead) links on various Web pages:
http://py-howto.sourceforge.net/regex-to-re/regex-to-re.html...
|
by: ~K |
last post by:
I have 3 Oracle servers that I would like to keep in sync. Only one is
used as my production, the other is a backup and the third is used for
development purposes. In case my primary Oracle server...
|
by: kartik |
last post by:
I open an fstream in read-only mode, read till the end, then try to
sync() before seeking to position 0 & reading again. But the sync
fails. I discovered that clear()ing the stream before the sync...
|
by: alejandro lapeyre |
last post by:
How can I load / parse an HTML file with .NET?
Thanks!
Best regards,
Alejandro Lapeyre
|
by: cppdev |
last post by:
Hello,
After reading a few articles,
http://blogs.gotdotnet.com/cbrumme/PermaLink.aspx/e55664b4-6471-48b9-b360-f0fa27ab6cc0...
|
by: Rob |
last post by:
I have a form where the user may see a matrix of data in a grid (populated
via a dataset). If the user wishes to add a new row of data, they click a
button and a new form opens where the user may...
|
by: Anthony Malt |
last post by:
Hi,
my server has a database table. I read this table on the server into a
dataset and my client retrieves it through a webservice.
No changes on the client and server happen. What's the best...
|
by: Ben Voigt [C++ MVP] |
last post by:
This is more of a C# question than a C++ question, but my best chance of
explaining it is via comparison to C++.
Ok:
In C++ you can forward declare a type. Then references to that type can be...
|
by: glubber |
last post by:
I have a cronned perl script that runs on a different server.
when I try to restore it to the server below things dont copy across correctly.
the target server is described below.
debian 4.0...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |