The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
1answer
1k 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 ...
6
votes
6answers
4k 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?
4
votes
2answers
6k 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 ...
3
votes
0answers
46 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 ...
3
votes
0answers
100 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 ...
0
votes
0answers
89 views

RockMongo Connection Issue with MongoDB Slave

I have a MongoDB Replication with Master-Slave (not RepliSet) I have configured RockMongo on two servers. But I able to login to master server through rockmongo but when I login to slave with rock ...
0
votes
0answers
125 views

ISPConfig multi-server DNS setup

I have 2 servers with ISPConfig 3 installed. Both servers are used to all services (hosting, db, mail, dns etc). One of the servers is also configured to be ns1.mydomain.com and the secondary is ...
7
votes
4answers
3k 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... ...
0
votes
2answers
61 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?
3
votes
0answers
264 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 ...
0
votes
2answers
123 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 ...
0
votes
1answer
123 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" { ...
5
votes
1answer
2k 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 ...
-2
votes
2answers
112 views

Is it possible to do mysql replication with one server in internet and another in a intranet?

I have a server in internet that must have all data synced (dont need to be in realtime) from a server from a intranet (obviously has internet connection). Is it possible? How about sync both sides, ...
2
votes
1answer
117 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 ...
7
votes
1answer
1k 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 ...
8
votes
3answers
6k views

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 ...
0
votes
1answer
113 views

DNS Slave doesnot serve new record while master is down until restart

could anyone explain the behaviour of DNS slave. i am testing dns server, for internal purpose, and after configuring master slave everything works fine, but i am willing to understand the mechanism ...
4
votes
2answers
351 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 ...
-1
votes
1answer
142 views

understand BIND9, DNS Master and Slave Zones [closed]

edit: (for clarification) I have two servers. Server 1 has a static IP, and server2 has a dynamic hostname using DDNS services. both servers are running Ubuntu 12.04 lts, and virtualmin. on server ...
4
votes
4answers
2k 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 ...
3
votes
1answer
355 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, ...
1
vote
1answer
197 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 ...
1
vote
1answer
85 views

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 ...
0
votes
1answer
84 views

Replicate from slaves to master and viceversa

I've a great dilema here and didn't know how to solve it. I need to replicate a few tables from MySQL DB (slaves) to MySQL DB (master). Take as an example this: MySQL DB (master) table1 table2 ...
0
votes
1answer
152 views

Moving Redis persistence to a slave

Redis' background AOF rewrites are killing performance of our service. The general consensus is to move AOF persistence to a slave in a separate VM and disable it on master. There is a problem with ...
1
vote
2answers
787 views

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 ...
3
votes
1answer
731 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 ...
1
vote
2answers
264 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 ...
3
votes
2answers
1k 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 ...
2
votes
1answer
913 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 ...
6
votes
2answers
2k 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. ...
4
votes
2answers
3k 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 ...
0
votes
3answers
373 views

Design a DNS Master/Slave with SVN

I am looking for a good design of a master, slave DNS servers with SVN. Few doubts bothering me are: Would it be good if I have a post-commit hook to replicate/rsync the DNS master data to the ...
3
votes
1answer
445 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 ...
1
vote
1answer
248 views

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 ...
5
votes
1answer
3k 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 ...
2
votes
2answers
2k 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 ...
1
vote
1answer
78 views

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 ...
3
votes
2answers
881 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 ...
0
votes
1answer
207 views

Can I turn eNom in to a slave, or somehow work side by side?

I ran out of space at eNom, and can add no more sub domains. Now I'am setting up bind9 on my server and was wondering, can I turn eNom in to a slave. I would have preferred running my dns server as ...
1
vote
1answer
182 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. ...
1
vote
3answers
525 views

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 ...
0
votes
2answers
91 views

MySQL Master Slave Replication Not Working

I setup MySQL master slave replication, but none of the databases, tables, and data is being copied over to the slave from the master. Here is the relevant configuration on the master: server-id=1 ...
1
vote
1answer
326 views

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 ...
0
votes
0answers
384 views

Error 'Unknown table engine 'InnoDB'' on query. after restarting mysql

I have mysql DB on server S1 (mysql version 5.1.41-3ubuntu12.7-log), i have created master-slave for this DB on server S2 (mysql version 5.1.54-1ubuntu4-log). the DB on S1 was using one data file ...
3
votes
2answers
465 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 ...
1
vote
3answers
636 views

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 ...
0
votes
2answers
1k views

test if master dns has transfered copy to slave

I setup my master and slave using FreeBSD. I'm currently running the Bind 9.X version, so far everything is working successfully. Just one small problem. I can't get the master copy of my DNS to ...
0
votes
3answers
224 views

Unable to do automatic updation in the slave server

I've installed BIND 9.5.2-P1 running in Windows Server 2003. There is 1 master server and 1 slave server. i already have master that work well for our zones. The problem is my slave server didn't ...