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

What can cause mongodb replset to be so slow?

This is the first sync to the primary node: 2017-03-03T02:26:22.035+0100 I - [repl writer worker 3] prodbase.offer collection clone progress: 283940/5543302 5% (documents copied) 2017-03-03T02:36:17.984+0100 I - [repl writer worker…
Lisio
  • 1,571
  • 2
  • 15
  • 22
0
votes
1 answer

Copying Indexes From Publisher To Subscriber in SQL Server Replication

I am configuring transactional replication. I have configured that and its working fine. Now i want to copy all the non clustered indexes and covered indexes(NC Index) from publisher to subscriber. Any approach followed by people to do that stuff…
Ayush Kalia
  • 31
  • 1
  • 7
0
votes
0 answers

Replicate one db into another on same server and same instance in MYSQL

I just want to replicate a db into another on same machine and same mysql instance. is it possible..?? i have tried but not working as all server-id = 1 report_host = master-is-slave-host log_bin =…
Sudhanshu Jain
  • 494
  • 3
  • 11
0
votes
1 answer

SQL Server replication / mirroring without transaction logging?

I'm new to SQL Server replication options. I want to set up a system such that a backup database at a remote location is used for data analysis over some large set of data in the primary database. The analysis does not need to have access to live…
AlexPi
  • 539
  • 5
  • 16
0
votes
0 answers

Read performance: replication to another DB vs another table

I have a SQL Server instance (hosted via Azure SQL) where a certain table currently gets lots (around 10/sec on average) of writes, but no reads. I have a requirement where i need to read some of this data now, where the read involves performing…
RPM1984
  • 72,246
  • 58
  • 225
  • 350
0
votes
1 answer

SQL Server Replication Process Account Error

As per below image, I am Configuring the Transactional Replication in SQL Server 2008 R2. I need to give process account and password. I tried to provide the account as the account from which i login for ex "sa" and password is password for…
Ayush Kalia
  • 31
  • 1
  • 7
0
votes
2 answers

Oracle -> Postgresql Log-Based replication

(I do not code on my own, to make things clear) I am looking for a solution that would allow to replicate data between a, master, Oracle 11g DB and a new PostgreSQL DB. Those are 2 different applications but the need to exchange data in real-time.…
czuczer
  • 1
0
votes
1 answer

SQL replicaton - collecting data

I have master SQL server with DB Central and a lot of satellite SQL servers with DB Client. I need to collect data from log tables(LogTable) on Client(each client has own ID in log table) to one big table on Central(LogTableCentral). Data must go…
drizzt
  • 2,756
  • 6
  • 27
  • 41
0
votes
1 answer

Cassandra Replication setup

I'am working with Cassandra 3.9 . I have some doubts like I'am currently having 2 physical machines and want to have data stored the best possible way :- 1) Either in a distributed order on both machines. 2) The other way to store complete data on 1…
jAi
  • 115
  • 1
  • 14
0
votes
1 answer

how to run a mysql command when mysql server startup?

i want to run a mysql command START SLAVE; is it possible to do that?
friends
  • 589
  • 5
  • 10
  • 16
0
votes
0 answers

is mysqladmin status locking?

I'm having lag issues with master slave replication with a mysql server. Server version: 5.5.53-0ubuntu0.12.04.1 (Ubuntu) I'm running a cron that uses $ mysqladmin status every minute. Is this query using locks of any kind? thanks!
orr barkat
  • 1
0
votes
0 answers

Sql Server Replication Errror: Login failed for user 'NT AUTHORITY\ANONYMOUS

Where I work there are 2 SQL server 2008 that are linked servers and have a database that has a replication. A few month ago we have migrated our AD DC to a new one in order to be part of the company forest. I had to reinitialize the replication due…
Kristiyan Dobrev
  • 1
  • 1
0
votes
0 answers

Snapshot Replication or Backup/Restore

A SQL Server that serves as a DW for reporting purposes (OLAP) is also used directly by users to perform direct ad-hoc queries. User queries add a lot of extra load on this server because of number and concurrency and since this is not its primary…
jayt.dev
  • 975
  • 6
  • 14
  • 36
0
votes
0 answers

mysql replication dump data to binlog

As mysql replication sometimes breaks and it is not possible do recover the replication with the binary logs I would like to know if there is a possibility to dump certain tables or maybe a whole database to the binary log. Is this possible?
c l
  • 1
0
votes
1 answer

SQL query to tell when server no longer has the requested starting point

I have a master-slave setup using postgres 9.5.3 and got the following error in my postgres log "could not start WAL streaming: ERROR: requested starting point 0/D000000 on timeline 2 is not in this server's history" I would like to know if there…
user1409708
  • 953
  • 2
  • 11
  • 20
1 2 3
…
99 100