Обсуждение: Shared Database across multiple servers using OCFS2
Hi there, Does anyone know if it is possible to share a single database across multiple machines each running a database server using OCFS2? Thanks in advance, Kind regards, Henry ___________________________________________________________________________________________________ �The information contained in this e-mail is confidential and may contain proprietary information. It is meant solely for the intended recipient. Access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted in reliance on this, is prohibited and may be unlawful .No liability or responsibility is accepted if information or data is, for whatever reason corrupted or does not reach its intended recipient. No warranty is given that this e-mail is free of viruses. The views expressed in this e-mail are, unless otherwise stated, those of the author and not those of FirstRand Bank Limited or its management. FirstRand Bank Limited reserves the right to monitor, intercept and block e-mails addressed to its users or take any other action in accordance with its e-mail use policy. Licensed divisions of FirstRand Bank Limited are authorised financial service providers in terms of the Financial Advisory and Intermediary Services Act 37 of 2002.� ___________________________________________________________________________________________________
Kleynhans, Hendrik wrote: > Hi there, > > Does anyone know if it is possible to share a single database across > multiple machines each running a database server using OCFS2? Are you: 1. Looking to spread disk-accesses over several machines, or 2. Looking to run multiple PostgreSQL server against the same database? You might be ok with #1, but not #2. -- Richard Huxton Archonet Ltd
Hi Richard, : Are you: : 1. Looking to spread disk-accesses over several machines, or : 2. Looking to run multiple PostgreSQL server against the same : database? : : You might be ok with #1, but not #2. Thanks for the quick response. I am looking at #2, but I could not find anything from my searches. If I am looking to access large amounts of data, such as in a data center, would it be better to run a/several database servers and accessing them across the network? Kind regards, Henry ___________________________________________________________________________________________________ �The information contained in this e-mail is confidential and may contain proprietary information. It is meant solely for the intended recipient. Access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted in reliance on this, is prohibited and may be unlawful .No liability or responsibility is accepted if information or data is, for whatever reason corrupted or does not reach its intended recipient. No warranty is given that this e-mail is free of viruses. The views expressed in this e-mail are, unless otherwise stated, those of the author and not those of FirstRand Bank Limited or its management. FirstRand Bank Limited reserves the right to monitor, intercept and block e-mails addressed to its users or take any other action in accordance with its e-mail use policy. Licensed divisions of FirstRand Bank Limited are authorised financial service providers in terms of the Financial Advisory and Intermediary Services Act 37 of 2002.� ___________________________________________________________________________________________________
Kleynhans, Hendrik wrote: > Hi Richard, > > : Are you: > : 1. Looking to spread disk-accesses over several machines, or > : 2. Looking to run multiple PostgreSQL server against the same > : database? > : > : You might be ok with #1, but not #2. > > Thanks for the quick response. > > I am looking at #2, but I could not find anything from my searches. PostgreSQL backend processes communicate using shared memory - if you can't manage that between different machines then it won't work. > If I am looking to access large amounts of data, such as in a data > center, would it be better to run a/several database servers and > accessing them across the network? Difficult to say without more information. You'll need to know how much data, what queries, how many at one time etc. You might want to check the mailing-list archives (particularly the performance list) and see if any other users have a similar setup to that which you are planning. -- Richard Huxton Archonet Ltd
On Jan 25, 2006, at 18:43 , Kleynhans, Hendrik wrote: > If I am looking to access large amounts of data, such as in a data > center, would it be better to run a/several database servers and > accessing them across the network? If you want *access* (i.e., select only, not modifying data), you might want to look at Slony for database replication. You can have your applications access the slaves. All modification would be done on the master. http://gborg.postgresql.org/project/slony1/projdisplay.php Michael Glaesemann grzm myrealbox com
Kleynhans, Hendrik wrote: <snip> > ___________________________________________________________________________________________________ > > “The information contained in this e-mail is confidential and may contain proprietary information. > It is meant solely for the intended recipient. Access to this e-mail by anyone else > is unauthorised. If you are not the intended recipient, any disclosure, copying, > distribution or any action taken or omitted in reliance on this, is prohibited and > may be unlawful .No liability or responsibility is accepted if information or data is, > for whatever reason corrupted or does not reach its intended recipient. No warranty is > given that this e-mail is free of viruses. The views expressed in this e-mail are, unless > otherwise stated, those of the author and not those of FirstRand Bank Limited or its management. > FirstRand Bank Limited reserves the right to monitor, intercept and block e-mails addressed > to its users or take any other action in accordance with its e-mail use policy. > Licensed divisions of FirstRand Bank Limited are authorised financial service providers > in terms of the Financial Advisory and Intermediary Services Act 37 of 2002.” > > ___________________________________________________________________________________________________ > That has got to be one of the longest disclaimers I've ever seen in an email...