We’re rewarding the question askers & reputations are being recalculated! Read more.

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

Replication or Sharding (MongoDB)

I understand each of the terms but I do not understand very well if they can work simultaneously. In my case, for example, I have a machine with 20GB and I would like to know which is the best ...
0
votes
1answer
35 views

Different CREATE_TIME for tables in Master and Slave

We have found that the value of CREATE_TIME column in information_schema.tables for many tables was different in MASTER and SLAVE. Upon going through the logs, it was found that the CREATE_TIME value ...
0
votes
0answers
78 views

Automate Replication Scripts

In SSMS, one can "Generate Scripts..." to Create or Drop Publications and Subscriptions and Distributor configurations. Is there any way to do this automatically? We have several people on the DBA ...
2
votes
0answers
57 views

Does Azure SQL natively support being the subscriber in transactional replication where Oracle is the publisher?…and if PostgreSQL is the publisher?

Is there a native way to setup transactional replication where an Azure SQL database is the subscriber and the publisher database is in Oracle? What if the publisher database is in PostgreSQL? If ...
0
votes
1answer
26 views

MySQL replication with no connection

I configured MySQL replication between a Master and a Slave throught VPN. Everything works fine, when connection between them is down, and i make some changes to the Master (like insert a row), then ...
1
vote
0answers
72 views

Mongodb won't start after adding 2nd net option to mongod.conf file

I try to add another net with the its corresponding bind ip and port to my AMI ec2 mongod.conf file so I will be able to create a 2 node replica set but when I run the command "sudo service mongos ...
1
vote
0answers
52 views

Changing Postmaster File Name in PostgreSQL

I have two instances of PostgreSQL with master-slave replication between them and want to use GlusterFS. Everything works fine until the second instance wants to store the data in the GlusterFS. ...
0
votes
0answers
39 views

Replicate multiple server databases to single slave server

I have several databases in several locations running with MySQL 5.7.25. Now i want to replicate all these databases to single server. Master database servers (All databases are with same name) ...
0
votes
1answer
37 views

Problem in PostgreSQL replication - ALTER DATABASE

Recently I put to work a Master/Slave replication in my PostgreSQL (9.3). Everything is ok... insert, update, delete, in data and changes in tables... but when I changed the data base name the ...
0
votes
0answers
160 views

Sync PostgreSQL with Cloud and multi Local Locations

I need help with a complex (for me) multi server setup with PostgreSQL. I have to setup a Cloud Server and 3 Local Servers for our company. Each Server will have: Linux Ubuntu 16.04 Docker ...
0
votes
0answers
2k views

ERROR 1794 (HY000): Slave is not configured or failed to initialize properly

This is my my.cnf file: [mysqld] server_id = 1 log_bin = /var/log/mysql/mysql-bin.log log_bin_index = /var/log/mysql/mysql-bin.log.index relay_log = /var/log/...
0
votes
0answers
55 views

MySQL slave connect to master error_code 2005

I have a master running MySQL 5.6.17 on Windows 10, and a slave running MySQL 5.7.25 on an Ubuntu 17.10 box on a (Windows) LAN. Replication ran fine until Ubuntu upgrade to 18.04. Now slave ...
0
votes
1answer
40 views

Mysql replication rebuild dump database lock

I need to rebuild master-slave replication of whole instance of mariadb on innodb. What I often see is that people do read lock then dump master then unlock, like: FLUSH TABLES WITH READ LOCK; SHOW ...
0
votes
1answer
24 views

Microsoft SQL secondary read-only DB for SSRS?

I know that Microsoft SQL has AlwaysOn with a read-only secondary replica. However the cost of enterprise edition for all of our SQL servers makes this not possible. We have SSRS configured to run ...
1
vote
0answers
182 views

Why is restart_lsn not set, even on checkpoint - postgresql

A logical slot will emit each change just once in normal operation. The current position of each slot is persisted only at checkpoint, so in the case of a crash the slot may return to an earlier ...
-1
votes
1answer
74 views

Automate setting secondary node to primary when majority nodes are down-MongoDB

There are many ways to force a secondary node to become a primary when majority nodes are down in mongo replica set. But we need to do this manually. For eg, forcing reconfig: cfg = rs.conf(); cfg....
1
vote
1answer
126 views

