473,714 Members | 1,968 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

DB2 Clustering

We are thinking of starting to use clustering with our DB2 V8. I
understand that with clustering when a node goes down that the other
nodes will keep the database up for the users. What I would like to
know is does this include if the node has a hard drive crash and the
disks are not salvagable or just if the machine looses connection?
And if a new machine is used to replace the damaged one how does it
sync together? Any information on the subject will be appreciated.

Daniel G. Cantua
Los Angeles County - ISD
Nov 12 '05 #1
5 10355
Daniel,

Have you downloaded DB2 Stinger? Given that you are just "starting to
look" you want to add HADR to your choices. Take peek :-)

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #2
Cluster-based high availability tends to work by combining multi-ported disk
devices,
spare processing power, and a cluster manager (such as HACMP, MSCS, etc.).
When
a processor fails, the services that were running there (which could include
a DB2 "node"
aka processing "partition" ) are restarted in the spare processing facilities
(which may have
previously been idle, or may be already loaded processors that are set up to
absorb
additional workload in a failover). The disk resources associated with the
failed node
need to be accessible from the new node as well.

Disk (media) recovery is not usually part of this picture. Other approaches
are used
for that, including RAID/mirroring and database recovery (restore and
rollforward).

HADR (high availability disaster recovery), mentioned by Serge, is a log
shipping
database replication feature. Such products are typically deployed to
provide
failover to both different processors and different disks. This can be used
within
a cluster, with *separate* disk resources, which is different from the usual
configuration
meant when someone refers to cluster-based HA. More typically, log shipping
based HA is deployed between independent (not clustered) systems, either
within
one data center for "local" failover, or between geographically separated
("remote")
systems for protection against whole site failures.

Regards,
-steve p.
-------------------
Steve Pearson
DB2 UDB Development
Portland, OR, USA
"Daniel G. Cantua" <dc*****@co.la. ca.us> wrote in message
news:6c******** *************** ***@posting.goo gle.com...
We are thinking of starting to use clustering with our DB2 V8. I
understand that with clustering when a node goes down that the other
nodes will keep the database up for the users. What I would like to
know is does this include if the node has a hard drive crash and the
disks are not salvagable or just if the machine looses connection?
And if a new machine is used to replace the damaged one how does it
sync together? Any information on the subject will be appreciated.

Daniel G. Cantua
Los Angeles County - ISD

Nov 12 '05 #3
Steve,

If we use HADR on two machines and one the machines is physical
damaged or turned off, will the user be able to continue to work as if
nothing happen. Or will they have to do some type of reconfiguration
the the workstation. What we have are six sites in LA county that
will need to connect to this DB. We were thing that clustering will
take care of a disaster occurs. But it sounds like if we have two
machines using HADR that both machines will mirror each other. Can
this be used also for load balancing. Like I said I am new to this.

Thank You For Your Help,
Daniel G. Cantua
Los Angeles County - ISD
Nov 12 '05 #4
When the primary crashes and DB2 fails over to the secondary, the user
will have to reconnect. The secondary will assume the IP address of the
primary, so the user will just reconnect to the same database on the
same instance (it will seem the same to the application).

When DB2 Stinger ships, the reconnection will not be necessary.

Daniel G. Cantua wrote:
Steve,

If we use HADR on two machines and one the machines is physical
damaged or turned off, will the user be able to continue to work as if
nothing happen. Or will they have to do some type of reconfiguration
the the workstation. What we have are six sites in LA county that
will need to connect to this DB. We were thing that clustering will
take care of a disaster occurs. But it sounds like if we have two
machines using HADR that both machines will mirror each other. Can
this be used also for load balancing. Like I said I am new to this.

Thank You For Your Help,
Daniel G. Cantua
Los Angeles County - ISD


Nov 12 '05 #5
> If we use HADR on two machines and one the machines is physical
damaged or turned off, will the user be able to continue to work as if
nothing happen. Or will they have to do some type of reconfiguration
the the workstation. What we have are six sites in LA county that
will need to connect to this DB. We were thing that clustering will
take care of a disaster occurs. But it sounds like if we have two
machines using HADR that both machines will mirror each other.
The results from the user's perspective would depend on specifics of the
configuration and application. First, something or somebody (cluster
manager software, a system administrator, etc.) must recognize that a
failure has occurred and invoke the TAKEOVER HADR command.
Once the standby takes over as new primary, the applications will need
to reconnect. How exactly this happens depends somewhat on the
application's own behavior. As Blair mentioned, in Stinger there
will also be an ability to configure an automatic connection rerouting.
In-flight transactions must roll back, but the client can be reconnected
to the alternative server automatically. Other possible elements of
the failover, such as moving IP addresses around and so on are out of
HADR's control but may come into play with how the application
behaves. HADR only makes the standby database available at the
standby site after issuance of a Takeover command.

