netherlands tech tour 05 - strategic operationalization of mysql
TRANSCRIPT
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Strategic Opera?onaliza?on of MySQL
Ron Heg Territory Manager BeNeLux, Israel and South Africa Oracle MySQL GBU
1
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Program Agenda
1
2
3
How does MySQL become strategic?
Opera?onaliza?on principles
Case studies
2
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
MySQL Adop?on in Your Organiza?on
OEM product Custom Applica?on
Vendor Requirement Ad Hoc Need
Typical Early Adop?on Model
§ Support by ‘Web’ § Backup by ‘mysqldump’ § Monitoring by ‘script’ § Tuning by ‘log’ § Hardening by ‘password’ Usual early adop?on model and mindset. Not inherently bad at the beginning, but condi?ons evolve…
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Power Curve of MySQL Deployments
Ini?al Deployment
‘Nice to Have’ Era
Business Value Discovered
Mission Cri?cal
Complete Opera?onaliza?on
Typical Pa]ern
Time
Cri?cality
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Power Curve of MySQL Deployments
Initial Deployment
‘Nice to Have’ Era
Business Value Discovered
Mission Critical
Complete Operationalization
Increasing Accelera?on to “Business Cri?cal”...
Time
Cri?cality
§ Data & applica?ons become business cri?cal faster § Not all deployments get to Opera?onaliza?on § One or a mix of small deployments can force Opera?onaliza?on § Required to opera?onalize at once
Ø The key is being ready for when ‘Business Cri?cal’ hits
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
The Opera?onal Principles
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
IT Complexity Imposes a “Tax” on the Business Slows Time to Market Interferes with Customer Service
S;fles Business Processes Impedes M&A Goals
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Principles of Strategic Opera?onaliza?on The Four Cores
TCO Consistency of Execu?on
Organiza?on Scalability Risk
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Major TCO Savings with MySQL
-‐ Term: 3 Years -‐ Users: Unlimited (web)
-‐ MySQL EE -‐ Microsoj SQL EE -‐ Sybase ASE EE -‐ Hardware: Intel x86 -‐ Servers: 4 -‐ Sockets/Server: 4 -‐ Cores/Socket: 4
In addi?on to sojware and hardware opportuni?es, significant savings in opera?onal efficiencies to be realized
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
How does MySQL enable Opera?onaliza?on The Four Layers
1. Monitoring and query analysis automa?on 2. Authen?ca?on, connec?on hardening and audit 3. Backup 4. Technical support
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Monitoring and Performance Intelligence: MySQL Enterprise Monitor
§ Proac?vely monitor out of the box § Op?mized for Cloud § Capture all queries and analyze performance automa?cally § Automated discovery
Ø By experience, tradi?onal tuning methodologies such as log capture, load tes?ng and development query review may miss 40% of the worst performing SQL statements. Produc?on analysis is cri?cal.
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Authen?ca?on, Hardening and Audit MySQL Enterprise Security & Audit
§ Tie MySQL instances into enterprise creden?al system § Manage 200 instances without touching them § Reduce impact of DDoS a]acks and app glitches § Audit captures everything that happens on an instance
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Backup #1 DBA Responsibility: Data Integrity • Hot InnoDB backup • Customers run as ojen as every 15 minutes • Great for establishing replica?on and table only restore • Backup is immediately mountable
MySQL Enterprise Backup
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Oracle Premier Support for MySQL Rely on the Experts – Get Unique Benefits
• Straight from the Source
• Largest Team of MySQL Experts
• Backed by MySQL Developers
• Forward Compa?ble Hot Fixes
• MySQL Maintenance Releases
• MySQL Support in 29 Languages
• 24/7/365 • Unlimited Incidents
• Knowledge Base • MySQL Consulta?ve Support
14
Only From Oracle
"The MySQL support service has been essen?al in helping us with troubleshoo?ng and providing recommenda?ons for the produc?on cluster, Thanks." -‐-‐ Carlos Morales – Playfulplay.com
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Oracle Premier Life?me Support
Oracle Product Cer?fica?ons/Integra?ons
MySQL Enterprise High Availability
MySQL Enterprise Security
MySQL Enterprise Scalability
MySQL Enterprise Backup
MySQL Enterprise Monitor/Query Analyzer
MySQL Workbench
MySQL Enterprise Edi?on Comprehensive Offering to Opera?onalize MySQL
MySQL Enterprise Audit
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
MySQL Subscription Server-Based Pricing (One-Year Price)
Per Server (up to 4 Sockets)* EURO USD
MySQL Standard Edition € 1,736.00 $2,000.00
MySQL Enterprise Edition € 4.341,00 $5,000.00
MySQL Cluster CGE € 8.682.00 $10,000.00
Per Server ( >=5 Sockets)* EURO USD
MySQL Standard Edition € 3,473.00 $4,000.00
MySQL Enterprise Edition € 8.682.00 $10,000.00
MySQL Cluster CGE € 17.364.00 $20,000.00
* Socket: is defined as a occupied slot that houses a chip. Regardless of the number of cores, each chip (or mul?-‐chip module) counts as a single socket.
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Cases Studies
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Just a few MySQL customers/partners in Benelux Enterprise and Embedded
1. Booking.com 9. Tennet 2. ASML 10. NMBS 3. KPN 11. Luxair 4. Smals 12. Ziggo/upc 5. KU Leuven 13. Smartbit 6. VDAB 14. UWV 7. TomTom 15. TU Delj 8. Tennet 16. Wimi Online
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Company Overview Biggest online hotel booking site WW. They sell hotel nights! Applica;on 3000 DB servers running Perl/MySQL/CentOS Why MySQL Enterprise Edi;on? “ To get of course support but also we are not a technology company. We sell hotel nights. Access to development is crucial, influencing the roadmap too and therefor we pay the money.”
Booking.com
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Wrapping up Par?ng thoughts
• MySQL is already in your organiza?on and will grow • MySQL in The Netherlands is the nr. 1 Database • It is a robust technology used for numerous web, custom and departmental applica?ons, quickly becoming business cri?cal
• Treat as you would a core “top down” enterprise offering • The enabling technology is available out of the box Deploy the methodology early in the lifecycle to reduce TCO faster and manage risk systema;cally
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Learn More
Demos: MySQL Enterprise Edi?on – MySQL Cluster h]p://www.youtube.com/mysqlchannel
Try the Solu?ons: h]p://www.mysql.com/trials/