Questions tagged [master-slave-replication]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
56 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
92 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
224 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
44 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
30 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
146 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
634 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
253 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
407 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
1answer
398 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
164 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
905 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
262 views

MySQL Replication - Resync master after slave taking over

A few days ago, we've had to stop every machine for some maintenance. Two of these were a MySQL master-slave. After the restart, the master didn't get the service back online and, due to the critical ...
0
votes
1answer
488 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. ...
0
votes
2answers
350 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
214 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
35 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
308 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
255 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
137 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
262 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
85 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?
-1
votes
1answer
82 views

(memery table)MySQL master/slave replication on the same server, after restart MySQL err: 1381 (HY000): You are not using binary logging

It's used for replicating a memory table, before restart, there is no err info and replication works fine. I have tried modifying my.cnf and restarted MySQL for many times, but it doesn't work show ...

1 2 3
4