Benefits of MySQL Enterprise Edition

Are you using MySQL on-premises in your company or organization? If so, this is for you!

In a world where hacking and data theft make the daily news, it’s become even more important to make sure that your customer data and your employee data are protected by the highest levels of security.
With always increasing worldwide regulations and rules, it is important that your business easily enforces compliance.

But it is not just about security. In a highly competitive world, it is very important that your applications deliver top performance and the highest availability. And when questions arise or expert help is needed, having access to the most knowledgeable MySQL engineers – those who write the code – can make a difference.

MySQL Enterprise Edition delivers all this and more to Fortune 1000 companies. Learn how in this webinar and ask your questions directly to the MySQL team.

Transcript

1. MySQL Enterprise Edition Achieve the Highest Levels of Performance & Security Olivier Dasini MySQL Cloud Principal Solutions Architect EMEA olivier.dasini@oracle.com Blogs : www.dasini.net/blog/en : www.dasini.net/blog/fr Linkedin : www.linkedin.com/in/olivier-dasini Twitter : @freshdaz
2. Safe harbor statement The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, timing, and pricing of any features or functionality described for Oracle’s products may change and remains at the sole discretion of Oracle Corporation. © 2022 Oracle MySQL
3. 3 © 2022 Oracle MySQL Me, Myself & I  MySQL Geek  Addicted to MySQL for 15+ years  Playing with databases for 20+ years  MySQL Writer, Blogger and Speaker  Also former : DBA, Consultant, Architect, Trainer, ...  MySQL Cloud Principal Solutions Architect EMEA at Oracle  Stay up to date!  Blog: www.dasini.net/blog/en  Linkedin: www.linkedin.com/in/olivier-dasini/  Twitter: @freshdaz 3 Olivier DASINI © 2022 Oracle MySQL
4. Case Studies 5 © 2022 Oracle MySQL
5. Case Studies  SQUARE ENIX reduced database backup time with MySQL Enterprise Edition to 1/6th to offer superb game environment for users worldwide – https://www.mysql.com/why-mysql/case-studies/square-enix-reduced-database-backup-time-mysql-enterprise-editionl/  The BBC ensures World-class broadcasting service – https://www.mysql.com/why-mysql/case-studies/bbc-broadcasting-mysql-enterprise-edition.html  BBC Ensures High Availability with MySQL – https://www.youtube.com/watch?v=q33Gfc5AdTs 6 © 2022 Oracle MySQL https://www.mysql.com/why-mysql/case-studies/
6. 7 © 2022 Oracle MySQL The world’s most popular open source database
7. Some Of Our Customers  MySQL powers the most demanding Web, E-commerce, SaaS and Online Transaction Processing (OLTP) applications  It is a fully integrated transaction-safe, ACID compliant database with full commit, rollback, crash recovery and row level locking capabilities  MySQL delivers the ease of use, scalability, and performance to power: 8 © 2022 Oracle MySQL Reliability, high-performance, and ease of use
8. Innovating & Evolving 9 © 2022 Oracle MySQL
9. Our Server Usability Guidelines « As well adding new features, our goal in the server team is to make MySQL easier to use. We try to design features with the goal of making a net improvement on usability. » 10 © 2022 Oracle MySQL
10. MySQL 8.0 Enables Modern Web Applications 11 © 2022 Oracle MySQL Scalable & Stable Better handling of high contention, improved security, and minimizing downtime Data Driven Optimizing services with real time data analysis Developer First Hybrid data model and data access APIs for flexibility for developers Mobile Friendly Ready for location based services. Handling Emoji and Unicode characters 24 x 7 at Scale
11. Innovating And Evolving  MySQL JSON Document Store – SQL + NoSQL = MySQL – Combining Relational & Document Stores Workloads  HA & DR made easy – MySQL InnoDB Cluster – MySQL InnoDB ReplicaSet – MySQL InnoDB ClusterSet  MySQL Shell – Interface for Development and Administration of MySQL  MySQL Operator for Kubernetes – Manage MySQL InnoDB Cluster inside a Kubernetes Cluster – Provide MySQL Official Docker Images  Performance / Scalability  Reliability  Geo Spatial (GIS)  Security  ... 12 © 2022 Oracle MySQL
12. Security Improvements (summary)  AES 256 Encryption now the default  Password rotation policies  Password history (not reuse old ones)  Deployment: enable secure unattended install by default – Random password set on install – Remove anonymous accounts – Deployment without test account, schema, demo files  Easier instance initialization and setup: mysqld --initialize  New detection and support for systemd  MySQL Roles – Improving MySQL Access Controls  SSL – Enabled by default – Auto-detection of existing keys and certs – Auto generation of keys and certs when needed – New helper utility: mysql_ssl_rsa_setup – New --require_secure_transport option to prevent insecure communications – Added SSL support to binary log clients  Extended Proxy User Support – Added Built-in Authentication Plugins support for Proxy Users – Allows multiple users to share a single set of managed privileges  File, Tablespace & Log Encryption – AES 256 logs & tablespaces encryption at rest 13 © 2022 Oracle MySQL
13. MySQL Enterprise Edition 14 © 2022 Oracle MySQL https://www.youtube.com/watch?v=CtRIc6Hsia8
14. MySQL Enterprise Edition 15 © 2022 Oracle MySQL Oracle Premier Lifetime Support Oracle Product Certifications/Integrations MySQL Enterprise High Availability MySQL Enterprise Security MySQL Enterprise Scalability MySQL Enterprise Backup MySQL Enterprise Monitor/Query Analyzer MySQL Enterprise Audit Highest Levels of MySQL Security, Manageability and Reliability
15. MySQL Enterprise Edition 16 © 2022 Oracle MySQL Management Tools Advanced Features Support • Authentication • Audit • Encryption / TDE • Firewall • Data Masking • High Availability • Monitoring • Backup • Development • Administration • Migration • Technical Support • Consultative Support • Oracle Certifications Reduce the risk, complexity and cost
16. MySQL Enterprise Monitor 17 © 2022 Oracle MySQL https://www.mysql.com/products/enterprise/monitor.html
17. MySQL Enterprise Monitor  See a central view of the complete MySQL env  Real-time MySQL performance and availability monitoring  Visually find & fix problem queries with the Query Analyzer  Alerts through email or text message  Disk monitoring for capacity planning  Replications monitoring  Role based access controls  Cloud friendly architecture – No agents required – Policy driven configuration – Easy integration with DevOps tools 18 © 2022 Oracle MySQL A DBA’s assistant: Visualize problems and tuning opportunities.
18. MySQL Enterprise Monitor – Best Practice Advisors  Enforce MySQL best practices  14 Advisor categories  250+ Advisors  Threshold-based alerts – Exponential moving averages – Rate change detection  Expert problem resolution advice 19 © 2022 Oracle MySQL Provide a set of rules designed to enforce MySQL best practices “I definitely recommend the MySQL Enterprise Monitor to DBAs who don't have a ton of MySQL experience. It makes monitoring MySQL security, performance and availability very easy to understand and to act on.” Sandi Barr Sr. Software Engineer Schneider Electric
19. MySQL Enterprise Monitor  Easily ensure all your MySQL assets are hardened and secure – Identify vulnerabilities  Manage MySQL Enterprise Firewall – Protect MySQL assets from SQL injection attacks and other common threats  Manage MySQL Enterprise Audit – Ensure regulatory compliance & Know what happened when things go wrong  Change monitoring and tracking – Configuration Management & Tuning Advice  Backup policy enforcement  Centralized user management 20 © 2022 Oracle MySQL Security A DBA’s assistant : Notify problems and tuning opportunities
20. MySQL Enterprise Monitor – Query Analyzer  Real-time query performance  Visual correlation graphs  Find & fix expensive queries  Detailed query statistics  Query Response Time index (QRTi) – "Quality of Service" (QoS) measurement for each query – QoS measurement for a server, group, or every instance – Single metric for query performance 21 © 2022 Oracle MySQL Visual Query Analysis for troubleshooting “With the MySQL Query Analyzer, we were able to identify and analyze problematic SQL code, and triple our database performance. More importantly, we were able to accomplish this in three days, rather than taking weeks.” Keith Souhrada Software Development Engineer Big Fish Games
21. MySQL Enterprise Monitor – Replication Dashboard  Source/Replica and Group Replication  Auto-discovers replication topology – High level overviews of all instances – User centric views on individual sets  Performance monitoring  Replication advisors  Best practice replication advice 22 © 2022 Oracle MySQL Display detailed instrumentation available & the current configuration
22. MySQL Enterprise Monitor – NDB Cluster Support  Auto discovery and grouping of NDB processes – ndbapi – ndb_mgmd – ndbd/ndbmtd  Visual cluster topology  New reports and graphs  New advisors 23 © 2022 Oracle MySQL Visibility into the performance, availability, and health of the cluster
23. MySQL Enterprise Monitor – Backup Dashboard  Monitor backup usage and health – Across your entire datacenter  Drill into backup job details – Allowing for easy backup recovery  Supports all backup types  Alerting on significant events – Poor backup performance – Backup job failures – Out of date backups 24 © 2022 Oracle MySQL Provide key visibility into critical backup activities
24. MySQL Enterprise Backup 25 © 2022 Oracle MySQL https://www.mysql.com/products/enterprise/backup.html
25. MySQL Enterprise Backup  Online, non-locking backup and recovery – Complete MySQL instance backup (data and config) – Full & Partial backup and restore  Direct Cloud storage backups (OCI, S3, etc.)  Incremental backups & Point-in-time recovery  Advanced compressed and Strong encryption: AES 256  Backup to tape (SBT)  Backup validation  Optimistic backups  Cross-Platform (Windows, Linux, Unix)  Certified with Oracle Secure Backup, NetBackup, Tivoli, ... 26 © 2022 Oracle MySQL Ensure availability of end-user data
26. MySQL Enterprise Audit 27 © 2022 Oracle MySQL https://www.mysql.com/products/enterprise/audit.html
27. MySQL Enterprise Audit 28 © 2022 Oracle MySQL Help implement stronger security controls & satisfy regulatory compliance 1. DBA Enables Audit Plugin • Defines Filters and Options • Who, What, Where, When, How Audit File (XML or JSON format) MySQL Enterprise Audit 2. User Connects from a Host • Authenticates • Runs Queries • Alters Tables, etc. 3. DBA Reviews Local Audit Events • MySQL Workbench EE • Or other JSON/XML viewer 4. IT Sec Archives to Audit Vault • Globally Assesses Audit Trail www.dasini.net/blog/2018/04/04/mysql-security-mysql-enterprise-audit/
28. MySQL Enterprise Audit 29 © 2022 Oracle MySQL Help implement stronger security controls & satisfy regulatory compliance  Out-of-the-box logging of connections, logins, and query  Auditing for Security & Compliance – GDPR, PCI DSS, Sarbanes-Oxley, HIPAA, FIPS, ...  You see who has done what - connections, logins, and queries (works with firewall)  Secure SQL Access to audit events  Simple to fine grained policies for filtering, and log rotation  Dynamically enabled, disabled: no server restart  Send data to a remote server / audit data vault – Oracle Audit Vault, Splunk, etc. – Custom Settings • XML and JSON audit stream formatting options • Compression & Encryption • Remote Read Only SQL statement access Adds regulatory compliance to MySQL applications (GDPR, HIPAA, PCI DSS, etc.) Adds regulatory compliance to MySQL applications (GDPR, HIPAA, PCI DSS, etc.) www.dasini.net/blog/2018/04/04/mysql-security-mysql-enterprise-audit/
29. MySQL Enterprise TDE T Transparent D Data E Encryption 30 © 2022 Oracle MySQL https://www.mysql.com/products/enterprise/tde.html
30. MySQL Enterprise Transparent Data Encryption (TDE) 31 © 2022 Oracle MySQL Protects against Attacks on Database Files MySQL Database Encrypted Tablespace Files Undo/Redo logs Shared Tablespaces Binary & Relay logs Protected Key Hacker / Dishonest OS User Accesses Files Directly Information Access Blocked By Encryption Keyring plugin - used to retrieve keys from Key Stores over Standardized KMIP protocol www.dasini.net/blog/2018/04/10/mysql-security-mysql-enterprise-transparent-data-encryption/
31. MySQL Enterprise Transparent Data Encryption (TDE)  Data at Rest Encryption – [System | General | Data Dictionary] Tablespaces, Undo/Redo & Binary/Relay logs, Storage, OS File system – Policy to enforce table encryption – Strong Encryption – AES 256  Transparent to applications and users – No application code, schema or data type changes  Transparent to DBAs – Keys are hidden from DBAs, no configuration changes  Requires Key Management – Protection, rotation, storage, recovery 32 © 2022 Oracle MySQL Protects against Attacks on Database Files www.dasini.net/blog/2018/04/10/mysql-security-mysql-enterprise-transparent-data-encryption/
32. MySQL Enterprise Transparent Data Encryption (TDE)  KMIP – Key Management Interoperability Protocol (Oasis Standard) – Keys are protected and secure  KMIP mode tested with the following products – Oracle Key Vault (OKV) – Oracle Cloud Infrastructure Vault – HashiCorp Vault – Thales Enterprise Key Management – Fornetix Key Orchestration Appliance – Townsend Alliance Key Manager  Enables customers to meet regulatory requirements 33 © 2022 Oracle MySQL KMIP Compliant  Additional Options – Key Ring File – Encrypted Key Ring File Also – Oracle Cloud Infrastructure Vault (OCI) – Cloud Key Services (AWS)  https://dev.mysql.com/doc/refman/8.0/en/keyring.html
33. At Rest Encryption Covers  InnoDB Tables and Tablespace – File Per Table Tablespace or General (Multi-Table) Tablespace  MySQL System Tablespace – Data Dictionary Tables  Binlog Encryption  MySQL Enteprise Audit Logs  MySQL Enterprise Backup Files  Note: DBAs can optionally force Table Encryption – i.e. Users can only create encrypted tables 34 © 2022 Oracle MySQL
34. MySQL Enterprise Firewall 35 © 2022 Oracle MySQL https://www.mysql.com/products/enterprise/firewall.html
35. MySQL Enterprise Firewall 36 © 2022 Oracle MySQL Guard against cyber security threats  Block SQL Injection Attacks – Allow: SQL Statements that match Allowlist – Block: SQL statements that are not on Allowlist  Intrusion Detection System – Detect: SQL statements that are not on Allowlist • SQL Statements execute and alert administrators Select * from employee where id=22 Select * from employee where id=22 or 1=1 or 1=1 Block ✖ Allow ✔ AllowList Applications Detect & Alert Intrusion Detection Rule www.dasini.net/blog/2018/04/16/mysql-security-mysql-enterprise-firewall/
36. MySQL Enterprise Firewall 37 © 2022 Oracle MySQL Guard against cyber security threats  Real Time Protection – Queries checked against Allowlist and Firewall Rules  Blocks SQL Injection Attacks – Block Out of Policy Transactions  Intrusion Detection – Detect and Alert on Out of Policy Transactions  Automated Allowlist – Learning mode for creation of approved list of SQL command patterns on a per user basis  Custom Rules – using Powerful JSON definitions  Transparent – No changes to application required MySQL Enterprise Firewall monitoring using MySQL Enterprise Monitor www.dasini.net/blog/2018/04/16/mysql-security-mysql-enterprise-firewall/
37. MySQL Enterprise Firewal 38 © 2022 Oracle MySQL Guard against cyber security threats  Combined Firewall/Audit Rules – Create more general allow/deny firewall rules using JSON syntax – using abort=on Example - block execution of specific  SQL statements (insert, update, delete)  For a specific table (finances.bank_account) Test rules  By writing to audit log  If data as expected change to firewall – add “abort”
38. MySQL Enterprise Data Masking & De-Identification 39 © 2022 Oracle MySQL https://www.mysql.com/products/enterprise/masking.html
39. MySQL Enterprise Masking & De-Identification 40 © 2022 Oracle MySQL Help protect sensitive data from unauthorized uses
40. MySQL Enterprise Masking & De-Identification  Data Masking – String masking – Dictionary based replacement – Specific masking • SSN • Payment card : Strict/Relaxed 41 © 2022 Oracle MySQL Help protect sensitive data from unauthorized uses  Random Data Generator – Random number within a range – Email – Payment card (Luhn check compliant) – SSN – Dictionary based generation www.dasini.net/blog/2019/03/19/mysql-security-mysql-enterprise-data-masking-and-de-identification/
41. MySQL Enterprise Masking & De-Identification  Data Masking and De-identification helps database customers improve security  Accelerates compliance for – Government – GDPR, CHHS – Financial - PCI – Healthcare – HIPAA, Clinic Trials Data  Reduce IT costs by simplifying sanitizing production data – Transforming sensitive data for use in analytics, testing, development, and more 42 © 2022 Oracle MySQL Help protect sensitive data from unauthorized uses www.dasini.net/blog/2019/03/19/mysql-security-mysql-enterprise-data-masking-and-de-identification/
42. MySQL Enterprise Encryption 43 © 2022 Oracle MySQL https://www.mysql.com/products/enterprise/encryption.html
43. MySQL Enterprise Encryption 44 © 2022 Oracle MySQL Industry standard functionality for asymmetric encryption
44. MySQL Enterprise Encryption  Set of encryption functions based on the OpenSSL library that expose OpenSSL capabilities at the SQL level  MySQL encryption functions – Symmetric encryption AES256 (All Editions) – Public-key / asymmetric cryptography – RSA  Key management functions – Generate public and private keys – Key exchange methods: DH  Sign and verify data functions – Cryptographic hashing for digital signing, verification, & validation – RSA,DSA 45 © 2022 Oracle MySQL Industry standard functionality for asymmetric encryption
45. MySQL Enterprise Authentication 46 © 2022 Oracle MySQL https://www.mysql.com/products/enterprise/security.html
46. MySQL Enterprise Authentication 47 © 2022 Oracle MySQL Ready to use external authentication modules to easily integrate existing security infrastructures
47. MySQL Enterprise Authentication  Integrate with Centralized Authentication Infrastructure – Centralized Account Management – Password Policy Management – Groups & Roles  PAM (Pluggable Authentication Modules) – Native LDAP • Access native LDAP service for authentication – Windows • Access native Windows service - Use to Authenticate users using Windows Active Directory or to a native host – Linux PAM Standard interface (Unix, LDAP, Kerberos, others) 48 © 2022 Oracle MySQL Ready to use external authentication modules to easily integrate existing security infrastructures Integrates MySQL with existing security infrastructures Integrates MySQL with existing security infrastructures
48. MySQL Enterprise Scalability (Thread Pool) 49 © 2022 Oracle MySQL https://www.mysql.com/products/enterprise/scalability.html
49. MySQL Enterprise Scalability 50 © 2022 Oracle MySQL Designed to reduce overhead in managing client connections and statement execution threads  Limit the number of concurrently executing transactions to ensure that each has sufficient CPU and memory resources to fulfill its task  Provides up to 60x better scalability  A highly scalable thread-handling model designed to reduce overhead in managing client connections and statement execution threads  Improves sustained performance as user connections grow
50. MySQL Workbench EE  Database migrations – From Microsoft SQL Server, PostgreSQL, Sybase ASE, Sybase SQL Anywhere, SQLite, Microsoft Access, and more  Manage migration projects  Source and target selection  Object migration  Data migration  MySQL version upgrades 51 © 2022 Oracle MySQL Database Migration Wizard for SQL Server, Sybase, SQLite, Sybase & PostgreSQL
51. Oracle Enterprise Manager for MySQL  Availability monitoring  Performance monitoring  Configuration monitoring  All available metrics collected – Allowing for custom threshold based incident reports  MySQL auto-detection  Versions 13.2.4.0.0+ supports MySQL 8.0. 52 © 2022 Oracle MySQL
52. MySQL Enterprise Support  Largest MySQL engineering and support organization  Backed by the MySQL developers  World-class support, in 29 languages  Hot fixes & maintenance releases  24x7x365  Unlimited incidents  Consultative support  Global scale and reach 53 © 2022 Oracle MySQL Get immediate help for any MySQL issue, plus expert advice Get immediate help for any MySQL issue, plus expert advice https://www.mysql.com/fr/support/
53. MySQL Enterprise Consultative Support  Remote troubleshooting  Replication review  Partitioning review  Schema review  Query review  Performance tuning  ...and more 54 © 2022 Oracle MySQL https://www.mysql.com/fr/support/consultative.html Make the Most of your Deployments
54. MySQL Security Overview 55 © 2022 Oracle MySQL
55. MySQL Enterprise Security  Assess – MySQL Enterprise Monitor  Prevent – MySQL Enterprise Authentication – MySQL Enterprise Firewall – MySQL Enterprise TDE – MySQL Enterprise Encryption – MySQL Enterprise Data Masking  Detect – MySQL Enterprise Audit  Recover – MySQL Enterprise HA – MySQL Enterprise Backup 56 © 2022 Oracle MySQL
56. MySQL Security Achitecture 57 © 2022 Oracle MySQL
57. MySQL Enterprise Edition  MySQL Enterprise Authentication – External Authentication Modules • Microsoft AD, Linux PAMs, Native LDAP  MySQL Enterprise Encryption – Public/Private Key Cryptography – Asymmetric Encryption – Digital Signatures, Data Validation  MySQL Enterprise Firewall – Block SQL Injection Attacks – Intrusion Detection  MySQL Enterprise Audit – User Activity Auditing, Regulatory Compliance  MySQL Enterprise Monitor – Changes in Database Configurations, Users Permissions, Database Schema, Passwords  MySQL Enterprise Backup – Securing Backups, AES 256 encryption  MySQL Enterprise TDE – AES 256 encryption – Key Management  MySQL Enterprise De-Identification – Data Masking and Obfuscation – Formatted Data Randomization – Pseudonymization, Data Blocklists – Random Data generation 58 © 2022 Oracle MySQL Designed to provide monitoring, online backup, as well as improved security and scalability More information available at : http://www.mysql.com/products/enterprise/
58. Resources – MySQL Blogs 59 © 2022 Oracle MySQL • The complete list of new features in MySQL 8.0 – https://mysqlserverteam.com/the-complete-list-of-new-features-in-mysql-8-0/ • MySQL Server Team’s blog – http://mysqlserverteam.com/ • MySQL High Availability Team’s blog – http://mysqlhighavailability.com/ • MySQL Release Engineering Blog – https://mysqlrelease.com/ • MySQL Dev Team Blog – https://insidemysql.com/ • MySQL Enterprise Team Blogs – https://blogs.oracle.com/mysql/ • Lefred’s blog (MySQL Community Manager) – http://lefred.be/ • Olivier Dasini’s blog – www.dasini.net/blog/ – https://www.youtube.com/channel/UC12TulyJsJZHoCmby3Nm3WQ
59. Resources – MySQL Blogs 60 © 2022 Oracle MySQL • MySQL Document Store – https://dev.mysql.com/doc/x-devapi-userguide/en/ – https://github.com/mysql/mysql-connector-nodejs – https://www.npmjs.com/package/@mysql/xdevapi – https://dev.mysql.com/doc/refman/8.0/en/document-store.html – https://dev.mysql.com/doc/x-devapi-userguide/en/ – https://dev.mysql.com/doc/dev/connector-nodejs/8.0/ – https://www.mysql.com/news-and-events/web-seminars/mysql-document-store-and-node-js/ • MySQL Performance by Dimitri – http://dimitrik.free.fr/blog/archives/2018/04/mysql-performance-over-18m-qps-with-80-ga-on-2s-skylake.html – http://dimitrik.free.fr/blog/archives/2018/04/mysql-performance-80-and-utf8-impact.html • MySQL InnoDB Cluster – https://mysqlserverteam.com/mysql-innodb-cluster-8-0-ga-is-available-now/ – https://mysqlserverteam.com/mysql-innodb-cluster-whats-new-in-the-8-0-ga-release/ – https://mysqlserverteam.com/mysql-innodb-cluster-8-0-a-hands-on-tutorial/
60. Resources – MySQL Blogs 61 © 2022 Oracle MySQL • Common Table Expressions (CTE) – http://mysqlserverteam.com/mysql-8-0-labs-recursive-common-table-expressions-in-mysql-ctes/ – http://mysqlserverteam.com/mysql-8-0-labs-recursive-common-table-expressions-in-mysql-ctes-part-two-how-to-generate-series/ – http://mysqlserverteam.com/mysql-8-0-labs-recursive-common-table-expressions-in-mysql-ctes-part-three-hierarchies/ – http://mysqlserverteam.com/mysql-8-0-1-recursive-common-table-expressions-in-mysql-ctes-part-four-depth-first-or-breadth-first-traversal-transitive- closure-cycle-avoidance/ • Window Functions – http://mysqlserverteam.com/mysql-8-0-2-introducing-window-functions/ – https://mysqlserverteam.com/row-numbering-ranking-how-to-use-less-user-variables-in-mysql-queries/ – https://fr.slideshare.net/DagHWanvik/dublin-4x3finalslideshare-80423777 • Security – https://www.mysql.com/news-and-events/web-seminars/checking-and-hardening-mysql-8-0-security-via-sql-and-without-os-access/ – https://mysqlserverteam.com/mysql-8-0-4-new-default-authentication-plugin-caching_sha2_password/ – http://lefred.be/content/mysql-8-0-listing-roles/ – https://dev.mysql.com/doc/refman/8.0/en/password-management.html • Upgrade from 5.7 to 8.0 – https://mysqlserverteam.com/inplace-upgrade-from-mysql-5-7-to-mysql-8-0/ – https://mysqlserverteam.com/upgrading-to-mysql-8-0-here-is-what-you-need-to-know/
61. 62 © 2022 Oracle MySQL Get Started Today! MySQL Enterprise Edition Trial Contact a MySQL Sales Rep http://www.mysql.com/trials/ http://www.mysql.com/about/contact/
62. Follow us on Social Media 63
63. Merci! Q&R Olivier Dasini MySQL Cloud Principal Solutions Architect EMEA olivier.dasini@oracle.com Blogs : www.dasini.net/blog/en : www.dasini.net/blog/fr Linkedin : www.linkedin.com/in/olivier-dasini Twitter : @freshdaz