Questions tagged [master-slave]
The master-slave tag has no usage guidance.
126
questions
0
votes
0
answers
34
views
How to remove a query from a MySQL master/slave setup that is causing the slave instance of MySQL to crash?
Specifically I have a query that is trying to grant privileges that for whatever reason is causing the slave MySQL instance to crash. As a result I can't even bring up the mysql console from the ...
- 113
1
vote
2
answers
1k
views
PowerDNS Master/Slave AXFR chunk error: Server Failure
Short description I´m running two PowerDNS 4.2 machines on Ubuntu 20.04 with PowerDNS-Admin and PowerDNS-recursor. Both machines use mysql backends.
The problem is, wehn ever I start a NOTIFY from ...
- 11
0
votes
1
answer
475
views
MariaDB Master-Master replication with 3 servers, no ports open on master
I want three MariaDB database servers, one master and two "slaves". I want to be able to read and write on every server, and have this replicated on the other servers. I read on the internet ...
-1
votes
2
answers
323
views
MySQL replcating huge changing data
Hi I have a master MySQL server with 950 gb of data and slave has stopped for some reason and there is a difference of 80gb of data.
so I started to setup new slave .
Since the data is changing and ...
0
votes
1
answer
256
views
Why is Server working Slow and bandwidth chokes
We have a cloud server. We have load balancer of 3 server and one public IP. We have master slave for DB Connection.
The application serves some data to users, the users post some data and some files ...
- 3
1
vote
1
answer
618
views
How to handle failover for wordpress woocommerce store?
I am working on a project with multiple WordPress + Woocommerce stores. We have 3 dedicated servers. As the traffic grows. Sometimes, the server is down. I am looking for a failover solution that ...
- 35
1
vote
1
answer
257
views
How to setup a master-slave connection with an invisible master? [closed]
I know, the question may sound weird at first but let me explain some things, I'm sure you will understand my problem after that:
I have a raspberry pi recording all data from my weather station at ...
- 121
1
vote
1
answer
8k
views
psql: could not connect to server: No route to host
I know this is repeated question but I didn't found any solution
I want to Set-Up Master-Slave Replication for PostgreSQL 9.6 in Debian 9. But slave server could not connect master .
xx.xxx.xxx.205 = ...
- 21
2
votes
1
answer
1k
views
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 ...
- 43
0
votes
0
answers
276
views
Mysql 5.7 slave poor performance with 5.6 master
We recently reinstalled 3 of our mysql servers running in master slave with percona 5.7 and ubuntu 18.04 instead of oracle linux 7. These servers are currently connected to a mysql 5.6 master. And ...
1
vote
0
answers
24
views
Using bind 9.11 with Masters Only
a little bit of background Information before asking the question: Our current setup is:
1 Master bind and 1 Slave bind in Datacenter A
2 Slave binds in Datacenter B
2 Unbounds in Datacenter A
2 ...
- 11
1
vote
2
answers
7k
views
bind9 not working when starting bind9 service but works when explicitly starting named
I have a really odd situation I don't fully understand. I have a master and slave DNS, I've checked the configuration, and no errors are returned. if I try to start bind9 as a service, it fails to ...
- 45
0
votes
1
answer
2k
views
Bind9 Slave not resolving clients queries
I have two VM's running OpenSUSE 15, one master and one slave.
Master is running well and transfer the zones file to the slave correctly but if I stop the bind on master server, slave should respond ...
0
votes
2
answers
2k
views
OPENLDAP Master/Slave replication stopped
I configured my system in this way:
Master OpenLDAP 10.100.1.6 and slave OpenLDAP 10.100.1.7
I used this guide:
https://www.itzgeek.com/how-tos/linux/configure-openldap-master-slave-replication.html
...
- 169
0
votes
2
answers
3k
views
Keepalived two master have virtual IP simultaneously
It's really strange on my BACKUP device always turn to MASTER several secs.
I've already search both master have virtual IP simultaneously cases,and all of there solution I've tried, but still not ...
- 1
0
votes
1
answer
883
views
trying to close two ports with firewalld, leaving everything else open
I think I'm using the wrong technique, but not sure of the right one.
Machine: Red Hat release 7.2
firewalld.noarch: 0.3.9-14.el7
I've been asked to close two ports but insure that all other ...
1
vote
1
answer
4k
views
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 ...
- 113
1
vote
1
answer
8k
views
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.
...
4
votes
4
answers
19k
views
Jenkins build happening on master instead of slave
I have been working on an android OS build automation through Jenkins and the repository is massive and the build itself takes a fair amount of time. Therefore, I need to to run on my slave that has ...
- 237
3
votes
2
answers
10k
views
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 ...
- 425
0
votes
1
answer
1k
views
Keepalived loadbalancing with Nginx not working with only backup Nginx alive after Master Nginx dies
I am using 2 Nginx servers on 2 different machines with Keepalived installed respectively on both machines. Below is the configuration for both Keepalived.
MASTER KEEPALIVED
vrrp_instance VI_1 {
...
- 101
0
votes
1
answer
2k
views
Mysql Master-Slave replication database duplication issue
I have done master-slave replication for performing web-server mirroring. Web contents are getting replicated properly. But I am facing issue in database replication. Database is replicated and slave ...
1
vote
1
answer
2k
views
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 ...
- 11
0
votes
4
answers
8k
views
MySQL Master-Master with offsets getting ERROR 1872
I'm trying to fix the replication between a master-master MySQL database replication model.
Server 1 (with the IP of 192.168.2.6) is configured with:
auto-increment-increment = 2
auto-...
- 101
0
votes
1
answer
465
views
Master/Master and Master/slave replication issues on raspberry pi 3
So for 2 weeks, I've been trying to set a Master/Master replication ( with apache2 web server and mariadb database ) on two Raspberry pi using different methods I've found all over the web ( french ...
- 11
1
vote
1
answer
2k
views
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:...
- 301
0
votes
1
answer
589
views
Centos 7 , Master-slave replication iptables?
This is the iptables on my mysql_slave server:
# sample configuration for iptables service
# you can edit this manually or use system-config-firewall
# please do not ask us to add additional ports/...
- 1
0
votes
1
answer
607
views
overwrite values with mysql master-slave replication
I have a production database with master-slave replication being done on it. Production DB backups are done off of the slave server.
I'd like to make it so that an arbitrary number of development ...
- 349
0
votes
1
answer
702
views
Domain Slave Zone Definition
I've been using Linode for about a year, and am still confused by 'Master' Domain Zone and 'Slave' Domain Zone terminology on their DNS Manager. The term 'Zone' in conjunction with 'Master' AND 'Slave'...
- 123
0
votes
1
answer
209
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 ...
- 783
2
votes
1
answer
4k
views
Multi source replication not working in MySQL
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 ...
- 783
0
votes
1
answer
149
views
Making master server slave of another master
I have 4 MySQL servers Master1, Master2, Master3 and Master4.
Both Master1 and Master2 are masters of each other while Master3 and Master4 are masters of each other.
I want to make Master3 slave of ...
- 783
3
votes
2
answers
4k
views
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 ...
- 783
0
votes
2
answers
389
views
Bind DNS named.config serial- Should it autoincrement? Alternatives to ammending it each time
I'm configuring a DNS service for the first time which involves a master DNS server and a slave DNS server. On investigating why the slave zones were not updating after I make edits to the zones on ...
- 51
5
votes
2
answers
5k
views
Slave DNS server (bind) zone files transffered but data is unreadable
I've set up a slave DNS server on Linux using bind. On starting the named service the zone files transffered to slaves/ but the information in the files looks like its in strange computer symbols (i'm ...
- 997
2
votes
1
answer
1k
views
Port out of range in ReplicatedDB ActiveMQ
I have 3 replicated machines with Zookeeper and ActiveMQ (linux).
I can confirm that zookeeper works correctly since I can see their ports (2888 and 3888) listening via netstat. The problem is ...
- 121
0
votes
1
answer
81
views
creating a consumer by cloning the provider in openldap, anything wrong with that?
I have setup an ldap server on centos 7 as a provider and created a consumer by simply cloning the provider and adding syncrepl.ldif to it and seems to work just fine. In all the documentations and ...
- 169
0
votes
1
answer
490
views
Can not select multiple LDAP servers with authconfig bug report
There is this bug report "Can not select multiple LDAP servers with authconfig"
Red Hat Bugzilla – Bug 1142830; https://bugzilla.redhat.com/show_bug.cgi?id=1142830
which is suppose to be solved on ...
- 169
0
votes
1
answer
70
views
how a client switches from provider to consmure openldap centos 7
I have setup a basic provider/consumer and client openldap on centos 7. Data does get replicated to the consumer when I add something to the provider and it is all synced up. The client can read info ...
- 169
0
votes
1
answer
2k
views
openldap replication on centos 7 not replicated
I have setup a simple openldap server on centos 7 minimum. Added a couple of users and setup a client that can retrieve the users using getentpasswd and ldapsearch works fine between the two. Then I ...
- 169
0
votes
1
answer
692
views
Master and slave bind DNS servers with different version
I am having issues with my master-slave setup, so I'm trying to release what is an causing troubles.
Master is running on CentOS Linux release 7.1.1503 (Core) and using BIND 9.9.4-RedHat-9.9.4-29....
- 13
0
votes
1
answer
4k
views
Mysql master-slave replication very slow
We're running a MySQL master-slave replication set-up and the slave is very slow at catching up. There seems to be no high network or cpu usage while the slave is going through the masters' logs. ...
- 151
0
votes
3
answers
1k
views
Web Server failover solution [closed]
Sorry for a dumb question but I`m a green hand yet.
I have two Linux server: one of it is running Apache with MySQL to serve my web-platform (master server) another one is supposed to be a sort of ...
- 33
2
votes
2
answers
1k
views
The right way to set up master and slave nameservers
I'm wondering about the proper way to set up a master and slave DNS.
I read somewhere that your master DNS server should not have an NS record in your zone file - that's sort of secret and then your ...
- 121
1
vote
2
answers
16k
views
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 ...
- 11
0
votes
1
answer
543
views
XtraBackup restore gives duplicates on slaving?
We've recently upgraded a MySQL 5.0 master-master setup to Percona 5.6. Slaving went b0rken due to some failures on our side, but we thought we could simply fix it by using xtrabackup to create a ...
- 628
2
votes
1
answer
4k
views
BIND9: Send Notifications on Specific IP Address
I've been trying to implement a bind master->slave setup between two machines, but I've a problem regarding the IP address BIND used on the master to notify my slave machine.
Here is my setup:
...
- 1,288
1
vote
1
answer
250
views
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 ...
- 169
0
votes
1
answer
1k
views
CRUD with MySQL Master-Slave Architecture
I have setup mysql master-slave replication with 1 master and 3 slaves. Now that I have finished setting up the architecture I am curious as to the best way to make my reads. I realize all writes, ...
- 171
0
votes
2
answers
12k
views
ERROR 1130 (HY000): Host 'host' is not allowed to connect to this MySQL server, only on slave
So I have a master and a slave in a mysql cluster, the syntonization works as it should however I am not able to connect to the slave from any host except from the server it self.
I have no problems ...
- 1