Re: [Openinteract-dev] SPOPS and MySQL replication

[Greg F. <gre...@ya...>]

--- 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