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 5 10375
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
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
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
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
> 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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.
|
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
|
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?
|
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...
|
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!?
| |
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
|
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....
|
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!
|
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
|
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.
|
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...
| |
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,...
|
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,...
|
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...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
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...
| |