which distributor the Subscriber receives the publication from. There are two types of subscriptions, push subscriptions (push) and pull subscriptions, which, by name, can be words too literally to know that, in the case of a push subscription, the Distributor updates the content of the subscription directly when the publisher generates the update, and the pull subscription requires subscribers to periodically check to see if updates are available at the Distributor , the Subscriber updates the
Label:The functionality of the transaction has been in SQL Server for a long time, because it has recently been a data synchronization scheme, so there is a chance to study it again and snapshots, and found that there are a lot of good features and improvements. Here, as an example of sqlserver2008 's transactional publishing function, the way to publish a subscr
subscription.An instance of SQL Server.Subscribe The subscription is a copy of the publication. A subscription defines which server (subscriber) will receive updates published in the publication. Each subscription establishes a link between a publication and a subscriber. There are two types of subscriptions: Push subscriptions and pull subscriptions. In a push subscription, the Distributor updates the dat
The functionality of the transaction has been in SQL Server for a long time, because it has recently been a data synchronization scheme, so there is a chance to study it again and snapshots, and found that there are a lot of good features and improvements. Here, as an example of sqlserver2008 's transactional publishing function, the way to publish a subscription
The functionality of the transaction has been in SQL Server for a long time, because it has recently been a data synchronization scheme, so there is a chance to study it again and snapshots, and found that there are a lot of good features and improvements. Here, as an example of sqlserver2008 's transactional publishing function, the way to publish a subscription
constraintck_blance - --Set a transaction
the --from Liyong to Mali and money .
* begin Transaction
$ UpdateAccountSetBalance=Balance- + whereId= '620101'
Panax Notoginseng if((SelectBalance output fromAccountwhereId= '620101') 0)
- begin
the PRINT('Insufficient balance! '); + ROLLBACK;
A End
the Else
+ begin
- UpdateAccountSetBalance=Balance+ + whereId= '620106'
$ Commit;
$ PRINT('Transfer Success! '); - End
- Go
the sp_help - --Backup Device
WuyiSp_addumpdevice'Di
The functionality of the transaction has been in SQL Server for a long time, because it has recently been a data synchronization scheme, so there is a chance to study it again and snapshots, and found that there are a lot of good features and improvements. Here, as an example of sqlserver2008 's transactional publishing function, the way to publish a subscription
The functionality of the transaction has been in SQL Server for a long time, because there is a recent data synchronization scheme, so there is a chance to study it again and snapshots, and found that there are many good features and improvements. Here take the sqlserver2008 transaction publishing function as an example, the way to publish a subscription to briefly introduce the operation process, on the on
to serializable.Summary: In order to avoid the problems caused by transaction concurrency, high transaction isolation level can be adopted, but it will reduce the parallelism of transaction, in turn, if the pursuit of high parallelism and lower transaction isolation level, it is easy to bring concurrency problems. Therefore, SQL Server has a relatively low "READ COMMITTED" with the default isolation level.
the Distribution Agent and the Merge Agent, only one instance of a Queue Reader Agent serves all publishers and publications for a given distribution database.Replication type: SQL Sever provides three major types of replication: snapshot replication, transactional replication
. Figure 6: Merge replication Create a simple transactional replicationBelow I make a simple transactional replication. First, install two instances of SQL Server locally, and two of my native installations are
be kept unblocked.3. Subscribers can also be set up as pull subscriptions, so that subscribers can also stay connected to the distributor without having to keep them on the server.4. Suitable for environments where real-time is required.The mapping from MSDN is a good illustration of transactional replication, as shown in 5Figure 5:
tracer tokens that the Subscriber has received. This table is stored in the distribution database, and the replication process uses this table to monitor performance.
MStracer_tokens
The table maintains a record of the tracking token records that are inserted into the publication. This table is stored in the distribution database, and the replication process uses this table to monitor pe
publisher (one-way synchronization, and B's data is all consistent with a, and the equivalent of a modification is not effective)Transactional publications:The publisher periodically checks to see if the data has been modified, and if so, transmits the data (record row level) to the subscriber-(that is, if the subscriber modifies a row of data and the Publisher does not change the row, the record for the subscriber row is out of sync with the publish
Tags: Server reader support view error logging service build Info CLIOriginal: SQL Server local replication subscription for database server read-write separationThe previous paragraph Echosong wrote about MySQL data synchronization to realize the separation of business read
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 uses scripts to create updatable subscriptions for distribution services and transaction replication, and SQL server scripts
[Create a local distributor]
/************************ [Use local distribution server configu
the data. The publisher copies copies of all changes to the published data to the Distributor Distributor, which contains a distribution database that receives all changes to the data and saves the changes and distributes the changes to subscribers.
SQL Server replication technology type, three replication technologi
Subscriber. History and snapshots are recorded at the Distributor. Fundamentals of Transactional replication: 1, the initial data and architecture (through snapshot replication to complete), from here can be reflected in snapshot replication, is the basis of all replication
aware of the following requirements and considerations: 1. The principal and mirror databases must share the Distributor. It is recommended that you use a remote distributor here, and the remote Distributor can provide greater fault tolerance if the publisher has an unexpected failover. 2. For merge replication, and for transactional replication using read-o
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.