Menu
▾
▴
openinteract-dev
|
From: Andreas N. <an...@kl...> - 2004-07-15 11:20:24
|
Hi all, we are thinking about redundancy and scaling up once again.=20 One possible solution we are thinking about is using MySQL master / = slave replication, where you have one master, which handles the write = requests, and multiple read only slaves. My question is, if anyone has used OI/SPOPS in such an environment or = otherwise has any ideas concening the usage of SPOPS in such an = environment. 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. Any comments welcome. Andreas |
|
From: Greg F. <gre...@ya...> - 2004-07-15 13:37:33
|
--- 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 |
|
From: Andreas N. <an...@kl...> - 2004-07-15 14:13:42
|
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 > |
|
From: Greg F. <gre...@ya...> - 2004-07-15 17:04:57
|
--- Andreas Nolte <an...@kl...> wrote: > > 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 ) ? > For a Proxy server, I was simply thinking of either Apache or Squid. This assumes you are using HTTP to access OI. greg_fenton. ===== Greg Fenton gre...@ya... __________________________________ Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! http://promotions.yahoo.com/new_mail |
|
From: Andreas N. <an...@kl...> - 2004-07-15 17:19:11
|
Am Do, den 15.07.2004 schrieb Greg Fenton um 19:04: > For a Proxy server, I was simply thinking of either Apache or Squid. > This assumes you are using HTTP to access OI. > > greg_fenton. > > ===== > Greg Fenton > gre...@ya... > .. well, we already using multiple OI "application servers" to which the users are currently directed to via round robin dns. The app servers use a mounted NFS filesystem, so they stay in sync. Our problem comes later, when these application servers access the "main" OI database, which is MySQL... |
|
From: Vsevolod (S. I. <si...@cs...> - 2004-07-15 22:34:53
|
You probably want memcached: http://www.linuxjournal.com/article.php?sid=7451 SPOPS supports caching (there is a bug to be fixed there, though), and you should be able to plug in MemCache there. Simon Andreas Nolte wrote: > Am Do, den 15.07.2004 schrieb Greg Fenton um 19:04: > > >>For a Proxy server, I was simply thinking of either Apache or Squid. >>This assumes you are using HTTP to access OI. >> >>greg_fenton. >> >>===== >>Greg Fenton >>gre...@ya... >> > > .. well, we already using multiple OI "application servers" to which the > users are currently directed to via round robin dns. The app servers use > a mounted NFS filesystem, so they stay in sync. Our problem comes later, > when these application servers access the "main" OI database, which is > MySQL... > > > > ------------------------------------------------------- > 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 > -- Simon (Vsevolod ILyushchenko) si...@cs... http://www.simonf.com Terrorism is a tactic and so to declare war on terrorism is equivalent to Roosevelt's declaring war on blitzkrieg. Zbigniew Brzezinski, U.S. national security advisor, 1977-81 |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X