Traditional in-cluster failover (not involving HADR) is another
alternative, as I discussed before.

Can this be used also for load balancing.


In the Stinger release, HADR does not provide for anything like this.
What is most common with log-shipping database replication products
(in which category HADR falls) is to provide for periodic consistent
read access and/or periodic or continuous dirty read access to data
at the standby site. We recognize the value of this kind of access, and
it is high on our list of possible future enhancements to HADR.

Other kinds of replication technologies, such as DB2 SQL Replication
or, coming with Stinger, MQ Series based "Q" Replication, provide
logical (vs. HADR's physical) replication, at object rather than database
level, and the possibility of load balancing through either multi way
replication (update anywhere) or consistent read on non-updated sites.
Such features can also be employed in support of high availability, but
with somewhat different failover characteristics .

So you have plenty of choices! :-)

Regards,
-steve p.
-------------------
Steve Pearson
DB2 UDB Development
Portland, OR, USA
Nov 12 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
5876
by: Nico de Groot | last post by:
I have a 2 node Microsoft 2000 cluster with a shared storage device. I want to create automatic failover for MS SQL 2000 server. I can do that wit the following options: 1. Active/Pasive (one instance installed) 2. Active/Active (More then one instance/virtual sql servers installed) I have a question about option 2.
1
4278
by: kumar | last post by:
Dear Friends, I wanted to configure Failover cluster for SQL Server 2000 on Windows 2000 advanced servers. I have only 2 no.s of windows 2000 advanced server m/cs. I dont have any shared disks and SCSI drives. Can I still configure the Failover clustering? I would like to know more about the need for the shared disks in the
3
5163
by: Shabam | last post by:
When a web application becomes overloaded with traffic, one can offload it by load balancing and clustering the front end web servers. What happens when the back-end MSSQL database becomes overloaded? Does MYSQL offer load balancing and clustering?
1
2155
by: willie | last post by:
Hi all: I have a clustering SQL Server on Node1 and Node2, the Node1 has named Instance1 and Node2 has named Instance2, no default instance. We tested it that everthing is OK, then we decide to move to DR location. The relocation kept the same virtual and phusical server name, and we did not change SQL Server server network utility. But server IP addresses were changed(vitual and physical). We can start the clustering SQL Server as...
2
1990
by: CSN | last post by:
Just wondering - is there something similar to this (clustering) for PostgreSQL? If so, how does it compare? http://www.mysql.com/press/release_2003_30.html __________________________________ Do you Yahoo!?
3
2330
by: datapro01 | last post by:
Running DB2 version 8.1.1 on AIX 5.1.1 The table (employee) is being reorged and has a clustering index (empid). Is there any different between these two commands? db2 reorg table employee index empid allow no access indexscan db2 reorg table employee index empid allow no access
11
730
by: chmmr | last post by:
Hi, I am currently in the process of gathering info/experiences for an incoming Linux DB2 clustering phase we actually know nothing about (since we are doing it for the first time ever), so I would really appreciate if you could share some of your experience here or recommend some additional websites/literature aside from IBM Developerworks - specifically, if there are some caveats or things to look out for during the process, etc....
3
1949
by: dejavue82 | last post by:
Hi, Does anybody know of a software package that allows for several servers, running asp.net 2.0 to be clustered, regardless of where they are located (ie. without a hardware load balancer). This way one could link two or more dedicated servers, perhaps even running on different hosts. Does something like this exist? Thank you for your time!
5
2141
by: Lakesider | last post by:
Hi NG, I have a question about data: I have travel-times from A to B like this from | to | sec. A B 17 A B 18 A B 30 A B 32
3
3331
by: Manish | last post by:
I think this question has been asked number of times. However, I am looking for some specific information. Perhaps some of you can help close the gap. Or perhaps you can point me towards right direction. Perhaps this group can help me fill in ms-sqlserver related following questions. 1. Do this database have data Clustering capabilities? 1a. If yes, what mechanism is used such as shared disk, share nothing, etc.
0
8817
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
8715
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9322
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9189
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9086
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9037
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
4470
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
2531
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2116
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.