Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chih
Posting Yak Master
154 Posts |
 Posted - 2013-05-08 : 03:25:11
|
| Hi all,My company is planning to launch a website/mobile app in different countries. As data need to be sync between different countries, what is the best architecture to setup database? i am wondering how facebook does. Anyone can give me a light? or article i can readThanks in advance |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2013-05-08 : 04:57:27
|
| Replication would be one option.mohammad.javeed.ahmed@gmail.com |
 |
|
|
chih
Posting Yak Master
154 Posts |
Posted - 2013-05-16 : 20:26:03
|
mmm...If one site is in Aus and one is in US, will it have delay using replication? Do I need to setup link between 2 sites?quote:
Originally posted by ahmeds08
Replication would be one option.mohammad.javeed.ahmed@gmail.com
|
|
|
|
Ifor
Aged Yak Warrior
700 Posts |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2013-05-17 : 06:45:32
|
This isn't something that sql server is traditionally good at. At least in comparison to some different datastores I've used. There are products such as CouchDB that have merge / merge synchronization as key principals.what kind of data needs synchronizing?How much delay is acceptable for cross country / continent replication?If you are storing session state or other key/value type information and need to synch that, then you may want to consider looking into a distributed key value store instead.Have a look at RIAK Enterprise.http://basho.com/riak-enterprise/I love riak's scaling model and how it performs under failure conditions.Transact CharlieMsg 3903.. The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. http://nosqlsolution.blogspot.co.uk/ |
|
|
|
|
|
|
Distributed Database Architecture