Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-replication]

99 questions
6
votes
2 answers

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 install two nodes to get an highly available SQL…
Mat
  • 1,783
  • 4
  • 22
  • 39
5
votes
2 answers

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 seems to be not possible to do either the…
Andy K
  • 119
  • 14
5
votes
2 answers

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 everything and not worry about how many DBs are…
Tommy Burazin
  • 53
  • 1
  • 6
5
votes
2 answers

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 connect to the secondaries from the primary and…
Cris McLaughlin
  • 151
  • 1
  • 3
5
votes
1 answer

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 so far, It's possible to use a shared disk to…
Rad
  • 195
  • 3
  • 10
4
votes
0 answers

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 localhost interface gradually fills up once I start…
Daniel C
  • 41
  • 3
4
votes
1 answer

MongoDB Replica-Set with Replication Lag on one node only

we experience a strange behaviour in our MongoDB Replica-Set, setup of 3 Nodes (all Xeon Quad-Core-Class CPUs, 16GB of RAM for one, 24GB for the other two nodes) The one node with less RAM is normal secondary with priority 0, other two priority 1.…
martinseener
  • 149
  • 11
3
votes
0 answers

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 it's transactions. Each server also has a…
Joel
  • 31
  • 1
3
votes
1 answer

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 I can store all of the log files. Master…
Aidan Kane
  • 185
  • 1
  • 1
  • 8
3
votes
1 answer

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.2.3, and the new replica member running the latest…
Dor
  • 43
  • 5
3
votes
2 answers

"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 backup on both. Edited pg_hba on master. Added…
Alex
  • 131
  • 1
  • 3
3
votes
3 answers

PostgreSQL 9.0.X or 8.4.X - performance, replication, stability

I've been developing an app w/ server infrastructure for a while now, and I'm getting ready to release soon(ish). So far the server backend has been running on PostgreSQL 8.4.7, and it's working as it should. Right now, though, I'm thinking about…
uvesten
  • 284
  • 3
  • 9
3
votes
2 answers

How to set up multiple web and database servers?

My websites have been growing in terms of traffic and the load on the mysql has been increasing. I wanted a solution that would help deal with the increased load on mysql (all queries already optimized) because of the increase in traffic + backup…
Sam
  • 51
  • 1
  • 2
3
votes
2 answers

Replicate Oracle to MySQL

I am developing a web apps, this web application will be using MySQL. Now I need to replicate my client's Oracle database into MySQL, only a few tables will be involved.. a table can be up to 2-3 million rows. I only have SELECT privilege on this…
Rosdi
  • 229
  • 2
  • 3
  • 11
2
votes
0 answers

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 did not have any failover mechanism in place,…
deepankardixit90
  • 153
  • 2
  • 7
1
2 3 4 5 6 7