数据库复制还是镜像? [英] Database Replication or Mirroring?

问题描述

SQL server 2005 中的复制和镜像有什么区别?

What is the difference between Replication and Mirroring in SQL server 2005?

推荐答案

简而言之，镜像可以让你有第二台服务器成为主服务器的热"备用副本，随时准备接管主服务器服务器失败.因此，镜像提供了故障转移和可靠性.

In short, mirroring allows you to have a second server be a "hot" stand-by copy of the main server, ready to take over any moment the main server fails. So mirroring offers fail-over and reliability.

另一方面，复制允许两个或多个服务器保持同步"——这意味着辅助服务器可以回答查询并且(取决于设置)实际更改数据(它将在同步中合并).您还可以将其用于本地缓存、负载平衡等.

Replication, on the other hand, allows two or more servers to stay "in sync" - that means the secondary servers can answer queries and (depending on setup) actually change data (it will be merged in the sync). You can also use it for local caching, load balancing, etc.

这篇关于数据库复制还是镜像?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！