All Questions

Filter by
Sorted by
Tagged with
0
votes
0answers
64 views

Data integrity in one-to-many distributed architecture

We are a retail shop that has a central data repository which collects data continuously from geographically distributed 1500 odd servers (each store has one SQL Server instance). Like a one to many ...
-1
votes
1answer
217 views

Archiving strategy

I have an instance with only one database which contains 4 years of data (400 gigas). I name this instance inst_live I want to implement this following archiving strategy: create an archive instance (...
1
vote
0answers
176 views

Mysql multisource replication : on slave map masters dbname to something like mastername-originaldbname

I need to implement a mysql multisource replication using mysql >=5.7.11, there are already a certain number of mysql servers running which will become masters for the single slave which is going to ...
1
vote
0answers
44 views

Real-time Synchronization [duplicate]

I have created an application in .Net with Microsoft SQL Server for desktop with a local database and an online application with an online database. Data entry will be done on both platforms in real-...
2
votes
1answer
279 views

Which databases can meet these replication requirements?

I am doing research on database architectures, and I am looking for which software can meet my requirements. To try to explain the requirements simply: You have a master database server. This may ...
1
vote
1answer
125 views

MySQL - Migrating from Master-Slave replication to Master-Master

We currently run 2 large mysql master-slave replication trees. Each tree is built with one master, several 'middle' slaves replicating from the master, and 'end' slaves replicating from the 'middle' ...
7
votes
2answers
2k views

Is a geographically distributed application with SQL Server replication a good idea?

We are currently thinking about a target architecture for a geographically distributed application. This application tracks and schedules the movements of all material units across various production ...
1
vote
1answer
1k views

Is there an easy way to replicate MySQL data?

My software is deployed in various cities, each have a database, but they have different authorizations such as: central DB /\ / \ DB1 ...
0
votes
2answers
410 views

Need advises for a new MySQL architecture

I need to deploy a MySQL-based application with the following requirements and would love to receive some guidance (any) as to how I could set things up: Scale of deployment 5 servers with a latency ...
8
votes
1answer
10k views

MySQL high availability, failover and replication with Latency

We are in the process of implementing a new CMS (Drupal 6.x) that runs on MySQL. We have two data centers -- primary and secondary -- with known latency between them. We're unsure which version of ...