Download as PDF, PPTX
![Copyright © 2018, Oracle and/or its affiliates. All rights reserved. | NetMotion Wireless develops software to manage and secure wireless data deployments for organizations with mobile field workers. They had used Microsoft SQL Server with Mobility Analytics, their mobile VPN product's analytics module, but found it was too costly and lacked the platform and language flexibility to be a good [embedded] database. As a result, when the NetMotion Wireless product team was developing Locality, a cellular network management product, they decided to find an alternative database to use with it and with Mobility Analytics. The team compared MySQL with Microsoft SQL Server on a number of key criteria and, after finding nothing in the "con column", decided to use MySQL. Ticketmaster.com Ticketmaster Entertainment, Inc. is the world leading event ticketing company, which provides ticket sales, ticket resale services, marketing and distribution through www.ticketmaster.com. Ticketmaster.com had been a Microsoft shop, using many of Microsoft’s products. In 2001, due to the growing popularity of online sales of show and sports tickets, the demand for Ticketmaster.com began to exceed its capacity and caused stability issues. To solve the problem, Ticketmaster.com evaluated many databases and decided to move the Event database from Microsoft SQL Server to MySQL. In 2008, six years after the MySQL migration, Ticketmaster.com hosts ticket sales for 120,000 events and 24,000 venues, a 400% increase compared to pre-migration days in 2001. It is MySQL that enables Ticketmaster.com to achieve the 4x scalability, while consistently maintaining the average replication time of less than one second.](https://image.slidesharecdn.com/mysql-expr2019-190108174345/75/Intro-To-MySQL-2019-41-2048.jpg)
Uploaded byMark Swarbrick
Intro To MySQL 2019
This document provides an overview of MySQL, including its history and key features. MySQL was created in 1994 and is an open-source relational database management system. It has become very popular for powering websites and applications due to its low cost, ease of use, and ability to scale. The document discusses MySQL's open source licensing model and how it is the leading open-source database. It also outlines some of MySQL's advanced features available in MySQL Enterprise Edition, including security, encryption, authentication, and support offerings.
Intro To MySQL 2019
- 1.
- 2.
- 3. Copyright © 2018, Oracle and/or its affiliates. All rights reserved. | MySQL – A brief History MySQL was created by a Swedish company, MySQL AB, founded by David Axmark, Allan Larsson and Michael "Monty" Widenius. • Original development of MySQL by Widenius and Axmark began in 1994. • The first version of MySQL appeared on 23 May 1995. • Version 3.20: January 1997 • Version 5.0: beta from March 2005, production release October 2005 • Sun Microsystems acquired MySQL AB in 2008 • Version 5.1: production release 27 November 2008 • Oracle acquired Sun Microsystems on 27 January 2010
- 4.
- 5.
- 6.
- 7. Copyright © 2018, Oracle and/or its affiliates. All rights reserved. | Databases: Explosion 2000 Year Born at Yahoo Born at FacebookBorn at LinkedIn Born at DoubleClick
- 8. Copyright © 2018, Oracle and/or its affiliates. All rights reserved. | Software is Eating the World • Software is eating the world • Open Source is eating software • Cloud is eating Open Source https://twitter.com/asynchio/status/719194725287243777
- 9.
- 10.
- 11. Copyright © 2018, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted 11 More Jobs than Developers/DBAs • Growing Demand Source: StackOverflow, Developer Hiring Trends in 2017 More Developers/DBAs than Jobs
- 12. Copyright © 2018, Oracle and/or its affiliates. All rights reserved. | • Open Source – GPL • Cost – 90% TCO Savings over SQL Server • Default Database – OpenStack, LAMP, Docker • Reliability – “It just works” • Performance – Over 2,500,000 Queries / Second Why MySQL?
- 13.
- 14. Copyright © 2018, Oracle and/or its affiliates. All rights reserved. | SW Licenses: OS Viral vs. OS Permissive vs. Closed Source Permissive (BSD) PostgreSQL Viral (GPL) MySQL Commercial Closed Source Microsoft Free to Develop ✔ ✔Pay Free to Modify ✔ ✔ Pay Free to Use ✔ ✔ Pay Free to Distribute with Commercially Licensed SW ✔ X Pay ✔ - Free, No Legal Obligation X – Legal Obligations to provide source code to product under GPL
- 15. Copyright © 2018, Oracle and/or its affiliates. All rights reserved. | MySQL Features ✔ SQL, OLTP, ACID, MVCC ✔ Optimizer, Cost Model, EXPLAIN ✔Replication ✔ Sharding, Partitioning ✔ Backup ✔ Security, Authentication, Encryption, Firewall ✔ Monitoring, Performance Schema, SYS Schema (Oracle V$ catalog views) ✔ Geo Spatial, Full Text Search ✔ JSON Data Type ✔ Drivers (JDBC, ODBC, .Net, PHP, Python, Ruby, NodeJS, Go, Rust)
- 16.
- 17. Copyright © 2018, Oracle and/or its affiliates. All rights reserved. | 1. Google 2. YouTube 3. Facebook 4. Baidu 5. Yahoo! 6. Reddit 7. Tencent QQ 8. Taobao 9. Amazon 10. Tmall 11. Twitter 12. Sohu 13. Windows Live 14. Mail.ru 15. Instagram 16. Sina Weibo 17. LinkedIn 18. Netflix 19. Wordpress 20. MSN Global Top 20 Sites: Powered by MySQL Source: Wikipedia 2017 Oracle Confidential – Internal/Restricted/Highly Restricted 17
- 18.
- 19.
- 20.
- 21.
- 22.
- 23.
- 24.
- 25.
- 26. Copyright © 2018, Oracle and/or its affiliates. All rights reserved. | MySQL Enterprise Edition • MySQL Enterprise Firewall – Block SQL Injection Attacks – Intrusion Detection • MySQL Enterprise Encryption – Public/Private Key Cryptography – Asymmetric Encryption – Digital Signatures, Data Validation • MySQL Enterprise Authentication – External Authentication Modules • Microsoft AD, Linux PAMs • MySQL Enterprise Audit – User Activity Auditing, Regulatory Compliance 26 • MySQL Enterprise Monitor – Changes in Database Configurations, Users Permissions, Database Schema, Passwords • MySQL Enterprise Backup – Physical backup ideal for larger databases – Verifies data as it copies • MySQL Thread Pool – Improves performance on high concurrency workloads More information available at : http://www.mysql.com/products/enterprise/
- 27.
- 28. Copyright © 2018, Oracle and/or its affiliates. All rights reserved. | Using MySQL Transparent Data Encryption is EASY SQL • New option in CREATE TABLE ENCRYPTION=“Y” • New SQL : ALTER INSTANCE ROTATE INNODB MASTER KEY Plugin Infrastructure • New plugin type : keyring • Ability to load plugin before InnoDB initialization : --early-plugin-load Keyring plugin • Used to retrieve keys from Key Stores • Over Standardized KMIP protocol InnoDB • Support for encrypted tables • IMPORT/EXPORT of encrypted tables • Support for master key rotation Confidential – Oracle Internal/Restricted/Highly Restricted 28
- 29. Copyright © 2018, Oracle and/or its affiliates. All rights reserved. | MySQL Enterprise Firewall • Real Time Protection – Queries analyzed and matched against White List • Blocks SQL Injection Attacks – Block Out of Policy Transactions • Intrusion Detection – Detect and Alert on Out of Policy Transactions • Learns White List – Automated creation of approved list of SQL command patterns on a per user basis • Transparent – No changes to application required • New Feature in 5.7.20 – Firewall Rules – VIA Audit Plugin abort() – Create more general allow/deny firewall rules using JSON syntax. 29 MySQL Enterprise Firewall monitoring
- 30. Copyright © 2018, Oracle and/or its affiliates. All rights reserved. | Security Direction Continuing to focus in areas such as • TDE / Encryption / Key Management • Masking • Audit • Firewall • Authentication • Integration to various Oracle Cloud Services Confidential – Oracle Internal/Restricted/Highly Restricted 30 Customer feedback and requirements drive our priorities Tell us what you want, need, etc. Give us problematic use cases
- 31.
- 32.
- 33.
- 34. Copyright © 2018, Oracle and/or its affiliates. All rights reserved. | How DBAs see data How Developerssee data { "GNP" : 249704, "Name" : "Belgium", "government" : { "GovernmentForm" : "Constitutional Monarchy, Federation", "HeadOfState" : "Philippe I" }, "_id" : "BEL", "IndepYear" : 1830, "demographics" : { "Population" : 10239000, "LifeExpectancy" : 77.8000030517578 }, "geography" : { "Region" : "Western Europe", "SurfaceArea" : 30518, "Continent" : "Europe" } } Copyright @ 2018 Oracle and/or its affiliates. All rights reserved.
- 35. Copyright © 2018, Oracle and/or its affiliates. All rights reserved. | X DevAPI Connectors for C++,Java, .Net, Node.js, Python, PHP working with Communities New MySQL Shell Command Completion Python, JavaScript & SQL modes Admin functions New Util object A new high-level session concept that can scale from single MySQL Server to a multiple server environment Non-blocking, asynchronous calls follow common language pat erns Supports CRUD operations 37 / 112 Copyright @ 2018 Oracle and/or its affiliates. All rights reserved.
- 36. Copyright © 2018, Oracle and/or its affiliates. All rights reserved. | Copyright @ 2018Oracle and/or its affiliates. All rights reserved. MySQL Shell 8.0.11+ MySQL Server 5.7 MySQL 8.0 Upgrade Checker Prompt Themes Auto Completion & Command History MySQL Server 8.0 Document Store X DevAPI InnoDB Cluster SQL CLI Output Formats (Table, JSON, Tabbed) Batch Execution JavaScript Python SQL
- 37. Copyright © 2015, Oracle and/or its affiliates. All rights reserved. | DMBS or NoSQL? Why not both ? Copyright @ 2018 Oracle and/or its affiliates. All rights reserved.
- 38. Copyright © 2018, Oracle and/or its affiliates. All rights reserved. | MySQL Document Store: Architecture Copyright @ 2018Oracle and/or its affiliates. All rights reserved.
- 39.
- 40.
- 41.
- 42. Copyright © 2018, Oracle and/or its affiliates. All rights reserved. | facebook Application Facebook is asocial networking site that connects people with friends and others who work, study and live around them. Key Business Benefit MySQL has enabled facebook to grow to over 1.8 billion users. Why MySQL? “We are one of the largest MySQL web sites in production. MySQL has been a revolution for young entrepreneurs.” Facebook
- 43. Copyright © 2018, Oracle and/or its affiliates. All rights reserved. | YouTube Application Video sharing sitewith over 1 billion users. Every day people watch hundreds of millions of hours on YouTube and generate billions of views Key Business Benefit Scalability by doing a lot with the LAMP stack. They program primarily in Python, use MySQL as their database and rely on Apache and Linux. Why MySQL? “When you watch a video you are getting data from MySQL.” Mike Solomon YouTube
- 44.
- 45. Copyright © 2018, Oracle and/or its affiliates. All rights reserved. | Booking.com Application Process tens ofthousands of online bookings every day for over 30,000 hotels in 8,000 destinations worldwide – Europe’s largest hotel reservation site serving 1 million visitors per day. Key Business Benefits By adopting MySQL’s popular scale-out architecture, Booking.com can cost- effectively manage high traffic growth, while assuring that their organization’s data is always synchronised and up-to-date. Why MySQL Enterprise Unlimited? Flexibility and Lower Costs “Because the MySQL database is based on open standards, building our system was very easy and fast, and integrated with very low expense ” Herald van der Breggen Senior developer Booking.com