Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
The results are in! See what nearly 90,000 developers picked as their most loved, dreaded, and desired coding languages and more in the 2019 Developer Survey.

Questions tagged [database-replication]

The tag has no usage guidance.

0
votes
1answer
13 views

MongoDB - Database Profiler does not capture queries sent to secondaries replicas

I'm new to MongoDB and need some help to understand how profiler works with replication in Mongo. I have a replica set with three instances and the secondaries are used for read only by the ...
0
votes
0answers
6 views

MSSQL 2008 replication fails with sp_bindrule on Time

I'm trying to set up replication between a few MSSQL 2008 instances. I think I've got it mostly working, but the replication fails with this strange error: Command attempted: EXEC sys.sp_bindrule @...
0
votes
0answers
113 views

Failed to create connection pool: Failed to initialize pool: Communications link failure

We are using mysql router service 8.0 with group replication 1 master and 2 slaves 5.7.24 and 2 application host. After initating the app services we got the error in the middle ware log. ERROR [xx....
0
votes
0answers
124 views

Master Master replication between RDS and database instance on EC2 Errno: 1032

I face this error many times with my replication Last_SQL_Error: Could not execute Delete_rows event on table db_name.event; Can't find record in 'event', Error_code: 1032; handler error ...
0
votes
0answers
173 views

How to create a failover for PostgreSQL logical replication slots?

I want to hook a business-critical part of our application architecture to PostgreSQL replication slots. They work great, but one of my fears is failover. Currently we have a active/readonly failover ...
0
votes
1answer
112 views

Mysql Master-Slave replication database duplication issue

I have done master-slave replication for performing web-server mirroring. Web contents are getting replicated properly. But I am facing issue in database replication. Database is replicated and slave ...
0
votes
0answers
244 views

MongoDB secondary crashes on initial sync because of too many journal files on RAID 10

My secondary DB server went down, so I'm booting up a replacement secondary and trying to perform the initial sync. I've been following the tutorials and advice out there to use RAIS 10 on Amazon EBS ...
-4
votes
1answer
113 views

how to initiate and maintain mongo shard replica set from mongos server? [closed]

I am trying to initiate a mongo shards replica set from mongos server, I want my mongos to maintain replica set and able to add new server to replication if needed.
1
vote
0answers
130 views

Moving entire database server to Galera cluster

We currently have more or less the following setup: Three individual MySQL database servers (individual Linux machines) with 15 to 50 logical databases and 20 to 50 GB of data Galera cluster (MariaDB)...
6
votes
2answers
351 views

SQL Server Failover strategies

In my infrastructure I have a SQL Server 2014 Standard standalone server. As databases and applications which are using SQL Server are growing up, I want to upgrade to SQL Server 2016 Standard and ...
1
vote
1answer
52 views

Local PC to Cloud - Network Connectivity Issue

What I'm trying to do: I trying to setup SQL Server log shipping between my desktop and Oracle Cloud. I have a developer edition of MSSQL installed in both my desktop and Oracle Cloud instance. ...
5
votes
2answers
677 views

Using Amazon EC2 for postgres_fdw or BDR replication

I've been tasked to do two proofs of concept with Postgres on Amazon RDS, one with postgres_fdw and another one with BDR (bi-directional replication extension). After many searches on the internet, it ...
0
votes
1answer
83 views

mysql replication fail (no error)

I'm doing a replication on a mysql 5.6 server (master) to a slave in mixed mode. The thing is, i connect to mysql trought workbench, i execute querys and are replicated. But if another user connected ...
1
vote
1answer
185 views

Is it possible to replicate _users in CouchDB with a non-admin user, but “users_db_public = true”?

Via a non-admin user, I am able to GET any user with users_db_public = true and public_fields set to something valid without authorization problems, as expected. However I am getting 401 (Unauthorized)...
0
votes
1answer
2k views

Database server vs NAS for data files

Regarding costs and maintenance speed/simplicity in case of hardwar failures, does it make any sense to keep SQL data files on a NAS server, separate from the SQL Server instance? Our app stores large ...
0
votes
1answer
138 views

Is it possible to do database replication on aws s3

I have 4TB database in company. As many different analytics require that full data the current database is not able to handle concurrent session from 100s of users. Is it possible to have databse ...
0
votes
0answers
209 views

SYNC MYSQL database instantly from one Digital ocean server to another

I have a site (data entry site ) on a Digital Ocean server and its database ( MYSQL ) is being updated with new records every second. I am hosting the public site on another Digital ocean server ...
-1
votes
1answer
195 views

Error when I run “bucardo add database mybd”

This is the message error: install_driver(Pg) failed: Can't locate DBD/Pg.pm in @INC (@INC contains: /usr/local/lib/perl5 /usr/local/share/perl5 /usr/lib/perl5/vendor_perl /usr/share/perl5/...
2
votes
0answers
540 views

How to automate failover of master in PostgreSQL 9.5 on Windows?

I have 4 nodes (version - PostgreSQL 9.5 Beta) in a slot replication set up. Recently the master node, due to less disk space available, PostgreSQL started throwing errors and crashed in the end. As I ...
0
votes
1answer
2k views

Postgres 9.5 server not starting due to already active replication slot

I have a Postgres (version - 9.5 Beta) server replication set up where there are 3 slaves and a primary server. After all required configuration is done, I start 1st slave after taking base backup and ...
1
vote
1answer
2k views

Slot replication not working in Postgres 9.4

I am using Postgres 9.4 on Windows 2008 server. There are three such instances that I am using. One as master and the rest of the two are slave/standby. The version of Postgres is 9.4 in all the three ...
1
vote
1answer
69 views

How to handle replication post SQL Server 2000/2008 migration?

I have two servers; server A host SQL Server 2000 and server B ( a remote server) host SQL Server 2005. I replicate data between these two servers using transactional replication. I recently migrated (...
0
votes
2answers
6k views

repmgr - after a failover switch, both nodes act as a master

I have a two node PostgreSQL cluster configured through repmgr. The database topology looks like this: db1 - 10.10.10.50 ( master ) db2 - 10.10.10.60 ( standby ) wit - 10.10.10.70 ( witness ) The ...
4
votes
2answers
2k views

CouchDB replicate ALL databases?

I have a CouchDB I'd like to replicate to another server in order to do backup dumps without taxing the production server. The production CouchDB has a varying number of databases and I'd like to sync ...
1
vote
0answers
255 views

How can I efficiently create daily write replicas of an RDS instance?

We're looking to create a replica of a postgres RDS instance that our developers can write to (not just a simple read replica that AWS can easily provide). Currently we run a script nightly that ...
3
votes
1answer
4k views

Mongo secondaries stuck at startup state

I have a MongoDB replica set with secondaries that won't make it past the STARTUP state. The database is large but they should have moved to STARTUP2 by now. The correct ports are open as I can ...
3
votes
0answers
355 views

combine two mysql replication log files

So I use a master-master replication of a mysql database and load balance traffic between the two. This results in server A with a binlog of all it's transactions and Server B with a binlog of only ...
1
vote
2answers
2k views

Ubuntu 2 Node Cluster Postgresql 9.3 with pacemaker and Streaming Replication

I'm trying to setup a 2 Node Cluster with Postresql 9.3 and Streaming Replication. Streaming Replication is successfully configured. Master is listen up and is sending to slave. I can do failover ...
3
votes
1answer
2k views

Postgresql 9.3 Log Shipping on a Hot Standby

My setup I've just set up streaming replication in postgres for the first time (9.3.5), and while the streaming is working as I expect, I'm struggling to get my standby to run the archive_command so ...
2
votes
1answer
1k views

mongodb keep looping while trying to sync data

I'm converting my my standalone mongodb into a replica set. I've added one more member (and I want to add two more members later, and to shutdown the primary server). My primary mongodb is running 2....
0
votes
1answer
2k views

Communication errors while trying to replicate mongodb

I'm trying to replicate my mongodb database, I've crated 2 VM on my windows azure account. both of them are Ubuntu 14.04. I've opened 27017 port on both of them, and installed mongodb latest version. ...
5
votes
1answer
1k views

Multiple Postgres Servers (one writer, multiple reader) with Shared Disk

Here's the scenario: One shard disk (Gluster) Multiple Postgres servers Requirements: Use the shared disk to store the database files Use a configuration which provide maximum efficiency Findings ...
1
vote
1answer
511 views

Very strange disk-usage for replica in Mongodb

tl;dr: the new 2.6 replica eats up a lot more disk space than the 2.4 members. We're heavy users of MongoDB's GridFS. We're currently on 2.4, and are intending to upgrade to 2.6 by simply adding a ...
1
vote
1answer
387 views

Running a database heavy webapp in the UK and Aus server setup

I am running a webapp from a uk datacenter. Speed is fine as expected. The webapp relies heavily on a database. I would like to open the webapp to Australia and New Zealand but maintain good response ...
1
vote
2answers
6k views

Scheduled copy of production database into test database

My question is similar to this one. I've Two different severs (both SQL Server 2014 Std Edition). Production and Test. I want my test server to connect every night to the production server and copy/...
0
votes
1answer
557 views

PostgreSQL 9.1 on CentOS 6.5 - recovery.conf causing process exit with error code

I did setup streaming replication on the Ubuntu 12.04 LTS with rsyncing of the WAL files in case of failure. Now I was trying to do the same on the CentOS 6.5. To do this I've added official RPM from ...
1
vote
2answers
152 views

MySQL Replication threeway

We have MySQL Multi-Master replication setup between two servers ( A & B ). It has been working for a few years now and life is good. The management tool in our office connects directly to ...
4
votes
0answers
972 views

UDP Overflow / UDP Drops on Standby Postgres Service

I am stumped trying to prevent an overflowing UDP buffer on a standby Postgres service. Any help would be most appreciated. Essentially a UDP buffer associated with the pg_standby process on my ...
1
vote
0answers
946 views

SQL Server Replication - How to connect to a system via computer name rather than IP address in Amazon AWS?

In Amazon AWS, VPC, I am trying to setup replication in SQL Server, and have three servers setup with port 1433 RDP open (1 web, two SQL). I can RDC into each server. From the web server, I can ...
1
vote
0answers
1k views

CouchDB v1.2.0 - Timeout error on replication

Currently, I have a replication task that looks something like this: { "continuous": true, "create_target": true, "owner": "admin", "source": "https://remote/db/", "target": "db", "...
1
vote
1answer
3k views

If a SQL Server Replication Distributor and Subscriber are on the same server, should a PUSH or PULL subsciption be used?

Thanks in advance for any help. I'm setting up a new Microsoft SQL Server replication and I have the Distributor and Subscriber running on the same server. The Publisher is on a remote server (as it ...
1
vote
3answers
751 views

Replicating databases using Dell equallogic

Can the Dell Equallogic 6100/4100 replicate databases like mysql, MS SQL 2012, and Oracle 11g? I would like to set up my web applications and their databases in VMWare 5. They would run off the ...
-1
votes
2answers
290 views

SQL 2012 Server Database Transaction Replication performance issue [duplicate]

We have configured SQL 2012 Server Database Transaction Replication for our client's .NET Web application to distribute SQL transaction and reporting on different SQL servers. We had implemented ...
3
votes
2answers
5k views

“Could not create IPv6 socket” postgresql standby error

I'm trying to create Postgresql 9.1 hot-standby using following steps: Configured 2 virtual linux machines. Master's ip: 10.10.10.1, Standby's ip: 10.10.10.2. Ping test passed. Restored the same db ...
0
votes
1answer
640 views

Postgresql replication lag EU/US

I've a Postgres 9.2.1 server master (geolocalized in EU) and 2 slave replica (one in EU and one in US). The EU slave is used also for read queries, the US only for failover. Is it possible to have a ...
0
votes
1answer
3k views

Error in trying to delete a local publication for DB replication

I logged in in db ad sa (super admin). I want to remove a publication made using management studio wizard (right click on Replication/Local Publications/ New publication) After trying to delete I ...
0
votes
1answer
252 views

Database replication with old data

I am using MySQL to accomplish Database replication. The replication process is works very well. What my problem is, the old record is not copied from the master database. Is there is any way to keep ...
1
vote
1answer
175 views

Introduce artificial delay in streaming replication

I have set up PostgreSQL with streaming replication. It replicates very fast, in a fraction of a second. I'd like to insert a delay of 5, maybe 10, maybe 15 seconds, so that bugs related to ...
0
votes
1answer
2k views

Native Postgresql 9.2 Streaming Replication

I'm trying to build up native postgresql 9.2 streaming replication in the Amazon cloud. According to documentation, I've set up everything correctly - but at the slave I get these logs: 2013-02-04 ...
0
votes
1answer
263 views

MySQL and MariaDB replication

Did anyone configure the replication from mysql to mariadb if yes can let me know how he did it thx in advance. My problem occurred after getting replication to start and the error is saying Error ...