Linked Questions
16 questions linked to/from MySQL high availability, failover and replication with Latency
1
vote
1
answer
97
views
How to replicate MySql database between two 2012 server [duplicate]
I am setting up a disaster recovery strategy for two 2012 servers DB1 and DB2 in one location and may be later I plan to set them in different locations, I want DB2 to take control incase of of DB1 ...
8
votes
2
answers
12k
views
Does MySQL Replication hamper the performance of my DB?
I am not exactly a 'Qualified' DBA, but yes i am in charge of my own DB which we use in our social app.
I have recently implemented Master/Slave Replication on my Database for obvious reasons.
What ...
- 183
7
votes
1
answer
21k
views
Best way to setup master to multi master replication
ORIGINAL QUESTION:
I have multiple servers that all need to act as masters, as if one fails the next server kicks in and takes over. I'm just wondering what the best way to replicate is. All servers ...
- 171
9
votes
1
answer
12k
views
Best solution for cross-datacenter MySQL master-slave replication
We are working on a new system architecture for our company. We have a HPC, which runs in our own data-center and we are planning our front-end and a fallback system on Amazon Web Service.
System ...
- 307
5
votes
3
answers
3k
views
With MySQL Replication, what level of resilience is possible?
I've found lots of good material on setting up MySQL replication, but not much on what to do in the event of failures. Understanding the degree of resilience I can achieve is fundamental to designing ...
djna
4
votes
1
answer
5k
views
MySQL Replication and High Availability
I know this might not be a very good question to be asked in this site, but I really need some helps/hints to be directed to the right path.
I want to have failover strategy for 2 MySQL servers which ...
- 205
2
votes
2
answers
3k
views
Mysql database replication on different vlan/subnet/another site
Saw the posts for "MySQL high availability, failover and replication with Latency"
Is it possible to work it in a DR site when its not in the same vlan?
- 21
3
votes
1
answer
4k
views
MySQL replication between datacenters
I am trying to figure out the best MySQL replication topology, but I am not sure the best way to lay it out.
datacenter A | datacenter B
____ | ____
| | | | |
| AA | |...
- 365
5
votes
1
answer
2k
views
MySQL Replication : 1 Slave / Multiple Masters
I have a web app with 2 web servers and 2 database servers.
The DBs are setup for multimaster replication. (this is the primary environment)
I also have the exact same setup on a different location ...
- 153
3
votes
2
answers
1k
views
MySQL High Availability for InnoDB
I am looking for MySQL High Availability with huge transactions. I prefer to go with InnoDB Engine.
I prefer to use MySQL Master - Slave Replication. However, this option provides us Manual fail over ...
- 997
1
vote
1
answer
1k
views
Heartbeat Options with MySQL and Possibilities
I would like to understand if the following scenarios are possible in Heartbeat in Linux.
Setup: Two Database Servers running Mysql in Active/Passive mode in replication mode having Heartbeat setup ...
- 1,511
2
votes
2
answers
1k
views
3 Databases, Best Replication Setup?
We have 3 DB servers, two of them i.e. db1, db2, are located in the same data center. The other one i.e. drdb, is located in a different site. Currently, the replication setup for these servers is of ...
- 201
1
vote
1
answer
1k
views
Is there an easy way to replicate MySQL data?
My software is deployed in various cities, each have a database, but they have different authorizations such as:
central DB
/\
/ \
DB1 ...
- 13
1
vote
1
answer
332
views
MySQL Cluster Replication Merge
We'd like to have two MySQL cluster groups, and at the same time have replication set up between them. Is that possible?
frankp
1
vote
2
answers
256
views
Two master databases for two separate apps
We have two different websites one is hosted in Asia datacenter called it asiadata.com and other site is hosted in Europe datacenter called it europedata.com. Currently we have only one master ...
- 11