Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [master-slave]

125 questions
1
vote
1 answer

Backups from MySQL slave server -- Good idea or bad?

I'm have one MySQL master and two MySQL slaves set up to replicate. I'm running my database backup process, consisting of an Xtrabakup (via the perl wrapper Innobackupex) backup and an atomic mysqldump, off one of the slaves. This morning, I…
CamelBlues
  • 303
  • 4
  • 10
1
vote
3 answers

Can DNS do failover switch for a domain?

I have heard about round robin solution. But that one is making different request to different ips to do load balancing. What I want is making one IP as master, only if it dies, the DNS server switch the IP to server B. Is it possible on a Windows…
Tommy
  • 123
  • 1
  • 6
1
vote
1 answer

mysql replication - slave seems up to date but data not synchronized

I have a master-slave setup with 2 servers over a network. Due to an error, the slave IO thread stopped, though I could get it started and running, the slave is way behind the master. Also, SHOW SLAVE STATUS shows Seconds_Behind_Master: 0. Have a…
shyam
  • 187
  • 3
  • 13
1
vote
3 answers

MySQL slave reporting incorrect values for Seconds_Behind_Master

I have a MySQL slave that when it is 0 seconds behind the master, it correctly reports 0 Seconds_Behind_Master. However, if it gets even 1 seconds behind, it reports 14401 Seconds_Behind_Master (which is 4 hours and 1 second behind). The unix date…
Mike Sherov
  • 113
  • 1
  • 7
1
vote
1 answer

Erratic Seconds_Behind_Master

One of my MySQL slaves will at one moment, report 57 seconds behind master, and the next will show 0. I am also monitoring with mk-heartbeat which shows an average of less than 1 second. MySQL and system dates are correct. How exactly does MySQL…
sreimer
  • 2,218
  • 15
  • 17
1
vote
1 answer

Master Server Bind i's OK but Slave NO

I install two dns server (BIND 9) was the first master, the second is slave. In Master Server: The file /etc/bind/named.conf.local zone "globaltic.tk" { type master; file "/etc/bind/db.globaltic.tk"; notify no; allow-transfer {…
tmedtcom
  • 127
  • 2
  • 9
1
vote
2 answers

master-slave datastore replication, automatic failover, and wackamole

I have 2 dedicated servers provisioned for my next project's datastores. The datastores are configured for master-slave replication. There's no inherent automatic failover but I of course want this. That is, I'd love for access to the master…
z8000
  • 792
  • 1
  • 7
  • 15
1
vote
2 answers

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 the Master-Server I get this Error on the Slave: No…
zenz
  • 11
  • 1
1
vote
1 answer

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 works with those wordpress+woocommerce sites. First,…
Philip
  • 25
  • 3
1
vote
1 answer

How to setup a master-slave connection with an invisible master?

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 home. All this data gets stored in a MariaDB…
MeineHTMLCodes
  • 121
  • 5
1
vote
1 answer

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 = master xx.xxx.xxx.206 = slave …
Karippery
  • 21
  • 1
  • 4
1
vote
0 answers

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 Unbounds in Datacenter B All managed by Puppet. No…
JayBe
  • 11
  • 1
0
votes
2 answers

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 and configured them so as: vim rpuser.ldif…
Marco Ferrara
  • 169
  • 6
0
votes
2 answers

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 work. There's two way probably to solve it Priority…
YCS
  • 1
  • 2
0
votes
1 answer

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 ports are open. The solution needs to be easy to turn…
Ron Christian
  • 1
  • 1
1 2 3
…
8 9