SAN Storage for Database Systems

0
0
1765 days ago, 680 views
PowerPoint PPT Presentation
SAN Capacity for Database Frameworks. Future stockpiling subsystem choices for database frameworks. Themes. Current CSS SAN Unaddressed Issues Cutting edge Exhibits NFS Costs. Current CSS SAN. Traditional Strike Bunches Standard Luns (<=2TB) Brought together Administration Progressively assign capacity

Presentation Transcript

Slide 1

´╗┐SAN Storage for Database Systems Future stockpiling subsystem alternatives for database frameworks

Slide 2

Topics Current CSS SAN Unaddressed Issues Next Generation Arrays NFS Costs

Slide 3

Current CSS SAN Conventional RAID Groups Standard Luns (<=2TB) Centralized Management Dynamically assign capacity Cluster capable

Slide 4

Unaddressed Issues Downtimes Maintenance Tuning/Optimization Restructuring Unscheduled Amount of capacity utilize Cost

Slide 5

Next Generation Arrays 3PAR Data and Compellent Reduce measure of capacity utilize Thin provisioning R/W previews Reduce support blackouts Dynamic Optimization/Tuning Non-troublesome redesigns Reduce cost Non-problematic layered stockpiling

Slide 6

Reducing Amount of Storage Use: Thin Provisioning Existing Projects New Projects 1TB 6TB 5.25TB 5TB 4.35TB 3.25TB 4TB 2TB 3TB Year 1 Year 2 Year 3 Year 4

Slide 7

Reducing Amount of Storage Use: R/W Snapshots Traditional 3x Storage Needed Integration Production Development Delta from Integrators New Much littler in size than creation DB Delta from Developers 1+x capacity required Refresh DB for Dev and Int significantly quicker Development R/W Snapshot Integration R/W Snapshot Production

Slide 8

Reduce Amount of Storage Use Thin Provisioning Recover unused capacity which has been allotted Allows activities to buy stockpiling as required versus all in advance R/W Snapshots Copy of genuine information yet significantly littler Can be utilized for improvement, mix and additionally DR recuperation Guidelines for utilizing preview stockpiling frameworks for Oracle Databases http://www.oracle.com/innovation/send/accessibility/pdf/oscp_snapshot_use.pdf

Slide 9

Reducing Maintenance Downtimes Traditional 4+1 RAID5 Group I/O Bound/Disk Change Add Storage Copy Data off Recreate RAID Group Downtime Repopulate new capacity Dynamic Optimization 4+1 RAID5 Group I/O Bound/Disk Change Add Storage Dynamically Optimize crosswise over new stockpiling NO DOWNTIME

Slide 10

Reducing DR Recovery: R/W Snapshots for close CDP 2:00PM 2:15PM SNAP 2:30PM 2:45PM Production DB 3:00PM New S/W @ 2:35PM 3:15PM Corruption at ~ 3:00PM? Discovery at 3:15PM 3:30PM Determine game-plan 3:45PM Recover to 2:30 PM Snapshot Mount 2:45 + 3:00PM Snapshots for examination

Slide 11

Reduce upkeep blackouts Dynamic Optimization/Tuning Increase transmission capacity, IOPS, size of capacity progressively w/o upsetting application Move starting with one RAID level then onto the next as required Non-troublesome redesigns F/W updates are non-problematic to application if multi-appended

Slide 12

Reduce Cost: Non-troublesome Tiered Storage Fiber Channel Storage New, high-esteem information on Fiber-Channel circle High Value Data Move more established information to lower Tier stockpiling Hold current FC development Older Data Expand just in lower Tier? ~2.5:1 cost advantage Lower-Cost FATA Storage

Slide 13

Reduce Cost Non-problematic Tiered Storage Tiered capacity = Place information on fitting stockpiling sort with respect to information's significance and prerequisites Move from costly Fiber-Channel circle to lower-cost Fiber ATA drives as information ages. Development is straightforward to applications.

Slide 14

Oracle over NFS File administrations for: Directorate, CD, FESS, ESH, LSS, and so on. Subnet 111 FCC2 Core Rest of FNAL Network FC FCP IP CSS SAN Storage Email and IMAP Services

Slide 15

Oracle over NFS Oracle over NFS Best if CPUs are < 70% used Snapshots, thin provisioning, dynamic development Virtualized crosswise over many plates Non-problematic tiering on a lun premise Lower-cost association choice

Slide 16

Oracle over NFS Titan SiliconServer for Oracle 9i http://hosteddocs.ittoolbox.com/VC051305a.pdf Database Performance with NAS: Optimizing Oracle on NFS http://www.netapp.com/library/tr/3322.pdf Oracle Compatible NAS stockpiling http://www.oracle.com/innovation/convey/accessibility/htdocs/vendors_nfs.html

Slide 17

Costs + Risks See gifts for quotes HDS AMS-500: 4.38TB FC, 12TB SATA NSC55+WMS100: 4.67TB FC, 12TB SATA (NSC55 has 100% uptime ensure) EMC CX500: 4.38TB FC, 2.5TB SATA

Slide 18

Costs + Risks Compellent: 4.67TB FC, 12TB FATA 3PAR: 4.67TB FC, 12TB FATA Risks: Newer, secretly held organizations Longevity? Buyout?

Slide 19

Costs + Risks NFS: Cost of one of the HDS alternatives Risks: Oracle + NFS obscure at lab Network switch not repetitive

Slide 20

Questions Send email to rayp@fnal.gov

SPONSORS