Questions tagged [master-slave]
The master-slave tag has no usage guidance.
126
questions
19
votes
5
answers
33k
views
Modifying columns of very large mysql tables with little or no downtime
I periodically need to make changes to tables in mysql 5.1, mostly adding columns. Very simple with the alter table command. But my tables have up to 40 million rows now and they are growing fast... ...
- 365
14
votes
3
answers
7k
views
How to setup MySQL replication with minimal downtime
Basically we have a large MySQL database and we're looking to do replication to a slave (master slave setup). Do you guys have any step-by-step guide on how to do this with MINIMAL downtime on the ...
- 455
12
votes
3
answers
33k
views
BIND, Master, Slaves and Notify
It might seem like a very basic question, but, how is a master DNS server aware of its slaves?
I mean, does it parse the zone file and determine where to send the NOTIFY message?
And if that is the ...
- 842
11
votes
4
answers
56k
views
MySQL simple replication problem: 'show master status' produces 'Empty set'?
I've been setting up MySQL master replication (on Debian 6.0.1) following these instructions faithfully: http://www.neocodesoftware.com/replication/
I've got as far as:
mysql > show master status;...
simon
10
votes
3
answers
32k
views
Bind zone transfer refused
UPDATE:
BIND Version:
[[email protected]] $ named -v
BIND 9.3.6-P1-RedHat-9.3.6-16.P1.el5
Operating System:
CentOS release 5.6 (Final)
After running [[email protected]] $ dig @10.224.45.130 ...
- 251
9
votes
4
answers
32k
views
How to find slave's IP address and user name from Master server?
I am writing code to extract the IP address and username of all slave servers in a MySQL replication environment.
Does anyone know any function, variable, or something else that I can run in the ...
- 321
9
votes
2
answers
19k
views
Mysql Slave stuck in "System lock"
My MySQL slave is spending a lot of time in Slave_SQL_Running_State: System lock. I can see that the system is currently I/O write bound, and that it is processing the log, although slowly. Show ...
- 1,463
7
votes
2
answers
4k
views
Magento hosting on a budget
I have to do a setup for Magento. My constraint is primarily ease of setup and fault tolerance/fail over. Furthermore costs are an issue. I have three identical physical servers to get the job done. ...
- 303
7
votes
6
answers
7k
views
Is it possible to use an EC2 RDS MySQL instance as a slave to an external master?
I have a master MySQL instance running on our local network, but I was wondering if I can get an EC2 RDS instance to replicate the master or is this locked down by amazon?
user57758
7
votes
4
answers
32k
views
BIND slave doesn't sync up with master until it is restarted
I have two DNS servers running BIND9, one master and one slave. When the zone file is updated on the master, I want the slave server to immediately start serving the changed record(s), but BIND is ...
- 13.6k
7
votes
1
answer
11k
views
Pacemaker DRBD resource not getting promoted to master on any node
First off, I'm no linux specialist, I've been following tutorials and been working with the help of google, this worked out fine until now, but currently I'm stuck with a problem.
I'm using CentOS 6.5 ...
- 71
6
votes
2
answers
8k
views
MySQL slave replication reset with no Master Downtime (using MyISAM)
Root of the issue:
In all instructions for creating a slave on a running master requires flush tables with read lock. We use MyISAM, so we can't just use --single transaction to get consistent table ...
- 282
5
votes
4
answers
11k
views
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 ...
- 417
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
4
votes
2
answers
3k
views
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 ...
- 145
4
votes
3
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 ...
- 217
4
votes
1
answer
11k
views
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.
...
- 638
4
votes
3
answers
10k
views
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 ...
- 709
4
votes
1
answer
3k
views
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 ...
- 165
4
votes
2
answers
2k
views
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 '...
- 289
4
votes
2
answers
2k
views
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
...
- 5,933
4
votes
1
answer
981
views
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, ...
- 539
4
votes
0
answers
9k
views
Nameserver: Slave can't transfer zones from master [closed]
My slave can't transfer the zones from the master.
My configuration:
Master server: Ubuntu 12.04 with Plesk 11.5. Plesk uses Bind 9 as nameserver.
Slave server: Ubuntu 12.04, Bind 9.
To tell the ...
- 41
3
votes
4
answers
474
views
Old, stale DNS slave server considered harmful?
Its been a while since I was dabbling in DNS setups, so my knowledge might be a bit outdated.
We have a domain for which master server is administered by our team, and slave server is provided by the ...
- 470
3
votes
2
answers
2k
views
mk-table-sync in a master-slave scenario: Changes not replicated to the slave
I have being employing mk-table-sync to synchronise tables from a
master to slave on mysql 5.1.
Unfortunately, while differences are correctly detected, modifications done on the master (DELETE,...
- 115
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
3
votes
1
answer
817
views
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 ...
- 409
3
votes
1
answer
5k
views
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 ...
3
votes
2
answers
1k
views
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 ...
- 2,090
3
votes
1
answer
1k
views
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/...
3
votes
1
answer
2k
views
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 ...
- 31
3
votes
1
answer
993
views
Hadoop slaves file necessary?
I'm working on a team trying to create a system for creating Hadoop clusters on EC2 with minimal effort on the part of the user. Ideally, we would like slave instances to only require the hostname of ...
- 235
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
2
votes
3
answers
8k
views
BIND Slave Receiving Notify From Other Slave?
I have a master nameserver setup with a few slaves as well. Today I was changing one of the slaves to a new server when I came accross a weird error message.
After updating the DNS records on the ...
- 586
2
votes
2
answers
3k
views
Overwrite SOA expiry in a bind9 slave name server
I run a slave name server of a domain that I do not have full control over (i.e. changing the SOA is not possibly). The SOA specifies an expiry time of one week. For various reasons, I’d like to ...
- 4,049
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,258
2
votes
3
answers
4k
views
MySQL - Does the change in MySQL master db password affect on slave db?
I want to change the MySQL DB password on the master db. My question is: do we have to care for the slave DB when changing the master database password?
- 423
2
votes
1
answer
4k
views
BIND no longer responds to AXFR Requests
Recently we moved our primary external DNS server. It has three caching DNS slaves in front of it provided by our ISP. They've told us they've started getting access denied requests when doing zone ...
- 1,130
2
votes
2
answers
8k
views
--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 '...
- 52k
2
votes
1
answer
2k
views
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 ...
- 6,247
2
votes
2
answers
492
views
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....
- 99
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
2
votes
1
answer
132
views
Performance-wise, is a DNS Slave better to have than two duplicate Masters?
I have two bind9 servers that are not setup with duplicate settings and know nothing about each other. Our CPU usage is sitting around 7% - 10%: mostly bind, which I believe is perfectly in range for ...
- 1,275
2
votes
2
answers
13k
views
mySQL: Slave not able to connect to Master for replication
On my master, I did:
GRANT REPLICATION SLAVE ON *.* TO 'repluser'@'%' IDENTIFIED BY 'mypassword';
On my slave, I see:
mysql> show slave status \G;
*************************** 1. row *************...
- 901
2
votes
2
answers
216
views
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 ...
- 105
2
votes
1
answer
960
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
2
votes
1
answer
2k
views
Bind9 Master Slave replication
I have Bind9 on Debian for NS1 and NS2
They are two virtual machines.
I create a file /etc/bind/zones/db.domain.com
Then I have to add this to the /etc/bind/named.conf.local
zone "domain.com" {
...
- 215
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
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
2
votes
1
answer
2k
views
I really want a wildcard NS record in BIND. Is there a workaround? [duplicate]
We have a public DNS provider, a private DNS master, and a private DNS slave.
The public DNS provides the "example.com" zone, and all of it's subdomains.
Our private DNS also provides the "example.com"...
- 340