Click here to Skip to main content
14,836,169 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have the database where many connections is serviced in the same time (reading, writing)
My idea to unload the connections is to create a replica of my DB. So that, I have 2 DBs one for writing, second for reading.-

- could you tell me the way how to synchronize these DB ?

- maybe you know a better idea to solved that problem with overwhelmed database problem ?

What I have tried:

Try to find smth on the internet.
Posted
Updated 17-Sep-20 10:54am
Comments
Sandeep Mewara 18-Sep-20 0:29am
   
Read about database Replication.

1 solution

I can't really see the "Read DB" and "Write DB" idea working in practice: when you write to a multiuser DB any other user should be able to read the new info pretty much immediately.

You might want to consider a server farm or cluster instead.
Server farm - Wikipedia[^]
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900