0
votes
2answers
42 views

Microsoft SQL Server Standard High Availability without Shared Storage

I'm a software dev with little experience managing SQL so please bear with me! We are developing a piece of software that needs to be highly available, with a significant degree of resilience. This ...
4
votes
1answer
69 views

Regarding High Availability for MSSQL Server

Already used in MySQL : Real Time Replication (synchronization) between primary and secondary server is done using master and slave commands. So What is the equivalent feature for MsSQL. Which ...
0
votes
1answer
363 views

Setup HA postgres database, failover concept

I want to setup a HA postgres database. I setup master and slave database with synchronous streaming replication on different physical servers. When there is an error in the replication, the slave db ...
-1
votes
1answer
83 views

Choosing a database management system to maximize availability and scalability [closed]

If I was planning on choosing a database management system and know that the data needs to be available as close to 100% as possible and that it needs to scale as well as possible, is there a "best" ...
0
votes
2answers
90 views

How do I implement a transparent high availability database fail-over solution? [closed]

How do I implement a transparent high availability database fail-over solution for my website?
2
votes
1answer
194 views

What database is easy to maintain and manage in a cluster?

I'm looking for a database (DBMS) that is easy to scale out. I would like to have high availability so I need a multi-master cluster, where the data is replicated to two or more physical computers. I ...
0
votes
2answers
314 views

Ideas for scaling out database architecture

We're looking to scale out our existing database architecture and need some advice on which way to go. We currently have 2 web servers behind a load balancer that both read & write to a single ...
2
votes
8answers
688 views

Suggestions for programming language and database for a high end database querying system (>50 million queries a day)?

These requirements are sketchy at the moment, but will appreciate any insights. We are exploring what would be required to build a system that can handle 50 database million queries a day - ...
0
votes
2answers
1k views

High availability for databases (DRBD + GFS)?

Does it work to have like an MySQL (or any other relational database) on the GFS (with DRBD) and have multiple nodes reading and writing to it? Is that the "best" way of providing a HA ...
0
votes
2answers
229 views

How common is it to use additional dedicated servers for redundancy?

I'm new to handling the infrastructure for production service deployments. My intuition tells me that if I want to have my service be "up" as much as possible and yet can only afford say 2 dedicated ...
1
vote
2answers
614 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
3answers
148 views

How to measure the time needed to switch a database mirroring role?

I want to measure the time needed for SQL Server to switch server roles. Is there a way to know how long does it take the mirror to become the principal and ready for new updates? Thank you very ...
0
votes
2answers
238 views

Good books on high availability database?

My thesis at university is studying about high availability database. Can you suggest me some good books on this field? I want to concentrate on SQL Server. Thank you!
2
votes
5answers
428 views

Mysql high availability

I have a application that receives data from approximately 1000 different sources every couple of minutes. This data needs to be saved into a OSS database (most likely MySQL - but depending on answers ...