1 / 69

Non-stop computing

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.

cybele
Download Presentation

Non-stop computing

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Non-stop computing 學 生:R90725004 黃錫煙 :R90725007 黃春照 指導教授: 莊 裕 澤 教授

  2. Agenda • E*Trade Case Study • Oracle9i Real Application Cluster • Sun Cluster [TM] 3.0 architecture • Sun Cluster [TM]3.0 management • Conclusion • Reference

  3. 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

  4. 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

  5. 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

  6. 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

  7. 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

  8. 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

  9. System Architecture

  10. 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

  11. 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

  12. 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

  13. 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

  14. 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

  15. Unlimited Reliability More Computers = More Reliable Application Oracle9i Real Application Clusters Oracle Real Application Cluster

  16. 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

  17. 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

  18. 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

  19. Analyze Stage Load Transform Mine Oracle9i Traditional Business Intelligence Extract Store Use

  20. Oracle9i - Better business decisions faster Extract StageLoadTransformStoreAnalyzeMine Use

  21. 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

  22. 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.

  23. 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

  24. Choosing A Deployment Platform A Single SMP • Scales to multiple CPUs • Doesn’t scale beyond one node • Multiple single points of failure Users

  25. Choosing A Deployment Platform Failover Clustering • Fault tolerant systems; highly available • Doesn’t scale beyond one node Users Oracle9i

  26. Grow your data Grow your users Grow processing power Oracle Parallel Server Users Oracle9i

  27. 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

  28. Runs SAP Runs PeopleSoft Runs Siebel Runs All Your Applications Oracle9i Announcing Oracle9iDB Real Application Clusters

  29. TAKE IT TO THE NTH • Sun Cluster [TM] 3.0 architecture • Sun Cluster [TM] 3.0 management

  30. 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.

  31. 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

  32. 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

  33. SunPlex Enabled by Sun Cluster 3.0 Application Service Sun Cluster 3.0 Solaris OE Cluster Extensions Solaris Solaris Solaris Solaris Solaris

  34. 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.

  35. 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

  36. SunPlex Service Level Management Platform to Deliver Applications ScalableServices FailoverServices

  37. 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

  38. 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

  39. 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

  40. 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

  41. 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

  42. 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

  43. Sun Cluster 3.0 Main Components Solaris 8 OE HA Framework Global Components Userland Components

  44. Sun Cluster 3.0 Main ComponentsGlobal Components : Devices Domain 1 Domain 2 Domain 3 Domain 4 Network Tape Drive

  45. Sun Cluster 3.0 Main ComponentsGlobal Components – File Service Domain 1 Domain 2 Domain 3 Domain 4 Global File Service Network

  46. Sun Cluster 3.0 Main ComponentsGlobal Components – File Service Domain 1 Domain 2 Domain 3 Domain 4 Global File Service Network

  47. 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

  48. 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

  49. 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

  50. 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

More Related