120 likes | 147 Views
Explore how to enhance PeopleSoft architecture with a robust SAN infrastructure for improved performance, scalability, and data availability. Learn about certification, current issues, solutions, benefits, and future releases.
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 ??