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

Filter by
Sorted by
Tagged with
0
votes
1answer
14 views

Multi Master replication vs Single-Master performance

I'm trying to wrap my head around a hypothetical scenario. Imagine we have a very write-heavy distributed database and sharding is not an option. I wonder if / how is multi-leader replication (...
0
votes
1answer
27 views

Questions around migrating to a live replicated database from an existing log shipping database in SQL Server 2016 SP1

I have two large databases, one on my production server named S1 and the other on my reporting server named S2. S1 is the live database used for our customer orders and accounting, and S2 is the ...
2
votes
0answers
45 views

CREATE TABLE AS SELECT with GTID

I am trying to migrate to MySQL/Percona server 8.0 and GTID based replication and have stumbled upon the issue where CREATE TABLE AS SELECT is not allowed using GTID. The tables that are created are ...
-1
votes
0answers
40 views

SQL server 2016 -SQL Log Shipping Two Databases using the same shared folder [duplicate]

Server A -Primary database, Server B - secondary database and Server C is file server. Server A and Server B not able to connect or different network. Server A and B able to connect server C. ...
0
votes
1answer
35 views

How can I decrypt data on a replicated MSSQL database?

I have a database which uses a symmetric key to encrypt a credit card field. There is a trigger on the credit_card field which runs every time it is updated, to encrypt the contents, and save it to ...
0
votes
0answers
25 views

Forgot to add a table in Transactional Replication : Initialize with backup

I have a transactional replication(with initialize from backup) setup in my server. So i setup replication as below: Used full backup(publisher database full back is scheduled every night) from the ...
0
votes
1answer
18 views

MySQL with Glusterfs Storage vs MySQL replication with hostPath storage

I am trying to search right road in a project. We have currently three nodes openshift cluster(okd 3.11) and deployed MySQL with Glusterfs storage. its working fine but look like over engineered to ...
0
votes
1answer
17 views

Mongo replication sync halfway SocketException: remote: 192.168.168.122:27017 error: 9001 socket exception [RECV_ERROR] server [192.168.168.122:27017]

I got one mongo v2.4.10 server with 1.7TB data, I am trying to migrate and upgrade the mongo to mongo v.3.0.15 server I've setup a new mongo v.3.0.15 and configured replication for v3.0.15 to be ...
0
votes
1answer
18 views

Transactional replication Issue

I am getting this error when i try to create a new publicaton in dbserver-1 after reinstalling SQL Server in my database server 2. Msg 18482, Level 14, State 1, Line 1 Could not connect to server '...
0
votes
0answers
11 views

Availability Group Replication issues: Distributor (named instance) and Publisher (default instance)

Following the documentation provided (Configure replication with availability groups - SQL Server Always On | Microsoft Docs) I set up an AG-based Distributor (REPLAG) and an AG-based Publisher (PUBAG)...
0
votes
0answers
9 views

SQL Server 2014 Replication Subscription Sync

I have SQL Server 2014 Replication set up. It is my understanding that when you add a new subscription that it will truncate the table and re-insert/re-initialize the tables you are subscribing to. ...
0
votes
1answer
26 views

How can i replicate many database into one, by avoid primary key collision?

I have n number of databases and I have to collect data from those into one database. The databases has some specific value (e.g. currencies) which I want to update from the collector database(of ...
0
votes
0answers
22 views

Start replication again from crashed MySQL master

I am messing around with MySQL replication trying to learn about it and have ran into a snag that I can't seem to find the solution to. I have a local instance of MySQL running as Master and a remote ...
0
votes
0answers
49 views

Data integrity in one-to-many distributed architecture

We are a retail shop that has a central data repository which collects data continuously from geographically distributed 1500 odd servers (each store has one SQL Server instance). Like a one to many ...
0
votes
0answers
20 views

MariaDB Galera + Replication (GTID error)

Using MariaDB 10.2.25 + Galera with 3 masters All Masters have binlogs active Want to switch the Master_Host of an external salve (also running MariaDB 10.2.25) to a different Master. Replication is ...
1
vote
1answer
26 views

Transactional replication of Date column from Sql Server 2012 SP4 to Azure Sql Database

We have a Sql Server 2012 SP4 where we are trying to setup transactional replication to Azure Sql Database. When starting replication is says Column mycolumn in object mytable contains type Date, ...
1
vote
0answers
21 views

Slave I/O for channel error connecting to master Error_code: 2003

i am trying a master master replication mysql with phpmyadmin using wamp server. everything seems to be fine, the configuration was well done, so the server is slave and master at the same time , but ...
0
votes
1answer
29 views

PostgreSQL logical replication slave - shouldn't it be read-only and available only for subscription updates?

I have database and table collection_city on one server. It has 21 rows. I have database and table collection_city on a second server. It also has 21 rows. They both have this row: tinker=# table ...
0
votes
1answer
22 views

PostgreSQL - PUBLICATION tries to copy the data which already exists in another database?

I have database and table collection_city on one server. It has 21 rows. I have database and table collection_city on second server. It also has 21 rows. They both have this row: tinker=# table ...
2
votes
0answers
12 views

Is it possible to create AWS RDS as replication from external server?

I can't find any tutorial to create a new instance of AWS RDS (MySQL) to be an replication db from an external db server. Is it possible to create one? Thanks.
1
vote
1answer
28 views

Postgresql Vacuum and replication

I have an architecture of cascading replication with 3 postgresql db Because the master is becoming too big (~ 170Gig), I wanted to run a "cleaning" job over the week-end that would do multiple ...
0
votes
0answers
23 views

Republishing data in merge replication SQL Server

srv1 is distributer and publisher srv2 also is distributer and publisher srv3 subscriber of srv2. I create merge replication and data successfully replicated from srv2 to srv3 However, when ...
0
votes
1answer
38 views

Postgres Logical Replication - “replication slot ”mysub“ was not created in this database”

I have two database servers 192.168.150.210 and 192.168.150.220 I created publication and subscription successfully for logical replication. postgresql.conf file is modified on both servers. ...
0
votes
0answers
7 views

Memsql replication fails - master not reachable

I'm trying to replicate a database between two Memsql clusters residing in the same local network. For doing this I'm using the following command: REPLICATE DATABASE my_db_name FROM master_user:'...
0
votes
1answer
19 views

What will happen if master goes down in peer to peer replication?

In case of Peer to peer replication, if Master goes down, will the other two nodes continue synchronizing or not?
2
votes
0answers
6 views

Is binary log purging done by expire_logs_days equivalent to PURGE BINARY LOGS?

In a MySQL replication environment where replication is done with binary logs, if you run PURGE BINARY LOGS on the master, the server will not delete logs that are currently being replicated by a ...
3
votes
2answers
50 views

Distribution database corrupt - What to do?

The below error message has been received from one of our SQL Server databases: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x6847f47b; actual: ...
0
votes
1answer
29 views

wal_level both hot_standby and logical

I have a PostgreSQL setup with one master and three slaves. It's configured as streaming replication. Now, I want to replicate only a few tables from the master server to an analytic server using ...
0
votes
1answer
33 views

SQL Server replication: can I modify contents of a snapshot?

I have a merge replication which I was unfortunate enough to start modifying, in a way that required the subscriptions to get re-initialized. It makes very good sense and all, since I was touching ...
0
votes
1answer
22 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
14 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
14 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
34 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
31 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
22 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
22 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 ...
0
votes
2answers
33 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
31 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
103 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
29 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
29 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
56 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
12 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
27 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
36 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
26 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
44 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
9 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
16 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 ...