What's the deal with Deno? We talk with a major contributor to find out. Listen now.

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

Can any one Explain me What is the Use of Cascading Replication in Postgresql?

What are the advantages of cascading replication in PostgreSQL. I have done Testing On this With three nodes. M1---->S1----->S2 What is the Use if My master(M1) goes Down(failover). Where the ...
0
votes
0answers
3 views

Could not load replication libraries | Unable to load one or more of the requested types - DBATools - Test-DbaRepLatency

I get the below message when trying to check replication latency on a couple of servers. From others, I seem to be able to run completely fine without any issues (run from, not against). I have ...
0
votes
0answers
9 views

MYSQL Server shows it is master server in replication. How to turn off this?

I'm using Ubuntu 20.04 version. I have installed MySQL server using apt-get install mysql-server and used mysql_secure_installation for security. Then I have installed phpMyAdmin using apt-get install ...
0
votes
1answer
397 views

Automatically purging binlogs after successful replication

I have a dedicated server hosting a MySQL database, and want to use replication to have an always up-to-date backup somewhere. I chose to use Amazon RDS as my replica, and I'm following this guide: ...
0
votes
1answer
313 views

Sync of Master Master replication when Primary node comes up MySQL 5.7 Enterprise

I have a Master (say Node A) - Master (Say Node B) asynchronous replication setup with ROW based logging method. Node A has been setup as Write/Read node and Node B has been setup as Read Node Only. ...
2
votes
2answers
740 views

Replication Issue - Changing the replication-do-db filter

I have a server that someone has setup which are acting as a master on both database. Since they have been configured as both master on the same database, changes one on end has caused all sorts of ...
1
vote
1answer
27 views

Database distribution in AlwaysOn

Good morning all, I have an on Always On SQL server configuration where transactional replication is configured If I open SSMS I find that the distribution database is set to AlwaysOn on then I cannot ...
0
votes
1answer
529 views

PostgreSQL stop streamig replication

I've setup streaming replication between a master and a backup server. Now I want to stop the replication but I've noticed that every time I stop postgres in the backup server some old WALs files stay ...
1
vote
2answers
427 views

RDS Replication Error (Apply Error 1406 / Truncation)

I have a MySQL RDS instance as a master, created a Read Replica from it, and ran some schema change operations on it. To be specific, I changed the charset and collation of all the tables and columns ...
2
votes
1answer
79 views

Transactional Replication breaks when schema is changed in Publisher

We have set up Transactional replication where in two Publishers feed into one Subscriber , now if try to change the schema of any one Publishers or both publishers, replication breaks. We have ...
2
votes
2answers
315 views

MariaDB/MySQL SSL Replication Failure

After searching for a solution for the last 6 hours, I have come up dry in my attempt to add SSL to the replication. I managed to get it to connect with SSL via the mysql command line tool without ...
1
vote
2answers
445 views

Large MYSQL DB on single file

I have a large MYSQL innodb database (115GB) running on single file mode in MySQL server. I NEED to move this to file per table mode to allow me to optimize and reduce the overall DB size. Im ...
4
votes
1answer
2k views

Replication stops with GTID_NEXT error after creation/drop of memory table in mysql5.6

We have recently upgraded to mysql5.6.25 from mysql5.5.x/mysql5.1.x on our mysql-cluster. Below is a brief snapshot of our architecture. Since we have upgraded and enabled gtid-mode we have been ...
-1
votes
0answers
13 views

Azure SQL Managed Instance replication

I'm working on legacy application migration to the cloud, currently on planning and estimation stage, the question I wasn't able to google is: Can a Subscriber database be in the same Azure SQL ...
0
votes
1answer
659 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 ...
2
votes
1answer
420 views

how to publish user defined table type as an article in Transactional replication

I am new to replication and trying to use transactional replication. I am trying to publish all data and schema. My stored procedure takes user defined table type as input. CREATE type TableBParam as ...
0
votes
0answers
20 views

MySQL replication error 1452

could you help me to figure out the solution for a MySQL replication error? mysql replication error: (Last_Errno: 1452) Last_SQL_Error: Error
'Cannot add or update a child row: a foreign key ...
0
votes
0answers
15 views

