Questions tagged [database-replication]
104 questions
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
2
votes
1 answer
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 instances. I have set up replication using…
deepankardixit90
- 153
- 2
- 7
2
votes
2 answers
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 creation of cluster ( as the replication and…
user294262
2
votes
2 answers
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/clone one database.
I Know I could schedule a…
Jonathan
- 121
- 1
- 1
- 4
2
votes
1 answer
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 is a production database and MS recommends that…
userx
- 133
- 1
- 4
2
votes
1 answer
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 replication manifest themselves clearly and developers can…
Antonis Christofides
- 2,598
- 2
- 23
- 35
2
votes
2 answers
Best PostgreSQL replication solution that minimizes network costs
I'm looking into PostgreSQL replication solutions. I know two varieties of these solutions
Low level - which involves streaming log-shipping, hot-standby features available in PostgreSQL 9.x
High level - Slony, Londiste that work at SQL query…
Jayesh
- 337
- 1
- 4
- 12
2
votes
0 answers
SQL Server 2008 R2 Replication conflict
We have software that during the installation or updates it drop and adds all of its views, triggers, and stored procedures. This became a problem when we tried to implement a snap shot replication on two SQL Server 2008 R2 Standard machines.…
pcrary
- 21
- 1
2
votes
1 answer
error setting up replication from mssql to mysql
I'm trying to setup replication from SQL Server 2005 to MySql 5.1.53. I am able to add the publication without any problem. However, when I go to add the subscription I get this error:
OLE DB or ODBC Subscribers cannot subscribe to article…
btenney
- 131
- 4
2
votes
1 answer
Setup database replication between 2 servers
Is it possible to setup replication of oracle databases, with one server outside the firewall? If so any suggestions on how to setup would be great.
chris
2
votes
1 answer
Is it possible to have MySQL/MariaDB bidirectional replication?
I am trying to install replication on several MariaDB servers.
With no experience at all on this.
I am wondering something.
Would it be possible to have both servers acting simultaneously as master and as slave for each others, for different…
GingkoFr
- 83
- 5
2
votes
1 answer
Add 3rd server with pglogical replication to a 2 server cluster with stream sync replication and failsafe with patroni
I have 3 servers with Ubuntu 19.10, PostgreSQL 12.2 and Patroni 1.6.4 and I would like to have the following setup:
I want to have two servers with synchronised replication
and I want to add a 3rd server with pglogical replication just to accept…
ufk
- 333
- 3
- 8
- 31
1
vote
0 answers
MS SQL 2008R2 Peer-to-Peer replication Zombie data
We have two SQL 2008R2 boxes - each in a geographically separate data center - that stay sync'd using peer to peer replication (with a pair of smaller boxes acting as replication providers). This replication has been running like a champ for more…
RemonsterGrrr
- 11
- 1
1
vote
0 answers
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) with 3 nodes and ~5 logical databases and…
r2_
- 11
- 2
1
vote
1 answer
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.
Windows Server in Cloud instance is in workgroup.
SQL…
tesla747
- 113
- 4