From: Anupam Karmarkar
Date: May 24 2012 9:17am
Subject: Architectural Help
List-Archive: http://lists.mysql.com/mysql/227526
Message-Id: <1337851032.11827.YahooMailNeo@web193503.mail.sg3.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="1898624822-1904863826-1337851032=:11827"

--1898624822-1904863826-1337851032=:11827
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi All,=0A=0A=0AI need architectural help for our requirement, =0A=0A=0AWe =
have nearly 50 data centre through out different cities from these data cen=
ter application connect to central database server currently, there are con=
ectivity and nework flcutions issues for different data center, so we comeu=
p 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 server.=
=A0 Application consists of write/read/delete operations, =0A=0A=0ACurrent =
writes each day central server 1million. =0A=0A=0AOnly 1/1000 need to be di=
strubuted acrross servce rest need to be in central server.=0A=0A=0AHow can=
 we achive this ? solution needs very much real time data accepting nework =
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 into=
 local database from central server(Using Repliation Can be done)=A0=0A=0A=
=0A=0A--Anupam=0A
--1898624822-1904863826-1337851032=:11827--