Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [master-slave]

125 questions
2
votes
2 answers

--log-slave-updates is OFF but some updates are still logged to the slave binary log?

MySQL version 5.5.14 According to the document, by the default, slave does not log to its binary log any updates that are received from a master server. Here are my config. on the slave: # egrep 'bin|slave'…
quanta
  • 51,413
  • 19
  • 159
  • 217
2
votes
1 answer

M-M or M-S replication of EBS volume across multiple EC2 instances

I would like to share EBS backed file system of size up to 20GB in 200K files across multiple EC2 instances. Master-master would be ideal, but I'd be happy with master-slave solution too. I know that generic Linux solution would be to use DRBD, but…
vartec
  • 6,217
  • 2
  • 33
  • 49
2
votes
2 answers

Mysql leave slave 1 hour behind

Is it possible to leave the mysql slave 1 hour behind? I would like to create an script wich stops the slave when I markup some hacks such as big drop tables and stuff, to make this work I would like to stop the slave when this happens.
Ronn0
  • 105
  • 1
  • 7
2
votes
2 answers

Replicate MySQL database with "non-permanent" write

I'm working with a production MySQL database and I would like to: Create a read-only slave copy of the database that gets updates from the master. The master is the only one that can be written onto. Have "non-permanent write" access to the slave…
Shlomo Shmai
  • 99
  • 1
2
votes
1 answer

How to properly backup and restore mariadb master/slave

I've got a master/slave mariadb setup using gtid. As far as I've read I should prefer using the slave side for backups. But what's in case of a desaster? Can I restore the slave in the new master? And what's the way to restore it properly? Do I have…
meme
  • 43
  • 4
1
vote
1 answer

Jenkins slave unable to clone from Gitlab

I have an autoscaling Jenkins cluster on AWS, which spawns & runs agents via JNLP. Both Master & Slaves run on Ubuntu. I don't quite understand where Jenkins actually stores the SSH keys for Gitlab, or if/how the slaves are expected to use…
Mcar49
  • 113
  • 1
  • 3
1
vote
1 answer

Promoting MYSQL Slave to MYSQL Master

I have a MySQL setup with one master (M1) and one slave(S1). Due to some unforeseen issue I need to promote my slave server to master and demote master to slave. My MySQL version is 5.6 in Linux. Please let me know the exact process as this is the…
Anand Shrestha
  • 41
  • 5
  • 12
1
vote
1 answer

MariaDb Master-master replication

I tried master-slave replication of mutliple databases of mariadb-5.5.52-1 in RHEL environment, the mariadb came as a part of nagiosxi application. while replicating from master to slave i had many duplicate errors 1602, the master cannot overwrite…
mohan reddy
  • 11
  • 2
1
vote
1 answer

Zone transfer from KNOT (master) to BIND (slave) fails with NAUTH

There is a KNOT DNS master name server that I do not manage myself for my domain. I try to setup a BIND DNS server as a slave in-house. BIND fails to do the zone transfer and reports 31-Dec-2017 16:19:02.503 zone whka.de/IN: Transfer…
user2690527
  • 121
  • 3
1
vote
2 answers

MySQL master-slave replication not updating

This is my first time setting up master-slave replication. I am using this as a guide. I followed the steps and all works till the last part when i need to verify the replication. When i create a new table and INSERT some data to the table in the…
user311807
  • 11
  • 1
  • 1
  • 2
1
vote
1 answer

Best method to ensure Mysql master slave replication is consistent?

I am running a master slave replication system on AWS EC2 systems over ssh. However I came across a couple of best practice articles indicating that even this might allow inconsistencies to creep into the databases - I'd like to know what is the…
user1658296
  • 169
  • 1
  • 2
  • 8
1
vote
1 answer

How to configure an additional BIND instance for a domain already described by other public name servers?

Background I have a small virtual server hosted by my provider and there I have configured a relatively simple combination of postfix, dovecot and roundcubemail (backed by nginx) that works OK. I wanted to add support for SPF and DKIM. To do that I…
flashheart
  • 11
  • 2
1
vote
1 answer

Percona xtradb cluster with asynch slaves

I have a Percona xtradb cluster set up with 3 nodes. Node 1 is also set up as a master with an asynchronous slave. When I make an update to Node 1, it is replicated to the cluster as well as the slave. However, when I make an update to Node 2 or…
Francis Snipe
  • 165
  • 5
1
vote
2 answers

Ulimit settings in Oracle 11g on Linux 5

Is there an issue with "Ulimit -Hn" being set too low (at 1024) when (Oracle recommend 65536)? This is for Oracle 64-bit 11g on Linux 5. It is one of the settings that appears to be woefully short of its recommendation. But I am also aware that the…
Stuart
  • 21
  • 3
1
vote
1 answer

MongoDB ReplicaSet Elections when some nodes are down

I'm trying to get into ReplicaSet concept, and found something weird in mongoDB Documentation: For a node to be elected primary, it must receive a majority of votes. This is a majority of all votes in the set: if you have a 5-member set and 4…
SecondThought
  • 409
  • 1
  • 4
  • 11
1 2 3
…
8 9