473,836 Members | 1,562 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

PostgreSQL in Cluster

Hi everyone,

Anyone have PostgreSQL running on a cluster?
I'm trying to run on a OpenMosix 2-machine cluster but the processes are not migrating.
All the load is concentrating in one machine.
And, how can I have fail over?

Thank you,

Luiz
Nov 22 '05 #1
7 11240
On Fri, 27 Feb 2004, Luiz Guilherme Freitas de Paula wrote:
Hi everyone,

Anyone have PostgreSQL running on a cluster?
I'm trying to run on a OpenMosix 2-machine cluster but the processes are not migrating.
All the load is concentrating in one machine.
And, how can I have fail over?


so far, everyone who's tested postgresql on openmosix has found it to be
quite slow. IT would appear the shared memory is the deal breaker there.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 22 '05 #2
On Friday 27 February 2004 18:31, Luiz Guilherme Freitas de Paula wrote:
Hi everyone,

Anyone have PostgreSQL running on a cluster?
I'm trying to run on a OpenMosix 2-machine cluster but the processes are
not migrating. All the load is concentrating in one machine.
I don't think openmosix allows shared memory to migrate. Since PG uses shared
memory to communicate between backends, this will cause you problems.
And, how can I have fail over?


More information?

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

Nov 22 '05 #3
Is there any way to use PostgreSQL in a cluster configuration or have
redundancy?
How can I have my DB to not stop on hardware failure?

Thank you,

Luiz
On Friday 27 February 2004 18:31, Luiz Guilherme Freitas de Paula wrote:
Hi everyone,

Anyone have PostgreSQL running on a cluster?
I'm trying to run on a OpenMosix 2-machine cluster but the processes are
not migrating. All the load is concentrating in one machine.
I don't think openmosix allows shared memory to migrate. Since PG uses

shared memory to communicate between backends, this will cause you problems.
And, how can I have fail over?


More information?

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 22 '05 #4
On Friday 27 February 2004 20:13, Luiz Guilherme Freitas de Paula wrote:
Is there any way to use PostgreSQL in a cluster configuration or have
redundancy?
Well, you don't say much about your hardware, usage patterns etc. but you
might want look at the various replication options currently available.

There's one in the source distribution: contrib/dbmirror.
Or perhaps erserver/rservimp on gborg.postgresq l.org
How can I have my DB to not stop on hardware failure?


I don't know of anyone doing instant fail-over to a secondary machine. You
might want to consider the following:

1. External, shared RAID drives (note that you *MUST NOT* run two versions of
PG against the same files)
2. Duplicate machines with replication and one of the "heartbeat+fail over"
options (free or commercial)
3. Commercial high-availability hardware (I know - too expensive)

Can't say much more without knowing what you want. Whatever path you decide to
take, do a proper risk assessment first and allow time to understand the
systems involved and too proper testing.

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 22 '05 #5
> Is there any way to use PostgreSQL in a cluster configuration or have
redundancy?
How can I have my DB to not stop on hardware failure?
You can have a fail-over cluster by having an external disk array
connected to two machines, where machine B is activated, mounts the
disks, and switches off power from machine A if it fails.

Jon

Thank you,

Luiz
On Friday 27 February 2004 18:31, Luiz Guilherme Freitas de Paula wrote:
Hi everyone,

Anyone have PostgreSQL running on a cluster?
I'm trying to run on a OpenMosix 2-machine cluster but the processes are
not migrating. All the load is concentrating in one machine.


I don't think openmosix allows shared memory to migrate. Since PG uses

shared
memory to communicate between backends, this will cause you problems.
And, how can I have fail over?


More information?

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

Nov 22 '05 #6


-----Mensagem original-----
De: pg************* ****@postgresql .org
[mailto:pg****** ***********@pos tgresql.org] Em nome de Luiz Guilherme
Freitas de Paula
Enviada em: sexta-feira, 27 de fevereiro de 2004 17:14
Para: Richard Huxton; pg***********@p ostgresql.org
Assunto: Re: [GENERAL] PostgreSQL in Cluster

Is there any way to use PostgreSQL in a cluster configuration or have
redundancy?
How can I have my DB to not stop on hardware failure?

Thank you,

Luiz
On Friday 27 February 2004 18:31, Luiz Guilherme Freitas de Paula wrote:
Hi everyone,

Anyone have PostgreSQL running on a cluster?
I'm trying to run on a OpenMosix 2-machine cluster but the processes are not migrating. All the load is concentrating in one machine.


I don't think openmosix allows shared memory to migrate. Since PG uses

shared memory to communicate between backends, this will cause you problems.
And, how can I have fail over?
More information?

--
Richard Huxton
Archonet Ltd

