DAT305 SQL Server AlwaysOn Technologies: 올바른 고 가용성 기능 선택

Presentation on theme: "DAT305 SQL Server AlwaysOn Technologies: 올바른 고 가용성 기능 선택"— Presentation transcript:

1 DAT305 SQL Server AlwaysOn Technologies: 올바른 고 가용성 기능 선택
18년 11월 27일 19시 50분 16초 DAT305 SQL Server AlwaysOn Technologies: 올바른 고 가용성 기능 선택 이종인 온디멘드 수석 컨설턴트 다우 교육원 SQL Server 전임강사 MCT, MCSE+Internet, MCDBA (SQL Server 7.0 / 2000), MCITP (SQL Server 2005), OCP-DBA (8/8i/9i/10g), HPCP-Master ASE, HPCP-ASE+StorageWorks © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

2 SQL Server 2005 AlwaysOn technologies
18년 11월 27일 19시 50분 16초 SQL Server AlwaysOn technologies 미션 크리티컬한 시스템 환경을 지원하기 위한 Microsoft 및 파트너 프로그램과 기술 계획된 시스템 다운타임에도 가용성 유지 방법 제공 응용 프로그램, OS, 하드웨어 업그레이드, 기타 유지 관리 작업 시 계획되지 않은 시스템 다운 시 빠른 시간 내에 복구 사용자 및 시스템 오류, 데이터 손상, 자연 재해 등 현재의 AlwaysOn technologies SQL Server 2005 Enterprise Edition AlwaysOn Storage Solution Review Partners © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

3 SQL Server™ 2005 Microsoft® AlwaysOn Partner Program
18년 11월 27일 19시 50분 16초 Microsoft® AlwaysOn Partner Program SQL Server™ 2005 *Review in progress © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

4 가용성이란? 서비스 수준 협약(SLA)에 의해서 명시적 또는 암시적으로 응용 프로그램의 가용성이 결정됨. 예)
18년 11월 27일 19시 50분 16초 가용성이란? 서비스 수준 협약(SLA)에 의해서 명시적 또는 암시적으로 응용 프로그램의 가용성이 결정됨. 예) 주문 시스템은 1분 이내에 주문을 완료할 수 있어야 하며 최대 다운 타임은 1개월에 5분을 초과해서는 안 된다. 다운 타임 = SLA를 충족시키지 못하는 경우 계획된 다운 타임을 제외하고 전체 적인 가용성은 유지되어야 한다. (예, 99.99%) SLA는 디자인, 배포, 수정 및 모니터 작업 등에도 적용될 수 있다. © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

5 응용 프로그램 다운타임의 원인 시스템 관리 논리적 오류 (사용자 or 응용 프로그램) 사이트 재난 하드웨어 장애
18년 11월 27일 19시 50분 16초 응용 프로그램 다운타임의 원인 시스템 관리 업그레이드, 인덱스 재구성… 논리적 오류 (사용자 or 응용 프로그램) 데이터 수정 오류 , 삭제 등… 사이트 재난 태풍,화재 등… 하드웨어 장애 메모리, 네트워크, 디스크 등… 소프트웨어 장애 버그, 바이러스 등…. © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

6 SQL Server 2005 고 가용 솔루션 고 가용성 요구 사항 솔루션 시스템 관리 작업 온라인 관리
18년 11월 27일 19시 50분 16초 SQL Server 2005 고 가용 솔루션 고 가용성 요구 사항 솔루션 시스템 관리 작업 온라인 관리 사용자 및 응용 프로그램 실수 논리적인 복구 사이트 재난 대비 데이터베이스 or 스토리지 미러링 데이터베이스 쿼리 부하 분산 및 이중화 복제 시스템 하드웨어 고 가용성 클러스터링, SQL Server AlwaysOn 솔루션 © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

7 온라인 관리 작업 예제 시나리오 솔루션 패치 or 업그레이드 시스템 관리 작업 목적으로 테이블 전송
18년 11월 27일 19시 50분 16초 온라인 관리 작업 예제 시나리오 패치 or 업그레이드 시스템 관리 작업 목적으로 테이블 전송 새로운 버전의 응용 프로그램 배포 손상된 데이터 파일 복구 솔루션 데이터베이스 미러링, 로그 전송, 복제 등을 통한 롤링 업그레이드 신속한 업그레이드 온라인 테이블 수정, 인덱스 생성 및 재 작성 온라인 부분 복구 Enterprise Edition Enterprise Edition © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

8 롤링 업그레이드 (3 단계를 통한) 미러 서버(미러링), 보조 서버(로그 전송), 구독자(복제)에서 업그레이드 수행 역할 변경
18년 11월 27일 19시 50분 16초 롤링 업그레이드 (3 단계를 통한) 미러 서버(미러링), 보조 서버(로그 전송), 구독자(복제)에서 업그레이드 수행 역할 변경 데이터베이스 미러링 미러 서버로 장애 조치 로그 전송 클라이언트 연결을 보조 서버로 변경 복제 클라이언트 연결을 구독자 서버로 변경 주 서버 업그레이드 수행 선택 사항: 역할 다시 변경 © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

