Re: [Openinteract-dev] SPOPS and MySQL replication

[Andreas N. <an...@kl...>]

Hi Greg,

we use OI as an application server for our internal applications ( 20-30,
e.g. callcenter crm type applications, order entry, digital imaging, etc. )
with about 1000 concurrent users. Each app usually has it`s own database (
some MySQL, some Oracle, some MSSQL ), but the what always gets shared are
the OI tables themselves ( sys_security, sys_error etc. ).

The reason for thinking about replication is availability ( .. ahem - just
had a very unpleasant hardware issue... ), mainly for read access, since
apart from the session table most system tables are not used that much by
our applications.

But for your proposal of some kind of proxy: that of course would be also a
good idea. Do you have a concrete suggestion ( e.g. package  / product ) ?
We plan to look at the MySQL Cluster, which is coming up, and also at the
Linux Virtual Server, but none of these is readily available, it seems.

Therefore: any hints / ideas are very welcome....

cheers,

Andreas
----- Original Message ----- 
From: "Greg Fenton" <gre...@ya...>
To: <ope...@li...>
Sent: Thursday, July 15, 2004 3:37 PM
Subject: Re: [Openinteract-dev] SPOPS and MySQL replication


> --- Andreas Nolte <an...@kl...> wrote:
> >
> > Actually I`d be surprised if SPOPS could do this out of the box
> > already, but I am sure it could be extended to use one database
> > handle for reading objects and anotherone for writing.
> >
>
> So you are planning on running one server w/ OI and/or SPOPS connected
> to multiple mysql servers?  Have you determined that the bottleneck
> truly is mysql?
>
> Have you considered having multiple OI servers with a Proxy server in
> front that is pushing all write requests to server and load-balancing
> read requests to others?
>
> This would avoid complicating the SPOPS design (I'm making the same
> assumption as you that SPOPS is not designed for separate db
> connections, one for writes and multiple for reads).
>
> greg_fenton.
>
> =====
> Greg Fenton
> gre...@ya...
>
>
>
> __________________________________
> Do you Yahoo!?
> Read only the mail you want - Yahoo! Mail SpamGuard.
> http://promotions.yahoo.com/new_mail
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by BEA Weblogic Workshop
> FREE Java Enterprise J2EE developer tools!
> Get your free copy of BEA WebLogic Workshop 8.1 today.
> http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
> _______________________________________________
> openinteract-dev mailing list
> ope...@li...
> https://lists.sourceforge.net/lists/listinfo/openinteract-dev
>