in Moscow
Also work as a independent consultant
Developer in
pastEmail: sql@dev.ms
Twitter: @gR4mm
Blog: http://sql.dev.ms
|
- Главная
- Разное
- Бизнес и предпринимательство
- Образование
- Развлечения
- Государство
- Спорт
- Графика
- Культурология
- Еда и кулинария
- Лингвистика
- Религиоведение
- Черчение
- Физкультура
- ИЗО
- Психология
- Социология
- Английский язык
- Астрономия
- Алгебра
- Биология
- География
- Геометрия
- Детские презентации
- Информатика
- История
- Литература
- Маркетинг
- Математика
- Медицина
- Менеджмент
- Музыка
- МХК
- Немецкий язык
- ОБЖ
- Обществознание
- Окружающий мир
- Педагогика
- Русский язык
- Технология
- Физика
- Философия
- Химия
- Шаблоны, картинки для презентаций
- Экология
- Экономика
- Юриспруденция
Что такое findslide.org?
FindSlide.org - это сайт презентаций, докладов, шаблонов в формате PowerPoint.
Обратная связь
Email: Нажмите что бы посмотреть
Презентация на тему Transactional Replication
Содержание
- 2. About meEvgeny KhabarovMoscow, RussiaDBA in a financial
- 3. Our sponsors
- 4. AgendaWhat is replication?When we can use transactional replication? When we must not use it?Replication componentsHow works simplest replication schema What we
- 5. What is replication?Synchronization mechanismSynchronizes different objectsTablesViewsSPUDFReplication typesTransactionalPeer-To-PeerMergeSnapshot“Articles”
- 6. What is transactional replication?Tracks changes through transactional
- 7. When we can use transactional replication? DWH & ReportingLoad distribution across databases (retail network)Cross-database foreign keysIDNamePriceDatabase ADatabase BIDIDAID….Table ATable BTable A
- 8. When we must not use it?HA/DRDoesn’t supports automatic page repairDoesn’t supports
- 9. Replication components (1)PublisherPublished database PublicationArticleDistributorSubscriberSubscriptionPUSHPULL
- 10. Replication components (2)AgentsSnapshot agentLog reader agentDistributor agent
- 11. Replication components (3)JobsAgent history clean up: Distribution
- 12. How works simplest replication schema
- 13. DEMOFast replication setup aka “next, next, next, finish”
- 14. DEMOLet’s break something and see what happens
- 15. DEMOIncorrect ANSI_PADDING settings
- 16. Tips & Tricks Initialize with backupsp_configure, ‘max text
- 17. Thank you!Email: sql@dev.msTwitter: @gr4mmBlog: http://sql.dev.ms
- 18. Скачать презентацию
- 19. Похожие презентации
About meEvgeny KhabarovMoscow, RussiaDBA in a financial company in MoscowAlso work as a independent consultant Developer in pastEmail: sql@dev.msTwitter: @gR4mmBlog: http://sql.dev.ms |
Слайд 2
About me
Evgeny Khabarov
Moscow, Russia
DBA in a financial company
in Moscow
pastEmail: sql@dev.ms
Twitter: @gR4mm
Blog: http://sql.dev.ms
Слайд 4
Agenda
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 happensHow change replication
Tips & tricks
|
Слайд 5
What is replication?
Synchronization mechanism
Synchronizes different objects
Tables
Views
SP
UDF
Replication types
Transactional
Peer-To-Peer
Merge
Snapshot
“Articles”
Слайд 6
What is transactional replication?
Tracks changes through transactional log
Propagates
changes to Subscribers in near real time
Transactional consistency within
Publication guaranteedPublisher and Subscriber might be not-SQL Server database, for example Oracle or DB2
Слайд 7
When 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
Слайд 8
When 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
Слайд 9
Replication components (1)
Publisher
Published database
Publication
Article
Distributor
Subscriber
Subscription
PUSH
PULL
Слайд 11
Replication components (3)
Jobs
Agent history clean up:
Distribution
clean up:
Expired subscription clean up
Reinitialize subscriptions having
data validation failuresReplication agents checkup
Replication monitoring refresher for
Слайд 16
Tips & 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