changing domain name for Mongodb primary

Im trying to initialize my replica set sp that the primary node has a specific domain:port pairing. what I want is: "vagrant-ubuntu-trusty-64:27022" but what I get is: "localhost:27022" This ...
0
votes
0answers
28 views

what is replay_lsn in postgres stat replication

We are trying to implement Postgres streaming replication for which I'm reading PostgreSQL streaming replication material. Thus far things are looking good but I'm puzzled about what is replay_lsn ...
0
votes
0answers
16 views

MySql slaves on Amazon EC2 RHEL 7.6 server not getting connected automatically after mysql service restart on master

I have setup MySQL Master - slave replication on Amazon EC2 instance. OS : RHEL 7.6 MySQL Version: 8.0.13 Master server IP : 192.168.1.128 Slave server IP : 192.168.1.129 I have two EC2 instances on ...
2
votes
1answer
244 views

MongoDB stepDown fails in a PSA Architecture

I have set up a MongoDB cluster using a 3-Member Primary-Secondary-Arbiter Architecture Environment: LXC containers Linux Debian Stretch (9.8) MongoDB server version: 4.0.6 MongoDB Containers: lxc-...
0
votes
1answer
77 views

MongoDB Replication Set Configuration Issue on CentOS 7

My mongodb instance will not run as standalone and I haven't been able to discover why. Its probably something simple. Please point me in the right direction. Linux myserver 3.10.0-514.el7.x86_64 #...
0
votes
1answer
42 views

deploy replicas on multiple VMs

How do you set up a multi-node replica set in Mongodb? I don't know where to start. I'm trying to set up a replica set of three members in three virtual machines, i.e. there will be a total of three ...
0
votes
2answers
101 views

MS SQL Server- Azure Cosmos DB real time replication in table format

What would be the easiest way to do real time replication of an on premises SQL Server/Oracle to an cloud Azure Cosmos DB ?
0
votes
0answers
28 views

Mongodb - add new node secondary in existing replica set shard

my mongodb configuration which i am trying to add. systemLog: destination: file logAppend: true path: /var/log/mongodb/mongod.log storage: dbPath: /var/lib/mongo/mongo journal: enabled: ...
1
vote
0answers
27 views

Can I restore a Replication Subscriber backup without needing to re-configer/re-initialize

I've been trying to read up on this and there are quite a few of posts about restoring a subscribers' backup on a different machine but my question is about -- in my opinion -- a much more simple ...
1
vote
1answer
68 views

Differential Backups with Replication?

I am pretty sure that Differential Backups with Replication is ok, but I am not finding anything that clearly says it. Nor am I finding anything indicating issues with it. Just looking for validation ...
0
votes
1answer
570 views

MySQL thinks Master & Slave have same server-id, but they don't

Trying to setup MySQL to run one-way replication. I have the master set to server_id = 1, a replication user setup, binary logging enabled, the Slave server_id = 2 and is connected and waiting for an ...
0
votes
0answers
32 views

PostgreSQL: Replace schema in db1 with schema from db2

Is there a way to replace data in a schema in db1 with data in a schema in db2, given that the schemas are identical (only the data differs)? An alternative would be to replace the whole schema? I ...
-3
votes
2answers
172 views

Replication and sharding combinations

In modern relational databases, what combinations of replication and sharding are possible? Actually, I'm interested in the following strategy. Is it possible to replicate a small table in order to ...
0
votes
1answer
96 views

Foreign key constraints check during replication?

I am a little bit new to replication and can't seem to find an answer to this anywhere. Let's say I have a simple relation in my database: Department table with Code column as PK and Person table ...
0
votes
0answers
27 views

SQL Server replication model snapshot, transactional and merge - which method can be used

I am trying to implement sql server database replication between 2 branch servers to a Head Office Server. My application is a distributed one, the main application is hosted on head office which is ...
1
vote
1answer
71 views

MySQL utf8mb4 Migration - Replication Considerations

We're planning to migrate a MySQL database with a mix utf8 and latin1 tables to the new utf8mb4 character set per this article: https://mathiasbynens.be/notes/mysql-utf8mb4. Our server is 5.7.22 and ...
0
votes
0answers
30 views

It's possible to avoid overload on a Mysql slave by slowing down replication?

