From: Anupam Karmarkar Date: May 24 2012 10:39am Subject: Re: Architectural Help List-Archive: http://lists.mysql.com/mysql/227529 Message-Id: <1337855965.99079.YahooMailNeo@web193501.mail.sg3.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-1439325297-1963907961-1337855965=:99079" ---1439325297-1963907961-1337855965=:99079 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Dear Nigel,=0A=0AThank for reply.. =0A=0A=0ASee my comments below=0A=0A=0A-= -Anupam=0A=0A=0A________________________________=0A From: Nigel Wood =0ATo: Anupam Karmarkar ; "mysql@stripped= ysql.com" =0ASent: Thursday, 24 May 2012 3:35 PM=0A= Subject: RE: Architectural Help=0A =0AA few questions:=0Awhich is more or a= problem: network outages, network capacity or query latency? =0A>>Network = Outages is problem, between data centres=0AWhen you say "near real-time" do= you need transactional consistent view on all 49 servers or can some lag b= e tolerated?=0A>>Some lag can be tolerated considering network outage =0ACa= n any one of the 49 local servers potentially update/delete the same rows o= r data?=0A>>Yes central server can update same row or local server but not = at same time,=A0 Few data will be updated in central location and others ma= jorly in local.One Application Writes in Centeral and Others in local, Loca= l app and central app shares some data.=0AIs there any natural segmentation= point within the data? =0A>>No=0ADo the data centers have diverse networks= so that connections to some data centers may remain when others? =0A>>Yes,= we have diverse nework , so connectivity will be avaiable in other data ce= nters.=0AIn the event that a local data centre is totally isolated from the= others what data should it be allowed to update?=0A>>Loca application shou= ld always write in local database, Central Application Updated will not be = available to local.=0ADo your applications produce/examine=A0 large data se= t querying by secondary keys or using tull text search?=0A>>We dont have te= xt search or we dont query large data=0AAre you in a position to modify the= applications?=0A>>No, Micro changes ok=0A_________________________________= _=0AFrom: Anupam Karmarkar [sb_akarmarkar@stripped]=0ASent: Thursday, May = 24, 2012 10:17 AM=0ATo: mysql@stripped=0ASubject: Architectural Help= =0A=0AHi All,=0A=0A=0AI need architectural help for our requirement,=0A=0A= =0AWe have nearly 50 data centre through out different cities from these da= ta center application connect to central database server currently, there a= re conectivity and nework flcutions issues for different data center, so we= comeup with solution each data center we should have local database server= which will keep syncing with other server so that application doesnt fail = , User data can be updated in any of server and should reflect in every ser= ver.=A0 Application consists of write/read/delete operations,=0A=0A=0ACurre= nt writes each day central server 1million.=0A=0A=0AOnly 1/1000 need to be = distrubuted acrross servce rest need to be in central server.=0A=0A=0AHow c= an we achive this ? solution needs very much real time data accepting newor= k lags.=0A=0A=0ASolution=0A=0ACollect all changes in other 49 server into 1= central server(How can we collect data)=0A=0A=0A49 keeps updating data int= o local database from central server(Using Repliation Can be done)=0A=0A=0A= =0A--Anupam=0A=0A--=0AMySQL General Mailing List=0AFor list archives: http:= //lists.mysql.com/mysql=0ATo unsubscribe:=A0 =A0 http://lists.mysql.com/mys= ql ---1439325297-1963907961-1337855965=:99079--