Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

Questions tagged [master-slave-replication]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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
1answer
122 views

MariaDB | Sync Master with Slave in another Datacenter

We have a web application hosted on a dedicated server at Datacenter A. I am in the process of setting up a disaster recovery protocol and am considering the following. My current plan is to purchase ...
1
vote
3answers
589 views

Seconds_Behind_Master high even though Read_Master_Log_Pos and Exec_Master_Log_Pos are very close

From what I understand from https://dev.mysql.com/doc/refman/5.7/en/show-slave-status.html, seconds_behind_master is the difference in the timestamp of where the IO thread is currently writing in the ...
-1
votes
1answer
254 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 ...
0
votes
1answer
434 views

Too much data queued in replication slots

Periodically we run a batch process that sequentially backups (delete, vacuum and later remote storage in AWS' S3) for a set of about 20.000 tables with the following shell script: #!/bin/bash ...
-1
votes
2answers
82 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?
0
votes
2answers
125 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
812 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
46 views

Mysql master-slave replication makes no sence

I have the following values in my.cnf settings in a simple Master -> Slave setup: # MASTER my.cnf: server-id = 1 log_bin = /var/log/mysql/mysql-bin.log binlog_format=ROW binlog_do_db = db2 ...
1
vote
0answers
51 views

postgres 8.4: makeslave it's own master

For a DR test, I've tried to split the slave from the master. To do this, I edited the master postgresql.conf, turned off archive_mode and restarted. No problem. Now I'm trying to make the slave a ...
0
votes
1answer
247 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 ...
2
votes
1answer
992 views

how can be changed hot_standby parameter on postgres 9.6 aws/rds?

I have a postgres solution on aws/rds with a master and a read replica. master slave hot_standby on on transaction_read_only on on ...
0
votes
1answer
377 views

Can drbd be used for mongodb replication or active/passive setting?

From this guide we know DRBD can used for PostgreSQL Active/Passive setting: https://www.howtoforge.com/how-to-set-up-an-active-passive-postgresql-cluster-with-pacemaker-corosync-and-drbd-centos-5.5-...
4
votes
2answers
16k views

PostgreSQL service start failed on CentOS 7

Installed PostgreSQL using: sudo yum install postgresql-server postgresql-contrib PostgreSQL version: 9.2.18 When start service: sudo service postgresql start Got error: Redirecting to /bin/...
1
vote
0answers
110 views

Replicate Specific Tables with fully qualified statements removed

Currently we have a replication system that is a master to slave, which that slave is also a master. We are replicating our web server to our stats server so we can report on users traffic as well. We'...
2
votes
2answers
2k views

Post Mortem Analysis: PostgreSQL replication failed

We have a PostgreSQL 9.4.9 production server which was replicating to a slave instance, but today I discovered that the instance is out of sync! The obvious actions would be to recreate the slave, ...
1
vote
1answer
876 views

Slave stoping with Last_SQL_Errno: 1032

I have added an extra Slave server to an existing MySQL Replication. The Master server and the old Slave server are working fine without any issue, but the newly added server is stoping with the ...
0
votes
1answer
446 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. ...
2
votes
1answer
964 views

How does one scale out with master-slave replication?

To my understanding, a master-slave replication might be set up where clients can read from multiple databases. However, they can only write to the master. I believe this helps guarantee ACIDity. I ...
3
votes
0answers
398 views

Replication doesn't resume once it fails to connect

We have MySQL replication running for our application. Right now the slave fails to resume if it fails to connect to the server for some time. We get the error below: [ERROR] Slave I/O: error ...
2
votes
1answer
278 views

Fetch just inserted data in master/slave model?

Say I have MySQL master DB(used for updates) and corresponding Slave DB(used for reads). Now user inserts the data into MASTER through application(java), just after insertion he tries to retrieve the ...
1
vote
0answers
168 views

MySql slave thinks that the query didn't run on the master, no helpful error

We have a master-slave replication that was running perfectly until recently. Today i've found the error: Query caused different errors on master and slave. Error on master: message (format)='Size ...
0
votes
2answers
321 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
190 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" : ...
2
votes
0answers
506 views

Cluster using docker

We are creating a new application using microservices, and for that we would like to be able to raise database instances just like we raise new instances for the application's microservices. We do not ...
0
votes
1answer
45 views

Can I edit queued MySQL binary logs for replication?

I have a simple Master-Slave replication set up, but Slave keeps falling behind do to what appears to be a simple checkout system. Master can keep up because it runs multi-threaded, but since the ...
0
votes
1answer
71 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 ...
2
votes
2answers
1k views

Importing a large mysql dump while replication is running

So we have a simple master/slave mysql replication running between two CentOS Servers. The master has multiple databases. eg.. Database1 Database2 Database3 The issue is we have a mysql dumpfile ...
0
votes
1answer
218 views

What sequence when changing the master MySQL server, but not IP?

I change the replica to the master server. But the IP master remains the same. * The second replica itself will continue to work, without changing the settings? * On the old master, just change ...
0
votes
1answer
2k views

Service mongod fails after adding security.keyFile in config file

My mongo.conf: # where to write logging data. systemLog: destination: file logAppend: true path: /var/log/mongodb/mongod.log # Where and how to store data. storage: dbPath: /var/lib/mongo ...
1
vote
1answer
303 views

sync_binlog different for master and slave

Is it fine if sync_binlog is different for master and slave? For my system I can see master has sync_binlog=1 and slave has sync_binlog=0.
2
votes
1answer
82 views

Options for having same tables in 2 different data bases

I need to know what options I have for my next problem: I have 2 databases (sql server 2012) first for an ERP second for an website For the website's database, I want to use a table (customer) ...
0
votes
1answer
41 views

Which server to be master and which one slave database?

I have an application for which I‌ want to set up a master/slave mysql database, because the current db struggles under high load. I have two different servers for db replication. Lets call them A ...
3
votes
2answers
185 views

MySQL chain replication timing of writes on first slave

With a MySQL chain replication setup, e.g. M1->S1->S2, what exactly is the order of operations for writing to the first slave? Is the binary log from the master simply streamed directly through ...
2
votes
1answer
364 views

PostgreSQL replication not working after base backup

Last week we had an incident with our master PostgreSQL server instance which got totally thrashed so, we had to switch to our slave as our one and only DB instance. After the initial chaos was ...
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 ...
1
vote
1answer
585 views

MySQL replication works but slave keeps reconnecting to master

I have a master-slave set-up with multiple slaves in different datacenters. One of the slaves stopped working normally today. This was easily resolved by restarting mysqld but ever since (and perhaps ...
0
votes
1answer
288 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 ...
1
vote
2answers
769 views

Need help with Master Slave Replication

I want to set up a Master-Slave Replication. Therefore I followed the MySQL manual. Once I was I wanted to test it. I've let me show the slave status with was as following; Slave_IO_State: Waiting ...
0
votes
1answer
198 views

MySQL Master Slave Replication where master is not allowed to talk to slave

I want to set up an Master Slave Replication between 2 different servers. The specialty is, that the Master is not allowed to talk to the slave, but the slave can talk with the master. I can not ...
2
votes
1answer
401 views

Why does mysqldump stop the slave SQL thread for the entire backup?

I realized recently that I was using --master-data to dump a backup from a replication slave when what I really wanted was --dump-slave. After switching to --dump-slave, I see that mysqldump will stop ...
2
votes
0answers
61 views

Fault tolerant cross datacenter MySQL replication & failover strategy [duplicate]

Which of the following method is the most fault tolerant way to achieve cross datacenter MySQL replication using DNS failover and why? MySQL master-master replication with one primary/active node and ...
3
votes
2answers
44 views

How do I create a MySQL slave server of a bunch of MyISAM databases on a master

I have a MySQL master server and slave became corrupt because of space issues on the master. Binary logs are potentially corrupt and I don't trust them. The databases are using MyISAM tables. I want ...
0
votes
1answer
281 views

Understanding Simple MongoDB Replication Works

I've been using MongoDB (3.2.9) replication for years and barely know the detail how it works. My Stack is Rails 4.2.5 with Mongoid 5.1.3. I've 3 database servers, let's call them A (Primary), B (...
4
votes
1answer
506 views

Can PostgreSQL slave server act as master for a new database?

My question is somewhat related to: https://stackoverflow.com/questions/19331577/does-postgres-replication-native-support-per-database-level-replication We have master-slave replication set up on ...
0
votes
1answer
359 views

How to create a multiple mysql replication

My question is about to create a mysql replication server. Here i have multiple slaves and i want replicate all respective database into multiple master server . Que is that how could i set multiple ...
1
vote
0answers
213 views

Master-slave + master-master replication at the same time

Can a MySQL database which is doing master-slave replication to a number of slaves be configured to do master-master replication to a new server at the same time? I have an application that has a ...
1
vote
1answer
32 views

runtime replication

We have a master-master replication setup with 3 databases being replicated between both masters; 'database a', 'database b', 'database c'. Replication is row-based. 'database c' had an issue and we ...
1
vote
1answer
29 views

Lost entire MySQL Server. Unsure if “master-slave” or “master-master” - How to tell?

Yup - my db02 server lost a disk, and the array itself is corrupt (RAID5, yet corrupt data.) I was able to get the OS back online, but the corruption is severe. I have zero documentation about the ...
1
vote
2answers
62 views

MYSQL DATABASE BACKUP

Currently my backup strategy invloves :- 1)I have one master server and two slaves (Data approximately 700 GBs and tables are of mixed innodb and myisam). 2)I take weekly and monthly backup from ...