LVS
lvs-users
Google
 
Web LinuxVirtualServer.org

Re: LVS and SQL databases (PostgreSQL)

To: "LinuxVirtualServer.org users mailing list." <lvs-users@xxxxxxxxxxxxxxxxxxxxxx>
Subject: Re: LVS and SQL databases (PostgreSQL)
From: "Jacob Coby" <jcoby@xxxxxxxxxxxxxxx>
Date: Tue, 28 Oct 2003 12:01:41 -0500
> I'm about to install (in a month or so) LVS in a test environnement
> before installing it in a production one.
>
> Two questions : the first one is about databases like PostgreSQl :
>
> Does LVS can handle load balancing for an SQL database or is it
> mandatory to use pgreplication (Postgres-R project) for a PostgreSQL
> database?

LVS wouldn't have any problem handling the load balancing.  However, you
need to take into account concurrency and cross database updates when
working with write access.  Read-only access shouldn't have any problems.

> A last question : LVS and sessions (like in PHP) : can we use LVS in a
> production environnement in such a context (with sessions)?

I don't remember exactly how PHP sessions work, but I think if you were to
host the stored session directory (session.save_path) on a NFS/SMB share,
you wouldn't have any problems.

-Jacob
Listingbook.com

<Prev in Thread] Current Thread [Next in Thread>