MySQL / MariaDB - Start multi-source replication with mariabackup (xtrabackup)

Many times I successfully performed procedure described in the https://mariadb.com/kb/en/setting-up-a-replication-slave-with-mariabackup/ - it's fastest and easiest because replica is restored by ...
0
votes
1answer
159 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
488 views

How To Prevent Replication Failure

If I become a MySQL DBA, will I had to deal all day with those kind of issues or do you have tips to prevent from breaking the whole replication? I received this message because I removed manually ...
1
vote
0answers
13 views

CREATE or ALTER when using replication

I am using CREATE OR ALTER in the scripts for all of my views and stored procedures, as they are pushed frequently from a CD pipeline. I am also using replication to push certain tables, views, and ...
0
votes
2answers
240 views

Setting up MySQL master-slave replication

I am trying to setup master-slave replication on MySQL 5.6. When I update my database in the master, the change is not reflected on the slave. When I show the process list on the slave it shows this ...
0
votes
0answers
7 views

Is it possible to replicate different Galera MAIN-MAIN clusters (MariaDB) with another Galera MAIN-MAIN cluster but as MAIN-SECONDARY asynchronously?

We are a small team of developers and we usually deal with single database access locally or remotely. We are working on a project that needs to have not only replication on the local network (we'll ...
0
votes
1answer
157 views

Replication using Datagaurd to FAR DR

We have already setup Oracle replication using Dataguard from a primary active site to a near DR site. The near DR is a passive site. Is it possible to replicate from the Near DR (Passive) site to ...
0
votes
0answers
16 views

The Replication Time in Short Time? [closed]

Background info: Apply CQRS model in relation to SQL server. Two similar database and its content. Database 1 is only used for add, update and delete. Database 2 is only used for read only. Database 2 ...
0
votes
2answers
289 views

Mysql 5.6 Replication Lag fluctuating between 0 and n

I have one master and 7 slaves. During high load on my master, I see replication lag and it keeps fluctuating between 0 and n (where n keeps increasing with time and I have seen n grow more than 1 ...
0
votes
0answers
31 views

Oracle DB Replication/Data Transfer

I need to replicate an oracle database without updating each other just for backup purposes. I have a Main DB(MDB) that have jobs to send to be processed data to interface DB(IDB). IDB will be ...
2
votes
3answers
10k views

How to know if MySQL replication is working?

I am replicating from a MySQL v 5.5.50 master, to a MySQL v 5.5.46 slave hosted in RDS. I've followed the AWS documentation on how to do this to the letter, got the dump file imported into the slave ...
2
votes
1answer
5k views

MySQL master master replication, safe to delete rows on both masters?

We have a MySQL (v5.1.61) cluster with two masters (and two slaves). We have a table logs with a primary key column logID. This log table grows rather huge, and we'd like to delete data from it. So I'...
1
vote
0answers
10 views

MySQL replication setup for high load Master

We have simple replication set up with 1 master and 1 slave. However, setting this up (after restart for instance) is always a difficult task. The moment between taking my database dump, noting the ...
2
votes
1answer
146 views

Scheduled snapshots of views (without using materialized views or Oracle Golden Gate)?

I have 40 views in an Oracle 18c GIS database that are used in a map in a workorder management system (WMS). The views are served up to the WMS map via a web service. There are an average of 10,...
0
votes
1answer
14 views

MongoDB - count current read/write operations

is it possible to count the current read or write operations on a mongodb replica set? (including all databases not just a single database) Thank you! Best regards
0
votes
1answer
3k views

Mysql replication, error 13 (permission denied) with slave_load_tmpdir

I've setup a virtual machine on Azure with Ubuntu 16.10 and Mysql 5.7 for a database replication Master/Slave from another server. I followed this article: https://www.opsdash.com/blog/mysql-...
4
votes
1answer
493 views

Write-lock a whole table during transaction

I need to perform a delicate operation to my table in which I will solely insert, delete and select upon all of my rows and no God may interfere with the table during this operation: the table will be ...
0
votes
1answer
76 views

MySql Galera Multi site high availability

We have a datacenter with 3 percona glera nodes We have a store that wants to be in sync with our datacenter(multi master) our store's internet connection is not reliable ( may be down for 30 min), ...
0
votes
2answers
86 views

MySql replication Failure

I have a mysql (Ver 14.14 Distrib 5.7.29, for Linux (x86_64)) primary -> secondary replication setup. Initially the replication was working successfully until we had to restart the primary database. ...
4
votes
1answer
493 views

mysql replication missed quite a lot SQL statement

I have set up a master/slave with mysql-5.1.73 The master's binlog format is "statement". The master and slave seemed running very well with slave status: Slave_IO_Running: Yes ...
1
vote
1answer
635 views

MongoDB 3.6 create local Shard db without replica

This is what I want to do: Create a Config Server Create 2 Shard Create a Mongos Router I don't want to replicate my data using replica set, I want to simulate that each shard has only a part of ...
1
vote
2answers
2k views

How to run a cold backup with Linux/tar without shutting down MySQL slave?

I run the following before tar-ing up the data directory: STOP SLAVE; FLUSH TABLES WITH READ LOCK; FLUSH LOGS; However, tar will sometimes complain that the ibdata* and ib_logfiles* files are ...
0
votes
0answers
20 views

MYSQL Error: 1026: Error writing file 'binlog' (errno: 2 - No such file or directory)

We are using MYSQL 8.0.20 Community Edition on Oracle Linux 7.8 (RHEL). On one server we are running master database and using row based replication to a slave on another server via bin-log. ...
0
votes
0answers
14 views

Create hot standby on top of Barman streaming backup

I set up a Barman server that uses pg_basebackup and pg_receivewal for streaming replication. It is pretty much the same setup as described in the Barman documentation (scenario 1). Is there a ...
0
votes
1answer
274 views

mysql - can a replica have a different primary key than the source?

I have a table with PRIMARY KEY (`id`) and I want to change it to PRIMARY KEY (`username`, `id`). These columns are defined as: `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `username` ...
1
vote
1answer
639 views

Replicating from MySQL 5.1 master to 5.6 slave failing because 'INSERT … VALUES (NOW())' results in 'Error_code: 1062'

I am migrating away from some old MySQL 5.1 servers to some new MySQL 5.6 servers. During this process, I'm creating a new MySQL 5.6 slave from an existing MySQL 5.1 slave, using the procedure in the ...
0
votes
0answers
9 views

mongo replica is down

I have A mongo replica with 6 nodes, not sure why but 4 of them went down and two entered to recovery state. each time I tried to start the service of one of the down nodes it fails with error there ...
1
vote
3answers
447 views

Unable to replicate a database

I setup a master slave replication, where the master has the following setup datadir = /mnt/DATADIR/ bind-address = 0.0.0.0 binlog-ignore-db = information_schema,...
2
votes
1answer
655 views

MySQL Semi-synchronous replication with Multi-Master

Is it possible to use semi-synchronous replication with a Multi-Master setup? I've tried to follow this guide to setup a semi-synchronous replication for a master-slave setup: https://avdeo.com/2015/...
1
vote
1answer
507 views

pg_repack slows down PostgreSQL replication

I have a master PostgreSQL 9.5 server and a standby server. For replication I use repmgr (WAL streaming). Typically the delay between master and standby is <5s: $ psql -t -c "SELECT extract(epoch ...
1
vote
1answer
3k views

MySQL - Enabling Scheduled Event on Master and Slave Simultaneously

This may seem a bit strange, but I am trying to get a Scheduled Event to execute on both Master and Slave. I have two databases set up in a Master (A) to Master (B) replication environment. Master A ...
0
votes
1answer
1k views

Mongo DB sharded cluster fails when one shard is down

I am using Mongo Sharded cluster with two shards. There was an issue on my one shard and and it was down for around 30 minutes. It stopped my writes to other shards also. Logically if one shard is ...
1
vote
1answer
26 views

What are version vectors?

Folks, I am currently learning about distributed data systems via the book "Designing Data-Intensive Applications". I think I have a pretty strong understanding about how version numbers in ...

1
2 3 4 5
61