Questions tagged [master-slave-replication]

The tag has no usage guidance.

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

Renaming multiple databases on a MySQL slave

I have 4 mysql databases that I'm replicating from a master to a slave. In the past, I have renamed one of them because the slave is also a dev server where it has a dev version of that schema with ...
0
votes
0answers
25 views

create backup on mysql master-slave

I have MySQL version 5.7 with a master-slave configuration. but I'm confused to make a backup cron. Is there a way to do a backup while remaining safe to master-slave? I heard that using mysqldump is ...
0
votes
0answers
11 views

Does replica config parameter affect primary/master RDS Postgres?

I want to add hot_standby_feedback = on to a RDS readonly replica. The problem is that the replica currently has a parameter group already attached, which is inherited from the master. My question is:...
0
votes
1answer
144 views

PostgreSQL 9.6 pg_rewind - takes a long time to replicate

I use Streaming Replication,and Replication works normally. Two servers are HA and PostgreSQL DB is replicated. The data in the DB is about 40G. When a failover occurs, the slave is successfully ...
0
votes
0answers
57 views

issues with temporary table with proxysql using mysql replication

I have the following stage, we are implementing a database with 3 nodes with proxysql, this database is using percona xtradbcluster, inside the code is created a temporary table and is successful its ...
0
votes
1answer
60 views

Could you monitor all changes made within a postgresql database by somehow subscribing to the replication log?

I've been reading about postgresql replication and was wondering if it was somehow possible to listen to the replication binary log and push that to some tool like sumologic or splunk so that any ...
0
votes
0answers
123 views

Applying batch of row changes (delete) MySQL Replication Stuck

I am using Master Slave replication for master and slave . Master Configuration 64 GB RAM 2 TB SSD Slave Configuration : 16 GB RAM 2 TB SSD My database size is 750 GB. When i configured ...
0
votes
1answer
41 views

MySQL Fast Database Data Validation Master/Slave

I'm moving a MySQL database from the US to Australia and have a requirement where downtime is kept to an absolute minimum. The database is 400GB is size, replication is working without any issues. ...
0
votes
0answers
26 views

Is it a good idea to have a read connection point to both write database and read replica?

In my laravel app I have a write connection to a write database, and a read connection to a dns server that is connected to a single read replica (as instructed here) In the past the dns server was ...
0
votes
0answers
28 views

Migrate a legacy application that uses MySQL replication

I have been working on the migration of a legacy ecommerce web application to a new server with far hardened security. I have found an aspect with the MySQL server that I am not acquainted with and I ...
0
votes
0answers
59 views

Insert Missing Data in Slave Database

We have a master slave replication [MySQL 5.6]. However In slave database 2 rows is missing in one table. I've tried to solve this using Percona Toolkit as suggested here. But pt-table-checksum ...
0
votes
1answer
27 views

MySQL replication without baseline data import

I've been reading about MySQL replication and all the resources I've looked at say that a data import (be it a mysqldump, or a raw data dump import) is needed before replication can start. I'm trying ...
0
votes
0answers
151 views

Set slave_exec_mode value for RDS

I am trying to figure out a way to set slave_exec_mode to idempotent on Amazon RDS. I've checked the parameters associated with created DB instance on Amazon Console, but this parameter is not exit ...
0
votes
1answer
36 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?
0
votes
1answer
66 views

MySQL replication process parallel with user process?

I have process which executes query like below on Mysql(InnoDB) slave INSERT ignore INTO user_profile_temp (some_fields) select some_fields from user_profile user_profile is bigtable of 8GB ...
0
votes
1answer
55 views

Where is pt-table-checksum finding this hostname?

The Setup: An EC2 instance running MySQL 5.6 locally replicating to RDS MySQL. The VPC IP address range is 172.0.0.0/8. Somehow the slave got out of sync and I'm getting this error when I do SHOW ...
0
votes
2answers
431 views

Effect of --flush-logs on a slave mysqldump?

I have this database setup: Master -> Slave A I would like to accomplish the following: Master -> Slave A -> Slave B I have reviewed the documentation. Master and Slave A are both in an ...
0
votes
0answers
43 views

Is there any global variable for PostgreSQL replication has configured or not

