690 likes | 841 Views
Non-stop computing. 學 生: R90725004 黃錫煙 : R90725007 黃春照. 指導教授: 莊 裕 澤 教授. Agenda. E*Trade Case Study Oracle9 i Real Application Cluster Sun Cluster [TM] 3.0 architecture Sun Cluster [TM] 3.0 management Conclusion Reference.
E N D
Non-stop computing 學 生:R90725004 黃錫煙 :R90725007 黃春照 指導教授: 莊 裕 澤 教授
Agenda • E*Trade Case Study • Oracle9i Real Application Cluster • Sun Cluster [TM] 3.0 architecture • Sun Cluster [TM]3.0 management • Conclusion • Reference
Strong management, marketing and technology teams from world leaders such as Schwab, Fedex, Chase, Visa. VP of Engineering: 10 years VISA system development and operation experience 10 Core development engineers are also from VISA, have the know-how of building high volume transaction systems Web creative team: experienced in developing attractive and user-friendly web interface for on-line trading E*Trade Team
Customer retention service personalization information customization dynamic content generation Peak load handling There is no way to control the internet user base There is no way to control concurrent users System must be able to scale up quickly to meet growing customer base No trade drop Highly reliable system Disaster recovery capability Transactional integrity E*Trade Challenges
Must bring out new products and services quickly to meet market demand and stay ahead of the competition a flexible architecture a rapid development environment Integration with partner offerings 3rd party integration capability 24x7 availability No service downtime even when new services are launched No service downtime even when new hardware are added Innovative off-hour services E*Trade Challenges
100% Replace the existing CGI based Stock Trading services with NAS and Java based Solutions Over 10 groups, about 70 people working on NAS based projects. US Stock Trading Risk management Research tools Portfolio management tools Advertisement Customer Care Marketing Professional Edge Smart Alert Content Alliances … E*Trade - Today
Scalable and High Performance: multi-tier architecture simulated 100,000 simultaneous concurrent users Open: works with but not lock in with any hardware platforms, DBs or clients Highly available: redundant on-line systems plus two identical data centers Reliable: even if the west coast data center is down, the incomplete transactions will be rolled over to the east coast data center over a WAN to continue the execution Flexible: layered, modularized application design new service launch every two weeks easy partner offering integration E*Trade - Today
Software Architecture Browser Clients WebTV PDA IVR OFX Thin Clients Comm GW I18n connection HTTP IIOP Digital Certificates Stateful Apps Quote News Sell Buy NAS: State/session Fail-over Load balancing Order mngt Quote mngt Content mngt Acct mngt Stateless Apps Tuxedo: TP Monitor Stock Exchange SDK Database Data Feeds
Business Benefits Created significant new business opportunity in less time Extends E*Trade’s position as “premier” electronic brokerage firm Cost effective, reliable hardware infrastructure E*Trade Success Debra Chrapaty Chief Technology Officer
Faster Database Software Run Database on Multiple Computers Faster Database Computer More Processors –2x64 or 32x4 Faster Processors –4 @ 700 MHz No Single Point of Failure Oracle9i Cluster Strategy
Database Software on Multiple Computers Very Hard to do for Real Applications Everyone did it for Benchmarks – TPC-C Only IBM Mainframes did it forReal Applications Oracle9i Cluster Strategy
Shared DiskRuns Real Applications IBM DB2 for Mainframes Oracle9iDB Shared Nothing Only Runs Benchmarks IBM DB2 UNIX & Windows Microsoft SQLServer Oracle9i Cluster Types Data A-Z Data A-E Data F-K Data L-S Data T-Z
Runs No Existing Applications You Must Write Custom Applications Gets Less Reliable As You Add Computers Multiple Single Points of Failure Very Hard to Manage You Must Re-Partition Data To Add Computers Oracle9i Shared Nothing Clusters IBM UNIX & Windows, MS SQLServer
Unlimited Reliability More Computers = More Reliable Application Oracle9i Real Application Clusters Oracle Real Application Cluster
Availability DataGuard On-Line Reorganization Flash-Back Query Hosting Enhanced Virtual Private Database Security Label Security Fine Grained Auditing Management Feedback-Directed Memory Management Resumable Statements Business Intelligence Integrated OLAP Advanced Analytics ETL Bitmap-Join Indexes Content Management Files UltraSearch Web Services Dynamic Services XML Datatype Oracle9i Oracle9i Unique New Features
Oracle9i Oracle9i Production Database Standby Database Oracle9i Oracle Data Guard Standby System Primary System Reporting from Standby Backup from Standby Broker Broker Log Receive Log Apply Redo Logs Optional Delay Standby Logs Log Ship Broker Management Interface
Oracle9i Oracle9i Database Online MaintenanceReducing Planned Downtime Operation/Time to Complete Oracle9i IBM Microsoft 18 hours 14 hours Can’t 16 hours 14 hours 26 hours Re-organize 100GB Tablewith indexes Undo accidental delete from 8hours ago Add additional node to clusterand re-distribute data online 1 min. online
Analyze Stage Load Transform Mine Oracle9i Traditional Business Intelligence Extract Store Use
Oracle9i - Better business decisions faster Extract StageLoadTransformStoreAnalyzeMine Use
Real Application ClustersContinuous Availability for all Applications Data GuardGuaranteed Zero Data Loss Flashback QueryEnable Users to Correct their Mistakes Dynamic ReconfigurationCapacity on Demand without Interruption Online RedefinitionAdapt to Change Online Oracle9i Database - ensures your business information is always available System Failures UnplannedDowntime Data Failures& Disasters Human Errors SystemMaintenance PlannedDowntime Database Maintenance
Operation in Hours:Mins Oracle8i Oracle9i Gain 6:00 8:00 8:00 12:00 6:00 40:00 2:11 1:04 0:17 2:24 1:12 7:08 x 2.75 x 7.45 x 28 x 5 x 5 x5-6 Load (Load, Merge, Multi Insert) Transform (Multi Stage, Parallel) Store (Summarize, Refresh) Analyze (Group, Rollup, Cube) Mine (xxxx ?) TOTAL Oracle9i Improved Data Warehousing Do overnight what used to take a weekend.
Option/Availability Personal Standard Enterprise No Yes Yes Yes Yes Yes Yes Yes No No No No No No No Yes Yes Yes Yes Yes Yes Yes Yes Yes Oracle Real Application Clusters Oracle Advanced Security Oracle Label Security Oracle Partitioning Oracle OLAP Oracle Data Mining Oracle Spatial Oracle Programmer Oracle9i DatabaseOption and Edition Availability
Choosing A Deployment Platform A Single SMP • Scales to multiple CPUs • Doesn’t scale beyond one node • Multiple single points of failure Users
Choosing A Deployment Platform Failover Clustering • Fault tolerant systems; highly available • Doesn’t scale beyond one node Users Oracle9i
Grow your data Grow your users Grow processing power Oracle Parallel Server Users Oracle9i
Real Application Clusters Grow your data Users Grow your users Cache Fusion Grow processing power Shared Cache Cache Fusion: Performance of a shared cache Oracle9i
Runs SAP Runs PeopleSoft Runs Siebel Runs All Your Applications Oracle9i Announcing Oracle9iDB Real Application Clusters
TAKE IT TO THE NTH • Sun Cluster [TM] 3.0 architecture • Sun Cluster [TM] 3.0 management
Types of Clusters Plexes - Hardware Components Network Servers/Domain Storage Public Network Domain 1 Domain 2 Domain 3 Domain 4 Interconnects A Domain is an instance of Solaris software running on an isolated set of hardware : CPUs, memory, and I/O.
Types of clustersPlexes – Software components Domain 2 Domain 1 Domain 3 Domain 3 Domain 4 Network Applications Agents Cluster Software Solaris Cluster Software: Userland software - Sun Cluster2.2, VCS 1.x Integrated with Solaris - Sun Cluster 3.0
Interconnects – low latency, high-bandwidth links Type of interconnects technology Fast Ethernet, Gigabit Ethernet, SCI, Future Number of interconnects between nodes Sun Cluster 3.0 : (min 2, max 6) Sun Cluster 2.2 : (min and max 2) VCS 1.x : (min 1 and max 2) Solaris OE and cluster software interface Integrated - Sun Cluster 3.0 (enables SunPlex environments) Userland - Sun Cluster 2.2 and VCS 1.x Types of ClustersPlexes – What is Tight Coupling? 0 5 10 VCS 1.x Sun Cluster 2.2 Sun Cluster 3.0 Tight Coupling scale 0-10
SunPlex Enabled by Sun Cluster 3.0 Application Service Sun Cluster 3.0 Solaris OE Cluster Extensions Solaris Solaris Solaris Solaris Solaris
SunPlex Conceptual breakthrough! ApplicationService Services Global FileService Global NetworkService Sun Cluster 3.0 Solaris OE Cluster Extensions Solaris Solaris Solaris Solaris Solaris Three core application service components are decoupled.
SunPlex Physical View of Core Application Service Components Global Network Service DB Web Web Web Web Web Domain 1 Domain 3 Domain 4 Domain 5 Domain 6 Domain 2 Global File Service DB Web
SunPlex Service Level Management Platform to Deliver Applications ScalableServices FailoverServices
SunPlex Failover Service Example – Databases Global Network Service DB DB Domain 1 Domain 3 Domain 4 Domain 5 Domain 6 Domain 2 Global File Service DB Failover Service
SunPlex Cluster Aware Service Example – Oracle 9i Real Application Cluster Global Network Service RAC RAC1 RAC2 RAC3 RAC4 Domain 1 Domain 2 Domain 3 Domain 4 Oracle 9i Real Application Cluster Instance Oracle Data Files on shared Disks
SunPlex Cluster Aware Service Example – Oracle 9i Real Application Cluster Global Network Service RAC RAC1 RAC2 RAC3 RAC4 Domain 1 Domain 2 Domain 3 Domain 4 Oracle 9i Real Application Cluster Instance Oracle Data Files on shared Disks
SunPlex Scalable Service Example – Web Server Global Network Service Web Web Web Web Web DB Domain 1 Domain 3 Domain 4 Domain 5 Domain 6 Domain 2 Global File Service Web DB ScalableService
SunPlex Scalable Service Example – Web Server Global Network Service Web Web Web Web Web Web DB Domain 1 Domain 3 Domain 4 Domain 5 Domain 6 Domain 2 Global File Service DB Web ScalableService
Application Services & ResourcesResource Groups view in a cluster – Failover and Scalable Node 1 Node 2 Failover Resource Group Interconnect Scalable Resource Group Scalable Resource Group Shared Storage
Sun Cluster 3.0 Main Components Solaris 8 OE HA Framework Global Components Userland Components
Sun Cluster 3.0 Main ComponentsGlobal Components : Devices Domain 1 Domain 2 Domain 3 Domain 4 Network Tape Drive
Sun Cluster 3.0 Main ComponentsGlobal Components – File Service Domain 1 Domain 2 Domain 3 Domain 4 Global File Service Network
Sun Cluster 3.0 Main ComponentsGlobal Components – File Service Domain 1 Domain 2 Domain 3 Domain 4 Global File Service Network
Sun Cluster 3.0 Main ComponentsGlobal Components – File Service Offers • A continous availability of data • Sun Cluster 3.0 maintains the access to the data • No changes in file systems required • No changes in applications accessing file system data required
Sun Cluster 3.0 Main ComponentsGlobal Components – Network Service Global Network Service LAN/WAN Domain 1 Domain 2 Domain 3 Domain 4 Global File Service
Sun Cluster 3.0 Main ComponentsGlobal Components – Network Service Global Network Service LAN/WAN Domain 1 Domain 2 Domain 3 Domain 4 Global File Service
Agents API Public Network Monitor Resource Group Mgr User Kernel Global Network Service TCP/IP N/W stack Cluster Membership Monitor Cluster Transport Other Nodes Cluster Configuration Repository Global File Service Global Device Access Volume Mgt HA Framework Storage Sun Cluster 3.0 ArchitectureArchitecture