Questions tagged [replication]
Replication is the process of sharing any level of information so as to ensure consistency between redundant hardware/software resources to improve reliability, fault-tolerance, and accessibility
0
votes
1answer
6 views
Logical Replication to different schema name
We have PostgreSQL 11 database with structure one database one schema (public).
dbname : production_one
schema : public
dbname : production_two
schema : public
I would like to set up a logical ...
1
vote
1answer
22 views
Replication to subscriber with different name
Is it possible in PostgreSQL to set up the following replication scenarios?
Replication between 2 servers with different database name. For example, replicate FROM server_A (primary) database name ...
0
votes
0answers
38 views
Cannot set up replication between two servers
I am trying to subscribe a 2016 (sp2, cu1) server to another 2017 server. I am getting the following error message:
For merge publications, the version of the Subscriber must not exceed the version ...
1
vote
1answer
23 views
What happened to pg_xlog?
There uesd to be a directory called pg_xlog that stored all of the WAL logs in PostgreSQL? Part of restoring a basebackup under the archiving scheme required me to copy the WAL into DATA_DIR/pg_xlog. ...
1
vote
1answer
20 views
Streaming replication archive folder taking all space- Postgresql- 9.4
We had recently setup postgres streaming replication between master (physical, CentOS release 6.6) and slave(virtual, CentOS 7.6). We did the test and streaming replication is working fine.
We ...
0
votes
1answer
28 views
MongoDB 3.6, adding replica set always fails as on production setup with cannot open /dev/urandom Too many open files
I am trying on add a 3.6 mongoDB node to a 3 member replica set running 3.4. Doing this as a part of DB upgrade from 3.4 to 3.6. When I add the new member to replica set, it goes to STARTUP2, data ...
0
votes
1answer
27 views
Why am I seeing these mongodb 3.6.5 server log messages in huge amounts?
Could someone please shed some light on these mongodb 3.6.5 server log messages on the primary node of a 3-member replicaset? rs.status() says all the nodes are up and running but seeing a ton of (I)...
0
votes
0answers
6 views
Decrypt RSSD maint password in Replication Server version 15.7.1
Is anyone knows any possibilities to decrypt an encrypted RSSD maint password in the Replication Server configuration file?
Thanks in advance.
0
votes
0answers
17 views
MariaDB GTID current_pos vs slave_pos
In a standard master-slave setup using MariaDB (10.3 at this time) and GTID (Global Transaction ID), it is unclear wether to use current_pos or slave_pos.
Reminder from the documentation:
Using ...
0
votes
0answers
35 views
[MongoDB]See Collections (and Files) created in a Shard on the Cluster
My structure:
A Sharded Cluster with multiple Shards. Each Shard contains 1 Collection, which is pinned to it by tags. Every Shard is at the same time a ReplicaSet Secondary. It receives data from a ...
0
votes
1answer
16 views
archive_command failed causing master to run out of disk space. Is there a command that prioritizes master's health
I had replication set up with a simple archive_command in postgresql.conf:
archive_command = 'rsync -a %p _postgresql@serverip:/var/postgresql/wal_archive/%f'
Which worked great for 2+ years until ...
0
votes
0answers
18 views
Is ProxySQL Suitable for Connection Pooling Apps?
I'm looking for some guidance on whether ProxySQL is suitable as a method of failing over Java connection pool based apps in a multi-master replication (with read/write split) set up?
I've found ...
0
votes
0answers
8 views
Adding index only on read replica of MySQL RDS instance
I have created read replica of RDS production database for reporting purposes. Cross-team is using the replica for their use.
Consumers of this replica are looking for additional indexes for faster ...
1
vote
1answer
9 views
Can a replication subscription also be used as a publication?
Some background: We are working with a vendor who makes a read-only copy of their source database available to us in the cloud via filtered transactional replication. The cloud database is a ...
2
votes
2answers
47 views
SQL Server Replication with Historical Tables
Is it possible to replicate a SQL Server database and for the replica to have temporal/historical tables?
Details:
I have a production system, running SQL Server 2014. I want to have a replica ...
0
votes
1answer
24 views
mongodb: Can I create an unshard Replica set for a sharded cluster?
I have a 3 node shard cluster mongoDB with replica set, and want to add (single node replica set) a un-sharded Replica set to collect all data in one node.
Can I create an unshard Replica set for a ...
0
votes
0answers
33 views
Error 'Unknown Collation: '2048' on query
I'm doing MYSQL Replication for the first time.
Master mysql version: mysql Ver 14.14 Distrib 5.1.52, for pc-linux-gnu (i686) using readline 5.1
Slave Version: mysql Ver 14.14 Distrib 5.1.73, for ...
1
vote
1answer
29 views
MongoDB replica has no primary
I have an existing MongoDB setup (part of a Graylog installation) where I'm attempting to configure a replica set with a primary, secondary and arbiter. I had the primary and arbiter configured ...
0
votes
0answers
12 views
mysql drop user has broken the replication
I was dropping a user on master. But that didn't execute on Slave. Instead its broken the replication.
GTID enabled Parallel
replication enabled.
On Master:
Binlog-do-db: prod_db
binlog-ignore-db: ...
0
votes
0answers
12 views
GTID ignore error on parallel replication
Im getting an error in replication where GTID and parallel replications are enabled. Now I want to skip one transaction.
I didn't find a way to do that.
Last_SQL_Error:
Worker 48 failed executing ...
0
votes
0answers
11 views
Where can I find the failover history for an Azure SQL Database with geo replication?
We have an Azure SQL Database that is geo replicated to another region. I suspect that they have swapped which is primary and which is secondary and would like to find information about when that has ...
0
votes
1answer
61 views
Merge replication - Could not remove directory
We are facing an issue with our replication server. We are currently setting up a new environment to replace the old replication server and we keep getting the following error.
Server XXX\YYY, Level ...
1
vote
0answers
24 views
Logical replication sync time
I'm trying to create a logical replication between 2 Postgres 10 databases in separate clusters. All the process seem to be working, no error and \dRs+ shows the subscription correctly. The master ...
0
votes
1answer
19 views
PostgreSQL pg_basebackup from several port number
I have one slave server which used as a replication server (let's called it slave1) from several master servers.
The `slave1' server is set up to receive replication from several postgresql server, ...
0
votes
0answers
37 views
Postgresql Replica is in sync but repmgr says node unattached
I've set up a replica of a Postgresql instance using repmgr, and the replica is totally in sync with the master instance and have been in sync since some days, but repmgr tells me replica isn't ...
0
votes
1answer
23 views
How to handle set up real time DML and DDL statements sync between two DB servers SQL Servers
We are looking to offload the data from a Production enviroment to a reporting environment. I currently have an SSIS package setup to extract and load data between the two servers.
However, now ...
1
vote
2answers
51 views
Is it possible to run an arbiter on a machine that also hosts a secondary member?
I have two machines (it is a restriction) configured as a replica set with MongoDB 3.6.5.
Is it possible to run an arbiter on a machine that also hosts a secondary member?
Even if it is not ...
0
votes
1answer
63 views
Accidental deletes at SQL Server Subscriber
Unfortunately, this happened twice in 2 weeks on our most critical db server; just before Christmas! Instead of running a delete script at the publisher, the script was run at the subscriber, which ...
0
votes
1answer
22 views
Replica Set Oplog Maxsize
I have two databases (Mongodb 3.6.5) using ReplicaSet, when I made a split in the network, I am forcing the secondary database to be the primary.
cfg = rs.conf()
cfg.members[0].votes = 0
cfg.members[...
0
votes
2answers
39 views
Safe backup of PXC / Galera cluster
I have 3 nodes 'master master' cluster and using PXC 5.6
But I am only using a single node for both read and write.
Before using pxc, i was using standalone Mariadb 5.5 and I was taking backup using ...
1
vote
0answers
40 views
postgres :: FATAL: could not access file “pglogical”: No such file or directory
We installed pglogical from source code, we are running PostgreSQL 9.4
make USE_PGXS=1 clean all
make USE_PGXS=1 install
Installation was successful after updating the parameters, we tried ...
0
votes
1answer
43 views
How do I tell what agent profile is being used?
When you change from one replication agent profile to another using the SSMS GUI, you often have to stop and restart the agent for the change to take effect.
I'm trying to debug an issue where it ...
2
votes
0answers
28 views
Postgres Replication out of sync
We have master server on one Datacenter, and the Replicate is in another Datacenter
Intermittently, on the replicate server, we see this as below.
“2018-12-19 07:24:25 UTC: : @: [25775]: [2-1] ...
0
votes
1answer
43 views
How to solve replication in MongoDB only with two machines?
I have two machines connected in a ring network, each one running Wildfly in HA mode using JGroups ant MongoDB in HA Mode using Replica Set. The machine 1 is the primary and machine 2 is secondary.
...
0
votes
1answer
14 views
Convert MyISAM to InnoDB in PXC master master
I have 3 nodes PXC 5.6 master master cluster. I have few tables that are using MyISAM.
Total MyISAM table = 120
Total MyISAM table size = 80MB
I have also read few recommendations where it suggests ...
1
vote
1answer
38 views
Streaming replication version between different minor versions
I want to know few details about streaming replication.
I want to setup streaming replication between version 9.4.4 and 9.4.20 ?
I have the master server in centos6.6 with postgres version 9.4.4 ...
0
votes
0answers
14 views
Postgresql streaming replication slow on macOS
I am using PostgreSQL 10.1 on MAC on which I am trying to set up streaming replication. I configured both master and slave to be on the same machine. I find the streaming replication lag to be slower ...
0
votes
2answers
38 views
How verify if replicaset is working?
I am newbie with MongoDB and even more in administration of databases. But my boss passed me an issue to solve.
SCENARIO
I have two servers using MongoDB and ReplicaSet, when I run the command
db....
0
votes
1answer
9 views
Character set warning in PXC logs
I am using PXC 5.6 (Percona-XtraDB-Cluster-56-5.6.41-28.28.1.el7.x86_64) and my log file is flooded with this warning:
[Warning] Client failed to provide its character set. 'latin1' will be
used ...
1
vote
1answer
8 views
Switch publisher - subscriber side
I have 2 server using merge replication. One acts as a Publisher and one acts as a Subscriber.
One day I want to switch the side, publisher become subscriber and subscriber become publisher. In my ...
0
votes
1answer
29 views
Replication stalling on one subscriber
I currently have transactional replication set up for three databases from the same Publisher to the same three Subscribers in SQL Server 2005. Publisher and Distributor are on the same server.
One ...
1
vote
0answers
30 views
SQL Server upgrade re-initializes subscriptions
I recently, in a test environment, upgraded my SQL Server Distributor from 2012 to 2017. The upgrade went off without a hitch but I noticed that after the upgrade was completed all of my subscriptions ...
-1
votes
0answers
40 views
pg_basebackup taking way too long
I'm trying to set up a replica of my Postgresql DB using repmgr, and every single time it takes way too long for it to finish.
This is the command that I actually run:
repmgr -h MASTER_DB_ADDRESS -U ...
0
votes
1answer
32 views
SQL Server Log Reader Agent while trying to add node in p2p Replication
I am trying to add one more node in peer-to-peer cluster.
In current state, I have 3 servers A, B and C.
I need to add a node D with node A(only).
For this, I used following steps:
Took full backup ...
0
votes
1answer
47 views
Create Copy of all rows where foreign key matches specified and then replace foreign key
I'm new to database administration (this is my first time) and have been tasked with creating a database with functionality that allows users to select a "Model" as a current state which can then be ...
1
vote
3answers
80 views
Using Postgresql logical replication, how do you know that the subscriber is caught up?
Postgresql has some interesting monitoring tools for monitoring the new logical replication system's progress, but I don't really understand them. The two tools I'm aware of are:
pg_stat_replication
...
1
vote
1answer
28 views
Bucardo - without Primary Key and Unique Key
I read this from Postgresql Wiki page.
Cannot incrementally replicate tables without a unique key (it can "fullcopy" them)
Now we have 5.5.0, so still do we need PK or unique key for this?
What ...
1
vote
1answer
31 views
Postgresql - archive_cleanup_command with multiple standby servers
Regarding the archive_cleanup_command command, the Postgresql 9.6 documentation states the following:
Note however that if multiple standby servers are restoring from the
same archive directory, ...
1
vote
1answer
26 views
In MySQL replication, why aren't queries run on the slave when there was no USE statement on master?
We have replication running from our master server to a slave. binlog_format is the default; mixed.
We have noticed something weird and are not sure whether it's a bug or intended behaviour. Certain ...
2
votes
1answer
24 views
postgresql configuring wal_archive directory
I had a problem with PostgreSQL server.
I took over PostgreSQL server from my former colleague, and today my server crashed due to filled up disk space with wal_archives.
Usually wal segments were ...
