Stack Exchange Network

Stack Exchange network consists of 174 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

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
26 views

Migrating Postgres server from Windows to Linux

Simple question: I want to migrate all of a Postgres server's data, schema, roles, everything from Windows to Linux. Can I just copy the contents of the %PGDATA% directory in Windows to which the ...
-1
votes
0answers
16 views

How to replicate a postgresql database into another server [on hold]

I have 2 postgresql databases in 2 different servers; I need the database in server A replicates to server B, in a master slave replication schema, so i've looked and found the best solution seems to ...
1
vote
0answers
14 views

Hosting postgres wal logs on a separate dedicated server with failover setup

a postgres novice here, so sorry if my questions don't sound meaningful. My postgres server setup goes as follows: Master(on server A), Upstream(on B, receiving wal from A), Downstream(on C, ...
-3
votes
0answers
27 views

database administrator [on hold]

I have a merge replication setup between multiple SQL Server 2012 databases via Pull method. There are several merge replications affecting different table sets. There are foreign keys linking them ...
0
votes
0answers
8 views

Bizarre MySQL Replication Connection Issue

I am configuring MySQL master-master replication (AKA master-slave replication done twice) between two servers. After I set the master settings on each server (CHANGE MASTER TO master_hos..., etc.) ...
4
votes
1answer
46 views
+50

Security considerations of allowing logical replication subscribers on PostgreSQL

I run a non-profit dedicated to sharing data kind of like Wikipedia. We recently had a client that wanted a replica of our database, and we realized that by using PostgreSQL's new logical ...
1
vote
1answer
23 views

The pg_wal directory on a standby server does not get auto-purged

I have a classic master-slaver PG (version 10) architecture. Despite the fact the parameter wal_keep_segments is set to 200, the pg_wal directory on the standby server is not purged and keeps filling ...
0
votes
0answers
16 views

Why slaveDelay is not respected by mongoDB replica?

I've seen related article below: Mongodb replica config slaveDelay but data still sync immediately My secondary node is set to be delayed by 3600 seconds: ... "members" : [ { "_id" : 0, ...
0
votes
1answer
11 views

Seconds_Behind_Master alternates between 0 and a number x

I have a slave server with mariadb 10.3.10 on debian 9. For several days the server has been working correctly, Seconds_Behind_Master was always kept at 0 indicating that it was properly synchronized. ...
1
vote
0answers
18 views

Postresql & Access synchronising

I would like to ask for hints / tips / pointers on the possible approaches that I might use for the following... I maintain a database locally using postgresql 9.5, hosted on a Linux server. However, ...
1
vote
0answers
26 views

Transactional Replication from Copy Only Backup

Is it possible to use a copy only backup when initializing a subscriber from a backup? I've been trying it but getting all kinds of issues with: Trying to update records that don't exist Inserting ...
0
votes
1answer
11 views

Is the subscription of merge replication only for SQL Server Compact Edition?

While creating a publication I saw this Does this mean the subscribers can't be other editions of SQL Server but Compact? Do other editions need to use Peer-to-Peer replication instead? Thanks
1
vote
2answers
13 views

Multi Master - Master Replication mysql [closed]

I have mysql 5.7.24 mysql version. Can i implement Multi-master replication between three nodes without to create a ring topology? Like a graph Thanks :)
1
vote
1answer
13 views

File Group Association while Snapshop Replication

I want to know how can I save filegroup structure during snapshop replication in SQL Server? Does this property solve my problem? I want the same filegroups in publishers be created in the subscriber. ...
0
votes
1answer
19 views

drop big table freeze server

I am using amazon rds mysql 5.6 master instance and 4 slaves. there is big table with 800 GIB size that i want to drop it for releasing space. But when i execute drop command, the server entering to "...
0
votes
0answers
8 views

mysql unable to start with semi sync parameter

Im using mysql 5.7 and it has 2 slaves with GTID. I tried to enable semi-sync and I have done with set global variable in mysql prompt. It was running fine. Then I did a restart, after that mysql ...
0
votes
1answer
21 views

MySQL slave only views

We are kind of struggling while creating the infrastructure for our BI sector. I had read on this link that it is possible to create views on a read-only slave. Still, when I run the query I get "...
6
votes
1answer
66 views

