sql server synchronous replication

For a geographically dispersed large enterprise organization, to build a large enterprise management information system with typical distributed computer features, it is always necessary to solve a very important problem: how to ensure the consistency of shared data among different database servers. The important problem is that the organization changes the local database with the same structure in different locations, but it is necessary to ensure that the modified database has the same result,

Reprint Address: http://www.cnblogs.com/echosong/p/3603270.htmlThe previous paragraph Echosong wrote about MySQL data synchronization to realize the separation of business read and write, today we look at SQL Server replication subscription implementation of data read and write separationSQL server

SQL Server 2008 database replication is a publish/subscribe mechanism for data synchronization between multiple servers, which we use for synchronous backups of the database. Synchronous backup here refers to the backup server and

Concepts ORACLE ORACLE is a large-scale relational database based on advanced Structured Query Language (SQL). It is a set of regular data manipulation in a language that facilitates logical management. It is one of the databases in the CLIENT/SERVER architecture. Advanced Replication What is replication? Simply put,

The WIN2008 R2 installed on the server does not care about the machine name. After the SQL2008 R2 database is installed, the machine name is changed when the AD domain is configured. Then, when you start configuring database image synchronization, you first try to copy and publish the database. The result shows that "SQL Server

) @repl_freq = n ' continuous ',--the type of replication frequency: output of log-based transactions @status = N ' Active ',-- Publish data can be used immediately for subscribers @independeNt_agent = N ' true ',--independent Distribution Agent @immediate_sync = N ' false ',--no synchronization files are created for the publication each time the Snapshot Agent runs @allow_sync_tran = N ' true ',--allow use of " Update subscription Now "@autogen_sync_

The concept of Microsoft SQL Server 2000 replication: A set of techniques for replicating and distributing data and database objects between databases and synchronizing them to ensure their consistency. With replication, you can distribute data to different locations, over a local area network, using a dial-up connecti

Tags: GRE info Tom tar snippet detail port IDE nullOriginal: SQL Server uses scripts to create updatable subscriptions for distribution services and transactional replication"Create using local Distributor"/************************ "Publishing with local distributor configuration" ***********************/--SQL

1. Create a publishing and distribution server [Welcome to the configuration release and distribution wizard]-> [select a distribution server] -> [Make "@ servername" its own distribution server, and SQL server will create distribution databases and logs] -> [Create a sna

two replication schemes: First, both statement-based replication and row-based replication are performed asynchronously by recording the binary logs of the master server and performing replay on the slave server. Mariadb or mysql replic