D
D
Dmitry Gavrilenko2017-04-07 00:44:52
.NET
Dmitry Gavrilenko, 2017-04-07 00:44:52

Database synchronization?

Hi all. I work for a large and rapidly growing company. We have a huge database, which is divided into 2 data centers and many wheelbarrows. In general, there is a task to synchronize data between databases.
1 - Azure Fabric Service is a cool solution, very flexible and allows you to make a practically indestructible layer with microservices
2 - Windows service. The service starts, checks in the database for new data provided from a special table, looks in the settings for where to transfer, and in N-number of threads transfers data from one database to another.
PS: An endless loop is just spinning, which every 5 seconds checks which databases have changed, takes out parameters that have instructions where to fill in this data. And that's all.
The above is used by colleagues, but in a different project.
The advantages of the first one are that there are specific microservices that perform their tasks. You can run them in several instances, make a cluster and spin them as soon as it comes into your head.
The second one has no advantages, but it is a quick option in terms of implementation.
It needs to be done quickly, but I would like to organize all this qualitatively. There was an idea to promote it on .NET Core + Docker, but it seems to me that we won’t be able to meet the deadlines.
In general, maybe you have ever done something like copying databases and have some interesting experience, write what you came up with and what eventually came out of it. Maybe there is a ready-made framework or something else.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Axian Ltd., 2017-04-07
@AxianLTD

The question was here - stackoverflow.com/questions/2639096/sql-server-and...
In order not to invent crutches (and the IMHO solution you described are ordinary crutches), you can read about MS SQL scaling here https://msdn.microsoft.com /en-us/library/aa479364.aspx

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question