c# - Caching architecture advise for a specific scenario -

-

setup:

we have .net application distributed on 6 local servers each local database(oracle), 1 main server , 1 load balance machine. requests come load balancer redirects incoming requests 1 of 6 local servers. in time intervals data gathered in main server , redistributed 6 local servers able make decisions complete data.

each local server has cache component caches incoming requests based on different parameters (location, incoming parameters, etc). each request local server decides whether go database (oracle) or response cache. in both cases local server has goto database 1 insert , 1 update per request.

problem:

on peak day each local server receives 2000 requests per second , system starts slowing down (cpu: 90% ). trying increase capacity before adding local server mix. after running benchmarks bottleneck is, seems inevitable 1 insert , 1 update per request database.

tried methods

to able decrease frequency have created windows service sits between db , .net application. contains pipe server , receives each insert , update main .net application , saves them in hashtable. new service @ time intervals goes database once batch inserts , updates. point go database less frequently. although had positive effect didn't benefit system load as expected. of cpu load comes oracle.exe requests per second increase.

i trying avoid going database as can , way avoid db seems increasing cache hit ratio other above mentioned solution tried. cache hit ratio around 81 % percent currently. because each local machine has own cache missing lots of cacheable requests. when 2 similar requests redirects different servers second request cannot benefit cached result of first one.

i don't have lot of experience in system architecture appreciate problem. suggestions on different caching architectures or setup, or tools welcome.

thank in advance, made question clear.

for me looks application timesten solution. in case can eliminate local databases , return one. have local oracle databases, can implement cache grid. going awt (async, write through) cache. see oracle in-memory database cache concepts it's not cheap option if worth investigating. can keep concentrating on business logic , have no worries speed. of course works good, if aplication code tuned , sql performant , scalable. sql has prepared (using bind variables) have best performance. application connects cache , no longer database. create cache tables in cache group want have caching. tables in sql should cached, otherwise, complete sql passed through oracle database. in grid cache fusion mechanism in place have no worries data in grid located. in current release support .net included. data consistent , asynchronously updated oracle database. if data needed in cache , take oracle database down, app can keep running. database again, synchronization pick again. powerful.


Comments

Post a Comment

Popular posts from this blog

php - What is the difference between $_SERVER['PATH_INFO'] and $_SERVER['ORIG_PATH_INFO']? -

-
what’s difference between $_server['path_info'] , $_server['orig_path_info'] ? how use them? when run print_r($_server) , path_info , orig_path_info not present in array. why not? how can enable them? i have read php manual on them, still don’t understand them. the path_info variable present if invoke php script this: http://www.example.com/phpinfo.php/hello_there it's /hello_there part after .php script. if don't invoke url that, there won't $_server["path_info"] environment variable. the porig_ prefix uncommon. path_info standard cgi-environment variable, , should never prefixed. did read that? (there issues around php3/php4 if invoked php interpreter via cgi-bin/ - hardly has such setups today.) for reference: http://www.ietf.org/rfc/rfc3875
Read more

fortran - Function return type mismatch -

-
i'm attempting recode old c++ program in fortran make use of lapack (i'm aware c++ have lapack++, i'm having lot of trouble installing it, gave up). i didn't have problems compilation, when had variables declared real . when started coding section of program required lapack, found parameters passed dsyev need double precision . tried change double precision (including changing hard coded numbers double precision counterparts, i.e. 0.0 -> 0.0d0) when try compile, following error of functions , subroutines i've written: error: return type mismatch of function <function> @ (1) (real(4)/real(8)) i'm not sure coming from, in program has been changed double precision. for example, i've declared following: double precision :: alpha(3),d(3),zeta1,zeta2 double precision :: a1(3),a2(3),d1(3),d2(3) double precision :: pi pi = 3.14159265359d0 alpha = (/0.109818d0, 0.405771d0, 2.22766d0/) d = (/0.444635d0, 0.535328d0, 0.154329d0 /) 10 i=1,3 ...
Read more

queue - mq_receive: message too long -

-
i implementing communication between 2 processes using queue. problem when call function mq_receive, error: message long. i have done following: struct mq_attr attr; long size = attr.mq_msgsize; .... // initializing queue "/gateway" int rc = mq_receive(gateway, buffer, size, &prio); if print size value, size=1, while when print same size program (got same mechanism), not long integer ( -1217186280 )... how can solve error?....so while size = 1, believe it's right "message long" why 1? p.s. have tried put : int rc = mq_receive(gateway, buffer, sizeof(buffer), &prio); but no result. it seems need read docs more carefully. when call mq_receive should pass size of destination buffer. this size must greater mq_msgsize attribute of queue . in addition, seems have error in queue attributes initialisation makes proper mq_receive call impossible. here standard message queue session: fill mq_attr struct ( doc ): struct mq_a...
Read more