---------------------------(end of

broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your message can get through to the mailing list cleanly

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

Nov 22 '05 #7
> Hi everyone,
Hello!

Anyone have PostgreSQL running on a cluster? Yes. Someone :) Me :) I'm trying to run on a OpenMosix 2-machine cluster but the processes are
not migrating. The solution you are looking for is depending on what you want to get
srom it. I mean even oracle cluster solution do not allow to migrate
updates if while update is going on the hardware fail happend. It
migrate to a second node and all selects are starting from the beginning
and update and inserts are canselled (as far as i know).
So to find a solution you should know:
1. How much time your database could be unavailable (one second per year
or one hour per day)
2. Does your application could recoonect to a database if the problem arise.
3. Does your application is cappable to check data consistancy (after
insert, update whatever if fail happend)
.............
1001.
As for me i answerred all that questions and have the following
configuration:
1. Two Intel SRKA4 machines with RAID1 for OS and RAID5 for databasee (i
know that RAID5 is too slow but for me it is just a solution)
2. Bouth computers connected to different power feeders via different UPSs.
3. I have 3 dedicated Gigabit ethernet connections established between
computers for data mirroring and two more for data access from the network.
4. Red Hat Linux8 installed it is a pitty thing because i'm using
FreeBSD on all other servers but DRBD is available only for linux.
5. All disks being mirrored over a network using DRBD software.
All database drives are configured to write data to remote node first
(Protocol C).
6. Hardware being monitored with heartbeat software that is configured
to send beats each second and if 2 heartbeats are missing it consider it
is as hardware mulfunction
7. Postgress migrating from one computer to another in 5 seconds.
8. There is a special daemon that controlls data consistancy.

Best regards,
Anton All the load is concentrating in one machine.
And, how can I have fail over?

Thank you,

Luiz

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

Nov 23 '05 #8

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

Similar topics

20
2453
by: My Internet | last post by:
Hello, I am in the process to define if our product can use PostgreSQL. Do you know what type of application use PostgreSQL, and also what is the size of the database for these projects? Our application has a table with more than 300000 rows. There are complexe query with many joins. And we must respect some time constraints. Also the application is running 24 hours per day, so the product must be stable, with
59
7230
by: Jeff Bowden | last post by:
For ease of configuration and other reasons, I would like for my single-user GUI app to be able to use postgresql in-process as a library accessing a database created in the users home directory. I think I could possibly get what I want by launching a captive copy of postmaster with appropriate args but it seems conceptually cleaner to not have a seperate process at all. Has anyone tried to do anything like this? I've looked at sqlite...
1
1110
by: phil campaigne | last post by:
On Mon, 1 Mar 2004, phil campaigne wrote: >> Nigel J. Andrews wrote: >> > > >>> >On Mon, 1 Mar 2004, Phil Campaigne wrote: >>> > >>> >
1
1474
by: Nilabhra Banerjee | last post by:
Hi friends, I am loading Potsgresql in shared hard disks. The Disk cluster is shared by two nodes. The nodes can access the disks asynchronously, i.e, the node coming up first gets disk. I have loaded the postgresql in local disk of one node and issued initdb command to put the datapath in shared disk and then created database. Right now I am installing postgresql in local disk of node 2, that must point to the same database in shared
2
2812
by: Jim Worke | last post by:
Hi list, My boss would like to convert from MySQL to PostgreSQL, but there are a few things that hold us back. We'd like to have the databases in several physical servers, with referential integrity between the tables. Reading from Oracle articles, their referential integrity can be done using their dblink and triggers. What I'd like to ask is whether contrib/dblink is stable? Seeing dblink in a contrib directory does bring a doubt...
2
9772
by: SmoothJazz | last post by:
Hi All! I am wanting to setup/run PostgreSQL on my server (a SuSE Linux 9.2 distro) but I'm not quite sure which way to go. I have a few books on PostgreSQL but they don't seem to match the way SuSE has installed it. The books explain how to install/make/etc. and then how to setup a "cluster". The directory structure differs alot from the SuSE install.
1
4957
by: bmt | last post by:
I intend to set up a large database with PostgreSQL: about 1.3 TB, very basic queries (but 1500 per second at peak charge), and most probably only a single one index. The overall application, which is rather simple, should react in less than 3 seconds, 80% of the time. Meaning that if the database gives a mean response time of more than 0.5 second, I am fully dead... I plan to set up a distributed cluster N+1. Each node of the cluster stores...
1
4783
by: foneman | last post by:
I'm running Sambar 7.0, PHP 5.2 and PostgreSQL 8.2 with WinXP. I built a database that's fed with form data, and created summaries with views and PHP scripts. I cloned the database two different ways. One way used pg_dump out of the existing and pg_restore into the new, the other method was to maually execute the SQL to create all the objects. Using the same summary script edited to point to the other database no matter how it was created takes...
1
5992
by: Kreshna | last post by:
I need to compile PostgreSQL 8.3.5 on CentOS 4.2. The CentOS already has PostgreSQL 7 installed as part of its default installation. For some reason, I cannot touch the existing PostgreSQL (upgrading, etc) --I really need to use my own compilation of PostgreSQL. Is it possible to have multiple installations of PostgreSQL (and different version too) on the same server? At least in theory, I should use a different port for my own PostgreSQL...
0
9668
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
10843
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
10546
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
10589
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
10254
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...
1
7790
isladogs
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...
0
5825
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4448
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
2
4015
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.