Thread: Re: [HACKERS] High Availability, Load Balancing, and Replication Feature Matrix

Re: [HACKERS] High Availability, Load Balancing, and Replication Feature Matrix

From
Bruce Momjian
Date:
Hannu Krosing wrote:
>
> ?hel kenal p?eval, N, 2007-11-08 kell 14:24, kirjutas Bruce Momjian:
> > [ BCC to hackers.]
> >
> > I have added a High Availability, Load Balancing, and Replication
> > Feature Matrix table to the docs:
> >
> >     http://momjian.us/main/writings/pgsql/sgml/high-availability.html#HIGH-AVAILABILITY-MATRIX
>
> Would you also put a section about pl/proxy in there ?
>
> It is and opensource solution providing virtually unlimited
> shared-nothing type scalability (similar to farms of webservers) for a
> limited set of data configurations and db programming styles.
>
> I try to come up with something relatively simple, on level with other
> explanations

I added this in the section "Statement-Based Replication Middleware":

    Also, this can be implemented using the PL/Proxy toolset.

In context:

    http://momjian.us/main/writings/pgsql/sgml/high-availability.html


--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

Re: Re: [HACKERS] High Availability, Load Balancing, and Replication Feature Matrix

From
"kalyan venishetty"
Date:
Hi all,
 
Can any one Provide me about the RAC server and FGAC(Fine Grained Access Control) and how to implement in the companies.
 
If some body can provide me , It would be great help for me.
 
Thanks in advance,
 
Kalyan

 
On 11/8/07, Bruce Momjian <bruce@momjian.us> wrote:
Hannu Krosing wrote:
>
> ?hel kenal p?eval, N, 2007-11-08 kell 14:24, kirjutas Bruce Momjian:
> > [ BCC to hackers.]
> >
> > I have added a High Availability, Load Balancing, and Replication
> > Feature Matrix table to the docs:
> >
> >     http://momjian.us/main/writings/pgsql/sgml/high-availability.html#HIGH-AVAILABILITY-MATRIX
>
> Would you also put a section about pl/proxy in there ?
>
> It is and opensource solution providing virtually unlimited
> shared-nothing type scalability (similar to farms of webservers) for a
> limited set of data configurations and db programming styles.
>
> I try to come up with something relatively simple, on level with other
> explanations

I added this in the section "Statement-Based Replication Middleware":

       Also, this can be implemented using the PL/Proxy toolset.

In context:

       http://momjian.us/main/writings/pgsql/sgml/high-availability.html


--
Bruce Momjian  <bruce@momjian.us>        http://momjian.us
EnterpriseDB                             http://postgres.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster



--
With Regards
venishetty kalyan kumar
kalyan venishetty wrote:
> Hi all,
>
> Can any one Provide me about the RAC server and FGAC(Fine Grained Access
> Control) and how to implement in the companies.

Did you read all of:

    http://momjian.us/main/writings/pgsql/sgml/high-availability.html

Are you saying you need "Synchronous Multi-Master Replication"?  Why?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +