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

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
0answers
4 views

Fail-over or switching the Reporting server database

I have two databases in server, dbs-01.One is a transactional database and a reporting server database.Reporting is minimum,that is why we have it together in the same instance. I have transactional ...
0
votes
0answers
3 views

MySQL Replicated table: How can I prevent a trigger chain?

I've written a trigger to log updates on a replicated table. The trigger inserts into a separate table. We use MIXED replication which defaults to statement-based. The trigger spins around and ...
0
votes
0answers
11 views

using Federated tables for different data sources

We are planning to create a standalone MySQL server specifically for Federated tables that points to 4 DB instances. Sample table: federated_db1_users federated_db1_transactions federated_db2_users ...
0
votes
0answers
10 views

error occurs when starting mysql group replication

With MySQL 8.0.15, I tried to set up the group replication according to the manual(not all the same steps), but the errors occurred. Maybe I missed some details. I was trying to set up the first ...
1
vote
1answer
28 views

SQL Server Replication and Recovery Model

In SQL Server for Replication when recovery model is not very important then how it saves the transactions and also keeps the secondary instance in sync? I tried to check on MSDN and found the ...
0
votes
0answers
17 views

Bidirectional Publish/Subscribe with PostgreSQL

With PostgreSQL, I can set up a publication and subscription between two databases and the subscription will duplicate the contents for the published table. What I found interesting is that the ...
0
votes
0answers
18 views

Postgresql - Can we create streaming and logical replication replication from same server

I have a postgresql setup with 1 master and 3 slaves. Now I want to setup a replication for only one database to reporting server. My problem statements: I can't use bucardo (no approval for ...
0
votes
0answers
18 views

Moving Replicated database in SQL Server Transactional Replication

I have a scenario where I need to move the published database (Transactional Replication) to another server, which is having upgraded Windows and SQL Server installed. Current config is: Windows 2012 ...
-3
votes
0answers
24 views

MySQL Replication via SSH Tunnel - Master Server ID same as Slave ID [closed]

I followed the below link to setup replication via SSH Tunnel. But the replication doesn't work as can be seen in the output below. mysql> show slave status\G; *************************** 1. row **...
0
votes
2answers
29 views

Transaction Replication as DR solution

