Hello,
I have what may seem a bit of an odd question, but here goes:
Is there any advantage to having an operating-system clustered set of
machines running DB2, as opposed to using DB2's PDF to "cluster" machines?
The discussion came up due to a cluster of Linux servers we have which are
not being used very much. The suggestion was to use them as a database
cluster. I actually had no idea on how to answer this question, since I
would imagine that even in an OS cluster, you would install DB2 on each
machine and make a node of each machine?
*scratching head as to what the implications are*
Mairhtin 5 1495
Mairhtin,
I am not sure of the distinction that you are making, can you elaborate
a bit more on what you mean by operating-system clustered set of
machines? Are you thinking of numa-type machines providing a single
system image from an OS perspective?
Whether it is a large SMP server (a la IBM p690, Sun starfire), a NUMA
box (e.g. from IBM x445, SGI) or a cluster of small nodes (cluster of
e325 servers, p570s, etc.), DB2 DPF maps pretty well on either
architectures. We have published industry-std benchmarks as well as
have a large number of customers using these various architectures in
their environments.
- Haider
"mairhtin o'feannag" <ir**********@rocketmaildot.com> writes: Hello,
I have what may seem a bit of an odd question, but here goes:
Is there any advantage to having an operating-system clustered set of machines running DB2, as opposed to using DB2's PDF to "cluster" machines? The discussion came up due to a cluster of Linux servers we have which are not being used very much. The suggestion was to use them as a database cluster. I actually had no idea on how to answer this question, since I would imagine that even in an OS cluster, you would install DB2 on each machine and make a node of each machine?
*Scratching head as to what the implications are*
Mairhtin
I'm talking about 10 machines that are a linux-cluster. Intel machines
running clustering software. ROCKS, I believe, but the same question
would exist for a Beowulf Cluster as well. The machines all have their
own hard drives.
Mairhtin
Haider Rizvi <ha*****@gmail.com> wrote in
news:7z************@thinkhr.torolab.ibm.com: Mairhtin,
I am not sure of the distinction that you are making, can you elaborate a bit more on what you mean by operating-system clustered set of machines? Are you thinking of numa-type machines providing a single system image from an OS perspective?
Whether it is a large SMP server (a la IBM p690, Sun starfire), a NUMA box (e.g. from IBM x445, SGI) or a cluster of small nodes (cluster of e325 servers, p570s, etc.), DB2 DPF maps pretty well on either architectures. We have published industry-std benchmarks as well as have a large number of customers using these various architectures in their environments.
- Haider
"mairhtin o'feannag" <ir**********@rocketmaildot.com> writes:
Hello,
I have what may seem a bit of an odd question, but here goes:
Is there any advantage to having an operating-system clustered set of machines running DB2, as opposed to using DB2's PDF to "cluster" machines? The discussion came up due to a cluster of Linux servers we have which are not being used very much. The suggestion was to use them as a database cluster. I actually had no idea on how to answer this question, since I would imagine that even in an OS cluster, you would install DB2 on each machine and make a node of each machine?
*Scratching head as to what the implications are*
Mairhtin
Mairhtin O'Feannag wrote: I'm talking about 10 machines that are a linux-cluster. Intel machines running clustering software. ROCKS, I believe, but the same question would exist for a Beowulf Cluster as well. The machines all have their own hard drives.
Beowulf is a set of tools used to allow a program to run on a group
("cluster") of machines -- it takes care of communication between
the nodes, distributing work to the nodes, etc.
The Database Partitioning Feature serves the equivalent purpose, but
it's built into DB2 UDB. You can't replace DPF with Beowulf.
Also keep in mind that using a cluster to scale out (using DPF or
Beowulf, if you're building a compute-farm) is not the same thing as
scaling for high availability (i.e. using a product like Veritas Cluster
or Steeleye Lifekeeper).
----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---
"Mairhtin O'Feannag" <ir********@rocketmail.com> writes: I'm talking about 10 machines that are a linux-cluster. Intel machines running clustering software. Rocks, I believe, but the same question would exist for a Beowulf Cluster as well. The machines all have their own hard drives.
I was confused by the way you posed your question.
DB2 + DPF is a shared-nothing parallel database that can run on a
cluster of nodes. Other than the basic linux OS (typically RHEL3 or
SLES8 these days for enterprise deployment) you don't need any special
software on these nodes (which is what Beowulf seems to be providing, I
don't know much about Beowulf). You can use a variety of software to
maintain / sys admin such a cluster, examples of such software are IBM
CSM, Power Cockpit, xCAT, etc.
You can read more details about dpf in the DB2 books, or various
articles at developerworks, etc. One overview article is at the
following url: http://www-106.ibm.com/developerwork.../dm-0403chong/
See specific db2 for linux clusters papers and related information at: http://www-306.ibm.com/software/data...ux/papers.html Haider Rizvi <ha*****@gmail.com> wrote in news:7z************@thinkhr.torolab.ibm.com:
Mairhtin,
I am not sure of the distinction that you are making, can you elaborate a bit more on what you mean by operating-system clustered set of machines? Are you thinking of numa-type machines providing a single system image from an OS perspective?
Whether it is a large SMP server (a la IBM p690, Sun starfire), a NUMA box (e.g. from IBM x445, SGI) or a cluster of small nodes (cluster of e325 servers, p570s, etc.), DB2 DPF maps pretty well on either architectures. We have published industry-std benchmarks as well as have a large number of customers using these various architectures in their environments.
- Haider
"mairhtin o'feannag" <ir**********@rocketmaildot.com> writes:
Hello,
I have what may seem a bit of an odd question, but here goes:
Is there any advantage to having an operating-system clustered set of machines running DB2, as opposed to using DB2's PDF to "cluster" machines? The discussion came up due to a cluster of Linux servers we have which are not being used very much. The suggestion was to use them as a database cluster. I actually had no idea on how to answer this question, since I would imagine that even in an OS cluster, you would install DB2 on each machine and make a node of each machine?
*Scratching head as to what the implications are*
Mairhtin
--
Regards,
--
Haider
Thank you all.
That's pretty much what I expected, but needed to be certain I wasn't
blowing smoke.... :)
So on with the DPF show!
Mairhtin
Haider Rizvi <ha*****@gmail.com> wrote in
news:7z************@thinkhr.torolab.ibm.com: "Mairhtin O'Feannag" <ir********@rocketmail.com> writes:
I'm talking about 10 machines that are a linux-cluster. Intel machines running clustering software. Rocks, I believe, but the same question would exist for a Beowulf Cluster as well. The machines all have their own hard drives.
I was confused by the way you posed your question.
DB2 + DPF is a shared-nothing parallel database that can run on a cluster of nodes. Other than the basic linux OS (typically RHEL3 or SLES8 these days for enterprise deployment) you don't need any special software on these nodes (which is what Beowulf seems to be providing, I don't know much about Beowulf). You can use a variety of software to maintain / sys admin such a cluster, examples of such software are IBM CSM, Power Cockpit, xCAT, etc.
You can read more details about dpf in the DB2 books, or various articles at developerworks, etc. One overview article is at the following url:
http://www-106.ibm.com/developerwork...icle/dm-0403ch ong/
See specific db2 for linux clusters papers and related information at: http://www-306.ibm.com/software/data...ux/papers.html Haider Rizvi <ha*****@gmail.com> wrote in news:7z************@thinkhr.torolab.ibm.com:
Mairhtin,
I am not sure of the distinction that you are making, can you elaborate a bit more on what you mean by operating-system clustered set of machines? Are you thinking of numa-type machines providing a single system image from an OS perspective?
Whether it is a large SMP server (a la IBM p690, Sun starfire), a NUMA box (e.g. from IBM x445, SGI) or a cluster of small nodes (cluster of e325 servers, p570s, etc.), DB2 DPF maps pretty well on either architectures. We have published industry-std benchmarks as well as have a large number of customers using these various architectures in their environments.
- Haider
"mairhtin o'feannag" <ir**********@rocketmaildot.com> writes:
Hello,
I have what may seem a bit of an odd question, but here goes:
Is there any advantage to having an operating-system clustered set of machines running DB2, as opposed to using DB2's PDF to "cluster" machines? The discussion came up due to a cluster of Linux servers we have which are not being used very much. The suggestion was to use them as a database cluster. I actually had no idea on how to answer this question, since I would imagine that even in an OS cluster, you would install DB2 on each machine and make a node of each machine?
*Scratching head as to what the implications are*
Mairhtin
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...
|
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...
|
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...
|
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...
|
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
...
|
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...
|
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)....
|
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...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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...
|
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,...
| |