recent , large scale it business innovations at crutchfield corporation

Recent, Large ScaleIT Business Innovations

at Crutchfield Corporation

Barry Tate – I.S. Manager, DBA Group btate@crutchfield.com

Craig VanHuss – I.S. Manager, Enterprise Systems cvanhuss@crutchfield.com

Changes to www.crutchfield.com New VoIP Phone System

How busy is our site? Avg. 132,000 web sessions/day Avg. 900,000 page views/day Avg. 122.5 MM database transactions/day Avg. 907 GB of data read/written/day

How busy is our site? - continued Anticipating a 40% increase during

Holiday Avg. 185,000 sessions/day Peak of 262,000 sessions 1.9 MM page views in a single day Avg. 171 MM database transactions/day Avg. 1.2 TB of data read/written/day

High-Level Architecture – Before

Dedicated server solution for IIS and SQL. Not enough SAN space for all servers,

most SQL servers utilized slower DAS. Equates to a lack of flexibility, reduced

scalability, and greater licensing and rack costs.

High-Level Architecture - Now Virtualized/blade server environment.

14 blade servers, 3 rack mount servers, 25 VM’s

High speed SAN storage available for all servers, with SQL utilizing EFD’s.

Scalability achieved with less cost and greater speed.

Virtualization reduces licensing costs and hardware costs.

Business Drivers for Colo Change Cost of rack space Cost of bandwidth On-site support MetroE connectivity to Charlottesville

Business Objectives I/O Bottlenecks

Affect page load times Page Load times affect ranking on Google Higher Rankings in Google = $$$ Technologies Implemented:

EMC SAN Enterprise Flash Drives Failover and Load-Balanced Clustering

Business Objectives Scalability

Quickly add additional servers to cover load Affect page load times Page Load times affect ranking on Google Higher Rankings in Google = $$$

Quickly remove servers when load trails off Technolgies Implemented:

Blade Servers Virtualization (Hyper-V Hypervisor) EMC SAN Failover and Load-Balanced Clustering

Business Objectives (cont.) Prepare for PCI 2.0 Compliance

Application Segmentation Network Segmentation

So how did we do it? Load Testing new site/hardware Data Transfer

Configure secure IPSec Tunnel between colo facilites

Staged Static Data Replicated Transactional Data

Morning of go live Internal Testing Update External DNS All in a window of 6 hours

Replace Phone System Entrepreneurial Spirit (a.k.a. “Are you guys

nuts!”) Aging Analog phone system with 20th century

capabilities VoIP System

Completely re-cable Headquarters Replace network infrastructure Move from TDM to SIP Integrate a number of LOB applications into a

unified system Phase 1 complete Phase 2 and 3 slated for 2012

Internship Opportunities Systems Oriented

Year round opportunities in SWVA Client or Server focus Emphasis in systems management

DBA Oriented Year round opportunities in SWVA Emphasis on Enterprise level database

administration Development Oriented

Summer only Charlottesville based

Questions??

Barry Tate – I.S. Manager, DBA Group btate@crutchfield.com

Craig VanHuss – I.S. Manager, Enterprise Systems

cvanhuss@crutchfield.com