Transcript High Availability Solutions with SharePoint Server 2013

SPC111
www.wbaer.net
Data Centric
Active/Passive, Active/Active, etc.
Availability
Failover Clustering/Network Load Balancing
Recovery
Application Centric
Uptime
Annual Downtime Allowance
Days
Hours
Minutes
99%
3
15
36
99.5%
1
19
48
99.9%
8
46
99.95%
4
23
99.99%
99.99%
53
53
99.999%
5
99.9999%
½ (30 seconds)
Analysis
Maintenance
Testing
Solution Design
Implementation
Unplanned Downtime
•
•
•
•
•
SAN/RAID
Backup/Restore
Log Shipping
Database Mirroring
Failover Clustering
Planned Downtime
• Rolling Upgrades/Patches
• Online Operations
• Database Snapshots
Prioritizes and routes
incoming requests
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this
feature. We recommend that you use AlwaysOn Availability Groups instead.
TPS
SAFETY FULL
SAFETY OFF
MIRRORING OFF
200
MIRRORING OFF
SAFETY OFF
SAFETY FULL
TPS
Non-Clustered Index
MIRRORING OFF
2.3
2.2
3.2
4.1
4.4
7.7
Clustered Index
SAFETY OFF
SAFETY FULL
Web Server
Confirmation
sent to client
4
Transaction
submitted
to mirror
Principal
SQL Server
2
Acknowledge
message sent
to principal
Mirror
SQL Server
3
Write
transaction
to log
Transaction
completed on
mirror
Write
transaction
to database
1
2
Principal Log Principal Data
2
Mirror Log
Mirror Data
Database Name
Support
HA Capable
Configuration
Synchronous
Y
Web Application: Central Administration
Content
Synchronous
Y
Web Application: Content Database
Synchronous, Asynchronous
Y
Usage and Health Data Collection Database
Synchronous, Asynchronous
Y
Business Data Connectivity Database
Synchronous
Y
Application Registry Database
Synchronous
Y
Subscription Settings Database
Synchronous
Y
Secure Store Database
Synchronous
Y
State Database
Synchronous, Asynchronous
Y
Staging: Web Analytics
Asynchronous
N
Database Name
Support
HA Capable
Reporting: Web Analytics
Synchronous, Asynchronous
Y
Search Service Application Administration
Database
Synchronous
Y
Search Service Application Crawl Database
Synchronous
Y
Search Service Application Property Database Synchronous
Y
User Profile Service Application Profile
Database
Synchronous
Y
User Profile Service Application
Synchronization Database
N/A
N
User Profile Service Application Social
Tagging Database
Synchronous
Y
Managed Metadata
Synchronous, Asynchronous
Y
Word Automation Services
Synchronous
Y
Database Name
Support
HA Capable
PerformancePoint Service Application
Database
Synchronous
Y
$dbs = Get-SPDatabase | ?{$_.MultiSubnetFailover –ne $true}
foreach ($db in $dbs)
{
$db.MultiSubnetFailover = $true
$db.Update()
}
Requests Handling
*Query Processing
*Request Routing and Prioritization
*Distributed Caching
Service Hosting
*Query Processing
*Request Routing and Prioritization
*Distributed Caching
Database Hosting/Storage
Server Farm
Web Application
Service Application
Web Application
Application Pool
Site Collections/Sites
Application Pool
Site Collections/Sites
Web Server (IIS)
Role
Web Server (IIS)
Role
Network Load Balancing
Admin component 1
Crawl component 1
Content processing
component 1
Analytics processing
component 1
Query processing
component 1
Index component 1
(that belongs to
index partition 0)
Admin component 2
Crawl component 2
Content processing
component 2
Analytics processing
component 2
Query processing
component 2
Index component 2
(that belongs to
index partition 0)
Databases
Database Mirroring
Databases
Learn more
http://sharepoint.microsoft.com/
Download the evaluation and experience SharePoint Server
http://office.com/preview
Build knowledge through training on SharePoint Server
http://technet.microsoft.com/sharepoint/fp123606
SharePoint Server 2013 Preview IT Professional
Reviewer’s Guide
SharePoint Server 2013 on TechNet
Better
Smarter
Build
Faster
Try the new Windows PowerShell Command Builder
http://technet.Microsoft.com
MySPC
http://myspc.sharepointconference.com