I have a slave on a machine less powerful than the the master (8CPU/8GB on the master, 2CPU/4GB on the slave, MySQL 5.7). Replication is binlog ROW based As the db is increasing on the master, the ...
0
votes
0answers
45 views

replication type of dynamodb

What is the replication type of the DynamoDB system? Like is it master slave, peer to peer, multi master, or something else. I know that that for global tables, DynamoDB has cross replication with ...
0
votes
0answers
42 views

Steps for write ahead log protocol

What are the steps for write ahead log protocol? I know these are the steps, but I don't know the order they occur in. a. Updated data is persisted on disk. b. Data is updated in memory. c. The ...
3
votes
1answer
384 views

RDS MySQL read replica larger than master

We have a Multi AZ AWS MySQL 5.6.40 server with a matching single AZ read replica. Both have 200GB of storage available. However, the read replica is rapidly running out of free storage space, while ...
0
votes
0answers
134 views

Replication Alternatives for Contained Databases

My team and I are in the process of designing a new application using the microservice architecture approach. Each application is going to to be responsible for releasing changes to its own database ...
0
votes
0answers
15 views

Ιndexed view after replication

I am trying to find a smart (no redundunt dataflow) way to aggregate data on views/tables to be used from our reporting tools. One given is that the reporting database is different from the oltp one, ...
0
votes
0answers
75 views

Is it possible to queue PostgreSQL logical replication messages from multiple sources?

I want to use multiple "forward" PostgrSQL instances which serve distinct applications but share overlapping subsets of the same schema to update a single master which holds a full version of the ...
0
votes
0answers
299 views

One way replication between 2 sql servers on different networks

I would like to replicate between 2 sql servers that exist in different networks. This link is not relevant to my case as the servers are not connected: https://docs.microsoft.com/en-us/sql/relational-...
0
votes
1answer
95 views

Transaction Replication on Azure MI servers

I'm struggling to verify whether an Azure Managed Instance of SQL Server can both subscribe to Transactional Replication, and Publish, at the same time - I've been googling like a demon and ...
0
votes
0answers
174 views

Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013)

Getting one issue in error log in every 30-45 mins. Mysql version 5.6.20-log Server is slave of master main server and its having 100 slaves to this server. Replication hierarchy is there in 3 stages. ...
0
votes
0answers
38 views

Your preferred HA replicated setup of PostgreSQL on Kubernetes - does this even make sense?

I'm currently looking to run a new production level PostgreSQL instance on a Kubernetes cluster. I'm just a software developer who only uses PostgreSQL on the local machine during application ...
0
votes
1answer
207 views

Replicate Postgres to Cockroach

We are planning to replicate our Postgres database to Cockroach. We are looking for a relatively simpler solution to achieve that. Currently, we are working on a Stream based replication (something ...
-1
votes
2answers
172 views

Heartbeat frequency in AWS DMS (Database Migration Service)?

Within "PostgreSQL Source WAL Heartbeat https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReleaseNotes.html#CHAP_ReleaseNotes.DMS230", what does heartbeat frequency represents? The AWS docs doesn'...
0
votes
1answer
115 views

REPLMERG.exe cannot connect to distributor

We have a SQL Express 2016 instance that is doing merge replication to a SQL 2016 box. This is an upgraded instance on both sides. We upgraded from SQL Express 2012 to 2016 and we moved the database ...
0
votes
0answers
34 views

Postgres Replication Scenario

I trying to implement following scenario using postgres : Server A : This server is used for product A production stage Server B : This server is used for product B production stage. This B product ...
4
votes
0answers
80 views

Should I use Transactional Replication here?

I have a database on SQL Server A & one on SQL Server B. (SQL 2017 w/ enterprise) They share similar objects and need to be kept fairly up to date. Both will require changes to be passed to each ...
0
votes
1answer
67 views

How Maxscale deals with “Select for update transactions”

We are facing intermitent deadlock issues that doesnt got reflected in the maxscale log nor the mariadb log. Only in the applications triying to do sql transactions in the database. We use mostly ...
1
vote
0answers
69 views

MySQL fatal error 1236 when swapping in new master, “master has purged binary logs”

Our situation: we have three MySQL 5.7.23 replica servers attached to a MySQL 5.7.23 master server running in EC2 instances in AWS. All the servers are fine and GTID replication is working properly. ...