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-...
