The tag has no wiki summary.

learn more… | top users | synonyms

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

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 ...
3
votes
4answers
307 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 ...
4
votes
2answers
7k 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
1answer
672 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 ...
-2
votes
2answers
89 views

Given three dedicated servers how do I implement a development cycle?

I am a beginner to server administration and network design. Following is the requirement: I have three dedicated servers. These three servers need to accomplish following: There is a master DB ...
0
votes
2answers
397 views

MySQL Incremental backups with Master-Slave replication

we have a MySQL system in Master-slave replication mode. Currently we are doing full backups with mysqldumps to a remote disk server. I think is best to do one full dump and many small incremental ...
0
votes
1answer
217 views

How to setup geographically different primary/secondary, master/slave DNS services at domain registrar?

This is a followup question to my previous post Multiple free dns services redundant as name servers of a website? I would like to setup DNS services as primary/secondary, master/slave and would like ...
2
votes
2answers
107 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 ...
0
votes
1answer
403 views

Promote MySQL master-slave to master-master replication

I'll be doing a upgrade of a large MySQL 5.0 database to Percona 5.1 and I'm attempting to keep the actual downtime as short as possible during the upgrade, so the regular mysqldump + mysql import ...
0
votes
0answers
315 views

Promote MySQL master-slave to master-master replication

I'll be doing a upgrade of a large MySQL 5.0 database to Percona 5.1 and I'm attempting to keep the actual downtime as short as possible during the upgrade, so the regular mysqldump + mysql import ...
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 ...
0
votes
1answer
487 views

Setting up MySQL Linux slave with a Windows master

I'm running a MySQL 5.0 database server on Windows Server 2008. The total size of the database is about 1Gb. I make daily backups, but I'd like to step up to having a slave server for extra ...
1
vote
3answers
3k views

How to find slave's IP address and user name from Master server?

I am writing a code to extract the ip address and username of slave server in a MySQL replication environment. Does anyone know any function, variable, or something that I can run on the console and ...
0
votes
3answers
950 views

Internal DNS Best Practice - should a slave resolve internet domain names?

I have inherited a internal DNS solution at my new company and I want to start to improve its reliability! At the moment there is one Master for the internal domain which forwards external DNS lookups ...
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?
7
votes
4answers
4k 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
1answer
287 views

How do I create a backup OpenLDAP server?

I have an OpenLDAP server running on a Debian machine that serves logins to various machines. I would like to create a backup server, which simply keeps a copy of all the OpenLDAP data so that in case ...
0
votes
1answer
130 views

MySQL master-slave replication with more than 1 server

Is it possible to setup replication for database_A from master_A and database_B from master_B server? It looks like I can only set one master-host in MySQL configuration file. Thanks in advance.
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 ...
1
vote
2answers
619 views

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. ...
2
votes
2answers
378 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 ...
2
votes
1answer
573 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 ...
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 ...
2
votes
1answer
2k 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 ...
-1
votes
2answers
2k views

Configuration of pacemaker

I am having trouble setting up the following with pacemaker: a 2-node cluster where the master server always has IP address A, and the slave server always has IP address B. This is a failover ...