Database Compatibility Requirement for Transactional Replication

Does the subscriber "within two version requirement" for transactional replication from this MSDN article apply to the SQL Server Instance, Database Compatibility Level, or Both? For example, would ...
2
votes
0answers
27 views

Foreign Key Error with Transactional Replication from Backup

I'm getting a missing foreign key error when I begin transactional replication. Steps taken: Created a pull publication (live server) Created a copy only full backup Restored backup on reporting ...
0
votes
1answer
22 views

Slave Timeouts/Stopping (Networking?), Seconds_Behind_Master jumping

I have 2 slaves (10.1.34-MariaDB) which have been running smoothly for months. Suddenly, my lightsail/ec2 slave is behaving strangely. While SHOW SLAVE STATUS\G shows both IO/SQL are running, ...
0
votes
0answers
40 views

Database swapping

I have a scenario to switch(Swap the databases) in my production databases after every ETL processing. DB size is approximately 300GB. The reason behind this is the main tables in the db we are ...
1
vote
0answers
13 views

Postgres service restart in a Master - Replica

Postgres 10 database running on a Centos RHEL 7. This Database is a Master and it has 1 stand_by replica acting as a mirror. Well my intention was to change the wal_level in the configuration from ...
0
votes
0answers
11 views

Problem during assign action to replication server error class

I am trying to create a replication server error class which is to fix the deadlock issue happening on replicated Database. I tried the below commands but seems there is some issue when assigning an ...
1
vote
0answers
16 views

Replication issues on the subscriber side

So here is my situation, an old admin who moved off to some better place had setup replication. Come that special day when the admins account was disabled, replication stopped working. No problem,...
0
votes
0answers
38 views

Identity value in a restored database is different from the value in the backed up database

I am replicating (using backup instead of snapshot) from 2008r2 to 2016 and it seems to be working fine except for a few tables where the restored table identity value is less than the backed up id ...
0
votes
1answer
16 views

slave replication stopped working

This morning my slave stopped working.. Slave_IO_State: Waiting for master to send event Slave_IO_Running: Yes Slave_SQL_Running: No Last_SQL_Error: Could not execute Update_rows event on table ...
0
votes
1answer
38 views

Reduce query execution time in frequently updated tables

The current query takes approx 6-7 seconds. Data is been fetched from 7 tables. Tables are fully normalized, frequently updated but are mostly read approximately 100 times a day. The same query gets ...
0
votes
1answer
28 views

Why does my Group Replication plugin fail in MySQL 5.7.24?

I've been using the group_replication plugin with MySQL without issues before 5.7.24. With this version, the server starts up without the plugin because of failure. I confirmed it manually (see steps ...
1
vote
1answer
30 views

How can I permanently remove replication by script if I only have access to the subscriber?

We've been building a replication network of DBs to give us some degree of Always On without paying the full price tag. Currently we have a master DB which replicates to a handful of slaves, so that ...
0
votes
0answers
25 views

MySQL not honoring binlog_format setting

I have an application that listens to the MySQL 5.6/5.7 binary log. It requires binlog_format to be set to ROW. This is working perfectly on RDS but I can't get the setting to work in a docker ...
0
votes
0answers
10 views

How we can store MongoDB Installation on specific folder on Ububtu 18.04 LTS version rather than default one

I am newbie on Ubuntu Platform (Past was on Windows 10). I want to create specific directory where my MongoDB data will be store. Expectation of Designing the Structure Mongodb is a main Parent ...
0
votes
0answers
19 views

Distributor job in SQL Server replication

Does anyone know how to dynamically set the -SubscriberDB name for the distributor agent job in snapshot replication? I have a scenario where I want to switch this between two databases, depending on ...
1
vote
0answers
42 views

MariaDB 10.3 slave fails to replicate from a MariaDB 10.2 master

We have a 10.2.18 master and 4 slaves with 10.2.18. Because of this bug that I've reported last week (https://jira.mariadb.org/browse/MDEV-17420) we tried to upgrade one of the replicas to 10.3.10 to ...
2
votes
1answer
68 views

Postgres 10 replica service error on startup

