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

Questions tagged [master-slave-replication]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
77 views

Master-Slave semi circle replication not working in MySQL

I didn't know how to describe it so I am calling it semi circle. Here's what I am doing. Server A Server B = This is slave of Server A Server C = This is slave of Server B When I update something ...
3
votes
0answers
6k views

Slave is not configured or failed to initialize properly. You must at least set --server-id to enable either a master or a slave

I am trying to setup multi source replication. In my slave I have defined following two properties in its configuration file. master-info-repository=table relay-log-info-repository=table These ...
3
votes
2answers
3k views

MySQL slave not able to execute long running update query

I am running a Master-slave replication servers of MySQL. As part of clean up of old data, i ran a delete query which deletes huge number of records from the database. It ran fine on Master server but ...
0
votes
3answers
3k views

Metrics for monitoring master-slave replication

Is there some kind of query/view/table available in PostgreSQL that can reflect the actual status of a master-slave replication process? Perhaps the "degree" of sync between the nodes? The above is ...
2
votes
2answers
4k views

org.postgresql.util.PSQLException: ERROR: canceling statement due to conflict with recovery

I currently have a PostgreSQL slave node that is presenting problems, that don't arise in the master node. Seems to be related with the node sync process. Complete stacktrace: org.postgresql.util....
1
vote
3answers
1k views

Select from slave and insert into master in MySQL

Because of pressure on my servers and variety of applications on my servers I was wonder if can I have application or proxy to select from slave database and insert into master. I'm using PHP/Laravel ...
5
votes
3answers
4k views

MySQL Master/Slave replication on same VM instance?

I'm fairly new to databases so I hope this isn't a silly question! Is it possible to set up master/slave replication on the SAME server? I understand there are not any advantages to this in terms of ...
11
votes
2answers
25k views

Trying to understand SHOW SLAVE STATUS in MySQL

I have a Master-Slave replication setup and it looks like that it is running fine. Below is a result of SHOW SLAVE STATUS command: show slave STATUS\G; *************************** 1. row *************...