Stack Overflow
Stack Overflow

Questions tagged [database-replication]

Database replication is used to ensure consistency between redundant databases and to improve reliability and increase fault-tolerance. The replication process commonly involves continuously duplicating a "master" database to one or more additional "slave" databases.

Database replication can be used on many database management systems, usually with a master/slave relationship between the original and the copies. The master logs the updates, which then ripple through to the slaves. The slave outputs a message stating that it has received the update successfully, thus allowing the sending (and potentially re-sending until successfully applied) of subsequent updates.

1836 questions
0
votes
1 answer

can we replicate Cross Region Replication (CRR) across more than 2 regions?

Cross Region Replication is one of the 2017 updates for DynamoDB.To experience with it, I used AWS Management Console to replicate my database once. Just wondered if anybody knows how to replicate it across more than 2 regions? Thanks
shirin
  • 152
  • 1
  • 14
0
votes
1 answer

Azure Data Sync Clustered Index Error

We are trying to setup an Azure Database Sync group to replicate our data from an on-premise server to an Azure SQL database. This as a first step for a migration to Azure. The Sync Group and Sync Agent have all been set up. When we press the…
Fluffymittens
  • 170
  • 7
0
votes
0 answers

SQL Server 2012 Replication web synchronisation snapshot failing

We're trying to build a new enviroment which replicates our existing setup. We're using sql server 2012 sp3, old servers were windows server 2008 new ones are 2016. One server works fine, but the issue we have with the new environment is that when…
Jim
  • 479
  • 2
  • 8
0
votes
1 answer

How to disable read permission on couchdb database

The problem is I have multiple couchdb local clients databases say A_db, B_db, C_db which is replicating to a couchdb server master database says server_db. Now each client is creating a document say A_doc, B_doc, C_doc in their local db which…
atultherajput
  • 175
  • 3
  • 18
0
votes
0 answers

Publishing a "standby / read-only" database

Every hour, we receive a database backup file via SFTP from a third-party vendor. We restore that database locally as a read-only database. The data in this database is an extract of our company's data from their web application. We restore it…
Eliezer
  • 429
  • 1
  • 9
  • 20
0
votes
1 answer

Questions about data loss with inactive subscription - SQL Server 2008

I have the databases A and B, A publish some tables to B, and the subscription to B is with error: ... has been marked as inactive and must be reinitiated... error 21704 There's very sensitive data on those databases, and I'm trying to figure out…
Felipe Bandeira
  • 3
  • 4
0
votes
0 answers

Oracle - synchronise tablespace schema changes to another tablespace from the same database

I am using two tablespaces from the same Oracle database (11g), one is tablespace A, the other is B. I'd like to set a daily planified task which would alter the tablespace B in order to integrate the changes made to the tablespace A during the day…
Antoine
  • 55
  • 1
  • 7
0
votes
1 answer

How does AWS RDS replication handle curdate() and other date-sensitive commands?

It looks as if AWS handles RDS MySQL replication by executing the same commands on the replicas that were executed on the master. However, our replicas are currently lagging by about 24 hours due to large volumes. How does the replication process…
Bruce
  • 2,406
  • 5
  • 29
  • 35
0
votes
1 answer

Number of masters for particular slave in multi source Replication MySQL?

Mysql has launched a new feature that a single slave server has multiple master server in which replication can be handled with the help of flag called channel for each separate master server. I want to know: What's the max number of master a slave…
Aman Aggarwal
  • 17,619
  • 9
  • 53
  • 81
0
votes
0 answers

does galera setup cause db down and slower db read?

recently I realized after I setup master to master replication using galera, my db seems to be loading slower than usual. Also, sometimes it cannot be connected. I am currently using django and I have it setup that if main DB cannot be connected…
Dora
  • 6,776
  • 14
  • 51
  • 99
0
votes
0 answers

Amazon RDS: Automatically Changing Replication Role During Import

I created an RDS instance on AWS (Aurora MySQL with replication). When I start importing an SQL file into the database I get an error message ERROR 2013 (HY000) at line 2805: Lost connection to MySQL server during query and AWS changes the…
Zvonimir Burić
  • 528
  • 3
  • 11
0
votes
1 answer

Can I just play relay logs as sql file?

Can I just play relay logs as sql file? I have a server that is lagging for 3 months from master now. I was thinking can I just record the log position from relay logs and make a SQL dump and play the transactions on the slave server.
Sherry_MySQL
  • 1
  • 2
0
votes
0 answers

Can you store more than N characters in varchar(N) in MySQL?

I have the following table on MySQL. I am using 5.6.32. The table contains about ~40 million records. I am only sharing columns which I feel are necessary to understand the issue. Table Structure create table `random` ( `id` bigint(20) not null…
MontyPython
  • 2,906
  • 11
  • 37
  • 58
0
votes
1 answer

Updating a migrated percona database to aurora

I've successfully copied data over the period of four hours from an external percona mysql database to an AWS Aurora cluster. Is it possible to configure the AWS Aurora database as a slave to avoid having to setup a fresh slave instance?
Lloyd Moore
  • 3,117
  • 1
  • 32
  • 32
0
votes
2 answers

Throttling SQL server Replication?

We have a performance issue with the current transactional replication setup on sql server 2008. When a new snapshot is created and the snapshot is applied to the subscriber, we see network utilization on the publisher and the distributor jump to…
sharadov
  • 968
  • 2
  • 13
  • 32
1 2 3
…
99 100