Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [master-slave]

123 questions
19
votes
5 answers

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... So those alter table commands take several…
apptree
  • 345
  • 1
  • 3
  • 10
14
votes
3 answers

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 database? Backing up the database and transferring…
Patrick
  • 455
  • 1
  • 7
  • 10
11
votes
3 answers

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 case, then, is the NOTIFY mechanism broken in a…
Peter
  • 802
  • 2
  • 10
  • 23
10
votes
3 answers

Bind zone transfer refused

UPDATE: BIND Version: [root@10.224.45.130] $ named -v BIND 9.3.6-P1-RedHat-9.3.6-16.P1.el5 Operating System: CentOS release 5.6 (Final) After running [root@10.224.45.131] $ dig @10.224.45.130 example.com. axfr: Slave: ; <<>> DiG…
Sarah Ryan
  • 251
  • 1
  • 3
  • 11
10
votes
4 answers

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; but this is unfortunately producing the following,…
simon
9
votes
2 answers

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 processlist doesn't show anything other than "Waiting…
Greg
  • 1,353
  • 1
  • 12
  • 13
9
votes
4 answers

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 console and retrieve these infos without looking into…
Kourosh Samia
  • 301
  • 1
  • 5
  • 12
7
votes
1 answer

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 and DRBD version 8.4.4. I have two nodes running…
Infi
  • 71
  • 1
  • 3
7
votes
3 answers

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 giving me some guff. DNS zone transfer is already…
Nic
  • 13,025
  • 16
  • 59
  • 102
7
votes
2 answers

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. Each server node has an i7 quad core, 16GB RAM,…
spa
  • 293
  • 2
  • 8
7
votes
6 answers

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
6
votes
2 answers

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 data. A slave fails for all sorts of "normal"…
Jonathan Hendler
  • 282
  • 1
  • 4
  • 10
4
votes
3 answers

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 much more power and threads available for the…
Husk Rekoms
  • 217
  • 1
  • 4
  • 15
4
votes
2 answers

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 not sure what the correct term is for this)…
neilH
  • 937
  • 1
  • 6
  • 16
4
votes
0 answers

Nameserver: Slave can't transfer zones from master

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 slave server which zones he needs to transfer I use…
jenswet
  • 41
  • 1
  • 3
1
2 3
…
8 9