Is there any unique identifier or any global variable which can tell us if replication is configured in current PostgreSQL server. Other than this query select pg_is_in_recovery(); The above ...
0
votes
1answer
93 views

Is there any unique identifier for PostgreSQL? How can the master identify its slave unqiuely?

Is there any way to have more than one PostgreSQL slave servers in the same system. If yes, how come a master detect each server as different slaves from the below query select * from ...
0
votes
1answer
359 views

pt-table-sync: syncing slave from master that has different credentials?

I have a MySQL slave under my full control and a master server where I have only read-only login. Also, logins are different. At some point replication have stopped due to some kind of problem. I ...
0
votes
0answers
41 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 ...
0
votes
0answers
20 views

MySQL: Ignore a Row in a table of a particular Database

I had replication in place between 3 databases, I am trying to ignore a Row in a table of a particular Database. I tried many ways but i couldn't, and also i couldn't find anything in online that ...
0
votes
0answers
55 views

Error 'Unknown Collation: '2048' on query

I'm doing MYSQL Replication for the first time. Master mysql version: mysql Ver 14.14 Distrib 5.1.52, for pc-linux-gnu (i686) using readline 5.1 Slave Version: mysql Ver 14.14 Distrib 5.1.73, for ...
0
votes
0answers
23 views

mysql cluster with 1 master 1 node and 2 slave

My Query is I want to set up MySQL cluster with 1 Master 1 Node and 2 Slave with Auto failover. If my master is down node should assign slave as a master. Can anyone suggest me an idea to do that? As ...
0
votes
1answer
35 views

Can i control access end point When some table data changed In Mysql Semisynchronous Replication

I'm trying to set up One master Multi slave in MySQL 5.7 My architecture is like this. Master - First slave(sync) Second slave, Third slave, Fourth slave, Fifth slave(async) My question is, If ...
0
votes
0answers
154 views

Why slaveDelay is not respected by mongoDB replica?

I've seen related article below: Mongodb replica config slaveDelay but data still sync immediately My secondary node is set to be delayed by 3600 seconds: ... "members" : [ { "_id" : 0, ...
0
votes
1answer
70 views

Seconds_Behind_Master alternates between 0 and a number x

I have a slave server with mariadb 10.3.10 on debian 9. For several days the server has been working correctly, Seconds_Behind_Master was always kept at 0 indicating that it was properly synchronized. ...
0
votes
1answer
144 views

Master slave replication with different mysql version is on both slave and master

Currently, we have MySQL master-slave replication. Both master and slave servers have Mysql 5.5 Currently I need to add one more Master server having version 5.7. Is it possible to add Multiple ...
0
votes
1answer
266 views

Does the row locking on slave database also apply to master database?

