Timeline for Is it possible to have 2 or more databases active, and synchronized between them?
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 2, 2011 at 18:45 | comment | added | mrdenny | For additional redundancy I'd probably add log shipping into the mix to get a third (or more) copy available for a more manual failover. When SQL 2012 comes out (assuming you can upgrade quickly) you have have Always On which is basically mirroring with 4 mirrors instead of one. It does have the requirement of having a Windows cluster under it, which requires AD but I assume that the ships have AD installed. | |
| Dec 2, 2011 at 18:42 | comment | added | RagnaRock | the "applications" are sensors to collect data from the ship, and must be kept for monitoring possible illegal activities of a ship. And there is another application that uses the information to generate reports, and send information to a control center in land. My fear is that 2 databases might not be enough in case the ship stays in sea for a month or so...all that balancing of the ship might not be healthy. | |
| Dec 2, 2011 at 18:15 | history | answered | mrdenny | CC BY-SA 3.0 |