I have migrated a database promoting the read-replica in a server with more capacity, this process worked smoothly. But I'm trying to create a read-replica now from this promoted server to have a ...
0
votes
1answer
17 views

Does the row locking on slave database also apply to master database?

In a transaction, for example, START TRANSACTION; SELECT count(*) as count FROM `order` WHERE user_id = 25286 LOCK IN SHARE MODE; INSERT INTO `order` (`id`, `user_id`, `product_id`) VALUES (NULL, '...
0
votes
0answers
24 views

Only one Log Reader Agent or log-related procedure (sp_repldone, sp_replcmds, and sp_replshowcmds) two times

Whenever I have to drop a publication I follow the steps below, ending by a call to sp_droppublication when I get the error below two times. The publications seems to have been dropped successfully ...
1
vote
2answers
47 views

Copy SQL Server replication configuration from production to test environment

Where I'm currently working we have an SQL Server's instance for a billing database and another instance for customer database. Both databases keep some tables synchronized using replication mechanism....
0
votes
0answers
27 views

Cascading binary replication to logical postgres

Im using Postgres 10, and I was wondering if its possible to cascade a logical replication from a binary slave replica? I am looking to have databases with the same data but indexed in a different way ...
0
votes
1answer
41 views

What is the point of a consistent and partition tolerant multi-master DB Architecture as opposed to Master-Slave

I should emphasize that my question is in regard to CP (Consistent and Partition Tolerant) systems. A lot of widely used NoSQL databases such as Mongo and Redis seem to fall in the CP category. And ...
0
votes
0answers
23 views

Configuring CloudSQL (MySQL) with binary logs but without backups

In the Google CloudSQL (MySQL) console, I can read: Automated backups required for binary logging. This requirement looks strange to me. I do not understand why automated backups are required for ...
0
votes
1answer
35 views

Postgres Logical Replication For Specific tables

I'm using logical replication to move data from postgres to a search engine via some background process, but I am only concerned with a small set of tables. Is there a way to specify which tables a ...
0
votes
1answer
19 views

Update two tables, each on separate MySQL servers, on two different machines in one query?

Have two MySQL servers running on two different machines in a local network. Using PHP and accessing via IP. No problems there. The databases have identical schemas. One was an import from the other ...
0
votes
1answer
24 views

Create a mysql replication from multiple master and single slave server? [closed]

How to create mysql replication with multiple master server and with single slave server? how to edit the "CHANGE MASTER TO MASTER_HOST='12.34.56.789',MASTER_USER='slave_user', MASTER_PASSWORD='...
0
votes
1answer
11 views

Openldap Replication don't run after configuring

I'm practicing OpenLDAP replication with 2 Centos 6.9 64bit virtual machines. The setting-up process was fine, but after I insert data into the master server, nothing happens in the slave. MASTER ...
0
votes
0answers
22 views

mysql (5.7) replication fails after adding user

I got Master running mysql Enterprise (5.7.12 ) and two slaves running mysql community(5.7.23). The replication is part of the downgrade from enterprise to community. I created a user on the master ...
3
votes
1answer
44 views

MYSQL database failover

Current status I have a MySQL (MariaDB 10.2) server with various databases, to which a lot of people have access to. Which means that users can create MyISAM or InnoDB tables/databases. Problem ...
0
votes
1answer
29 views

what is a safe way to stop the logreader?

Applying cumulative updates and service packs on sql server 2016 - The server is involved in transactional replication, being a publisher, The server is also a virtual machine. I need to stop the ...
1
vote
1answer
14 views

MySQL Replication ERROR 1130: error conecting to master

I'm having difficulty connecting MySQL slave database to master using MyWorkBench. I tried: executing CREATE USER 'replication'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON . TO '...
0
votes
1answer
31 views

Binlog commits and flushes on SQL Server (compared to MySQL)

With MySQL slave/master, sync_binlog and innodb_flush_log_at_trx_commit control log and disk flushing, and are important to maintain consistency between master and slave (so that the slave can never ...
0
votes
0answers
27 views

pglogical - Table Replication with pglogical, locks on sync_init status

I've successfully installed and got working a pglogical replication between 2 servers: Provider: Postgresql 9.4 Subscriber: Postgresql 9.6 From time to time, I need to add some tables (or entire ...