120 likes | 141 Views
SAN Infrastructure for PeopleSoft Architecture. Rakesh Radhakrishnan IT Architect Sun Microsystems Inc. Sun Microsystems, Inc. Sun Professional Service (Enterprise Services) Southeast (DC, NVA, ATL, FL, etc.) Dot.COM consulting (Practice Area -- How to Dot.Com -- Technical Architecture)
E N D
SAN Infrastructure for PeopleSoft Architecture Rakesh Radhakrishnan IT Architect Sun Microsystems Inc.
Sun Microsystems, Inc. • Sun Professional Service (Enterprise Services) • Southeast (DC, NVA, ATL, FL, etc.) • Dot.COM consulting (Practice Area -- How to Dot.Com -- Technical Architecture) • Federal Government Agencies (DOJ, DOL, etc.), AOL, BellSouth, NASD, FreddieMac, NSI, etc. • End-to-end IT Architecture (Infrastructure, Integration, Project Management, Architecture/Planning, etc.) • DOL/BLS PeopleSoft Implementation
The Network Computing Environment • Certification & Standardization Program • Total of 100+ Sun/Solaris Servers • Solaris/NT/Sybase/PeopleSoft/Veritas • 4GB to 80+GB • PeopleSoft/Financials & Java Applications • Back-end Infrastructure at HQ in DC
Certification Issues • 97- Certification Experience (PS 6.x/Solaris 2.5.x, Sybase 11.x, Veritas VM 2.4) • Two-tier model • Network Traffic (SQL Statements) • DBMS Support and Certification (Sybase & Veritas) • DBMS connection resources • DBMS locks (non-RLL) • Backup’s • DBCC’s • System Crashes/OS corruption (disk failures)
Current Issues • Applications accumulating enormous amounts of data (issues with data explosion) • ERP Systems are extended as E-Business Solutions (eStore/eProcurement) introducing new round the clock availability requirements • I/O Bottlenecks (both Sequential & Random I/O) -- for generating 1000+ web reports & transactions • Data availability needs (7x24) even during administrative/maintenance routines
The Solution • New Releases 1998/99 • Solaris 2.6/VM 2.6/Sybase ASE 11.5.1/PS 7.04 • Veritas Edition for Sybase • VM -- Software Based RAID -- Management of all data (Test Environment/Development Environment/Production Environment). • VM offloads workload from DBMS (mirroring, RAID, I/O bottlenecks, etc.) • Higher levels of Data Protection
Benefits • PS 7.x -- Scalable 3-Tier/N-Tier Architecture • Tuxedo provides capability for application partitioning, load balancing and fail-over. • Solaris 2.6/VM 2.6 Better I/O performance (simple internal benchmark -- dump a 60 GB database -- 50% improvements -- 3 to 2) • DMP - Dynamic Multi Pathing (performance and availability) • ASE 11.5.1 (Parallel processing, dedicated, LPM, LMM, DBCC DB, PAD, etc.)
Benefits • New Releases ensures higher levels of HA VM -- against disk failures -- Tuxedo/Jolt against application failures -- ASE 11.5.1 with Replication Server -- for database availability • ASE 11.5.1 with RS 11.5.1 -- offloads OLAP workload from primary to secondary • Network -- only remote Tuxedo/JOLT calls --reduced network traffic -- high bandwidth back-end • Middle-Tier Application Server offload connection resource consumption from DBMS
Future Release & SAN • PS 8.x (dot.com/e-store/e-procurement) • Solaris 8 (64 Bit/DR & AP/IPv6) • VM 3.x (Foundation for SAN) • ASE 12.x (Cluster, RLL & Java Support) • New Releases ensures higher levels of HA & Performance • SAN -- Online/LAN Free Backups, Server free backups, Continuous Availability of Data, Storage Capacity, I/O performance, etc. (Sun Servers with Sun Network Arrays -- existing hardware)
Future Release & SAN • SAN Based Clusters (Veritas Cluster Server/Application Level Clustering) -- ensuring round the clock availability with a logical and physical layer between data and apps: • DBMS, • App Servers, • Web Servers, • File Servers, • OLAP/reporting servers, • Process Scheduler, • etc.,
20/20 Hindsight • Test 120% before any upgrades • Bouncing Routine • Implement & Test a Recovery Plan • Gotchas. • One VM for multiple Storage Systems (a single view of the SAN) from any Server • Remote/web based admin/GUI (risky) • Apache httpd on production DBMS server (security issues) • Integrated Storage Solution (CVM/CVxFS & VCS)
Summary • SAN Based Clusters -- The Network Is The Computer -- Disk/Memory/CPU • Right fit for ERP/E-Business/E-Commerce Application Architectures (centralized and consolidated data) • Offers -- higher availability, increased performance, true scalability, easier administration/management • Veritas Edition for PeopleSoft e-Business Applications ??