I have a production database server and a failover database server set up. All the transactions from the primary production db server is being replicated(transactional replication with initialize ...
0
votes
1answer
28 views

MariaDB replication failure: Fatal error 1236 - binlog shows 'Event truncated'

Disclaimer: I am not a certified DBA I have configured MariaDB Master - Slave replication and everything was working but now have an error that I cannot get past. I have run the following on the ...
5
votes
2answers
97 views

DBCC SHRINKFILE on the distribution database

I have an .mdf file from distribution database which is growing. I know the advantages and disadvantages of shrinking database/files. Is it okay to shrink the .mdf file to some a smaller size. Is ...
0
votes
1answer
25 views

Best way to back-up MySQL production database to another database [closed]

The case: I have a very large MySQL production database. Due to performance problems I want to periodically clean-up this database automatically. Before cleaning-up I want to do an incremental backup ...
0
votes
1answer
24 views

-skipErrors in Transactional Replication not happening

I have set up a transactional replication initialized using backup for a big database(1.6TB).Due to some error(space issue in the subscriber) the replication was not happening and there were ...
0
votes
1answer
14 views

Monitor mongodb replica sets [closed]

In my cluster environment i have two shard replica set and 1 config replica sets is configured ,When i ran the command db.stats(); why it always shows the shard replica sets data? i need to collect ...
0
votes
1answer
25 views

change master to cause 1364

ip addr|grep inet inet 192.168.8.47/24 brd 192.168.8.255 scope global ec1 inet 192.168.8.45/24 brd 192.168.8.255 scope global secondary ec1:1 I got like this mysql> show slave status\G; ******...
1
vote
1answer
43 views

MongoDB replica set quorum config (network partitioning behaviour)

I use mongodb 4.0.10. I want to establish a quorum for a cluster of one primary node and two secondary nodes as written here. When the number of nodes is less than the quorum, 3 nodes in my case, ...
0
votes
1answer
11 views

resuming server replication on PostgreSQL servers

I got one main server and other two servers are replicating from the main. I got full disk space on the main server (I have an archive_command that put wal archives into the /wal_archive/ directory). ...
0
votes
1answer
24 views

What's the best way to maintain a writable DB slave which is always overwritten by the master?

I need to replicate our main server's databases (MariaDB) to a local server in our office, which will be used as an offline mirror when we have connectivity issues. The data on the master should ...
0
votes
1answer
32 views

Can I configure MySQL Replication as Master - Master - Slave?

I am considering how to configure our MySQL replication. Hope I can get any advices from community. In fact, I am using MySQL 5.7, and have 01-Master 02-Slave 03-Slave My Applications are using ...
0
votes
1answer
19 views

how to change the publication settings via T-SQL?

I set up a new server to host some database publications. On the same server I set the distributor db. All goes on well, then while running a snapshot of a publication on transactional replication: ...
0
votes
1answer
36 views

MySQL replication slave using percona and docker

I am trying to run a MySQL replication slave in a docker container. We are running MySQL 5.7.24-27-log in production and it's from the percona repository (Ubuntu 18.04). I have used xtrabackup to ...
0
votes
0answers
8 views

Table level replication in Mysql [duplicate]

I want to change the config file(my.ini) to replicate particular table. The following statement is working fine for particular database replication "binlog-do-db=databasename" and the same way i need ...
0
votes
1answer
13 views

Get position of mysqlbinlog error. I have the error's line number

If I use mysqlbinlog to load a binlog into my database like this: mysqlbinlog --defaults-file=/path/mysqld.cnf bin.000011| mysql -u root and get an error like this: ERROR 2006 at line 290: MySQL ...
0
votes
0answers
26 views

How to add a Database on existing Distributed Always on? [duplicate]

I have added a database on the existing Distributed Always on between server A and B which are prod server. Now I need to replicate same DB on server C and D which are DR server.
0
votes
1answer
23 views

How to replicate particular table in MySQL master-slave configuration?

How do I replicate a particular table in a MySQL master-slave configuration? I have tried replicate-do-table and replicate-wild-do-table. I tried in my.ini file; is there any alternative to replicate ...
1
vote
1answer
19 views

MySQL replication: how to safely propagate ignored table structure changes from master to slave?

We have a MySQL database with a replication set up (master to single slave). Some tables are skipped from replication (they are listed in Replicate_Wild_Ignore_Table when calling SHOW SLAVE STATUS). ...
0
votes
0answers
16 views

PostgreSQL: Very high read IO on one of the servers

We have two servers dedicated to PostgreSQL 11.3: master (128Mb RAM, 16 core CPU, SSD) - all write queries and 65% of read queries slave (64GB RAM, 12 core CPU, SSD) - 35% of read queries For ...
0
votes
1answer
34 views

mysql 5.6 replication log-slave-updates doesn't work

We have a setup of master -> replication -> replication the dbs are: mysql 5.7 -> 5.6 -> 5.7 on the replication 5.6 we have the following my.cnf: [mysqld] default-storage-engine=InnoDB ...
0
votes
0answers
26 views

Mongodb Replica Set Collection Has Different Document Count

I've created a new 3 node replica set and rsync'ed data from an existing mongo database for initial population. The secondary nodes went into STARTUP2 mode and seemed to successfully sync from the ...
0
votes
1answer
30 views

In a replication setup, does corrupted data also gets replicated?

Say one of the tables got corrupted, will that corrupted table still get replicated to the other DB? Or, will the replication stop to prevent the other DB from being corrupted too? Note: Question is ...
1
vote
1answer
47 views

Sensible database backup retention policy? [closed]

Scenario: DB is replicated in two availability zones (for high-availability) DB is backed-up daily in geographically separate location (for disaster recovery) App-level user events are stored in the ...
0
votes
1answer
22 views

T-SQL for starting Log Reader Agent

I am facing a problem regarding SQL Log Reader Agent. Whenever, I start SQL Server Agent, Log Reader Agent does not start. I have to start manually. Do I have start Log Reader Agent manually every ...
0
votes
1answer
24 views

MySQL Replication using GTID

I want to create MySQL replication using GTID. According to MySQL Manual I need the following settings in my.cnf (for the master) server-id = 1 log_bin = /var/log/mysql/mysql-bin.log ...
-1
votes
1answer
43 views

What are the pros and cons of having more data-bearing members in a MongoDB replica set? [closed]

A 3 member replica set has the same fault tolerance if all 3 members contain a copy of the data or if one is an arbiter so why would I ever want all 3 members to have a copy of the data? What is a ...
0
votes
1answer
22 views

Error on PostgreSQL streaming replication

I have the exact same problem as Wal segment still exists on master, but logs on slave and master say it's been removed except that it is in Production ! PostgreSQL 9.4 / Debian Jessie ...
0
votes
0answers
19 views

Physical and logical replication slots on Postgres (same time)

I wonder if it's possible to have a setup when changes from a single Postgres master streamed to two (or more) replicas same time, but some replicas to use streaming (logical) replication and some to ...
0
votes
0answers
40 views

PostgreSQL logical replication and partition table

We have a large database and we want a copy of the database in our company for faster access. we are going to achieve this copy by logical replication on PostgreSQL 11. But we have a big problem. We ...
0
votes
1answer
16 views

MYSQL Read Replica Bottle Neck

If my MySQL master has heavy writes, my read replicas will in-turn gets bogged down by the replication logs & executing them. Then could it serve the reads? Assume MYSQL master is executing at ...
0
votes
1answer
27 views

when is it necessary to create aliases in the SQL Configuration Manager?

I am having a problem with connectivity in one of my transactional replications and when checking the situation with the SQL Server configuration manager I see there are aliases. I was wonder why ...
0
votes
1answer
16 views

Recommended replication strategy for fast global access to MySQL DB

The app i'm working on has users from all over the world and due to the nature of the app, i need to minimize all delays. My application servers are located in different data centers across the world ...
0
votes
0answers
14 views

Replicate a db containing encrypted fields

We've been using aes-256-cbc in our code for some table fields and storing the encrypted strings in our DB to make sure that the data at rest is encrypted. Just a peep into what we do for the ...
0
votes
1answer
48 views

Master Master replication rows not sync properly

I have a wordpress website that run on 3 machines Machine1 | Machine 2 {nginx+lsyncd+mysql} visitor > cloudflare > haproxy ------ ...
0
votes
2answers
30 views

SQL Server Replication, is it possible to have “upload only” syncronization on some articles?

Within SQL Server's merge replication, I know how to make publication's article download-only (either with update restrictions on subscriber database or not) - @subscriber_upload_options parameter in ...
0
votes
0answers
13 views

SQL Server Merge Replication, dealing with existing tables

I have publisher and subscriber databases with identical schema, while some of the tables participate in replication and some don't. In some cases it is possible to have tables that have referential ...
1
vote
1answer
50 views

How to read/write from replicated slave in case master went down in SQL Server?

I've created a transactional publication in SQL Server, now my requirement is to write on master and read from subscriber and in case of master going down for some reason, the subscriber should act as ...
1
vote
1answer
35 views

MySQL - applying same binary log

Quick question - if I apply same binary log multiple times via: mysqlbinlog --start-position=xxx mysql-bin.xxxx | mysql will the server understand and omit previously applied changes or further ...
1
vote
1answer
66 views

Only SQL Server Enterprise Edition supports compression - how to work around that?

I have a script that needs to create a temp table and in that temp table I create an index. I noticed in some of my servers, the script would go on forever, and when checking from a different session ...
0
votes
1answer
43 views

Snapshot replication vs. Transactional replication

I have come across the following scenario in a practice test: Data from DB1 is accessed periodically by an external application. Data from DB1 will be sent to another DB, DB2, as soon as changes ...
1
vote
0answers
56 views

MongoDB ReplicaSet instance re-join after Kubernetes POD restart

I have simple MongoDB deployment in Kubernetes with PersistentVolumeClaims. Roughly like this: apiVersion: v1 kind: Service metadata: annotations: service.alpha.kubernetes.io/tolerate-unready-...