In a transaction, for example, START TRANSACTION; SELECT count(*) as count FROM `order` WHERE user_id = 25286 LOCK IN SHARE MODE; INSERT INTO `order` (`id`, `user_id`, `product_id`) VALUES (NULL, '...
0
votes
1answer
46 views

Mariadb 10.1.13 - log positions similar but “seconds behind master” is behind

The setup I have is a master/slave replication, both running Mariadb 10.1.13. On the slave I noticed that the Seconds_Behind_Master parameter is showing a delay due to some form of lagging, but the ...
0
votes
1answer
31 views

MySQL how to migrate to new server without data lost?

I'm using AWS RDS, with 1 master & 1 slave. Just now I alter 1 of the table and hangup halfway, so I force stop the process. Now the database got some problem. Let say I wanted to instantiate a ...
0
votes
1answer
175 views

Master DB Ran Out Of Space

My master server ran out of space today (at 20:22). My transactions logs ended up broken into multiple files: -rw-rw---- 1 mysql mysql 228M Jul 31 20:22 mysql-bin.000914 -rw-rw---- 1 mysql mysql ...
0
votes
1answer
717 views

MariaDB master-slave replication failover and failback

I'm trying to configure a DR instance of MariaDB (10.1.13) using master-slave replication. I was able to establish the master-slave relationship with GTID by locking the tables on master, backing up ...
0
votes
2answers
306 views

slave mysql configuration is not stored

EDIT It seems that the problem is with my SSH connection, so I created a different question on serverfault. From what I understand so far, it that this problem is caused from the fact that the port ...
0
votes
1answer
40 views

Single slave for multiple masters in AWS AuroraDB

We are planning to use AWS Aurora(MySQL version) as our relational database. There will be three masters in different regions. We need the data from these masters replicated in a single slave. I think ...
0
votes
0answers
55 views

MySQL Slave fails to flush privileges as Master gets flushed

0 down vote favorite I run into the issue with my slave mysql databases. When I flush the master server it fails to flush slave databases. What should be considering when adding a new user to MySQL.
0
votes
1answer
471 views

commit or rollback on a statement based replication, effect on auto increment id

How commit or rollback is safe on statement based replication in terms of auto_increment column? If I execute below queries, shoudn't there be discrepancy between master and slave in auto_increment ...
0
votes
2answers
463 views

Stored procedure in master slave replication

I have a master-slave replication for a schema products which is being replicated with binlog_do_db = products. one of the the tables in the master schema is being archived by calling a stored ...
0
votes
0answers
24 views

How to access a database hosted in a normal pc from the cloud?

[ Customer PC - MYSQL DB ] <--cloud--- [ Server - Web App ] [ Customer PC - MYSQL DB (master) ] <--cloud--- [ Server - MYSQL DB (slave) | Web App ] I have a mysql database that resides in a ...
0
votes
2answers
221 views

Can MongoDB manage balancing between the Mongos Dynamically using TCP Balancer

If I have a business where I maintain 10 applications and I need to divide the request load of these 10 applications between 3 Mongos Dynamically. Like the TCP Loadbalancer need to connect to MongoDB ...
0
votes
0answers
953 views

MySQL - Slave is not updating event SQL and IO threads are running

I tried to setup replication from my AWS EC2 instance to RDS Aurora, I tried this many times, But now my slave is not updating event the SQL and IO thread are running fine. And I found this ...
0
votes
1answer
521 views

Can I create a table and database on a slave without breaking replication?

I have One Mysql master server and Slave server running on ec2. The replication is working fine. Now I need to make some changes. I need to add new slave server to the current replication loop. Is ...
0
votes
2answers
369 views

Should I write to MySQL slave (replica) for reporting?

I intent to put reporting/analytics database on slave and run job scheduler every night to aggregate and insert data from operational database to reporting database. Should I do this or I have to ...
0
votes
1answer
228 views

Mongodb replica config slaveDelay but data still sync immediately

I've set slaveDelay to 600s but when the Primary data change, the Secondary data change immediately. Here's the curent configuration of repl with 2 server. "members" : [ { "_id" : 0, "host" : ...
0
votes
1answer
36 views

Starting a slave from behind master

We're moving to a different cloud provider so need to migrate our database with as little downtime as possible. Here's our current setup: master └───slave1 └───slave2 └───slaveBackup A dump of ...
0
votes
1answer
329 views

Mysql 5.6 replication works even if I block 3306 for slave in master's ufw firewall

I'm trying to write a bash script to monitor simple master-slave replication with 5.6.33 and send email and log messages when anything goes wrong. I want to test scenarios where replication fails and ...
0
votes
1answer
290 views

Row-row based logging in a blackhole replication filter setup?

I am using two MySQL server instances on the same server to filter replication to a third external server. My filter slave is using the blackhole engine as described here: https://dev.mysql.com/doc/...
-1
votes
1answer
158 views

MySQL Replication Relay for Peer-to-peer replication for Multi-master replications [closed]

Any one knows about MySQL Replication Relay for Peer-to-Peer Replication for Multi-master replications? Please share if you know anything with example and syntax for multiple clients with as masters ...
-1
votes
1answer
272 views

bigchaindb set up and run cluster node error

I have been following the instructions given on: https://docs.bigchaindb.com/projects/server/en/latest/production-nodes/setup-run-node.html in an attempt to create a cluster. However I get this error ...
-1
votes
2answers
92 views

Address of master PostgreSQL for replication?

What is the address (that goes to pg_hba.conf) for the master computer which is connected only to the internet which a slave VPS server will connect to for PostgreSQL replication?