I need a multi master database to let users talk from different continents. Each user will write his data to his local master database and it will replicate data to other master databases in other counties/continents.
The problem is that I can't store all copies of all users data in all data centers. I need something like a database/solution which will let me to set a replication level.
I need to have ability read any data from any nodes but store data on several nodes (on 3 nodes but not on all nodes).
Is there the solution? Maybe a proxy between database and application or a clever cluster? Any ideas or tips will be pleasant
相关问题
- NOT DISTINCT query in mySQL
- Flush single app django 1.9
- keeping one connection to DB or opening closing pe
- Mysql-installer showing error : Memoy could not be
- Android Room Fetch data with dynamic table name
相关文章
- Connection pooling vs persist connection mysqli
- Stacktrace does not print in Glassfish 4.1 Cluster
- Speed up sqlFetch()
- How Do I Seed My Database in the setupBeforeClass
- I set a MySQL column to “NOT NULL” but still I can
- Where in Django can I run startup code that requir
- Google OAuth 2.0 User id datatype for MYSQL
- Restore deleted records in PostgreSQL
You could use a distributed cache to achieve this result. Check out how they work under WAN replication strategies.
For example, check out NCache Wan replication (Bridge)
PS: A distributed cache keeps all of the data in memory for performance reasons. You could persist it as well.