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 ...
8
votes
4answers
4k 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
9k 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
5k 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
606 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
316 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
269 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 ...