Difference Between Mirroring and Replication

Thekey difference在镜像和复制之间是mirroring occurs on thedatabase复制发生在数据和数据库对象上。Another important difference between mirroring and replication is that mirroring does not support distributed environment but, replication supports distributed database environment.

Mirroring and replication are two techniques inDBMS这可以提高数据可用性和可靠性。镜像涉及数据库的冗余副本，而复制涉及复制数据和数据库对象，例如表观视图等。

CONTENTS

1.Overview and Key Difference
2.什么是镜像
3.What is Replication
4.Side by Side Comparison – Mirroring vs Replication in Tabular Form
5.概括

什么是镜像?

Database mirroring involves duplicating a database stored in a machine or a server to another server. The original database is the principal database. The copied database is the mirror database. The system copies all changes made to principal’s content to the mirror. In other words, the principal server automatically shifts the transaction log updates on to the mirror server database. If a failure occurs, the system can restore the data by copying from one database to another. Therefore, if a failure occurs, the mirror database starts performing similarly to the principal database.

Furthermore, database mirroring is expensive and the frequent updates can increase latency and slow down the performance. Usually, server fails can cause data loss but data mirroring is a better solution to overcome this issue.

What is Replication?

数据复制经常将数据和数据对象从数据库复制到另一个数据库。通常，向其他服务器提供复制数据的服务器是发布者。从发布者那里接收复制数据的服务器是订户。

There are three types of database replications. They are the snapshot, merging and transactional replication. Firstly, in snapshot replication, data on a server copies to another server’s database or another database in the same server. Secondly, in merging replication, data from multiple databases combine into a single database. Thirdly, in transactional replication, initially, users receive full copies of the data and then receive constant updates as the data changes.

Overall, Database replication provides a distributed database environment that helps the users to access data relevant to their task. One common database that provides database mirroring and replication is MSSQL Server.

镜像和复制之间有什么区别？

Mirroring is the process of creating and maintaining redundant copies of a database. On the other hand, Replication is the process of continuously copying data changes from one database to another database. Mirroring is performed on the database while replication is performed on both data and database objects.

The mirrored database is on another machine. On the contrary, the replication data and data objects are located in another database. With concern to supporting the distributed database, mirroring does not support distributed environment. However, replication supports distributed database environment. Overall, mirroring is considered expensive in comparison to replication, which is less expensive.

概括– Mirroring vs Replication

Mirroring and replication are two techniques that help to improve data availability and reliability in DBMS. The difference between mirroring and replication is that mirroring occurs on the database while replication occurs on data and database objects.

Reference:

1.PrasadBadana. Database Mirroring Lesson 13.5, PrasadBadana, 19 Sept. 2012.Available here
2.“什么是数据库复制？- whatis.com的定义。”searchsqlserver。Available here
3.“What Is Database Mirroring? – Definition from WhatIs.com.” WhatIs.com.Available here
4.SQL Server DBA Tutorial 99-What Is Replication, Types of Replication and When to Use Each Type, TechBrothersIT, 1 Jan. 2015.Available here

Image Courtesy:

1.’Database Management’ by Nick Youngson (CC BY-SA 3.0) viaAlpha Stock Images