9 18년 11월 27일 19시 50분 16초 온라인 관리 작업 © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

10 SQL Server 2005 Availability Solutions
18년 11월 27일 19시 50분 16초 SQL Server 2005 Availability Solutions 고 가용성 요구 사항 솔루션 시스템 관리 작업 온라인 관리 사용자 및 응용 프로그램 실수 논리적인 복구 사이트 재난 대비 데이터베이스 or 스토리지 미러링 데이터베이스 쿼리 부하 분산 및 이중화 복제 시스템 하드웨어 고 가용성 클러스터링, SQL Server AlwaysOn 솔루션 © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

11 사용자 or 응용 프로그램 오류로부터 복구 예제 시나리오 솔루션: 논리적 복구 테이블 삭제 잘못된 업데이트 등
18년 11월 27일 19시 50분 16초 사용자 or 응용 프로그램 오류로부터 복구 예제 시나리오 테이블 삭제 잘못된 업데이트 등 솔루션: 논리적 복구 특정 시점의 스냅숏 이미지로부터 복구 정기적인 데이터베이스 스냅숏 생성 지정된 시간 별 로그 전송 특정 시점으로 복구를 위한 로그 마킹 Tablediff.exe 도구를 사용한 테이블 비교 © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

12 SQL Server 로그 전송 Update orders set…. Primary Instance
18년 11월 27일 19시 50분 16초 SQL Server 로그 전송 Update orders set…. Primary Instance Secondary Instance Primary DB Secondary DB Transaction Log Backup Log Backup Log Restore Transaction Log Backup Log Backup Copy Transaction Log Backup Transaction Log Backup Transaction Log Backup Transaction Log Backup Transaction Log Backup Transaction Log Backup © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

13 SQL Server 2005 데이터베이스 스냅숏 Create snapshot database “Snapshot DB”
18년 11월 27일 19시 50분 16초 SQL Server 2005 데이터베이스 스냅숏 Select from orders where… Update orders set…. Create snapshot database “Snapshot DB” on ( filename=<files>) as snapshot of “Main DB” Maintains the original snapshot view of the database from the time of creation Main DB Snapshot DB V2 V1 Database Pages Database Files Instance © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

14 18년 11월 27일 19시 50분 16초 사용자 실수로부터 복구 © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

15 SQL Server 2005 Availability Solutions
18년 11월 27일 19시 50분 16초 SQL Server 2005 Availability Solutions 고 가용성 요구 사항 솔루션 시스템 관리 작업 온라인 관리 사용자 및 응용 프로그램 실수 논리적인 복구 사이트 재난 대비 데이터베이스 or 스토리지 미러링 데이터베이스 쿼리 부하 분산 및 이중화 복제 시스템 하드웨어 고 가용성 클러스터링, SQL Server Always On 솔루션 © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

16 사이트 재난 대비 예제 시나리오 솔루션 지진, 화재, 홍수 , 정전 등에 의한 재난 데이터베이스 미러링
18년 11월 27일 19시 50분 16초 사이트 재난 대비 예제 시나리오 지진, 화재, 홍수 , 정전 등에 의한 재난 솔루션 데이터베이스 미러링 데이터베이스 미러링을 통한 자동 장애 조치 솔루션 구축 추가적인 재난 대비 솔루션으로 로그 전송 구축 가능 HP, EMC, IBM 등 스토리지 업체가 제공하는 스토리시 수준의 이중화 구성 Microsoft AlwaysOn 웹 사이트를 통한 적합한 솔루션 참조 : © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

17 데이터베이스 미러링 Synchronous mode
18년 11월 27일 19시 50분 16초 데이터베이스 미러링 Synchronous mode Mirror is always redoing – it remains current Application Witness Commit 1 5 Principal Mirror 2 SQL Server SQL Server 4 2 >2 3 >3 Log Data Log Data © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

18 데이터베이스 미러링 구성 In three steps
18년 11월 27일 19시 50분 16초 데이터베이스 미러링 구성 In three steps Step 1: norecovery 옵션으로 데이터베이스 복구 Step 2: 미러링 ENDPOINT 구성 Step 3: 보호 수준 설정 및 미러링 시작 © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

19 데이터베이스 미러링을 통한 사이트 재난 대비 18년 11월 27일 19시 50분 16초
© 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

20 SQL Server 2005 Availability Solutions
18년 11월 27일 19시 50분 16초 SQL Server 2005 Availability Solutions 고 가용성 요구 사항 솔루션 시스템 관리 작업 온라인 관리 사용자 및 응용 프로그램 실수 논리적인 복구 사이트 재난 대비 데이터베이스 or 스토리지 미러링 데이터베이스 쿼리 부하 분산 및 이중화 복제 시스템 하드웨어 고 가용성 클러스터링, SQL Server AlwaysOn 솔루션 © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

