Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [master-slave]

125 questions
4
votes
2 answers

How to change the master in a MongoDB cluster without restarting the process?

Reading the documentation of MongoDB about how to configure a master-slave configuration of a cluster (our cluster will have more than 12 nodes, so unfortunately we can't have a replica-set configuration), how can I promote a slave to master without…
Kico Lobo
  • 145
  • 2
  • 6
4
votes
4 answers

Can you have multiple writable, authoritative BIND DNS servers for the same zone, like AD-integrated DNS?

In an AD-integrated DNS system, there really isn't a concept of one "Master" DNS server; all AD-integrated zones are authoritative and updatable across all DNS servers, and send updates to each other on a regular basis. Is there a similar…
Jeremy Holovacs
  • 407
  • 1
  • 6
  • 22
4
votes
1 answer

Configure fallback redis server

I am using redis as a cache server. Can I somehow configure multiple redis servers, that the cache is fully functional (read/write) even if some of them go offline? I looked into master->slave, but the problem I see there is, that if the master…
snøreven
  • 165
  • 1
  • 9
4
votes
1 answer

Using Amazon RDS (or similar) as a slave

Officially, RDS instances can't be directly set up to slave non-RDS databases. My production master is MySQL running on Hetzner and I want an RDS instance to closely follow it for backup purposes, including for the ability to actually use the RDS as…
GJ.
  • 529
  • 1
  • 7
  • 21
4
votes
2 answers

How to slave real-time data from two MySQL sources merging in to one MySQL destination?

I have two different MySQL instances that I would like to 'slave' to a third instance. (so I can do easy joins on the third instance) eg. mysql1> show databases db1 db2 mysql2> show databases db3 db4 mysql3> show databases db1 db2 db3 db4 I've…
Joel K
  • 5,853
  • 2
  • 30
  • 34
4
votes
1 answer

making slave server as master for another server

I have three servers, Server X, Y, and Z. I have the main mysql DB on X (innodb DB). now I have created Master-Slave from X to Y. everything is working fine here. and now i set Y as a master for Z. when i do show slave status on Z (the third…
Alaa Alomari
  • 638
  • 6
  • 19
  • 37
4
votes
2 answers

Why does MySQL replication break on missing row, then continue after "START SLAVE"?

The title is a bit confusing, but I can't think of a better one. What I have is a simple vanilla MySQL replication, with the slave occasionally failing, with this error: Error 'Can't find record in 'my_tbl'' on query. Default database: 'my_db'.…
shlomoid
  • 289
  • 3
  • 14
4
votes
3 answers

Automated failover strategy for master-slave Mysql replication - why would this not work?

I'd like some feedback about this failover strategy for a couple of MySQL servers I'm speccing up for a cluster, and I want to check if there's something obvious I'm not missing here. One app server that connects to a mysql master server in day to…
Chris Adams
  • 709
  • 3
  • 11
  • 18
3
votes
1 answer

Apache Derby master/slave replication and clustering

I'm interested in the possibilities of master/slave replication for Derby in client/server mode (if at all possible). However, I'm unable to find any material that either explains it in a decent fashion or is able to convince me that master/slave…
Luke
  • 3,826
  • 8
  • 36
  • 40
3
votes
2 answers

Jenkins windows slave unable to connect

Trying to start Jenkins slave on Windows with Java Web start gives me this: >java -jar agent.jar -jnlpUrl https://jenkins.example.com/computer/slave-office/slave-agent.jnlp -secret 74aebde5a38c4f19b0b6c64ee9d3d75571d6cd666e67ebae7d39d8b259d39a0f…
GTXBxaKgCANmT9D9
  • 415
  • 1
  • 7
  • 16
3
votes
2 answers

Why Redis slaves don't take over the master after master fail in Redis Cluster?

I have a Redis Cluster with 2 masters and 4 slaves (2 slaves for each master). After I manually crash a master (i.e. redis-cli -p 6379 debug segfault) slaves doesn't do anything. They detects that something wrong with the master but they are doing…
Oleksandr
  • 733
  • 2
  • 10
  • 17
3
votes
1 answer

Howto do VCSA redundancy?

We are currently in the process of setting up a new VMWare environment which is now only in lab phase. We are studying the possibility to have a vCenter cluster with an active and a standby/mirrored/whatever... vCenter, this is with the VCSA…
Nicolas Toureur
  • 39
  • 1
3
votes
1 answer

MongoDB -what's the safest and most efficient way to change from Master-Slave to ReplicaSet?

I now have two mongo servers with a Master-Slave configuration (all read-writes are done with the Master, the Slave is just a cold backup) serving a pretty demanding web app. I want to switch to ReplicaSet of 3 servers - I have these 3 already…
SecondThought
  • 409
  • 1
  • 4
  • 11
3
votes
1 answer

pgpool2+streaming replication failover on only 2 servers?

I am trying to configure pgpool2 and postgresql 9.1 to handle failover. I currently have streaming replication running, and are using pgpool2 for read-only load balancing. I have 2 servers in my setup, both running postgresql - 1 master and 1…
aneez
  • 31
  • 2
3
votes
2 answers

Online Schema Change Strategies for Large MySQL Tables

I'm curious to hear strategies and methods people use for performing alters on very large tables in MySQL. Large could be any number of rows or size that would be impacting to alter. For the sake of conversation, let's say 2 million+ rows to which…
sinping
  • 2,070
  • 14
  • 13
1
2
3
…
8 9