- Главная
- Разное
- Дизайн
- Бизнес и предпринимательство
- Аналитика
- Образование
- Развлечения
- Красота и здоровье
- Финансы
- Государство
- Путешествия
- Спорт
- Недвижимость
- Армия
- Графика
- Культурология
- Еда и кулинария
- Лингвистика
- Английский язык
- Астрономия
- Алгебра
- Биология
- География
- Детские презентации
- Информатика
- История
- Литература
- Маркетинг
- Математика
- Медицина
- Менеджмент
- Музыка
- МХК
- Немецкий язык
- ОБЖ
- Обществознание
- Окружающий мир
- Педагогика
- Русский язык
- Технология
- Физика
- Философия
- Химия
- Шаблоны, картинки для презентаций
- Экология
- Экономика
- Юриспруденция
Transactional Replication презентация
Содержание
- 1. Transactional Replication
- 2. About me Evgeny Khabarov Moscow, Russia DBA
- 3. Our sponsors
- 4. Agenda What is replication? When we can use transactional replication? When we must
- 5. What is replication? Synchronization mechanism Synchronizes different
- 6. What is transactional replication? Tracks changes through
- 7. When we can use transactional replication? DWH & Reporting Load distribution
- 8. When we must not use it? HA/DR Doesn’t supports automatic page
- 9. Replication components (1) Publisher Published database
- 10. Replication components (2) Agents Snapshot agent Log reader agent Distributor agent
- 11. Replication components (3) Jobs Agent history clean
- 12. How works simplest replication schema
- 13. DEMO Fast replication setup aka “next, next, next, finish”
- 14. DEMO Let’s break something and see what happens
- 15. DEMO Incorrect ANSI_PADDING settings
- 16. Tips & Tricks Initialize with backup sp_configure,
- 17. Thank you! Email: sql@dev.ms Twitter: @gr4mm Blog: http://sql.dev.ms
- 18. Resources http://www.sqlservercentral.com/stairway/72401/ Stairway to SQL Server Replication
About me Evgeny Khabarov Moscow, Russia DBA in a financial company in Moscow Also work as a independent consultant Developer in past Email:
Слайд 2About me
Evgeny Khabarov
Moscow, Russia
DBA in a financial company in Moscow
Also work
as a independent consultant
Developer in past
Email: sql@dev.ms
Twitter: @gR4mm
Blog: http://sql.dev.ms
Developer in past
Email: sql@dev.ms
Twitter: @gR4mm
Blog: http://sql.dev.ms
|
Слайд 4Agenda
What is replication?
When we can use transactional replication?
When we must not use it?
Replication components
How works simplest replication schema
What we should to do to
begin use replication or «fast setup of replication»
Let’s break something and see what happens
How change replication
Tips & tricks
Let’s break something and see what happens
How change replication
Tips & tricks
|
Слайд 5What is replication?
Synchronization mechanism
Synchronizes different objects
Tables
Views
SP
UDF
Replication types
Transactional
Peer-To-Peer
Merge
Snapshot
“Articles”
Слайд 6What is transactional replication?
Tracks changes through transactional log
Propagates changes to Subscribers
in near real time
Transactional consistency within Publication guaranteed
Publisher and Subscriber might be not-SQL Server database, for example Oracle or DB2
Transactional consistency within Publication guaranteed
Publisher and Subscriber might be not-SQL Server database, for example Oracle or DB2
Слайд 7When we can use transactional replication?
DWH & Reporting
Load distribution across databases (retail network)
Cross-database foreign keys
ID
Name
Price
Database
A
Database B
ID
ID
AID
….
Table A
Table B
Table A
Слайд 8When we must not use it?
HA/DR
Doesn’t supports automatic page repair
Doesn’t supports load balancing
Doesn’t supports failover/failback
Data
in Subscriber database could be changed
Can’t replicate any table without PK
Can’t replicate any table without PK
Слайд 9Replication components (1)
Publisher
Published database
Publication
Article
Distributor
Subscriber
Subscription
PUSH
PULL
Слайд 11Replication components (3)
Jobs
Agent history clean up:
Distribution clean up:
Expired
subscription clean up
Reinitialize subscriptions having data validation failures
Replication agents checkup
Replication monitoring refresher for
Reinitialize subscriptions having data validation failures
Replication agents checkup
Replication monitoring refresher for
Слайд 16Tips & Tricks
Initialize with backup
sp_configure, ‘max text repl size (B)’
Profiler
Snapshot/Distribution Agent
profile –MaxBCPThread
Don’t use many instances of Replication Monitor at the same time
Don’t use many instances of Replication Monitor at the same time
Слайд 18Resources
http://www.sqlservercentral.com/stairway/72401/
Stairway to SQL Server Replication by Sebastian Meine
http://www.replicationanswers.com/
Script and articles by Paul
Ibison
http://blogs.msdn.com/b/repltalk/archive/2010/02/07/repltalk-start-here.aspx
Microsoft SQL Server Replication Support Team
https://msdn.microsoft.com/en-us/library/ms151740.aspx
Frequently Asked Questions for Replication Administrators
https://technet.microsoft.com/en-us/library/ms152556.aspx
Enable Initialization with a Backup for Transactional Publications
https://technet.microsoft.com/en-us/library/ms152552(v=sql.105).aspx
Regenerating Custom Transactional Procedures to Reflect Schema Changes
https://msdn.microsoft.com/en-us/library/ms151227.aspx
Replication Security Best Practices
http://www.sqlskills.com/blogs/paul/category/replication/
Paul Randall blog
http://blogs.msdn.com/b/repltalk/archive/2010/02/07/repltalk-start-here.aspx
Microsoft SQL Server Replication Support Team
https://msdn.microsoft.com/en-us/library/ms151740.aspx
Frequently Asked Questions for Replication Administrators
https://technet.microsoft.com/en-us/library/ms152556.aspx
Enable Initialization with a Backup for Transactional Publications
https://technet.microsoft.com/en-us/library/ms152552(v=sql.105).aspx
Regenerating Custom Transactional Procedures to Reflect Schema Changes
https://msdn.microsoft.com/en-us/library/ms151227.aspx
Replication Security Best Practices
http://www.sqlskills.com/blogs/paul/category/replication/
Paul Randall blog