21 데이터베이스 쿼리 분산과 이중화 시나리오 솔루션
18년 11월 27일 19시 50분 16초 데이터베이스 쿼리 분산과 이중화 시나리오 재난 대비가 가능한 상황에서 재난 대비용 서버가 리포트 기능 제공Need for near real time reporting on a second server that can also be used for disaster recovery 쿼리에 대한 부하 분산 기능을 제공하며 동일한 복제 데이터베이스를 통한 쿼리 부하를 분산 솔루션 트랜잭션 복제 Peer-to-Peer 복제 Enterprise Edition © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

22 Database Query Workload Scale Out With Redundancy
18년 11월 27일 19시 50분 16초 Database Query Workload Scale Out With Redundancy Scenario Need for near real time reporting on a second server that can also be used for disaster recovery Need for a tier of identical databases for scaling out application queries with ability to use any one of the database copies for disaster recovery Solutions Transactional Replication Peer-to-Peer Replication Enterprise Edition © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

23 복제 옵션 트랜잭션 복제 Peer-to-Peer 복제 리포트 + 이중화 Query 분산 + 이중화 Boston England
18년 11월 27일 19시 50분 16초 복제 옵션 트랜잭션 복제 리포트 + 이중화 Peer-to-Peer 복제 Query 분산 + 이중화 Boston England New York Shanghai New Jersey Tokyo Seattle © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

24 SQL Server 2005 Availability Solutions
18년 11월 27일 19시 50분 16초 SQL Server 2005 Availability Solutions 고 가용성 요구 사항 솔루션 시스템 관리 작업 온라인 관리 사용자 및 응용 프로그램 실수 논리적인 복구 사이트 재난 대비 데이터베이스 or 스토리지 미러링 데이터베이스 쿼리 부하 분산 및 이중화 복제 시스템 하드웨어 고 가용성 클러스터링, SQL Server AlwaysOn 솔루션 © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

25 Highly Available System Hardware
18년 11월 27일 19시 50분 16초 Highly Available System Hardware 시나리오 시스템 하드웨어 신뢰성 극대화 솔루션 데이터베이스 미러링 or 클러스터링을 통한 이중화 및 자동 장애 조치 SQL Server AlwaysOn 솔루션 SQL Server AlwaysOn 파트너는 Microsoft SQL Server Storage Solution 요구 사항을 만족하도록 검증되었다. 파트너사의 스토리지 솔루션 기반의 SQL Server AlwaysOn Technologies는 고 가용성과 안전성을 지속적으로 제공한다. SQL Server AlwaysOn 파트너 프로그램은 저장소 솔루션을 중심으로 시작한다. 향후에 H/W 및 S/W로 확대될 예정 자세한 사항과 파트너 리스트 확인 : © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

26 Microsoft 클러스터링 로컬 서버 하드웨어 이중화 재난에 직접적인 대비 불가능 공유 디스크 사용
18년 11월 27일 19시 50분 16초 Microsoft 클러스터링 로컬 서버 하드웨어 이중화 공유 디스크 사용 전체 인스턴스를 가상화하여 하나의 단위로 장애 조치 비 SQL Server 리소스 사용 가능 재난에 직접적인 대비 불가능 H/W 파트너 사가 제공하는 스토리지 수준의 복제 기능 클러스터링은 데이터베이스 미러링, 로그 전송, 복제 등과 혼합 구성 가능 © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

27 고 가용성 기능 통합 구현 데이터베이스 미러링 로그 전송 복제 클러스터링 Always On 파트너 솔루션
18년 11월 27일 19시 50분 16초 고 가용성 기능 통합 구현 데이터베이스 미러링 재난 대비 사이트 구축 로그 전송 재난 대비 보조 사이트 구축 논리적 복구 복제 리포트 기능 및 읽기 부하 분산 및 데이터베이스 이중화 클러스터링 로컬 서버 이중화 Always On 파트너 솔루션 사이트 스토리지 HA Database Scale Out For Queries 복제 Hot Standby 데이터베이스 미러링 운영 DB 클러스터링 로그 전송 Warm Standby 지연시간을 조정한 로그 전송 Logical Recovery Standby © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

28 에디션별 고 가용성 지원 기능 X 기 능 Express Workgroup Standard Enterprise
18년 11월 27일 19시 50분 16초 에디션별 고 가용성 지원 기능 기 능 Express Workgroup Standard Enterprise 데이터베이스 미러링 X 클러스터링 로그 전송 트랜잭션 복제 온라인 시스템 변경 온라인 인덱싱 온라인 복구 고속 복구 Synchronous 2 Node Subscriber 5 Publications Includes Peer to Peer © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

29 이어지는 세미나 1. SQL Server AlwaysOn 기술 : 올바른 고가용 솔루션의 선택 (9/14 목)
18년 11월 27일 19시 50분 16초 이어지는 세미나 1. SQL Server AlwaysOn 기술 : 올바른 고가용 솔루션의 선택 (9/14 목) 2. SQL Server AlwaysOn 기술 : 클러스터링의 시작 (10/19 목) 3. SQL Server AlwaysOn 기술 : 미러링 이해와 성능 고려 사항 (11/9 목) 4. SQL Server AlwaysOn 기술 : 온라인 작업 (12/14 목) © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

30 18년 11월 27일 19시 50분 16초 © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION. © 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.