1 / 36

The future is mission critical Solutions your way

The future is mission critical Solutions your way. Migrating Enterprise DB to SQL/MX Why make the move? Scalability Availability TCO Case study Call to action. Today’s agenda. Why make the move?. Overview. Databases are critical to your business.

peggy
Download Presentation

The future is mission critical Solutions your way

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. The future is mission criticalSolutions your way

  2. Migrating Enterprise DB to SQL/MX Why make the move? Scalability Availability TCO Case study Call to action Today’s agenda

  3. Why make the move?

  4. Overview Databases are critical to your business Enterprise database hosts business critical information Databases support critical business functions Databases control all touch points of an enterprise DBAs are responsible for the wellness of business

  5. The Database decision Customers are looking for a database that: • Grows with the business without sacrificing performance • Meets global business needs 24x7 • Avoids complexity of too many moving parts • Provides information at the right time • Does not cripple IT budgets

  6. Common emerging pain points • Scale • Reached maximum throughput on a single node • Adding nodes increases user response time and does not scale proportionally Availability For some applications, the business cost of downtime, even a few minutes, is huge Recovery following failures is complex, error-prone and time-consuming Complexity of configurations and database layout makes online operations difficult Cost Licensing and support fees are high, and increase every year Configuration complexity translates into significant operational costs

  7. The HP NonStop database solution All modern, All standard, All nonstop • All standard • ANSI 2003 • JDBC 3.0 • ODBC 3.5 • All modern • Integrated hardwareand software • Out-of-the-box cluster aware • Virtualiseddata • Parallel query execution • All NonStop • 24/7 application availability • Linear scalability • Mixed workload handling • Online manageability Trusted HP expertise with comprehensive mission-critical services and world-class partnering

  8. Migration to NonStop SQLBusiness Drivers

  9. Ability to scale

  10. Optimise your database environment With HP NonStop SQL scalability NonStop SQL scalability • NonStop SQL throughput scales linearly (98-100%) • As more processing capacity (nodes) is added to a cluster (X-axis) • As #concurrent sessions are increased (Z-axis) • No performance penalty for clustered database apps

  11. NonStop SQL handles critical business needs Customer realises TCO and performance benefits of NonStop SQL Business Transactions (in Millions) per hour • A major financial solutions provider in Americas evaluates NonStop SQL • Dissatisfied with pricing and TCO of Oracle database solutions • Evaluated NonStop SQL for equivalent functionality and eXtreme performance • Application migration automated using SQLWays tool, low cost of migration, accelerated migration timeline • Sustained peak performance achieved is 11.4 Million business transactions/hour • Customer impressed with performance, all-inclusive NonStop SQL pricing and TCO 16p quad-core

  12. NonStop SQL handles critical business needs Customers realise scalability benefits of NonStop SQL • A securities company moves to NonStop SQL for its superior availability and TCO • Performing at 2000 tps, driving 20,000 sql statements from 10,000 concurrent users over 2000 JDBC connections An internet service provider uses NonStop SQL to manage Petabytes of database • Drives 100,000+ tps • Managed with 2 DBAs

  13. NonStop SQL handles critical business needs Customers realise scalability benefits of NonStop SQL • A government department deployed NonStop SQL to manage 250+TB • Driving mixed-workload consisting of 39,000 ingests per second concurrently with >5000 ad-hoc and OLAP queries • Executing concurrent database maintenance activities A major international supermarket evaluates NonStop SQL to handle growth in business • Needs capability to add twice as many stores • Twice as much assortment • Double the forecast period • And be always available

  14. System Availability

  15. Independent survey on high availability trends NonStop customers experience superior availability • 90% surveyed customers report significant database induced unplanned outages in a year • 25% outages lasted longer than10 hours, some lasted more than 24 hours • 55% surveyed customers report planned downtime for database upgrades and 27% cited planned downtime for database migration. * Survey of Independent Oracle User Group

  16. NonStop SQL handles critical business needs Customers realise availability benefits of NonStop SQL • Over 90% of all financial transactions for Nordea Finland run on NonStop (payments, card traffic and netbank transactions > 2000TPS ) who consistently report 100% availability • An internet service provider has had no outage since going live in 1995 • The BonTon stores has recorded zero minutes of unplanned time against their NonStop systems since 1998 • A US Financial Services company has had zero downtime since migrating to Integrity

  17. The TCO story

  18. NonStop customers enjoy lower operational costs NonStop SQL is out-of-the-box cluster aware • It takes 5 DBAs to manage few Gigabytes of an Oracle database at a Spanish Healthcare Center • It takes 2 DBAs to manage several Petabytes of NonStop SQL database at an Internet Service Provider It takes 208 steps to install an Oracle RAC database instance It takes 19 steps to install a NonStop SQL/MX instance and perform database upgrade

  19. NonStop SQL vs. Oracle Pricing All inclusive vs. add-ons

  20. NonStop SQL vs. Oracle Pricing All inclusive vs. add-ons * Oracle Technology Global Price List, August 2012

  21. NonStop SQL efficiency Dayton Hudson Corporation

  22. HP NonStop vs. Oracle/Sun System – Cost to Own NonStop beats Oracle by a factor of >2x • Cost to own include: • Hardware list prices for a given configuration • Support costs of hardware • 5 year software licensing list price • Support costs of software • Cost comparisons are based on similar HW configurations (# of cores, memory & storage), both single node and clustered configuration • Software stack includes OS and SW for clustered database engine, no middleware included

  23. Case study

  24. AOL's Live Migration From 16 Solaris-Sybase Servers to a Single NonStop DB…With No Down Time

  25. Road map steps to achieve parallel database Migration and Synchronisation for AIM data population • Design • SQL Tables • Data Transformations • Bulk Migration Utilities Develop Synchronisation Tools Bulk Migration Utility Test Synchronisation Migration Instrumentation

  26. Road map steps to achieve parallel database • Determine SQL Table Design for Destination System • This assumes the destination table structures will NOT be 100% identical to the tables on the source system • Design Data Transformations for ShadowBase Consumer User Exists • Requiring C code User Exits and script development for the required transformations

  27. Bulk migration • Use data transformation rules to design a Bulk Migration Utility • Bulk Migration Utility reads source tables and inserts data into destination tables • Transformations necessary to accommodate differences in table design • Develop Bulk Migration Utility

  28. Synchronisation • Develop synchronisation user exit code for ShadowBase consumer • Address “race” conditions • Test Bulk Migration Utility • Test synchronisation user exits

  29. Migration • Start ShadowBase Collector Process on source data system • Captures changes during Bulk Migration Utility runtime • Applies changes after bulk transfer complete • Run Bulk Migration Utility to copy all data to destination system

  30. Migration and synchronisation • With Bulk Transfer completes, ShadowBase consumer process executes on NonStop destination system • Applies any changes occurring while Bulk Transfer process ran • Does not address “race” condition for real-time transaction updates/applies to the NonStop host • Databases are now synchronised

  31. Instrumentation • Application availability and performance monitoring in an operations dashboard • Requires very limited application code change

  32. Extract Load AOL/ICQ Instant Messaging Migration AOL Sybase → NonStop Migration StagingHost Login Requests Compressed 16:1 SQL/MP database Data Accelerator Data Accelerator Data Accelerator Primary Linux/Sybase “Partitioned” Database – Production environment 16 Systems .... .... .... Shadowbase 14 Systems Sybase DR Backup Linux/Sybase “Partitioned” Database 16 Systems NonStop SynchroniseActive/ActiveLogin Request Complex –all nodes are production Linux With the exception of NonStop hosts, all AOL production servers have a “N+1” backup (non-production) configuration

  33. Optimise your database environment AOL Sybase → NonStop Migration • All DBA productivity tools are included with the base SQL license with no additional costs • No additional Partitioning Software licenses required • Diagnostic, Tuning, Management packs are all included in the base license • NonStop SQL deploys and is managed as a single clustered database image • NonStop has fewer moving parts and less complexity, leading to lower operational costs

  34. Next steps

  35. Take the next step with HP Perform a health check of your system • Let us show you how HP NonStop SQL: • Scales your application • Maximises availability • Optimises TCO • Let us help migrate and open-up your database applications

  36. Thank you

More Related