The tag has no usage guidance.

learn more… | top users | synonyms

6
votes
2answers
5k 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 ...
7
votes
6answers
5k 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?
3
votes
1answer
1k 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 ...
0
votes
3answers
235 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 ...
8
votes
4answers
3k 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 ...
9
votes
5answers
8k 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... ...
4
votes
4answers
4k 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 ...
3
votes
1answer
580 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, ...
3
votes
2answers
1k 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
177 views

CRUD with MySQL Master-Slave Architecture

I have setup mysql master-slave replication with 1 master and 3 slaves. Now that I have finished setting up the architecture I am curious as to the best way to make my reads. I realize all writes, ...
0
votes
1answer
310 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 ...
0
votes
1answer
266 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 ...