X

MySQL and HeatWave

Recent Posts

Webinar: MySQL Enterprise Edition Apr 29

Join us on Thursday April 29th, 2021 @10:00 CET (EMEA) for a live webinar that will cover the new features of MySQL Enterprise Edition.   Who's the event for?  Your applications manage personal data: name, account numbers, passwords  You belong to an industry or region that is subject to data protection requirements You use 3rd party components for authentication, auditing, & key management You're an ISVs and SaaS organization that manages sensitive customer data You're an existing MySQL Community Edition user Learn how MySQL Enterprise Edition will save you time and give you piece of mind by increasing the protection of your critical data, the prevention of data breaches and by helping you meet regulator requirements. MySQL provides advance security features to protect the privacy of information, prevents data breaches and helps organizations meet regulatory requirements such as GDPR, PCI, HIPAA and numerous others.     See how, by registering to the webinar today: Register now.   Among the MySQL Enterprise edition features covered are: MySQL Enterprise Transparent Data Encryption (TDE) MySQL Enterprise Transparent Data Encryption (TDE) enables data-at-rest encryption by encrypting the physical files of the database. Data is encrypted automatically, in real time, prior to writing to storage and decrypted when read from storage. New! MySQL Enterprise Masking and De-identification MySQL Enterprise Masking and De-identification provides an easy to use, built-in database solution to help organizations protect sensitive data from unauthorized uses by hiding and replacing real values with substitutes. MySQL Enterprise Backup MySQL Enterprise Backup reduces the risk of data loss by delivering online "Hot" backups of your databases. It supports full, incremental and partial backups, Point-in-Time Recovery and backup compression. MySQL Enterprise High Availability MySQL InnoDB Cluster delivers an integrated, native, HA solution for your databases. It tightly integrates MySQL Server with Group Replication, MySQL Router, and MySQL Shell, so you don’t have to rely on external tools, scripts or other components. MySQL Enterprise Scalability MySQL Enterprise Scalability enables you to meet the sustained performance and scalability requirements of ever increasing user, query and data loads. MySQL Thread Pool provides an efficient, thread-handling model designed to reduce overhead in managing client connections, and statement execution threads. MySQL Enterprise Authentication MySQL Enterprise Authentication provides ready to use external authentication modules to easily integrate MySQL with existing security infrastructures including PAM and Windows Active Directory. MySQL users can be authenticated using Pluggable Authentication Modules ("PAM") or native Windows OS services. MySQL Enterprise Encryption MySQL Enterprise Encryption provides encryption, key generation, digital signatures and other cryptographic features to help organizations protect confidential data and comply with regulatory requirements. MySQL Enterprise Firewall MySQL Enterprise Firewall guards against cyber security threats by providing real-time protection against database specific attacks, such as an SQL Injection. MySQL Enterprise Firewall monitors for database threats, automatically creates an allowlist of approved SQL statements and blocks unauthorized database activity. MySQL Enterprise Audit MySQL Enterprise Audit enables you to quickly and seamlessly add policy-based auditing compliance to new and existing applications. You can dynamically enable user level activity logging, implement activity-based policies, manage audit log files and integrate MySQL auditing with Oracle and third-party solutions. MySQL Enterprise Monitor The MySQL Enterprise Monitor and the MySQL Query Analyzer continuously monitor your databases and alerts you to potential problems before they impact your system. It's like having a "Virtual DBA Assistant" at your side to recommend best practices to eliminate security vulnerabilities, improve replication, optimize performance and more. As a result, the productivity of your developers, DBAs and System Administrators is improved significantly. Oracle Enterprise Manager for MySQL The Oracle Enterprise Manager for MySQL provides real-time monitoring and delivers comprehensive performance, availability and configuration information for your MySQL databases. MySQL Router MySQL Router is lightweight middleware that provides transparent routing between your application and any backend MySQL Servers. It can be used for a wide variety of use cases, such as providing high availability and scalability by effectively routing database traffic to appropriate backend MySQL Servers. MySQL Workbench MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. It provides data modeling, SQL development, database migration and comprehensive administration tools for server configuration, user administration, and much more. MySQL Technical Support MySQL Technical Support Services provide 24x7 direct access to our expert MySQL Support engineers who are ready to assist you in the development, deployment, and management of MySQL applications.   Learn more about MySQL Enterprise Edition Download the MySQL Enterprise Edition Whitepaper

Join us on Thursday April 29th, 2021 @10:00 CET (EMEA) for a live webinar that will cover the new features of MySQL Enterprise Edition.   Who's the event for?  Your applications manage personal data:...

MySQL Database Service

MySQL Database Service with High Availability

MySQL Database Service is now easier to use and has flexible deployment options, including High Availability. While creating a new DB System using the web console, users can choose between Standalone, Highly Availability, and HeatWave deployments. The service will pre-populate the necessary fields with the recommended settings. You only need to provide the MySQL user name and password to get MySQL up and running. With the Standalone option, users get a single-instance MySQL DB System back-ended by the resilient and secure OCI Block Volumes. This option is the most common for test and development environments. The High Availability option enables applications to meet higher uptime requirements and zero data loss tolerance. When you select the High Availability option, a MySQL DB System with three instances is provisioned across different availability or fault domains. The data is replicated among the instances using a Paxos-based consensus protocol implemented by the MySQL Group Replication technology. Your application connects to a single endpoint to read and write data to the database. In case of failure, the MySQL Database Service will automatically failover within minutes to a secondary instance without data loss and without requiring to reconfigure the application. See the documentation to learn more about MySQL Database Service High Availability.  The HeatWave option deploys a pre-configured DB System to allow accelerated query processing, suitable for running both OLTP and OLAP workloads. With its innovative in-memory analytics engine, HeatWave provides 400x query acceleration for MySQL at a very compelling price.  If you have an existing MySQL application experiencing slow queries, you can also request a Performance Health Check. A MySQL Technician will work closely with your team to run your queries using MySQL Database Service with HeatWave to verify the performance improvements. You can try MySQL Database Service and many other services for free. Go to oracle.com/cloud/free and create your free account in Oracle Cloud Infrastructure. Check the documentation for the quick steps to create your MySQL databases.  

MySQL Database Service is now easier to use and has flexible deployment options, including High Availability. While creating a new DB System using the web console, users can choose between Standalone,...

Announcements

Where’s the MySQL team from April - June 2021 (updated, Apr 28, 2021)

Please find below the list of shows where you can find MySQL Community and/or the MySQL team at during April to June 2021: April 2021: Data Love Conference/VIRTUAL, April 16, 2021 David Stokes, the MySQL Community Manager is going to talk about "Windowing Functions for Database Analytics", for the exact timing please check organizers' website. MidwestPHP/VIRTUAL, April 22-23, 2021 David Stokes, the MySQL Community Manager is going to talk about "MySQL 8.0 New Features". The talk is scheduled for 1:50pm-2:30pm on April 22nd.  May 2021: PerconaLive/VIRTUAL, May 12-13, 2021 This year MySQL is going to have MySQL track(s) with multiple talks given by MySQL development, Community & technical team members. For the schedule & talk details, (currently under review) please visit Percona's website. DOAG Databanken/VIRTUAL, May 17-18, 2021 Carsten Thalheimer, the Master Principal Sales Consultant is going to have a MySQL talk on "Vortrag: Dinge, die ich hätte wissen sollen, bevor ich MySQL installiert habe…", the talk is scheduled for May 18, 2021 @11:00-11:45 am, see in the DOAG schedule. Conf42: Python 2021/VIRTUAL, May 27, 2021 David Stokes, the MySQL Community Manager will be talking on "Python and the New MySQL Shell".  Open Source Conference (OSC) Nagoya/VIRTUAL, May 29, 2021 Yoshiaki Yamasaki, the MySQL Principal Solution Engineer, Japan & Asia Pacific & local team are going to run MySQL session. Please watch organizers’ website for further details. June 2021: OpenJS World 2021/VIRTUAL, June 2, 2021 David Stokes, the MySQL Community Manager will be speaking on Javascript Mode and the MySQL Shell topics.  DutchPHP/VIRTUAL, June 17, 2021 David Stokes, the MySQL Community Manager will run 3 hours workshop on "MySQL 8.0 Indexes, Histograms, and Other Ways to Speed Up Your Queries". The workshop is planned for June 17@14:00-17:00. OpenExpo Europe/VIRTUAL, June 17-21, 2021 As a partner of OpenExpo, MySQL team will run 2 presentations, one as part of OpenExpo conference and second before June 2021. We are working on the content and timing. Please watch organizers' website for further updates. Open Source Conference (OSC) Hokkaido/VIRTUAL, June 26, 2021 Same as for OSC Nagoya, Yoshiaki Yamasaki, the MySQL Principal Solution Engineer, Japan & Asia Pacific & local team are going to run MySQL talk. Please watch organizers’ website for further details. Conferences where our involvement still needs to be confirmed: SouthEast Linux Fest (SELF), US, Date: June 11-13, 2021 Hong Kong OS Conference, Date: June 2021 RootConf, India, Date: June 2021

Please find below the list of shows where you can find MySQL Community and/or the MySQL team at during April to June 2021: April 2021: Data Love Conference/VIRTUAL, April 16, 2021 David Stokes, the...

Analyst Report: Oracle Cranks up the Heat in the MySQL Cloud Market

Bringing High Performance Analytics to MySQL                                                                                                                                                                                                                              Author: Tony Baer, Principal, dblnsight                                                              Main takeaway:  “The MySQL landscape needed a shakeup. Until now, it was considered the default go-to open source database for online transaction processing (OLTP) for the scenarios not requiring the more sophisticated capabilities of “enterprise” databases. And, owing to lack of features such as materialized views, MySQL has not been seriously considered for analytics/data warehousing use cases. However, given the popularity of MySQL with its large skills base, there was a vacuum waiting to be filled. Oracle has been actively developing MySQL for over a decade, but in the MySQL cloud ecosystem, Oracle was overshadowed by cloud providers offering their own MySQL DBaaS services. To enter a MySQL DBaaS market that was already pretty crowded, Oracle would have to sharply differentiate itself. Oracle’s new “HeatWave” engine does just that, turning up the heat on rival cloud MySQL services by not only adding analytics to the mix, but incorporating hardware and software optimizations that significantly accelerate performance. With the new service, MySQL customers can use the same familiar database for their OLTP and OLAP workloads, while eliminating the cost, complexity, and risk of the ETL processes that are required when using separate databases. Aggressively priced, Oracle MySQL Database Service customers should get a good bang for their buck.”     Additional highlights include: “Oracle MySQL Database Service, with its integrated HeatWave engine, is the only MySQL cloud service that supports OLTP and OLAP workloads.” “The combination of conventional in-memory columnar, micro partitioning, and vector processing makes HeatWave unique.” “Oracle has run its own TPC-H benchmark comparing MySQL Database Service with HeatWave vs. Amazon Redshift. This is not an opaque benchmark; Oracle encourages customers to run the same benchmark for themselves, making all the scripts publicly available on GitHub.” “Oracle is not simply adding just another me-too MySQL cloud service to an already-crowded market. It is differentiating it, both in features and price.” “The big benefit is with transaction and analytic workloads relying on the same data.Because data stays within the same database, it dispenses with the need for ETL processes.” “HeatWave is a versatile engine for analytics, enabling in-memory vectorized processing, massive inter-and intra-node parallelism, and distributed query processing; the engine chooses the optimal path for the query.” “Aggressively priced, Oracle MySQL Database Service customers should get a good bang for their buck.” Read the full report   Additional references: Learn more about HeatWave (videos, testimonials, related blogs, Larry’s quote) Learn more about MySQL Database Service Try it free     

Bringing High Performance Analytics to MySQL                                                                                                                                                            ...

MySQL HeatWave: Your Reference Guide and Webinar

MySQL Database Service with HeatWave: 1100x Faster than Amazon Aurora, 400x faster than Amazon RDS, 18x faster than Amazon Redshift at ⅓ the cost. This blog post will guide you through the MySQL HeatWave references that are available today, from live webinar, to recorded videos, blogs, and more. Let's start with a quick definition of what is MySQL HeatWave. HeatWave is a new, in-memory query accelerator for MySQL Database Service available only in the Oracle Cloud. It can accelerate performance on large multi-TB datasets, and scale across 1,000s cores. Our benchmark results and customer feedback show that HeatWave accelerates MySQL queries by 400X and is 1/3 the cost of Amazon Redshift. Oracle MySQL Database Service, with HeatWave, is the only service that enables database admins and app developers to run OLTP and OLAP workloads directly from their MySQL database, eliminating the need for complex, time-consuming, and expensive data movement and integration with a separate analytics database.    Learn more in our upcoming live webinar: Date/Time: March 24, 2021. 9AM PST Speaker: Nipun Agarwal, Vice President, Research & Advanced Development Title: 400x Query Acceleration for MySQL with HeatWave Description: Learn how you can leverage HeatWave to accelerate your MySQL queries. Register now   Query Performance Health Check - The HeatWave Challenge Do you want to improve the performance of your slow queries? Sign up today for a HeatWave performance Heath Check.  As part of the Performance Health Check, a MySQL Technician will work closely with your team to run your queries using MySQL Database Service with HeatWave and share the performance improvements. Sign up now Videos: A 5 minute demo of the MySQL Database Service with HeatWave analytics engine.    A 30 minute video from the launch of MySQL Database Service with HeatWave analytics engine.     Recent blogs about HeatWave: Breakthrough Enhancements in MySQL Database Service with Analytics Engine HeatWave for MySQL – Technical Deep Dive MySQL HeatWave: 1100x Faster than Aurora, 400x than RDS, 18x than Redshift at ⅓ the cost Introducing MySQL Database Service and MySQL Analytics Engine   Other resources: Learn more about HeatWave on our website  Read the technical brief See the performance comparison and benchmarks  Peruse the documentation Ask your questions in our community forum Get MySQL Database Service Training and Certification   As a dolphin, Sakila is a fast swimmer, but when on its HeatWave surfboard, it is the fastest! There is no match when it comes to surfin’ data waves. Try it free     Customer quotes:    

MySQL Database Service with HeatWave: 1100x Faster than Amazon Aurora, 400x faster than Amazon RDS, 18x faster than Amazon Redshift at ⅓ the cost. This blog post will guide you through the...

MySQL HeatWave: 1100x Faster than Aurora, 400x than RDS, 18x than Redshift at 1/3 the cost

HeatWave is designed to enable customers to run analytics on data which is stored in MySQL databases without the need for ETL. This service is built on an innovative, in-memory analytics engine which is architected for scalability and performance and is optimized for Oracle Cloud Infrastructure (OCI) Gen 2 hardware. This results in a very performant solution for SQL analytics at a fraction of the cost compared to other cloud services including AWS Aurora, Redshift, Google Big Query, RDS. The amount of acceleration an application would observe with HeatWave depends upon a number of factors like the datasize, queries, operators being used in the query, the selectivity of the predicates. For the purpose of comparing, we are considering the TPCH benchmark which has the queries well defined and the only variable is the data size and the system configuration. HeatWave is able handle all workloads with a single shape so that significantly simplifies the choice for the customer.  400x Query Acceleration for MySQL  The first comparison we make is with MySQL database which is representative of MySQL running on various cloud platforms or various flavors of MySQL. For 400G datasize, using the same number of cores and the same amount of DRAM for MySQL, HeatWave accelerates performance by 400x times for analytics workloads like TPCH. Furthermore, there is no need to create any indexes with HeatWave.   Figure 1. HeatWave accelerates MySQL queries by 400x   1100x Faster than Aurora, 3x cheaper  The next comparison we show is with Amazon Aurora, which is Amazon’s premium database service. HeatWave offers dramatic improvement in performance for complex and analytic queries. For a 4TB TPC-H workload, MySQL HeatWave is 1100x faster than Amazon Aurora. Furthermore, there is no need to create indexes on the base table which takes over 5 days with Amazon Aurora compared to under 4 hours to load data in HeatWave. As a result, the data is available to query much sooner than with Aurora. Furthermore, the cost is less than 1/3 of Aurora. Figure 2. HeatWave is 1100x faster and less than 1/3 the cost of Aurora The performance improvement of MySQL Database Service with HeatWave over Aurora increases with the size of data. Figure 3. The performance advantage of HeatWave increases with data size vs. Amazon Aurora 17x Faster than Redshift, 3x Cheaper  Next, we compare with Amazon Redshift which is designed for analytics and is offered in multiple shapes. Compared to the fastest shape (dc2.8xlarge), HeatWave is up to 3x faster and 1/3 the cost. For HeatWave, the cost includes both OLTP and OLAP capabilities while for Redshift the additional cost of the OLTP system and the cost of ETL from the OLTP database to Redshift is not included.  Figure 4. HeatWave is 2.7x faster and 1/3 the cost of Amazon Redshift’s fastest shape. Compared to the cheaper shape of Redshift (RA3.4xLarge), HeatWave is up to 18x faster and 3% less expensive. Unlike Redshift, HeatWave is capable of running both OLTP and OLAP wokloads, without the need for ETL. With Redshift listed cost is only for OLAP, and additional costs are needed for the OLTP database. Figure 5. HeatWave is 17.7x faster and cheaper than Amazon Redshift’s cheaper shape   Customers who use HeatWave will benefit from significantly better performance, eliminating the need for ETL, support for real-time analytics, reduced monthly cost and a single database for OLTP and OLAP.   Conclusion HeatWave is a cloud native service which is exclusively available in Oracle cloud Infrastructure and provides compelling performance and cost for analytic workloads. Organizations using MySQL database for managing their enterprise data can now run analytic queries with HeatWave with significantly better performance, lower cost, not requiring ETL and support for real- time analytics in contrast to other database services like RDS, Google Big Query, Snowflake, Aurora and Redshift. The service can be deployed in a cloud only or in a hybrid environment, and it simplifies management for both transactional and analytic applications. We welcome you to try this service for free: https://www.oracle.com/cloud/free/

HeatWave is designed to enable customers to run analytics on data which is stored in MySQL databases without the need for ETL. This service is built on an innovative, in-memory analytics engine...

Integrating Any Type of Data with MySQL Database Service and HeatWave

  Oracle Cloud Infrastructure Data Integration with MySQL Database Service and Heatwave Virtually all data types from any data source can be integrated into the MySQL Database Service and HeatWave. When you need to collect data from diverse sources in a timely manner, Oracle Cloud Infrastructure (OCI) Data Integration, a cloud native, serverless ETL (extract, load, transform) service on the Oracle Cloud, provides a unified solution for building, deploying, and managing complex data warehouses. Discover how its combined elements of data integration; with a graphical, no-code designer, and interactive data preparation, all powered by Spark ETL or E-LT push-down execution, ensure that information is timely, accurate, and consistent across complex systems. Watch the full webinar (including demo): Speakers: Nicolas de Rico, MySQL Principle Solution Engineer Julien Testut, Senior Principal Product Manager, Oracle Cloud Infrastructure (OCI) Data Integration   Presentation slides: Download the slide presentation   Additional references: Oracle Cloud Infrastructure Data Integration - Documentation Oracle Cloud Infrastructure Data Integration - Connecting to Data Sources MySQL Database Service and HeatWave - Get Started MySQL Database Service and HeatWave - Free Trial MySQL Database Service and HeatWave - Tutorial

  Oracle Cloud Infrastructure Data Integration with MySQL Database Service and Heatwave Virtually all data types from any data source can be integrated into the MySQL Database Service and HeatWave. When...

MySQL 8.0.23 Top Blogs and Webinar

MySQL 8.0.23 introduces many new improvements and updates, many of which deserve their own blog post for a deep dive into the new features.  Among the notable changes are: Invisible columns, Query attributes, several new (security, InnoDB, GIS, Replication, Group replication, X Protocol, Router, MTR Testsuite) features, and many more. Recorded Webinar: Our webinar covers the many new features introduced with the latest 8.0.23 release, plus the highlights of MySQL 8.0    Top blogs: The MySQL 8.0.23 Maintenance Release is Generally Available A 250x improvement to tablespace truncation in MySQL Server 8.0.23 Announcing MySQL Cluster 8.0.23, 7.6.17, 7.5.21, 7.4.31, and 7.3.32 MySQL Shell 8.0.23 for MySQL Server 8.0 and 5.7 has been released MySQL Workbench 8.0.23 has been released New MySQL NDB Cluster version 8.0.23 Announcing MySQL Server 8.0.23 and 5.7.33 Group profiles in MySQL Enterprise Firewall MySQL 8.0.23: thank you for the contributions MySQL Invisible Column – part I MySQL Invisible Column: part II MySQL Invisible Column: part III MySQL Shell 8.0.23 – What’s New? MySQL Shell AdminAPI – What’s new in 8.0.23?   MySQL Connector/J 8.0.23 has been released MySQL Connector/C++ 8.0.23 has been released MySQL Connector/NET 8.0.23 has been released MySQL Connector/Node.js 8.0.23 has been released MySQL Connector/Python 8.0.23 has been released MySQL Connector/ODBC 8.0.23 has been released Support for Date-Time Types in Connector/J 8.0      

MySQL 8.0.23 introduces many new improvements and updates, many of which deserve their own blog post for a deep dive into the new features.  Among the notable changes are: Invisible columns, Query...

Announcements

Where's the MySQL Team from January - March 2021

As a continue of the regular blog posts informing you about where you can find MySQL Community & MySQL team at, please find below a list of shows you can join and listen MySQL talks & sessions.  January 2021: Coud Native Meetup/VIRTUAL, January 26, 2021 - URL to be provided later on. Frederic Descamps, the MySQL User Group Manager will talk on: "MySQL 8.0: Why to use MySQL 8.0 and how to deploy a web application in OCI using MySQL Database Service"  Scheduled for January 26th as EMEA & JAPAC session & January 27th, 2021. OpenSource Conference Osaka/VIRTUAL, January 30, 2021 Yoshiaki Yamasaki, the MySQL Principal Solution Engineer, Japan & Asia Pacific will be talking about "Introduction to HeatWave & MySQL Database Services". See session on the website. February 2021: FOSDEM/VIRTUAL, February 6-7, 2021 as usual a MySQL room is open at FOSDEM. Both, David Stokes & Frederic Descamps, the MySQL User Group Managers will speak at FOSDEM this year & much more speakers are up. You can see the full agenda of MySQL Dev room here. Rocky Mountain Oracle Users Group/VIRTUAL, February 8-11, 2021 David Stokes, the MySQL User Group Manager will be talking about "MySQL 8.0 New Features". His talk is scheduled for Feb 8th @ 3:15-4:10 pm. ConFoo/VIRTUAL, February 22-26, 2021 David Stokes, the MySQL User Group Manager got accepted two talks as follows:  Feb 24 @3:15pm: "MySQL 8.0 Update" & Feb 26 @3:00pm: "MySQL Histograms versus Indexes. March 2021: OpenSource Conference Spring/VIRTUAL, Mar 5-6, 2021 Machiko Ikoma, The MySQL Principal Solution Engineer will talk about "MySQL Update". See session on the website. OpenSource 101/VIRTUAL, March 30, 2021 David Stokes, the MySQL User Group Manager is going to have a talk at OS 101. More details will follow up. Watch for further details, the show might be postponed.

As a continue of the regular blog posts informing you about where you can find MySQL Community & MySQL team at, please find below a list of shows you can join and listen MySQL talks & sessions.  January...

MySQL Database Service

MySQL Database Service with HeatWave is now available in 22 regions

We are pleased to announce that MySQL Database Service with HeatWave is now available in 22 regions worldwide.  With the introduction of 10 new regions, MySQL Database Service is now present in all Oracle Cloud Infrastructure commercial regions: North America  US East (Ashburn)  US West (Phoenix)  US West (San Jose)  Canada Southeast (Toronto)  Canada Southeast (Montreal) Latin America  Brazil East (Sao Paulo)  Chile Central (Santiago) EMEA  UK South (London)  UK West (Newport)  Germany Central (Frankfurt)  Switzerland North (Zurich)  Netherlands Northwest (Amsterdam)  Saudi Arabia West (Jeddah)  UAE East (Dubai) APAC  Japan East (Tokyo)  Japan Central (Osaka)  South Korea Central (Seoul)  South Korea North (Chuncheon)  Australia East (Sydney)  Australia Southeast (Melbourne)  India West (Mumbai)  India South (Hyderabad)     You are welcome to try MySQL Database Service and many other services for free. Go to oracle.com/cloud/free and create your free account in Oracle Cloud Infrastructure. Check the documentation for the quick steps to create your MySQL databases.  Visit oracle.com/mysql to learn more about MySQL Database Service and HeatWave. The MySQL team is tirelessly working to continue to evolve MySQL Database Service and HeatWave. More features are coming soon. Stay tuned!

We are pleased to announce that MySQL Database Service with HeatWave is now available in 22 regions worldwide.  With the introduction of 10 new regions, MySQL Database Service is now present in all...

MySQL Best of 2020

2020 was a very eventful year at MySQL. Now that we just started 2021, this is a great time to look back at everything we accomplished in 2020, from the anniversary celebrations to the year's best webinars, the best events, the best customer quotes, the best new product addition, the best animated videos, the best social media contribution, the best social media posts and of course, Larry’s best quote and many more.  Here is our "Best of 2020," enjoy!  (We'd love to see your favorites too.  Feel free to share your favorites with us in the comment section) 1. 2020 was our MySQL 25th anniversary which we shared and celebrated with our friends from Java and PHP.  Watch the animated video that celebrates 25 years of community contribution and loyal customers and users. 2. Introduction of MySQL Database Service with HeatWave. The launch generated over 100 news media articles. Read the full press release and Watch the official launch event 3. First Oracle Developer Live event fully dedicated to MySQL. The event generated over 12k attendees and many more viewers on YouTube.  So, we’ll call it the best MySQL event of the year.  You can visualize the 11 sessions online at: https://developer.oracle.com/developer-live/mysql/ 4. Larry Ellison's awesome quote about the new MySQL Database Service introduction with HeatWave analytics engine.  We’ll call it the best MySQL quote of the year. 5. Top 2020 cloud webinars Migrating from Amazon RDS to Oracle MySQL Database Service Business Benefits of Using MySQL Database Service with HeatWave Getting Started with MySQL Database Service plus HeatWave Migrating From On-Premises to Oracle MySQL Database Service Top Reasons to Use MySQL Database Service Using MySQL Database Service with Oracle Analytics Cloud 6. Top 2020 on-premises webinars Top Features that Makes MySQL 8.0 the Most Innovative Database of the Year Demoing Oracle MySQL Transparent Data Encryption Road to Success to MySQL Discover New Insights for Your High Availability Strategy Benefits of Using MySQL for SQL and NoSQL 7. Top 2020 cloud blog posts  Introducing the MySQL Database Service Introducing MySQL Database Service and MySQL HeatWave Analytics Engine MySQL Database Service Analytics Engine and Oracle Cloud Infrastructure: Run applications and analytics with better performance, scale, and efficiency Migrate from on-premises MySQL to MySQL Database Service Announcing the MySQL Database Service support for E3 shapes Step by Step Guide to Take your MySQL Instance to the Cloud HeatWave for MySQL – Technical Deep Dive How to deploy a MySQL Database Service Instance with PHPMyAdmin Using MySQL Workbench with MySQL Database Service Manage MySQL Database Service (MDS) DB Systems with OCI CLI Deploy the Spring Boot framework on Oracle Cloud Infrastructure with MySQL Database Service. Deploy cloud native applications that use Oracle MySQL Database Service to the cloud. Deploying WordPress on OCI with MySQL Database Service: the easy way ! Using MySQL Database Service for WordPress Testing MySQL Database Service without VPN Testing MySQL Database Service without VPN – part 2 8. Top 2020 on-premises blog posts  New Release: MySQL 8.0.22 - Top Blog Posts MySQL Shell Dump & Load part 1: Demo! More Robust Network Partition Handling in Group Replication MySQL Shell and storing passwords From MySQL Group Replication to MySQL InnoDB Cluster MySQL: who’s filling my error log? MySQL Performance : Understanding InnoDB IO Internals & "Checkpointing" Three Bad MySQL Query Types You May Be Writing InnoDB Data Locking – Part 1 “Introduction” Upgrading from MySQL 5.7 to MySQL 8.0 Part I Upgrading from MySQL 5.7 to 8.0 on Windows Upgrading from MySQL 5.7 to MySQL 8.0 Part II 8. Top customer video testimonials SCSK achieves faster results (0:58) Square Enix sees performance gains (1:00) Credorax Selects MySQL EE for Increased Security 9. Best new feature from the MySQL Certification and Training team MySQL Explorer. Learn MySQL basics and earn the Explorer badge today! 10. Best Social Media contribution: MySQL Database Service in Forza Horizon 4 Shumber Rivera from Mazatlan in Mexico made a video game version of the MySQL racing car.  Congrats to Shumber for the most original social media contribution to MySQL.  Watch his car race.  11. Coolest videos Ready to take MySQL Database Service for a spin? Introduction to MySQL Database Service Introduction to MySQL Enterprise Edition MySQL 25th Anniversary  12. 2020 Product Releases MySQL 8.0.19 MySQL 8.0.20 MySQL 8.0.21 MySQL 8.0.22 MySQL Database Service HeatWave 13. Top white papers Guide to MySQL Database Service with Analytics Engine Guide to HeatWave: Real-time Analytics for MySQL Database Service 14. 2020 Top Customer Cases Studies University of Toronto (Canadian University) French Billet (French online ticket sales company) Seat24 (Swedish e-commerce travel group) Dhimyotis (French Certificate Authority) Flashnetworks  (Israeli optimization solution provider) Globo.com  (media group in Latin America) Mobitel (Sri Lanka's mobile communications provider) NJ India Invest (Indian financial services) K-Bank (the first Internet bank in Korea) BSE  (Asia's number one stock exchange) Timon (Korean e-commerce company) SQUARE ENIX (Japanese gaming company) KDDI  (Japanese telecom company)

2020 was a very eventful year at MySQL. Now that we just started 2021, this is a great time to look back at everything we accomplished in 2020, from the anniversary celebrations to the year's best...

MySQL

HeatWave for MySQL – Technical Deep Dive

In the previous blog we provided insights on how the MySQL database has been enhanced to integrate with a native high performance analytics engine – HeatWave: https://blogs.oracle.com/mysql/breakthrough-enhancements-in-mysql-database-service-with-analytics-engine HeatWave is a new, massively parallel in-memory query engine developed by Oracle Labs designed for accelerating analytic workloads. HeatWave provides 100x-1000x acceleration over MySQL and MySQL compatible databases like Aurora.  There are four key architecture choices which provide compelling performance with HeatWave: An in-memory hybrid columnar format which is conducive to vector processing. A massively parallel architecture which is enabled by a massively partitioned architecture. State of the art algorithms for distributed analytic algorithms. The engine is optimized for Oracle Cloud Infrastructure. Architecture Overview of HeatWave HeatWave uses a columnar in-memory representation that facilitates vectorized processing leading to very good query performance (Figure 1). The data is encoded and compressed prior to being loaded in memory. This compressed and optimized in memory representation is used for both numeric and string data. This results in significant reduced memory footprint which translates to reduced cost for customer. The data organization in memory and query processing is structured such that it is amenable to vector and SIMD processing which leads to reduced interpretation overhead for queries and improves query performance. Figure 1. Vectorized in-memory columnar representation for analytic processing  One of the key design points of HeatWave is to massively partition data across a cluster of analytics nodes, which can be operated upon in parallel in each node (Figure 2). The partitioning is done at near memory bandwidth and the size of the partitions is optimizes for the underlying cache. This enables high cache hits for analytic operations and provides good inter-node scalability. Each analytics node within a cluster and each core within a node can process partitioned data in parallel, including parallel scans, joins, group-by, aggregation and top-k processing.  Figure 2. Massively parallel architecture Data partitioning in the memory of HeatWave can be driven by a workload based mechanism which minimizes data movement across cores or nodes which improves scalability. Partitioning by workload dependent column reduces data movement for queries with join (or group-by) predicates since it provides co-location of data across tables in the join condition.  HeatWave has implemented state of art algorithms for distributed analytic processing (Figure 3). Joins within a partition are processed fast by using vectorized build and probe join kernels. Network communication between analytics nodes is optimized by using asynchronous batch I/Os. Figure 3. Distributed analytic algorithms optimized for OCI  Furthermore, HeatWave has an intelligent scheduler which efficiently overlaps computation tasks with network communication tasks such that while the data is being transferred between nodes, each node is busy doing some computation (Figure 4). This helps achieve good scalability across a large number of servers.   Figure 4. Intelligent scheduler to overlap compute time with network communication HeatWave uses AMD based VM shapes in OCI which provide the best price per GB of DRAM. Various aspects of query processing have been optimized for Oracle Cloud Infrastructure. For example, the granularity of partitioning has been optimized for the cache size of the underlying compute shape, algorithms are NUMA aware, and the query cost model factors in the network bandwidth available in OCI. Machine Learning Based Automation HeatWave leverages auto machine learning (AutoML) capabilities developed in Oracle Labs to automate various aspects of the service. This automation is helpful both for users of the service and engineers managing the service. Since this automation is based on machine learning, the system can intelligently predict and act upon various scenarios.  Auto Provisioning provides a recommendation on how many nodes are required to run a workload. When the service is started, database tables on which analytics queries are run need to be loaded to memory of HeatWave. The size of the HeatWave cluster needed depends on tables and columns required to load data, and the compression achieved in memory for this data. Figure 5 compares the traditional (i.e., manual) approach to estimating the cluster size with Auto Provisioning. In traditional provisioning, the user needs to guess a cluster size. Underestimation results in data load or query execution failure due to space limitations. Overestimation results in additional costs for unneeded resources. As a result, users iterate until they determine the right cluster size and this size estimate becomes inaccurate when tables are updated.  The right side of figure 5 shows how we solve this problem with Auto Provisioning, which is a ML-based cluster size estimation advisor. By leveraging well trained and accurate ML models, the user consults the Auto Provisioning model to obtain the right cluster size for their dataset. As a result, users do not need to guess the cluster size. Later, if the customer data grows or additional tables are added, the users can again take advantage of Auto Provisioning advisor. Figure 5 – Comparison of a traditional Provisioning Flow vs Auto Provisioning The techniques mentioned in this blog help HeatWave achieve good performance both on a single node as well as scale very well across a large number of nodes. Additionally, since HeatWave is optimized for the underlying OCI platform, it is very cost effective. In the next blog we will share performance

In the previous blog we provided insights on how the MySQL database has been enhanced to integrate with a native high performance analytics engine – HeatWave: https://blogs.oracle.com/mysql/breakthrough...

MySQL recorded sessions from September - November 2020

Since Covid situation we are - same as the rest of the world - switching most of our MySQL sessions & workshops to the online word. Below you can find the list of events with MySQL recorded sessions we run during the time from September to end of November and also some interesting videos as well. So, the list below includes publicly available recorded MySQL sessions (or slides only) from conferences end other events we attended.  September 2020: Open Source Conference Hiroshima, September 19, 2020 MySQL Session: "MySQL Update" Speaker: Yoshiaki Yamasaki, the MySQL Principal Solution Engineer URL: Agenda, Recording Zabbix China, Sepbember 25-26, 2020 MySQL Session (translated): “Insight into MySQL performance and troubleshooting methods” Speaker: Ivan Ma, the MySQL Principal Solution Engineer URL: Agenda, Recording MySQL User Group Session, September 28, 2020 MySQL Session: "Introducing MySQL GIS feature" Speaker: Yoshiaki Yamasaki, the MySQL Principal Solution Engineer URL: OSC Hiroshima Agenda, Recording October 2020: Oracle Developer Live MySQL (Americas), October 13, 2020 On the link above you can find following sessions:  Tomas Ulin, Vice President, MySQL Engineering, Oracle Mark Leith, MySQL Software Development Director, Oracle at Keynote of "MySQL 8.0: A Giant Leap for SQL” Nicolai Plum, Database Engineer, Booking.com on "MySQL 8 at Booking.com” Miguel Araújo, Principal Software Developer, Oracle on "MySQL Shell: The Best MySQL DBA Tool” Sugu Sougoumarane, Chief Technology Officer, Vitess on "Sharding MySQL with Vitess and Kubernetes” Rui Quelhas, Principal Software Developer, Oracle on "Developing NodeJS Applications with MySQL 8.0” Juan Rene Ramirez Monarrez, Software Developer Manager, Oracle on "Migrating to MySQL Database Service: Made Fast and Easy!” Luís Soares, Software Development Director, Oracle on "MySQL Replication Performance, Efficiency, and the Cloud” Harin Vadodaria, Principal MTS, Oracle Mike Frank, Product Management Director, MySQL, Oracle on "MySQL Security Model in Oracle Cloud” Kenny Gryp, MySQL Product Manager, Oracle on "MySQL Database Architectures” Jesper Wisborg Krogh, Principal Database Reliability Engineer, Okta on "MySQL Performance Tuning” Fred Descamps at Panel about "SQL or NoSQL? Schema or Schemaless?” URL: recording of the above sessions, More at Fred’s blog OpenSUSE & LibreOffice 2020, October 15-17, 2020 MySQL Session: "MySQL Clone: a better way to copy MySQL databases" Speaker: Georgi Kodinov, MySQL Software Development Director URL for slide deck only All Things Open 2020, Oct 19-20, 2020 MySQL Session: "MySQL Indexes, Histograms, Locking Options, and Other Ways to Speed Up Your Queries" Speaker: David Stokes, the MySQL Community Manager Recording Percona Live Online, October 21, 2020  Speaker: Fred Descamps, the MySQL Community Manager: MySQL Session: "MySQL 8.0 Document Store – Discovery of a New World”  URL: recoding MySQL Session: "The State of the Dolphin (keynote)" URL: recording More at Fred’s blog MySQL Webinar, October 22, 2020 Webinar title: "Running Drupal with Oracle MySQL Database Service" Webinar Speaker: Fred Descamps, the MySQL Community Manager URL: recording, More at Fred’s blog OSC Tokyo/Fall, October 23-24, 2020 MySQL Session: "MySQL Update" Speaker: Machiko Ikoma URL: recording MOPCON, October 24-25, 2020 ​​​​​​​MySQL Session: " Speaker: Ivan Tu, the MySQL Solution Engineering Manager URL: recording  November 2020: PyCon HK, November 6-7, 2020 MySQL Session: "Python is your friend with MySQL Shell" Speaker: Ivan Ma, the MySQL Principal Solution Engineer URL: recording MySQL Session: "Develop Cloud-Native Application using MySQL Database Service" Speaker: Ryan Kuan, the MySQL Master Principal Solution Engineer URL: recording OpenSource Lisbon, November 11, 2020 MySQL Session: "A step by Step Guide on Taking your MySQL instance to the Cloud" Speaker: Keith Hollman, the Principal Solution Engineer URL: recording MoodleMoot, November 16-18, 2020 Speaker: Keith Hollman, the Principal Solution Engineer MySQL Session: "Why clone your Moodle MySQL?" URL: recording MySQL Session: "Moodle available and scalable with MySQL HA" URL: recording DOAG, November 17-19, 2020 MySQL Session: "MySQL 8.0" Speaker: Carsten Thalheimer, The MySQL Solution Engineer URL for slide deck only Other Recordings you might find interesting:  OpenSource Summit North America & Embedded Linux conference NA, June 29-July 2, 2020 ​​​​​​​MySQL Session: "MySQL New Features" Speaker: David Stokes, the MySQL Community Manager URL: Recording ​​​​​​​cPanel Live with David Stokes, the Community Manager of MySQL, presenting MySQL 8.0 Changes for DBAs and DevOps, with a live Q&A session, August 12, 2020 ​​​​​​​Recording ​​​​​​​DebConf2020, Augst 23-29, 2020 ​​​​​​​MySQL Session: "MySQL Replication Update" Speaker: David Stokes, the MySQL Community Manager Recording ​​​​​​​Dave's MySQL Basis: ​​​​​​​David Stokes, the MySQL Community Manager talking about MySQL Basis. The playlist includes 13 Episodes right now! ​​​​​​​Recording ​​​​​​​​​​​​​​Jim Grisanzio talks with MySQL community managers Dave Stokes and Frederic Descamps about the latest news on the project, contributing, and upcoming online events. ​​​​​​​Recording​​​​​​​ "JSON Document Validation" by David Stokes, the MySQL Community Manager Recording "Python & MySQL", August 11, 2020 Recording Deploy Friday webcast, November 6, 2020 Live streaming video with Airton Lastori, the MySQL Principal Product Manager & David Stokes, the MySQL Community Manager talking about MySQL as a leading open-source database management system. Recording​​​​​​​

Since Covid situation we are - same as the rest of the world - switching most of our MySQL sessions & workshops to the online word. Below you can find the list of events with MySQL recorded sessions...

Introducing MySQL Database Service and MySQL Analytics Engine

This blog includes: Keynote video highlights, link to full keynote, product demo, testimonial, upcoming MySQL Database Service and Analytics Engine webinars, and more. Today the MySQL team introduces the MySQL Database Service with the MySQL Analytics Engine. 1. Watch the keynote highlights:   2. See the MySQL Database Service in action in a short product demo.    3. Learn about the great savings over competitive solutions such as Amazon Aurora, RDS, or Redshift.    4. Discover how the MySQL Analytics Engine accelerates MySQL queries by 400x. 5. Check out the benchmarks: MySQL Database Service with Analytics Engine is 1100x faster than Amazon Aurora, 2.7x faster than Redshift, and scale to 1000s of cores. 6. Read some of the customer testimonials and how they increased their query performance compared to other cloud solutions: "MySQL Analytics Engine is 10 times faster than the analytics service of another major cloud vendor. Now there is no need for ETL. Compared to MySQL on-premise, the MySQL Analytics Engine is 4,000 times faster.”  - Tetsuro Ikeda, Manager of Cloud IT Architecture Service Department,  SCSK Corporation   7. Watch the full keynote 8. Reference blogs: Breakthrough Enhancements in MySQL Database Service with Analytics Engine MySQL Database Service Analytics Engine and Oracle Cloud Infrastructure: Run applications and analytics with better performance, scale, and efficiency 9. Upcoming live webinars: 12/08/20 - 9AM PT - Business Benefits of using MySQL Database Service with the MySQL Analytics Engine 12/09/20 - 9AM PT - Getting Started with Oracle MySQL Database Service and MySQL Analytics Engine 12/14/20 - 9AM PT - Migrating from Amazon RDS to Oracle MySQL Database Service 12/16/20 -9AM PT - Using MySQL Database Service with Oracle Analytics Cloud 10. Other references: Official Press Release Whitepaper Oracle MySQL: https://www.oracle.com/mysql/ Try it now  

This blog includes: Keynote video highlights, link to full keynote, product demo, testimonial, upcoming MySQL Database Service and Analytics Engine webinars, and more. Today the MySQL team introduces...

Breakthrough Enhancements in MySQL Database Service with Analytics Engine

  Introduction MySQL is the most popular open-source database and many organizations choose MySQL to store their valuable enterprise data. MySQL is optimized for OLTP, but it is not designed for analytic processing. As a result, organizations which need to efficiently run analytics on data stored in MySQL database move their data to another database to run analytic applications. This approach of moving data to another database introduces complexity and additional cost for customers in multiple ways: Applications need to define complex logic for extracting relevant data from MySQL. The extracted data needs to be transported to another database across networks in a secure way, which takes times and creates security vulnerability. Data in the other database needs to be manually kept in sync with the MySQL database and as a result the data on which analytics is performed can become stale. Managing multiple databases and running OLTP and analytics applications on different databases incurs additional overhead and cost. MySQL Analytics Service is designed to enable customers to run analytics on data which is stored in MySQL database without the need for ETL (Figure 1) Figure 1. Both OLTP and OLAP applications can be run with MySQL Database Service with Analytics Engine This service is built on an innovative in-memory analytics engine which is architected for scalability and performance and is optimized for Oracle Cloud Infrastructure (OCI). Various aspects of this service leverage machine learning driven automation, reducing database administrative costs. This results in a very performant solution for SQL analytics at a fraction of the cost compared to other industry solutions. Customers who use MySQL Analytics Service will benefit from significantly better performance, a single database for their OLTP and analytic needs, not requiring ETL, support for real-time analytics and significantly reduced cost. Deployment Scenarios With the native MySQL Analytics Engine, customers who store data in MySQL database service can seamlessly run analytics. A MySQL Analytics instance is a cluster composed of a MySQL database service VM and one or more analytics nodes, as shown in red in Figure 2. When analytics is enabled, an analytics plugin is installed on the MySQL database node which is responsible for cluster management, loading data into the memory of the analytics nodes, query scheduling, query execution, and returning query results to the MySQL database. Applications continue to interact with the MySQL database without requiring to be aware of the MySQL Analytics Engine.  An Analytics node is a VM instance that stores data in memory for analytics processing and executes analytics queries. The number of nodes needed for a workload depends on the amount of data which needs to be processed, the compression factor which is achieved on the dataset, and the query characteristics. On an average, users can expect to load around 400GB of data per analytics node.  The exact number of nodes needed for a schema can be predicted by the auto provisioning advisor which is a part of the service. Figure 2. MySQL Analytics exclusively available in Oracle Cloud MySQL Analytics currently supports up to 24 analytics nodes in one cluster which translates to processing capacity of approximately 10 TB of analytics data. 10TB is the amount of data which can be populated in the memory of the analytics nodes at a given moment. There is no limit to the amount of data which can be stored in the MySQL database and customers can choose which tables or columns from MySQL database schema to load into the memory of analytics nodes. If the tables are no longer needed by queries, user can remove the tables from the memory to make room for other data. MySQL Database Service with Analytics Engine is a great solution for customers who need to run hybrid transactional and analytical workloads. Transactional queries are processed in the MySQL database node and data updated in MySQL InnoDB is transparently propagated to the analytics cluster in real-time. This enables customers to run both OLTP and real-time analytics simultaneously within a single database. On premise customers who cannot move their MySQL deployment to a Cloud because of compliance or regulatory requirements, can still leverage MySQL Analytics by using the hybrid deployment model as shown in Figure 3. In a hybrid deployment, customers can leverage MySQL replication to replicate on-premise MySQL data to MySQL Analytics without the need for ETL. Figure 3. Hybrid deployment for enabling analytics on data stored on premise Native Real-Time Analytics for MySQL Integration of MySQL Analytics Engine with MySQL Database Service provides a single data management platform for all OLTP and analytics needs of an enterprise. MySQL Analytics is designed as a native engine, and completely shields all the low-level implementation details at the storage level from the end users. As a result, users can manage both MySQL Analytics Engine and MySQL Database Service with the same management tools including OCI console, REST API, and command line interface. Since MySQL Analytics is an in-memory processing engine, data is only persisted in MySQL InnoDB storage engine. This allows users to manage analytics data the same way they manage transactional data in MySQL. Users connect to MySQL database node through standard tools and standard-based ODBC/JDBC connectors. Queries which can be accelerated by the analytics engine are transparently pushed by the MySQL database node to the analytics engine. This enables existing applications to take advantage of the MySQL Analytics Engine without any changes to their application, allowing easy and quick integration. Once users submit a query, the MySQL query optimizer transparently decides if the query should be offloaded to the analytics engine for accelerated execution (Figure 4). This decision is based on whether all operators and functions referenced in the query are supported by the MySQL Analytics Engine and if the estimated time to process the query with the analytics engine is less than with MySQL. If both conditions are met, the query is pushed to analytics nodes for processing. Once processed, the results are sent back to the MySQL database node and returned to the application. Figure 4. MySQL Database enhanced to natively integrate analytic processing Since the MySQL optimizer has been enhanced to transparently push the queries to the analytics engine, there is no change required in queries for them to be accelerated by the MySQL analytics engine. As a result, all existing MySQL compatible tools and applications work seamlessly with the MySQL Analytics Engine (Fig 5). Figure 5. All MySQL compatible tools and application run with the MySQL Analytics Engine Data for the MySQL Analytics Engine is persisted in MySQL InnoDB. Any updates to the tables are automatically propagated to the memory of the analytics nodes, as a result subsequent queries always see the updated data. This is done behind the scene by a light-weight change propagation algorithm that can keep up with MySQL data update rates. Changes made by an OLTP application are visible in real-time to analytic queries. Please stayed tuned for the next blog where we will provide insights into the innovations of the MySQL Analytics Engine.

  Introduction MySQL is the most popular open-source database and many organizations choose MySQL to store their valuable enterprise data. MySQL is optimized for OLTP, but it is not designed for...

MySQL Database Service

Announcing the MySQL Database Service support for E3 shapes

The MySQL team is excited to announce that MySQL Database Service now supports the Oracle Cloud Infrastructure Compute E3 shapes. These shapes are built on the 2nd Gen AMD EPYC 7742 processor, with a base clock frequency of 2.25 GHz and max boost of up to 3.4 GHz, and have better networking and more RAM. MySQL Database Service customers can start to use them today and enjoy higher performance and flexibility for diverse MySQL workloads. The MySQL Database Service E3 offers up to 64 OCPUs (128 virtual cores) and 1 TB of RAM. This is the highest core count and memory for a single fully managed MySQL instance on any public cloud. The new E3 shapes for MySQL Database Service are available in eight commercial regions: Brazil East (Sao Paulo), Canada Southeast (Toronto), Germany Central (Frankfurt), India West (Mumbai), Japan East (Tokyo), UK South (London), US East (Ashburn), and US West (Phoenix). More regions are coming soon. If you already have an Oracle Cloud Infrastructure account, you can easily start to use the new E3 shapes in the MySQL Database Service. Just access the web console and under the MySQL menu, select DB System and Create. You will be able to choose between the following options: Shape name OCPUs RAM (GB) MySQL.VM.Standard.E3.1.8GB 1 8 MySQL.VM.Standard.E3.1.16GB 1 16 MySQL.VM.Standard.E3.2.32GB 2 32 MySQL.VM.Standard.E3.4.64GB 4 64 MySQL.VM.Standard.E3.8.128GB 8 128 MySQL.VM.Standard.E3.16.256GB 16 256 MySQL.VM.Standard.E3.24.384GB 24 384 MySQL.VM.Standard.E3.32.512GB 32 512 MySQL.VM.Standard.E3.48.768GB 48 768 MySQL.VM.Standard.E3.64.1024GB 64 1024   Start your 30-day free trial at oracle.com/cloud/free. Get access to a wide range of Oracle Cloud services for 30 days, including MySQL Database Service. Check the documentation for the quick steps to create your MySQL databases. Drop by and check it out!

The MySQL team is excited to announce that MySQL Database Service now supports the Oracle Cloud Infrastructure Compute E3 shapes. These shapes are built on the 2nd Gen AMD EPYC 7742 processor, with a...

Announcements

Where's the MySQL Team from November to December 2020

We would like to return to the regular announcements about where you can find MySQL Community team or MySQL experts at during Nov-Dec 2020. All the shows we are attending by end of this year are mostly VIRTUAL ones. Please find more details below: November, 2020: GSCC2020/Virtual, November 14, 2020, @5:00-6:00pm David Stokes, the MySQL Community Manager will be talking about "MySQL 8.0 Features for Developers" MoodleMoot Global/Virtual, Nov 16-18, 2020 Please visit our online booth where you can talk online to our booth staff. Please also watch the Mainstreaming place where MySQL talk will be hold. Second talk will be in our own meeting room.  DeveloperWeek Austin 2020/Virtual, November 17-18, 2020 David Stokes, the MySQL Community Manager will be talking about "MySQL 8.0 Features for Developers", Dave's talk is scheduled for Nov 17 @ 1:30-1:55pm DOAG 2020/Hybrid event, November 17-19, 2020 Join our team at the online booth as well as watch the organizers schedule for two MySQL speaking slots given by Carsten Thalheimer, the MySQL Master Principal Sales Consultant. Also do not miss the MySQL Keynote!!!  JCConf/Hybrid event, Taipei, Taiwan, November 19, 2020 This event is partially virtual and partially physical event. You can find us at our physical booth in the venue as well as find a quick MySQL 3 mins talk before the session in the agenda. Do not miss to come to talk to our team at the physical booth at JCConf 2020. OSC Fukuoka/Virtual, November 28, 2020 Do not miss the MySQL talk on "Introducing the new MySQL backup tool and the MySQL Database Service", given by Yoshiaki Yamasaki, the MySQL Principal Solution Engineer. December, 2020: Open Developers Conference 2020/Virtual, Dec 19, 2020 Do not miss the MySQL session given by local MySQL team, please watch organizers' website for further update.

We would like to return to the regular announcements about where you can find MySQL Community team or MySQL experts at during Nov-Dec 2020. All the shows we are attending by end of this year are...

New Release: MySQL 8.0.22 - Top Blog Posts

MySQL 8.0.22 introduces many new improvements and updates, many of which deserve their own blog post for a deep dive into the new features.  Among the notable changes are: Prepared Statements, SHOW PROCESSLIST, TIMESTAMP, Read Only Schema, Error Log, User Management, Optimizer, Replication, Keyring, Router, and more.   Here are the MySQL 8.0.22 top blog posts: Server The MySQL 8.0.22 Maintenance Release is Generally Available Announcing MySQL Server 8.0.22, 5.7.32 and 5.6.50 Shell MySQL Shell 8.0.22 for MySQL Server 8.0 and 5.7 has been released What’s New in MySQL Shell 8.0.22 Replication Posted: MySQL 8.0.22 Replication Enhancements Connectors MySQL Connector/J 8.0.22 has been released MySQL Connector/NET 8.0.22 has been released MySQL Connector/Python 8.0.22 has been released MySQL Connector/C++ 8.0.22 has been released MySQL Connector/Node.js 8.0.22 has been released MySQL Connector/ODBC 8.0.22 has been released Workbench MySQL Workbench 8.0.22 has been released Integration MySQL announces integration with Oracle Cloud Infrastructure Vault Community MySQL 8.0.22: thank you for the contributions MySQL Router 8.0.22 enables REST API at bootstrap   Download MySQL 8.0.22 now: https://www.mysql.com/downloads/    

MySQL 8.0.22 introduces many new improvements and updates, many of which deserve their own blog post for a deep dive into the new features.  Among the notable changes are: Prepared Statements,...

Announcements

MySQL announces integration with Oracle Cloud Infrastructure Vault

Securing a database includes securing sensitive items such as keys, passphrases, and more. Its important to protect from misuse by using cryptography and access controls to limit usage by only the components that use them or admins that require them.  MySQL Enterprise Keyring security component provides integrated Key Management with secure vaults.  Starting with MySQL Enterprise Edition 8.0.22, you can manage your MySQL encryption keys for TDE and more using the Oracle Cloud Infrastructure Vault. OCI Vault lets you securely store, manage, and audit arbitrary keys and other types of configuration secrets using the Oracle Cloud Infrastructure's Vault service.  Oracle Infrastructure Vault - Console - Shown Storing MySQL Secrets This integration with the OCI Vault leverages the MySQL keyring with the addition of the "keyring_oci" plugin. This keyring plugin communicates with Oracle Cloud Infrastructure Vault for back end storage. No key information resides in MySQL server local file system storage.  Benefits of using OCI Vault for your MySQL Key Management: Fully Managed Service - but you control access to your keys and secrets Centralized - common repository to manage keys and secrets and define policies. Auditing - Know exactly details of secrets usage: where, by whom, and when.  Compliance - Vault drives controls required for regulatory compliance.  HA - Keys replicated within a region to ensure the durability and availability of the keys.  Secure - FIPS compliant.  No Cost if you have an Oracle Cloud Tenancy. For technical details  MySQL Keyring for OCI Vault MySQL Enterprise Security Overview MySQL 8.0 Secure Deployment Guide  

Securing a database includes securing sensitive items such as keys, passphrases, and more. Its important to protect from misuse by using cryptography and access controls to limit usage by only the...

A Step by Step Guide to Take your MySQL Instance to the Cloud

You have a MySQL instance? Great. You want to take it to a cloud? Nothing new. You want to do it fast, minimizing downtime / service outage? “I wish” I hear you say. Pull up a chair. Let’s have a chinwag. Given the objective above, i.e. “I have a database server on premise and I want the data in the cloud to ‘serve’ my application”, we can go into details: - Export the data - Hopefully make that export find a cloud storage place ‘close’ to the destination (in my case, @OCI of course) - Create my MySQL cloud instance. - import the data into the cloud instance. - Redirect the application to the cloud instance. All this takes time. With a little preparation we can reduce the outage time down to be ‘just’ the sum of the export + import time. This means that once the export starts, we will have to set the application in “maintenance” mode, i.e. not allow more writes until we have our cloud environment available.  Depending on each cloud solution, the ‘export’ part could mean “export the data locally and then upload the data to cloud storage” which might add to the duration. Then, once the data is there, the import might allow us to read from the cloud storage, or require adjustments before the import can be fully completed. Do you want to know more? https://mysqlserverteam.com/mysql-shell-8-0-21-speeding-up-the-dump-process/  Let’s get prepared then: Main objective: keep application outage time down to minimum. Preparation: You have an OCI account, and the OCI CLI configuration is in place. MySQL Shell 8.0.21 is installed on the on-premise environment. We create an Object Storage bucket for the data upload. Create our MySQL Database System. We create our “Endpoint” Compute instance, and install MySQL Shell 8.0.21 & MySQL Router 8.0.21 here. Test connectivity from PC to Object storage, from PC to Endpoint, and, in effect, from PC to MDS. So, now for our OCI environment setup. What do I need? Really, we just need some files to configure with the right info. Nothing has to be installed nor similar. But if we do have the OCI CLI installed on our PC or similar, then we’ll already have the configuration, so it’s even easier. (if you don’t have it installed, it does help avoid the web page console once we have learned a few commands so we can easily get things like the Public IP of our recently started Compute or we can easily start / stop these cloud environments.) What we need is the config file from .oci, which contains the following info: You’ll need the API Key stuff as mentioned in the documentation “Required Keys and OCIDs”. Remember, this is a one-off, and it really helps your OCI interaction in the future. Just do it. The “config” file and the PEM key will allow us to send the data straight to the OCI Object Storage bucket. MySQL Shell 8.0.21 install on-premise. Make a bucket. I did this via the OCI console. This creates a Standard Private bucket. Click on the bucket name that now appears in the list, to see the details. You will need to note down the Name and Namespace. Create our MySQL Database System. This is where the data will be uploaded to. This is also quite simple. And hey presto. We have it. Click on the name of the MDS system, and you’ll find that there’s an IP Address according to your VCN config. This isn’t a public IP address for security reasons. On the left hand side, on the menu you’ll see “Endpoints”. Here we have the info that we will need for the next step. For example, IP Address is 10.0.0.4. Create our Endpoint Compute instance. In order to access our MDS from outside the VCN, we’ll be using a simple Compute instance as a jump server. Here we’ll install MySQL Router to be our proxy for external access. And we’ll also install MySQL Shell to upload the data from our Object Storage bucket. For example, https://gist.github.com/alastori/005ebce5d05897419026e58b9ab0701b. First, go to the Security List of your OCI compartment, and add an ingress rule for the port you want to use in Router and allow access from the IP address you have for your application server or from the on-premise public IP address assigned. Router & Shell install ‘n’ configure Test connectivity. Test MySQL Router as our proxy, via MySQL Shell: $ mysqlsh root@kh01:3306 --sql -e 'show databases' Now, we can test connectivity from our pc / application server / on-premise environment. Knowing the public IP address, let’s try: $ mysqlsh root@<public-ip>:3306 --sql -e 'show databases' If you get any issues here, check your ingress rules at your VCN level. Also, double check your o.s. firewall rules on the freshly created compute instance too. Preparation is done. We can connect to our MDS instance from the Compute instance where MySQL Router is installed, kh01, and also from our own (on-premise) environment. Let’s get the data streaming. MySQL Shell Dump Utility In effect, it’s here when we’ll be ‘streaming’ data. This means that from our on-premise host we’ll export the data into the osBucket in OCI, and at the same time, read from that bucket from our Compute host kh01 that will import the data into MDS. First of all, I want to check the commands with “dryRun: true”. util.dumpSchemas dryRun From our own environment / on-premise installation, we now want to dump / export the data: $ mysqlsh root@OnPremiseHost:3306 You’ll want to see what options are available and how to use the util.dumpSchemas utility: mysqlsh> \help util.dumpSchemas NAME       dumpSchemas - Dumps the specified schemas to the files in the output                     directory. SYNTAX       util.dumpSchemas(schemas, outputUrl[, options]) WHERE       schemas: List of schemas to be dumped.       outputUrl: Target directory to store the dump files.       options: Dictionary with the dump options. Here’s the command we’ll be using, but we want to activate the ‘dryRun’ mode, to make sure it’s all ok. So: util.dumpSchemas( ["test"], "test", {dryRun: true, showProgress: true, threads: 8, ocimds: true, "osBucketName": "test-bucket", "osNamespace": "idazzjlcjqzj", ociConfigFile: "/home/os_user/.oci/config", "compatibility": ["strip_definers"] } ) ["test"]               I just want to dump the test schema. I could put a list of                                schemas here.      Careful if you think you can export internal                                      schemas, ‘cos you can’t. “test”                             is the “outputURL target directort”. Watch the prefix of all the                        files being created in the bucket.. options: dryRun:             Quite obvious. Change it to false to run. showProgress:                 I want to see the progress of the loading. threads:              Default is 4 but choose what you like here, according to the                                        resources available. ocimds:              VERY IMPORTANT! This is to make sure that the                                      environment is “MDS Ready” so when the data gets to the                             cloud, nothing breaks. osBucketName:   The name of the bucket we created. osNamespace:                 The namespace of the bucket. ociConfigFile:    This is what we looked at, right at the beginning. This what makes it easy.  compatibility:                There are a list of options here that help reduce all customizations and/or simplify our data export ready for MDS. Here I am looking at exporting / dumping just schemas. I could have dumped the whole instance via util.DumpInstance. Have a try! I tested a local DumpSchemas export without OCIMDS readiness, and I think it might be worth sharing that, this is how I found out that I needed a Primary Key to be able to configure chunk usage, and hence, a faster dump: util.dumpSchemas(["test"], "/var/lib/mysql-files/test/test", {dryRun: true, showProgress: true}) Acquiring global read lock All transactions have been started Locking instance for backup Global read lock has been released Writing global DDL files Preparing data dump for table `test`.`reviews` Writing DDL for schema `test` Writing DDL for table `test`.`reviews` Data dump for table `test`.`reviews` will be chunked using column `review_id` (I created the primary key on the review_id column and got rid of the following warning at the end:) WARNING: Could not select a column to be used as an index for table `test`.`reviews`. Chunking has been disabled for this table, data will be dumped to a single file. Anyway, I used dumpSchemas (instead of dumpInstance) with OCIMDS and then loaded with the following: util.LoadDump dryRun Now, we’re on the compute we created, with Shell 8.0.21 installed and ready to upload / import the data: $ mysqlsh root@kh01:3306 util.loadDump("test", {dryRun: true, showProgress: true, threads: 8, osBucketName: "test-bucket", osNamespace: "idazzjlcjqzj", ociConfigFile: "/home/osuser/.oci/config"}) As imagined, I’ve copied my PEM key and oci CLI config file to the compute, via scp to a “$HOME/.oci directory. Loading DDL and Data from OCI ObjectStorage bucket=test-bucket, prefix='test' using 8 threads. Util.loadDump: Failed opening object '@.json' in READ mode: Not Found (404) (RuntimeError) This is due to the bucket being empty. You’ll see why it complains of the “@.json” in a second. You want to do some “streaming”? With our 2 session windows opened, 1 from the on-premise instance and the other from the OCI compute host, connected with mysqlsh: On-premise: dry run: util.dumpSchemas(["test"], "test", {dryRun: true, showProgress: true, threads: 8, ocimds: true, "osBucketName": "test-bucket", "osNamespace": "idazzjlcjqzj", ociConfigFile: "/home/os_user/.oci/config", "compatibility": ["strip_definers"]}) real: util.dumpSchemas(["test"], "test", {dryRun: false, showProgress: true, threads: 8, ocimds: true, "osBucketName": "test-bucket", "osNamespace": "idazzjlcjqzj", ociConfigFile: "/home/os_user/.oci/config", "compatibility": ["strip_definers"]}) OCI Compute host: dry run: util.loadDump("test", {dryRun: true, showProgress: true, threads: 8, osBucketName: "test-bucket", osNamespace: "idazzjlcjqzj", waitDumpTimeout: 180}) real: util.loadDump("test", {dryRun: false, showProgress: true, threads: 8, osBucketName: "test-bucket", osNamespace: "idazzjlcjqzj", waitDumpTimeout: 180}) They do say a picture is worth a thousand words, here are some images of each window that was executed at the same time: On-premise: At the OCI compute host you can see the waitDumpTimeout take effect with: NOTE: Dump is still ongoing, data will be loaded as it becomes available. In the osBucket, we can now see content (which is what the loadDump is reading): And once it’s all dumped ‘n’ uploaded we have the following output: If you like logs, then check the .mysqlsh/mysqlsh.log that records all the output under the directory where you have executed MySQL Shell (on-premise & OCI compute) Now the data is all in our MySQL Database System, all we need to do is point the web server or the application server to the OCI compute systems IP and port so that MySQL Router can enroute the connection to happiness!!!! Conclusion

You have a MySQL instance? Great. You want to take it to a cloud? Nothing new. You want to do it fast, minimizing downtime / service outage? “I wish” I hear you say. Pull up a chair. Let’s have...

MySQL Database Service

MySQL Database Service - Webinar Series

We have scheduled a series of several live webinars about MySQL Database Service, the only service 100% developed, managed and supported by the MySQL Team.   Our webinars will cover a full introduction to the new service.  We will discuss the business benefits of using the MySQL Database Service compared to on-premises and vs services of “forked” cloud versions of MySQL.  We will show you how to migrate your existing database from on-premises directly into the new service.  We will demonstrate how to migrate data from RDS to the MySQL Database Service.  And if you happen to use WordPress, we will also show you how to run WordPress with the MySQL Database Service.  __________________________________________________________________________ Date: 9/9/2020 @9AM PST Title: Introduction to MySQL Database Service Description: The MySQL Database Service is the only database service that is 100% developed, managed, and supported by the MySQL team. Discover how the new database service makes it easy for organizations to deploy cloud native applications using the world’s most popular open source database. See how it delivers significant savings over on-premises database management and over “forked” versions from third party Cloud platforms. Register now __________________________________________________________________________ Date: 9/10/2020 @9AM PST Title: Top Reasons to Use the MySQL Database Service Description: Discover the top reasons businesses should use the MySQL Database Service. Learn the many benefits of a fully managed database service over on-premises database management. See the key competitive advantage of having your MySQL Database Service managed and supported by the MySQL Team. Check the savings over on-premises and over competitive cloud offerings. Register now __________________________________________________________________________ Date: 9/14/2020 @9AM PST Title: Migrating from on-premises to MySQL Database Service Description: See how easy it is to migrate from on premises to the MySQL Database Service. It is the only fully managed public cloud service to provide MySQL Enterprise Edition for the highest levels of MySQL security, reliability and uptime, and is built and managed by the same development team that develops MySQL. As a result, MySQL Database Service is 100% compatible with on-premises MySQL, allowing for a seamless transition to the public cloud or a hybrid cloud model.  Register now  __________________________________________________________________________ Date: 9/15/2020 @9AM PST Title: Migrating from Amazon RDS to Oracle MySQL Database Service Description: Migrate from Amazon RDS data to the MySQL Database Service on the highly secure OCI Gen2 cloud platform. Learn the quick steps and best practices for your database migration. Discover the key benefits of getting the MySQL team latest fixes, new features and support. See how MDS delivers up to 70% TCO savings over Amazon RDS. Register now __________________________________________________________________________ Date: 9/16/2020 @9AM PST Title: Running Wordpress with MySQL Database Service Description: Discover how to install Wordpress on the Oracle Cloud using MySQL Database Service. The webinar will cover the entire installation steps and will demo how to migrate a running Wordpress application to MDS with minimal maintenance time. You will learn how to use MDS, MySQL Shell Dump & Load and MDS Inbound Replication.   Register now  __________________________________________________________________________ Date: 10/21/2020 @9AM PST Title: Introduction to MySQL Database Service Description: The MySQL Database Service is the only database service that is 100% developed, managed, and supported by the MySQL team. Discover how the new database service makes it easy for organizations to deploy cloud native applications using the world's most popular open source database. See how it delivers significant savings over on-premises database management and over "forked" versions from third party Cloud platforms.   Register now  __________________________________________________________________________ Date: 10/22/2020 @9AM PST Title: Running Drupal with Oracle MySQL Database Service Description: Discover how to install Drupal in the Oracle Cloud using MySQL Database Service. The webinar will cover the entire installation steps and will demo how to migrate a running Drupal application to MDS with minimal maintenance time. You will learn how to use MDS, MySQL Shell Dump & Load and MDS Inbound Replication.   Register now  __________________________________________________________________________ See the full list of MySQL webinars, including MySQL Database Service webinars at: https://www.mysql.com/news-and-events/web-seminars/  

We have scheduled a series of several live webinars about MySQL Database Service, the only service 100% developed, managed and supported by the MySQL Team.   Our webinars will cover a full introduction...

MySQL Database Service

Introducing the MySQL Database Service

The MySQL team is thrilled to introduce the MySQL Database Service in the Oracle Cloud Infrastructure (OCI), the only service 100% developed, managed, and supported by the MySQL Team. For those not familiar with MySQL Database Service, it is the same MySQL you know and use, now available in the cloud as a fully-managed service running on Oracle Generation 2 Cloud Infrastructure. It automates time-consuming tasks such as MySQL instances provisioning, patches and upgrades, and backups and restores. Users can easily scale MySQL, monitor cloud resources, and implement security best practices to meet regulatory requirements. Customer applications simply access the MySQL databases via standard MySQL protocols. The typical administrative tasks are automated, integrated, and accessible via the OCI web console, REST API, CLI, or DevOps tools. The MySQL Database Service is available in multiple OCI Regions and quickly expanding to meet your data governance and location requirements. More data center regions are on the way, stay tuned. Built by the MySQL Engineering Team One of the biggest advantages of the MySQL Database Service is that it is developed, managed, and supported by the MySQL Engineering Team. Let’s take a look at why this is so important. MySQL Database Service is developed and maintained by the same team that develops MySQL Community and Enterprise Editions. The service is always up-to-date with the latest MySQL Server release and includes the latest security fixes. You get all the features available in the MySQL Server, including the NoSQL Document Store with the new X-Protocol and X DevAPI. MySQL Database Service has built-in default configurations recommended by the MySQL experts for the best performance while keeping the database secure and stable. The configuration management feature also allows advanced users to customize configurations safely. Because the same MySQL Server is used in the cloud, on-premises, and for hybrid deployments, you get maximum flexibility for your deployment strategy. Customers can use MySQL native replication and MySQL Shell to quickly and easily move workloads to the cloud. Unlike other Cloud Database services that offer limited MySQL support, the MySQL Database Service is backed by the MySQL Support Team at no additional cost. MySQL Database Service is built on top of Oracle Cloud Infrastructure as an ultra-secure native service, leveraging the benefits of a Cloud that is architected and designed to run mission-critical Enterprise workloads and databases. Pricing: Amazon RDS Costs 3.6x More MySQL Database Service is the most affordable database service among the major cloud providers – Amazon RDS, Microsoft Azure, and Google Cloud SQL. Amazon RDS is 3.6x more expensive than MySQL Database Service. Comparisons with other public cloud services are available below, along with the configuration that was used for comparison. MySQL Database Service: Standard E2 AMD 8GB/Core, all regions have the same price. Amazon RDS: Intel M5 8GB/Core, AWS US East. Azure: General Purpose Intel 10GB/Core, MS Azure US-East. Google: N1 Standard Intel 7.5GB/Core, GCP Northern Virginia. Configuration: 100 OCPUs, 1 TB Storage. It is also important to note that MySQL Database Service has the same price for all OCI regions while other services may have a significantly higher price for different regions. Additionally, users can even realize significant storage and backup savings compared to other cloud providers. You can use the Cost Estimator tool for your specific scenario. MySQL Database Service is available under the Data Management option. The consumption models are simple: pay-as-you-go billed monthly or committed annual flex consumption with an extra discount. Getting Started Try MySQL Database Service Now. Oracle offers a 30-Day free trial with $300 in free credits with access to a wide range of services including MySQL Database Service, Compute and Storage. Create an account and start for free. Check the documentation for the quick steps to create your MySQL databases. Additional Resources oracle.com/mysql Cost Estimator OCI Free Trial Documentation

The MySQL team is thrilled to introduce the MySQL Database Service in the Oracle Cloud Infrastructure (OCI), the only service 100% developed, managed, and supported by the MySQL Team. For those not...

Announcements

Top Blog Posts about MySQL 8.0.21

As with any new releases, MySQL 8.0.21 introduces many new improvements and updates, many of which deserve their own blog post for a deep dive into the new features.  Among the notable changes are: Account Management Notes, JSON Notes, Authentication Notes and changes related to InnoDB, Optimizer, Group Replication, and more. Here are the MySQL 8.0.21 top blog posts: Server: - The MySQL 8.0.21 Maintenance Release is Generally Available - MySQL 8.0 – Who stopped mysqld and how long did it take? - MySQL: who’s filling my error log? Shell: - MySQL Shell Dump & Load part 1: Demo!  - MySQL Shell Dump & Load part 2: Benchmarks  Optimizer: - PHP With MySQL: JSON_VALUE() now in MySQL 8.0.21  InnoDB: - MySQL – Keep an eye on your auto_increment values  Replication: - MySQL 8.0.21 Replication Enhancements  - More Robust Network Partition Handling in Group Replication  - START GROUP_REPLICATION can now take recovery credentials as parameters  - Group Replication SYSTEM messages in the error log - Specify Recovery IP Addresses in Group Replication  - MySQL Group Replication – Default response to network partitions has changed - You Can Now Use Binary Log Checksums with Group Replication Security: - Help with MySQL and Data for PHP Developers  Certifications: - MySQL 8.0 Certifications   community blogs: - MySQL 8.0.21: thank you for the contributions - Changes that I like in the new MySQL 8.0.21  Download MySQL 8.0.21 now: https://www.mysql.com/downloads/ 

As with any new releases, MySQL 8.0.21 introduces many new improvements and updates, many of which deserve their own blog post for a deep dive into the new features.  Among the notable changes are:...

MySQL

MySQL Day Virtual Event: 5 Sessions in 1 Day

MySQL Day Virtual Event Join us on July 29th, 2020 (8AM - 1PM PST) for a virtual event about why and how to upgrade to MySQL 8.0.  Learn the key reasons you should upgrade to 8.0. Discover the best practices developed by our support team based on their experience working directly with customers.  Get tips and techniques from our community evangelists.  Find out why the University of California at Irvine chose to upgrade to 8.0, learn about their process, their experience, and the improvements to their application performance. Register to the event and attend the sessions of your choice.  Sessions are running on the hour so you can easily plan your agenda around your session interest.  Each session will last approximately 30-40 minutes with a 15 minute Q&A, followed by 5-15 minute break in between sessions. AGENDA: About the sessions: Best Practices Tips | Upgrading to MySQL 8.0 Upgrading to MySQL 8.0 is easy and straight forward. This webinar will go over the upgrade process, the requirements, and how to use the new MySQL shell to determine potential problems before the upgrade. You will learn the dos and don’ts. After the webinar, you will know all you need to know to upgrade smoothly and effectively to MySQL 8.0. MySQL 8.0 Through the Eyes of the MySQL Support Team  Working directly with customers, the support team answers many questions related to upgrading to MySQL 8.0. This session will cover some of the best practices developed by the support team as well as Dos and Don’ts to be considered before upgrading. Customer Insights from UC Irvine In this session, you will get a quick introduction to UCI, why they chose MySQL, the system environment, number of servers, and some details about the architecture. The session will cover the reasons UCI chose to upgrade to 8.0, the upgrade process, and the upgrade experience.  MySQL 8.0 Indexes, Histograms, and Other Ways to Speed Up Your Queries Indexes have been used for years to speed up database queries but are badly understood and often over utilized. The system overhead of maintaining indexes can become burdensome. Plus MySQL has several types of indexes like multi-valued and functional that can add great value if used properly. Histograms were introduced in MySQL 8.0 and are great for data with little churn but they need to be properly established.This webinar will cover indexes, histograms, and some other 'secret' techniques to make your MySQL instances really perform. Transforming Your Application with MySQL 8.0 This session will focus on the business benefits of upgrading to MySQL 8.0.  There are many new features that makes MySQL 8.0 a must upgrade to version from ease of use, increase productivity, new SQL features, security and performance improvements and the ability to use the same database for both SQL and NoSQL. https://www.mysql.com/news-and-events/web-seminars/upgrading-to-mysql-8-0-2020/  

MySQL Day Virtual Event Join us on July 29th, 2020 (8AM - 1PM PST) for a virtual event about why and how to upgrade to MySQL 8.0.  Learn the key reasons you should upgrade to 8.0. Discover the best...

Live Webinar: Learn Credorax Best Security Practices with MySQL

Webinar date: July 8th, 2020 @9AM PST Webinar title: Learn How Credorax is Increasing its SaaS Application Security with MySQL EE.   Speakers: Mike Frank, MySQL Product Management Director Greg Paks, VP R&D and Operations IT  for Credorax Register now In this webinar, you will learn how Credorax leverages MySQL EE security features for their SaaS platform. Credorax’s SaaS application handles global and domestic domestic payments for merchants and partners, so security is a top priority for the company.  Discover how MySQL EE is used in the Credorax production environment to address the security challenges.  Learn Credorax best practices to protect their global operation across Europe, the US, the UK, Malta, Israel, Japan and China. This webinar will cover topics such as encryption, advanced authentication, auditing, database firewalls, and more. If you are a VP, CSO, CISO, or lead a line of business with concerns about security, join us and see how your teams can better secure MySQL. Credorax is a licensed Merchant Acquiring Bank, providing cross-border Smart Acquiring services to global merchants and payment service providers. Remaining true to their hi-tech roots and focus, Credorax is creating the next generation technology-driven banking solutions for the eCommerce arena. Credorax's Architecture Credorax's main payment processing engine uses MySQL at its core, for processing hundreds of transactions a second from customers globally. MySQL was chosen for it's flexibility and modular design allowing it to fit into a custom designed architecture meeting Credorax's specific throughput, availability and future scalability needs at a cost-effective price point. Credorax utilizes a custom-meshed, highly available MySQL Architecture which enables both high levels of uptime and spreading of the load for reporting and time delayed backup. Read more about how Credorax uses MySQL EE for its NextGen Payment Processing technology

Webinar date: July 8th, 2020 @9AM PST Webinar title: Learn How Credorax is Increasing its SaaS Application Security with MySQL EE.   Speakers: Mike Frank, MySQL Product Management Director Greg Paks, VP...

Interview + Webinar about SaaS Companies Using MySQL

In my interview with Shane Atherholt, Head of ISVs at MySQL, I asked him several questions: What is an ISV?  What is a SaaS application? How are ISVs using MySQL? We also went over the recent data breaches and new government regulations. I asked how MySQL helps ISVs secure their data and comply with the new regulations. I also asked Shane what were ISV CEOs and CIOs top priorities and why they should consider a relationship with Oracle. In conclusion, we talked about what we should look forward to in the future with MySQL. Watch the interview below. On May 27th, 2020, Shane Atherholt will hold a webinar focused on SaaS solutions for ISVs where he will go into more in depth detail about the MySQL offering for ISVs and SaaS. He will also cover the many MySQL Enterprise edition features that are designed to help ISVs with their SaaS applications so they can be more secure and in compliance. After the webinar, Shane will be available to answer your questions in a Q&A session. Register now to the webinar and prepare your questions! MySQL Enterprise Edition for SaaS Applications Wednesday, May 27, 2020 - 9AM Pacific Time Get a quick overview of the ISVs and SaaS applications using MySQL. Discover the different use cases and the many customer references. See what are the top priorities of ISV executives today. Learn how MySQL Enterprise edition will help secure your data and comply with the new regulations. Register to the webinar » Watch the interview with Shane Atherholt, Head of ISVs at MySQL: "use strict"; document.addEventListener('DOMContentLoaded', function(){if (window.hideYTActivated) return; let onYouTubeIframeAPIReadyCallbacks=[]; for (let playerWrap of document.querySelectorAll(".hytPlayerWrap")){let playerFrame=playerWrap.querySelector("iframe"); let tag=document.createElement('script'); tag.src="https://www.youtube.com/iframe_api"; let firstScriptTag=document.getElementsByTagName('script')[0]; firstScriptTag.parentNode.insertBefore(tag, firstScriptTag); let onPlayerStateChange=function(event){if (event.data==YT.PlayerState.ENDED){playerWrap.classList.add("ended");}else if (event.data==YT.PlayerState.PAUSED){playerWrap.classList.add("paused");}else if (event.data==YT.PlayerState.PLAYING){playerWrap.classList.remove("ended"); playerWrap.classList.remove("paused");}}; let player; onYouTubeIframeAPIReadyCallbacks.push(function(){player=new YT.Player(playerFrame,{events:{'onStateChange': onPlayerStateChange}});}); playerWrap.addEventListener("click", function(){let playerState=player.getPlayerState(); if (playerState==YT.PlayerState.ENDED){player.seekTo(0);}else if (playerState==YT.PlayerState.PAUSED){player.playVideo();}});}window.onYouTubeIframeAPIReady=function(){for (let callback of onYouTubeIframeAPIReadyCallbacks){callback();}}; window.hideYTActivated=true;}); .hytPlayerWrap{display: inline-block; position: relative;}.hytPlayerWrap.ended::after{content:""; position: absolute; top: 0; left: 0; bottom: 0; right: 0; cursor: pointer; background-color: black; background-repeat: no-repeat; background-position: center; background-size: 64px 64px; background-image: url(data:image/svg+xml;utf8;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSIxMjgiIGhlaWdodD0iMTI4IiB2aWV3Qm94PSIwIDAgNTEwIDUxMCI+PHBhdGggZD0iTTI1NSAxMDJWMEwxMjcuNSAxMjcuNSAyNTUgMjU1VjE1M2M4NC4xNSAwIDE1MyA2OC44NSAxNTMgMTUzcy02OC44NSAxNTMtMTUzIDE1My0xNTMtNjguODUtMTUzLTE1M0g1MWMwIDExMi4yIDkxLjggMjA0IDIwNCAyMDRzMjA0LTkxLjggMjA0LTIwNC05MS44LTIwNC0yMDQtMjA0eiIgZmlsbD0iI0ZGRiIvPjwvc3ZnPg==);}.hytPlayerWrap.paused::after{content:""; position: absolute; top: 70px; left: 0; bottom: 50px; right: 0; cursor: pointer; background-color: black; background-repeat: no-repeat; background-position: center; background-size: 40px 40px; background-image: url(data:image/svg+xml;utf8;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHZlcnNpb249IjEiIHdpZHRoPSIxNzA2LjY2NyIgaGVpZ2h0PSIxNzA2LjY2NyIgdmlld0JveD0iMCAwIDEyODAgMTI4MCI+PHBhdGggZD0iTTE1Ny42MzUgMi45ODRMMTI2MC45NzkgNjQwIDE1Ny42MzUgMTI3Ny4wMTZ6IiBmaWxsPSIjZmZmIi8+PC9zdmc+);}

In my interview with Shane Atherholt, Head of ISVs at MySQL, I asked him several questions: What is an ISV?  What is a SaaS application? How are ISVs using MySQL?We also went over the recent data...

Celebrating MySQL 25th Anniversary!

This week MySQL turns 25 - - - on May 23rd to be exact. Join us in celebrating 25 years of great success. Early on MySQL became the “M” in the LAMP stack that powered the open source revolution. It became and continues to be the most popular open source database. Early this year it earned the DB-Engine award for most popular database. The most successful applications and websites we all know and use today, such as Twitter, Facebook, Booking but also Uber, Airbnb and many more, started with MySQL, grew up with MySQL and now scale with MySQL. Over the years it has become the database of choice for many of the most successful open source applications like WordPress, Drupal, Joomla, Magento, and many more.    It has always been ranked the developers’ favorite database because, as developers say, “it’s easy to use and simply just works.” The graphic above goes over some of the main product versions MySQL has had over the years. From its first release on May 23rd 1995 to the latest MySQL 8.0, it has morphed from a pure SQL database to the dual SQL+NoSQL for what has become NoSQL + SQL = MySQL. Today, the entire MySQL team would like to take this opportunity to thank all of you, our users and customers, for your continued support over the years.  MySQL would not be the product it is today without your support. Once again, THANK YOU for your support from all of us here at MySQL. We’re raising our glass of Champagne from home since most of us are still sheltering-in-place …the cake will be for later, when we no longer live in a virtual world.  Here’s to the NEXT 25 years!  

This week MySQL turns 25 - - - on May 23rd to be exact. Join us in celebrating 25 years of great success. Early on MySQL became the “M” in the LAMP stack that powered the open source revolution. It...

MySQL

3 Days 3 Webinars to Learn More about MySQL Document Store

The week of May 4th, 2020, we will have a series of 3 live webinars on the MySQL DocStore topic.  With MySQL 8.0, developers can now use the same MySQL database for their NoSQL and SQL applications. To learn more about the MySQL Document Store feature, join us the week of May 4th for a series of 3 webinars, 1 webinar each day for 3 days at 9AM Pacific Time. Our first webinar will be more business focused and will cover the business benefits of using the same database for both SQL and NoSQL. The second webinar will be more technical and will give you a nice technical introduction of the MySQL document store as well as step-by-step instructions on how to use it.   Our third webinar will also be for a technical audience with deeper insight on how to leverage the dual SQL and NoSQL features of MySQL.  You will discover how to turn unstructured JSON data temporarily into structured tables for use with SQL.     1. Tuesday, May 05, 2020 Benefits of using the same MySQL database for both SQL and NoSQL This webinar will cover the many business benefits of using the same database for SQL and NoSQL. We will talk about real customer use cases who use MySQL for both SQL and NoSQL in order to consolidate their data management. Register for this web presentation »   2. Wednesday, May 06, 2020 A Step by Step Introduction to the MySQL Document Store The MySQL Document Store is a NoSQL JSON document database that is easy to learn to use and to master. You do not need to normalize data, set up tables, or do much of the traditional work needed to use a relational database. Simple connect to the server and start saving your data. And since your data is schema-less it is very simple to change your data format on the fly. This webinar will allow show you in simple step-by-step instructions how to create a document collection, add your data, and then manage that data all without any Structured Query Language using the MySQL Shell. Register for this web presentation »   3. Thursday, May 07, 2020 Discover the Power of NoSQL + SQL with MySQL In addition to MySQL's great performance as a relational database it can also be used as a NoSQL JSON Document Store.  Your data is stored in an easy to read JSON format that is easily changeable as your needs change or your application evolves. This is all done without any Structured Query Language with an easy to use API that supports all popular programming languages.  Plus you can easily turn the unstructured JSON data temporarily into structured tables for use with SQL if needed and also access that JSON data from SQL as to provide you with the best of both the NoSQL and SQL worlds. Register for this web presentation »   Additional Resources Want to learn more about the MySQL Document Store?  Download our white paper which covers the Top 10 reasons you should use MySQL Document Store for your NoSQL needs.  Can't wait for the live webinars?  Check our on-demand webinars on the Document Store: Oracle MySQL Live Webcast: MySQL, NoSQL, JSON, JS, Python: Document Store  NoSQL+SQL=MySQL MySQL: NoSQL and SQL Together  Business Benefits of using both SQL and NoSQL with the Same Database  NoSQL + SQL = MySQL  NoSQL Development for MySQL Document Store using Java NoSQL Development for MySQL Document Store using PHP NoSQL Development for MySQL Document Store using Node.JS NoSQL Development for MySQL Document Store using .NET NoSQL Development for MySQL Document Store using Python

The week of May 4th, 2020, we will have a series of 3 live webinars on the MySQL DocStore topic.  With MySQL 8.0, developers can now use the same MySQL database for their NoSQL and SQL applications....

Announcements

Where's the MySQL Team from March 2020 to May 2020

As follow up to the regular shows announcements, we would like to inform you about places & shows where you can find MySQL Community team or MySQL experts at during March to May 2020 timeframe. Please find the details with a list of MySQL talks & booth details (if available at this time) below: March 2020: Southern California Linux Expo (ScaLE), Pasadena, US, March 5-8, 2020 MySQL talk: "MySQL New Features for Developers" by David Stokes, the MySQL Community Manager.  Timing: Friday, March 6, 2020 - 15:15 to 16:00 Room: 101 Booth: please find us in the expo area at MySQL booth FOSSASIA, Singapore, March 19-22, 2020 MySQL team is a sponsor of this show again this year, however since the current situation in APAC we had to cancel our physical attendance at this show. Even without our speakers there will be a MySQL track running since multiple MySQL talks were accepted. We look forward to meeting you at FOSSASIA next year! LOADays, Antwerp, Belgium, March 28-29, 2020 Talk (still TBC): "Don't spend time implementing complicated MySQL HA architecture use the right tools!" by Frederic Descamps, the MySQL Community Manager. No booths at LOADays at all April 2020: Midwest PHP, Minneapolis, MN, US, April 2-4, 2020 Talk: "MySQL 8.0 Features for Developers" by David Stokes, the MySQL Community Manager. Timing: Friday, April 3, 2020 - 13:00 to 13:40 Room: check the organizer's website Booth: please find MySQL booth in the expo area  OpenSource101, Austin, TX, April 14, 2020 Talk: "MySQL 8.0 New Features" given by David Stokes, the MySQL Community Manager. Timing: Tuesday, April 14, 2020 - 16:30 to 17:15 Room: check the organizer's website Booth: you can find MySQL booth in the expo area LinuxFest Northwest, Bellingham, US, Apr 24-26, 2020 Talk(s):  "New MySQL 8.0 Features" "MySQL Document Store or MySQL without the SQL -- Oh My!" "EZ MySQL Replication" -> all are given by David Stokes, the MySQL Community Manager Timing & Room: check organizer's website Booth: please find MySQL booth in the expo area Great Indian Developer Summit (GIDS), Bangalore, India, April 20-24, 2020 MySQL is again part of GIDS as a part of the Oracle booth in the expo area. Please come to talk to our experts there. May 2020: PyTexas, Austin, TX, May 16-17, 2020 This year MySQL is a Community sponsor with no booth. We have submitted several proposals for this show, the schedule will be announced during March 2020. Please watch organizer's website. PHPTek20, Atlanta, US, May 18-21, 2020 Please find MySQL at the MySQL booth in the expo area PerconaLIve, Austin, TX, US, May 18-20, 2020 As usual you can find MySQL at the PerconaLive. Since not all proposals were validated yet, you can find more of MySQL talks in the final schedule. Just now the accepted talks are as follows: Session(s):  Half Day tutorial: "MySQL InnoDB Cluster & MySQL Replicaset in a nutshell", by Frederic Descamps, the MySQL Community Manager & Kenny Gryp, the MySQL Principal Product Manager Keynote: "State of the Dolphin" by Frederic Descamps, the MySQL Community Manager Session: "MySQL Shell" - the best MySQL DBA tool? by Frederic Descamps, the MySQL Community Manager Session: "MySQL 8.0 Performance : Scalability & Benchmarks" by Dimitri Kravtchuk, the Oracle Performance Architect Session: "NDB Cluster 101" by Bernd Ocklin, the Senior Director, MySQL Cluster Engineering Booth: you can find MySQL team at the MySQL booth in the expo area Texas Linux Fest, Austin, TX, US, May 1-2, 2020 MySQL is as tradition part of this Texas Linux show. Multiple talks were submitted and we are waiting for an evaluation. Please watch organizers website for further updates. Booth: you can find MySQL at the MySQ booth in the expo area DOAG - Databanken, Dusseldorf, Germany, May 25-26, 2020 Talk: "MySQL Best Practices - Tuning fur Dummies" by Carsten Thalheimer, the MySQL Master Principal Sales Consultant Booth: you can find us at the MySQL booth in the expo area Please watch organizer's website for more talks which has not yet been validated OpenSource Day (2019 edition), Warsaw, Poland, May 19, 2020 - website to be updated This year again MySQL & Linux team are part of this show. You can find us at the shared booth in the expo area as well as find the MySQL & Linux talk in the schedule. OSC Nagoya, Japan, May 16, 2020 MySQL is as tradition part of this Open Source Conference in Japan, this time in Nagoya. Please watch organizer's website for the 45 min MySQL talk which is still under process. Booth: you can find us at the MySQL booth in the expo area

As follow up to the regular shows announcements, we would like to inform you about places & shows where you can find MySQL Community team or MySQL experts at during March to May 2020 timeframe. Please...

NEW PRODUCT RELEASE: MySQL 8.0.19

New Year 2020 and New Product Release.  The MySQL Development team just released the new MySQL 8.0.19 version.   The new generally available version can be downloaded at dev.mysql.com. In addition to bug fixes, a few new features made it into the release.  You can download 8.0.19 from dev.mysql.com or from the MySQL  Yum,  APT, or SUSE repositories. The source code is available at GitHub. You can find the full list of changes and bug fixes in the 8.0.19 Release Notes. Here are the highlights. Enjoy! Among what's new: New InnoDB ReplicaSet, and major improvements in Router, SQL, Optimizer, Information Schema, Security, InnoDB, Replication, X-Protocol MTR testsuite, and more. Read the feature details: https://mysqlserverteam.com/the-mysql-8-0-19-maintenance-release-is-generally-available/ Other great MySQL 8.0.19 technical blog references: The all new MySQL InnoDB ReplicaSet MySQL Shell 8.0.19 – What’s New? MySQL Shell AdminAPI – What’s new in 8.0.19? MySQL Connector/NET 8.0.19 MySQL Workbench 8.0.19 MySQL Connector/C++ 8.0.19 MySQL Shell 8.0.19 for MySQL Server 8.0 and 5.7 MySQL 8.0.19 Replication Enhancements MySQL Connector/Node.js 8.0.19 MySQL Connector/J 8.0.19  MySQL Connector/Python 8.0.19  MySQL Connector/ODBC 8.0.19  Announcing MySQL Server 8.0.19, 5.7.29 and 5.6.47        

New Year 2020 and New Product Release.  The MySQL Development team just released the new MySQL 8.0.19 version.   The new generally available version can be downloaded at dev.mysql.com. In addition to...

Announcements

MySQL Wins “DBMS of the Year” Award from DB-Engine

What a great way to start the New Year!  I woke up this morning to find in the news that MySQL won the DBMS of the year award for 2019. “MySQL is the database management system that gained more popularity in our DB-Engines Ranking within the last year than any of the other 350 monitored systems. We thus declare MySQL as the DBMS of the Year 2019”, says DB-Engine. Getting the highest popularity gain among over 350 monitored systems is really impressive but this could only happen because of you, the users of MySQL.  Thank you all for your ongoing support and your feedback to help us continue to make MySQL always better. As for the method used for determining the winner every year, DB-Engine explained it this way “For determining the DBMS of the year, we subtracted the popularity scores of January 2019 from the latest scores of January 2020. We use the difference of these numbers, rather than a percentage, because that would favor systems with a tiny popularity at the beginning of the year. The result is a list of DBMSs sorted by how much they managed to increase their popularity in 2019, or in other words, how many additional people started to communicate about it in one of the ways we measure in our methodology, for example job offers, professional profile entries and citations on the web.” For more information about DB-Engine’s DBMS of the year award, you can check their post at: https://db-engines.com/en/blog_post/83   Again, a BIG thank you to you all from the entire MySQL team!   And now is a good time to check out why #MySQL8isGreat! Here are the MySQL 8.0 Top 10 Features: 1.  Hash Joins 2.  EXPLAIN Analyze 3.  Window Functions 4.  CTEs 5.  InnoDB Cluster 6.  InnoDB Clone 7.  Shell 8.  Roles 9. Data Dictionary 10. Document Store   Learn More about MySQL 8.0 at: https://www.slideshare.net/lefred.descamps/benefits-to-upgrade-to-mysql-80  

What a great way to start the New Year!  I woke up this morning to find in the news that MySQL won the DBMS of the year award for 2019. “MySQL is the database management system that gained more...

MySQL

WEBINAR: From MariaDB to MySQL 8.0

WORDS OF WISDOM: Like they say in Asia, nobody should use a fork.  Tradition even dictates to “chop” all your forks and “stick” to the original. Now, for those few of you, who by mistake, ventured to use a fork, Matthias from Pythian will show you the many reasons why you should always use the original and will demo the easy way to get back to using the real thing. Register now: http://ora.cl/zy5BH This webinar will cover the advantages and process for migrating from MariaDB/Galera cluster to InnoDB cluster. Over these last 2 years and especially with MySQL 8.0, MySQL Innodb Cluster has matured a lot. In this webinar our guest speaker Matthias Crauwels from Pythian will go over the key difference between both solutions. Matthias will use his experience to show how to migrate your application from MariaDB/Galera cluster over to MySQL InnoDB cluster with the least possible amount of downtime. WHO: Matthias Crauwels, Lead Database Consultant, Pythian WHEN: Thu, Dec 19: 09:00 Pacific time (America) Thu, Dec 19: 10:00 Mountain time (America) Thu, Dec 19: 11:00 Central time (America) Thu, Dec 19: 12:00 Eastern time (America) Thu, Dec 19: 14:00 São Paulo time Thu, Dec 19: 17:00 UTC Thu, Dec 19: 17:00 Western European time Thu, Dec 19: 18:00 Central European time Thu, Dec 19: 19:00 Eastern European time Thu, Dec 19: 22:30 India, Sri Lanka Fri, Dec 20: 00:00 Indonesia Western Time Fri, Dec 20: 01:00 Singapore/Malaysia/Philippines time Fri, Dec 20: 01:00 China time Fri, Dec 20: 02:00 日本 Fri, Dec 20: 04:00 NSW, ACT, Victoria, Tasmania (Australia) The presentation will be approximately 60 minutes long followed by Q&A.  

WORDS OF WISDOM: Like they say in Asia, nobody should use a fork.  Tradition even dictates to “chop” all your forks and “stick” to the original. Now, for those few of you, who by mistake, ventured to...

Announcements

Where's the MySQL Team from December 2019 to February 2020

As follow up to the regular shows announcements, we would like to inform you about places & shows where you can find MySQL Community team or MySQL experts at during December to February timeframe. Please find the list below: December 2019: UKOUG Tech Fest, Brighton, UK, December 1-4, 2019 Oracle is having a big booth at this show, however this time MySQL is not part of this. Instead David Stokes, the MySQL Community Manager has a MySQL talk on "MySQL 8.0" scheduled for December 2nd @16:45-17:30. Please see the schedule. London Open Source DB meetup, London, UK, December 4, 2019 David Stokes, the MySQL Community Manager is going to give a talk at the London Open Source Database Meetup on Dec 4, 2019. Details: Date: Dec 4, 2019 Time: From Agenda: 18:00 - Arrival, networking. Food and drinks offered by Oracle 18:20 - Intro by Federico Razzoli, database consultant * 18:30 Community lightning talks 19:00 - "New MySQL Features and a Brief Look into 2020!" - by David Stokes, MySQL Community Manager  Place: Innovation Warehouse 1 E Poultry Ave · London, UK IT Tage, Frankfurt am Main, Germany, December 12, 2019 IT Tage is one of Germany’s largest IT conferences to date. It covers a wide range of topics from agile development, over microservices, data-management/-usage as well as application and container design over to the internet of things: More than 230 sessions on various topics make it the must-go event of 2019 for IT interested parties. Carsten Thalheimer & Henry Kroeger will deliver a talk on “MySQL best practices – 8 easy steps to a more optimized MySQL instance”: On basis of RedHat Linux 8 we will demonstrate and discuss the creation of a scalable MySQL instance. Additionally an overview of the clustering possibilities within MySQL 5.7 & MySQL 8.0 will be given. The target audience for this talk are database administrators as well as those possessing a good basic understanding of database mechanics. You can find both, Carsten & Henry at Oracle booth all the time except the session time. Please come to talk to us! January 2020: OpenSource Conference Osaka, Japan, January 24-25, 2020 As tradition we are again part of OSC Osaka as Gold sponsor. You can find us at the expo area at MySQL booth as well as find a MySQL 8.0 talk in the schedule. During the talk we will introduce MySQL 8.0, the latest version of MySQL, MySQL Enterprise Edition (which provides extended functions and support), MySQL Cluster, a high-performance and highly reliable distributed cluster & Oracle MySQL Cloud Service. Please watch the conference website for talk timing & details. We are looking forward to talking to you at OSC Osaka! February 2020:  FOSDEM 2020, Brussels, Belgium, February 1-2, 2020 As tradition also this year MySQL wide team is part of FOSDEM. Find us at MySQL booth in the expo area as well as in the approved FOSDEM MySQL, MariaDB & Friends Devroom. The CFP ended on Nov 20 and soon the full schedule will be announced. SunShine PHP, Miami, FL, US, February 6-8, 2020 "MySQL New Features" given by David Stokes, the MySQL Community Manager. Please check the website schedule for the exact timing. You can also find MySQL at the shared booth in the expo area. DeveloperWeek, SFO, US, February 12-16, 2020 This year for the first time you can find MySQL Community team at this large Developer show in SFO Bay Area. You will be able to find us at the MySQL booth in the expo area as well as find a talk given by David Stokes, the MySQL Community Manager on "MySQL without the SQL - Oh My!" in the program. The talk is preliminary scheduled for Feb 13, 2020 @3:30-3:55.  OpenSource Conference 2020 Tokyo Spring, Tokyo, Japan, February 21-22, 2020 -> Conference was cancelled due to coronavirus We are happy to announce our attendance at OSC Tokyo Spring in February 2020. You can find MySQL talk in the agenda as well as our team at MySQL booth in the expo area. Please check the conference website for more details & schedule. Korean Community Day (KCD), Seoul, Korea, February 29, 2020) -> Conference was postponed due to coronavirus MySQL team is part of the Korean Community Conference hold in Korea. Please find MySQL talk in the schedule once that is announced.

As follow up to the regular shows announcements, we would like to inform you about places & shows where you can find MySQL Community team or MySQL experts at during December to February timeframe....

Announcements

Where's the MySQL Team in October & November 2019

As follow up to the previous blog announcement we would like to inform you about where you can find MySQL & MySQL Community Team during October & November 2019. Please find the list below: October 2019: PerconaLive, Amsterdam, Holland, September 30-October 2, 2019 For detailed information see the blog post from last week. OpenTech Summit, Bangkok, Thailand, October 1-2, 2019 MySQL becomes a Gold sponsor with a Gold booth in the expo area and four MySQL talks as follows: "MySQL Overview for Oracle DBAs" given by Ryan Kuan, the MySQL Master Principal Solution Engineer. Talk scheduled for Oct 1 @14:00. "The Secret of MySQL InnoDB cluster Deployment" given by Ivan Ma, the MySQL Principal Solution Engineer. Talk scheduled for Oct 1 @14:30 "Unleasing the power of NoSQL using MySQL 8.0" given by Ryan Kuan. Talks scheduled for Oct 1 @ 16:00. "MySQL Troubleshooting and Performance Analysis" given by Ivan Ma. Talk scheduled for Oct 1 @16:30. Come to visit our booth to talk to our MySQL experts!  JCConf, Taipei, Taiwan (October 4, 2019) As a tradition MySQL is a Silver sponsor of this Java conference. This year you can find our team at the MySQL booth in the expo area as well as find a MySQL talk in the schedule as follows:  "How Java Leverage MySQL Cluster To Build Application with 99.9999% Availability" given by Ivan Tu, the MySQL Solution Engineering Manager. His talk is scheduled for 13:55-14:40. There is also a 3 minutes MySQL talk before sessions scheduled. We are looking forward to talking to you at JCConf this year! Gitex, Dubai, United Arab Emirates, October 6-10, 2019 As usual our MySQL representatives are present at Gitex in Dubai. You can find us at Oracle booth or around if you are present.  OpenSource Conference Enterprise, Tokyo, Japan, October 10, 2019 MySQL is a Gold sponsor of this OS Enterprise conference in Tokyo. You can find our team at MySQL booth in the expo area as well as find MySQL talk in the schedule. We are looking forward to talking to you in Tokyo! Little Rock Tech Fest, Little Rock, AR, US, October 10-11, 2019 As a Silver sponsor MySQL will get a booth in the expo area and this time also with a MySQL talk on: "Windowing Functions in MySQL" given by David Stokes, the MySQL Community Manager. His talk is scheduled for Oct 10 @3pm. Come to talk to us! UbuCon Europe, Sintra, Portugal, October 10-13, 2019 MySQL team is supporting this Ubuntu conference as Silver sponsor. This time you can find us talking about:  "Introduction to the new Oracle DBA: MySQL & Oracle." given by Keith Hollman, the MySQL Principal Sales Consultant. "MySQL 8.0: Highly Available, JSON, NOSQL & Document Store Straight out-of-the-box" given by Keith Hollman. See schedule for more details about both Keith's talks. Tiago Jorge talk approved: "MySQL 8.0: The New Replication Features" given by Tiago Jorge, the MySQL Software Architect. His talk is scheduled for Oct 12 @15:30 in Auditório Ubuntu. Zabbix Summit, Riga, Latvia, October 11-12, 2019 MySQL as as Silver sponsor will be available at the MySQL booth in the expo area as well as have following talk: "Scaling Zabbix with MySQL InnoDB Cluster" given by Vittorio Cioe, the MySQL Senior Sales Consultant. Please do not miss the opportunity to come and stop by at our booth and listen Vittorio's talk at Zabbix Summit 2019! All Things Open 2019, Raleigh, NC, October 13-15, 2019 MySQL is a Bronze sponsor of ATO 2019. You can find us at the MySQL booth #64 as well as attend the MySQL talk as follows:  "MySQL 8.0 New Features" scheduled for October 14 @1pm in the room 204. The speaker is David Stokes, the MySQL Community Manger. OpenSource Conference India (OSI Days), Bangalore, India, October 17-18, 2019 MySQL is becoming Associate Partner of OSI Days this year. You can see & talk to us at our MySQL booth in the expo area as well as attend the MySQL Keynote given by Sanjay Manwani, the MySQL India Sr. Director. The topic is "NoSQL + SQL = MySQL 8.0", the talk is scheduled for October 18 @9:30-10:15 am.  MOPCON, Taipei, Taiwan, October 19-20, 2019 We are happy to announce that this year again MySQL is a sponsoring partner of MOPCON 2019 in Taiwan. This year with a MySQL talk as follows:  "MySQL 8.0 的地理資訊系統 (GIS) 支援新世代行動應用" given by Ivan Tu, the MySQL Solution Engineering Manager. The talk is scheduled for October 19 @10:15 - 10:55am in a room 2, 4F. PHP[World], WDC, US, October 23-24, 2019 MySQL as a Bronze level sponsor this year at PHP[World] will be available at MySQL booth as well as got a talk accepted as follows: "MySQL's InnoDB Cluster" given by David Stokes, the MySQL Community Manager. Forum PHP, Paris, France October 24-25, 2019 MySQL is supporting Forum PHP this year as Bronze sponsor. There is going to be a MySQL representative around, unfortunately without a booth this year. November 2019: Big Mountain Data and Dev Conference, Salt Lake City, UT, USA, November 1-2, 2019 David Stokes, the MySQL Community Manager will have following talks at this free Data & Dev conference: "'When boring tech is better than too exciting tech" "MySQL Without the SQL - Oh My!" MySQL Innovation Day, Tokyo, Japan, November 7, 2019 MySQL Innovation Day, Osaka, Japan, November 8, 2019 Feedback on MySQL latest information on Oracle OpenWorld 2019 (OOW) / Oracle Code One 2019 held in San Francisco from September 16-19, 2019! MySQL continues to actively add new features after the GA release of MySQL 8.0. Product manager Mike Frank (security officer), Kenny Gryp (high availability officer), community manager “LeFred” and Oracle Labs Vice President Nipun Agarwal will be coming to Japan. Highload++, Moscow, RF, November 7-8, 2019 Same as last year MySQL is a sponsorship partner of Highload++ conference in Moscow this year again. You can find our MySQL experts at the MySQL booth in the expo area as well as find two MySQL talks in the schedule (schedule is not fully announced yet). Both talks are given by Vittorio Cioe, the MySQL Senior Technical Sales Consultant, Oracle MySQL GBU ant their topics are: "Раскрытие секретов Group Replication в MySQL" "Новая инфраструктура компонентов в MySQL 8.0".  OpenSource Conference Fukuoka, Japan, November 9, 2019 MySQL is a Gold sponsor of this OS conference in Fukuoka. You will be able to find our team at our Gold MySQL booth in the expo area as well find our talk in the schedule, as follows: "MySQL開発最新動向-Oracle MySQL Cloud Serviceの最新情報もご紹介-" given by Yoshiaki Yamasaki, the MySQL Senior Solution Engineer, Asia Pacific and Japan MyNA (the MySQL Nippon Association) has another session scheduled: "MySQL 8.0 Thin Book" given by Kei Sakai & 松久 裕保. We are looking forward to talking to you in Fukuoka! Cloud Native & Edge Computing Summit, Tel Aviv, Israel, November 12, 2019 Newly and on a last minute we are happy to announce that you can find MySQL team at this Cloud show in Israel. You can find us at out MySQL booth as well as find a MySQL talk in the schedule as follows: "MySQL Shell: the daily tool for devs and admins" given by Vittorio Cioe, the MySQL Senior Sales Consultant. Time of the talk will be announced soon. Next Generation Data Technology Development Forum, Zhenzhou, China, November 15-16, 2019 MySQL team is a partner of this Annual conference. Oracle/MySQL will have a booth at this event and 2 MySQL sessions as follows in the Room 502: 14:00 - 14:40: MySQL企业安全最佳实施准则 given by Mike Frank. 15:35 - 16:15: MySQL 8.0后亮丽的新功能 given by 杜修文(Ivan Tu)   BGOUG, Pravets, Bulgaria, November 15-17, 2019 As tradition MySQL is a partner of this Bulgarian Oracle User Group event in Pravets. This time you can find the MySQL talk given by Georgi Kodinov, the MySQL Software Development Director. Georgi's talk as follows: "MySQL Clone: A better way to migrate your data across MySQL servers", for timing please check the agenda. DOAG Conference 2019 – (Oracle User Group in Germany), Nuremberg, Germany, November 19-22, 2019 DOAG is the largest Oracle User Group conference in Germany, stretching over 3 days plus 1 day of trainings for those interested and we are happy to announce that MySQL is again part of it. You can find MySQL at the Oracle booth as well as find a MySQL talk in the schedule as follows:   "Oracle MySQL the “other” database from Oracle” given by Carsten Thalheimer and Henry Kröger. The talk delivers a brief overview over the different MySQL versions, as well as presenting a live demo on how to set up a MySQL database on Linux with some basic optimizations. Additionally, a comparison is made to other existing database technologies. This is followed by a short section on how the software is integrated with existing Oracle infrastructures utilizing for example OEM 13c. Last but not least the talk concludes with a couple of practical examples on how MySQL is managed in professional contexts and what additional tools (TDE, backup/recovery, data-masking, auditing, etc.) are available for these use cases. The talk is scheduled for Nov 21 @10:00-10:45.  Carsten & Henry will be part of the larger Oracle booth in which each subsection will have their own table, representing the different aspects of the Oracle technology portfolio.  MySQL Security and High Availability Workshop, Lausanne, Switzerland, November 26, 2019 Join the Acceleris and MySQL experts for a half-day event on November 26 at the Mövenpick Hotel in Lausanne-Ouchy. This event is intended as a networking platform for participants and aims to familiarize them with the latest MySQL news.   Olivier Dasini, "Senior Consultant" and "Super User", will talk about the latest MySQL developments, show you how to improve the security of your data in a few simple steps and introduce you to the features of the InnoDB cluster to provide a high availability solution automated.   We hope to count you among our guests to exchange ideas and experiences in a friendly and warm environment. Time: 9:00-12:40 More information & agenda.            

As follow up to the previous blog announcement we would like to inform you about where you can find MySQL & MySQL Community Team during October & November 2019. Please find the list below: October...

MySQL

OOW 2019 – MySQL Highlights

We just wrapped up what was a very exciting OOW 2019 - San Francisco for MySQL.  Our MySQL track included 29 sessions, a keynote with 2 customer testimonials (Mercari and WePay), 1 tutorial, 1 Hands-on lab, 1 Birds of a Feather, and our always fun and enjoyable MySQL Community Reception.   A BIG Thank You to the companies who came to share their experience and testimonial about how MySQL helps scale their company such as Facebook, JP Morgan Chase WePay, Credorax, Mercari, Zuora, and more. Our focus this year: SECURITY.  With 3,800 breaches and over 4 Billion Records Stolen in just H1 2019, securing data has become a priority for any business. The first part of the keynote covers the new security features from Oracle and MySQL implemented in our latest version of the Enterprise Edition. Other highlights for MySQL: MySQL 8.0,  fastest adoption of any version with over 26% in a year New MySQL Analytics Service, faster than Google BigQuery says Mercari HA with MySQL InnoDB Cluster Microservices with MySQL and Vitesse on Kubernetes NoSQL with NodeJS and MySQL Document Store Many of the sessions are now available online: Keynote: State of the Dolphin with: Rich Mason,, MySQL General Manager Tomas Ulin, MySQL VP of Engineering Nipun Agarwal, Oracle Labs, VP of R&D Kenichi Sasaki, Mercari Rich Steenburg, WePay Recorded sessions: MySQL 8.0 at Facebook Managing MySQL at Scale in Facebook Python and MySQL 8.0 Document Store Running MySQL on Kubernetes the Easy Way MySQL with ProxySQL at Zuora What’s New in MySQL Optimizer and Executor? Using MySQL as a Document Store with Native APIs Building Carefree Data-Driven Applications with the MySQL X DevAPI Foreign Key Support in MySQL 8.0: Change, Opportunities, and More...   If you’d like to participate at one of our Oracle Open World events, or at a MySQL event, to share your experience and knowledge of MySQL and how MySQL helps scale your company, contact us through Chat or through your Sales representative. 

We just wrapped up what was a very exciting OOW 2019 - San Francisco for MySQL.  Our MySQL track included 29 sessions, a keynote with 2 customer testimonials (Mercari and WePay), 1 tutorial, 1...

Announcements

Where is the MySQL team this and next week?!

This week you can find our MySQL & MySQL Community experts at following shows: db tech showcase, Tokyo, Japan, September 25-27, 2019 MySQL team as Silver sponsor will have a booth in the expo area and in total 5 speaking slots related to MySQL as follows:  Two User Case Studies of MySQL Two Technical Sessions by MySQL User Community members (MyNA) MySQL Server, MySQL Workbench and MySQL Shell by MySQL GBU  Please watch organizers' website for more details. PerconaLive, Amsterdam, Holland, September 30-October 2, 2019 MySQL team is going to become Silver partner of PerconaLive Amsterdam this year. Do not miss the chance to talk to our experts at MySQL booth in the expo area & come to multiple MySQL talks which were accepted, see below: "MySQL 8.0: The New Replication Features" given by Luis Soares, the MySQL SW Development Director. "MySQL 8.0 InnoDB Cluster - Easiest Tutorial!" given by Kenny Gryp, the MySQL Principal Product Manager & Frédéric Descamps (lefred), the MySQL Community Manager. "MySQL InnoDB Cluster - Advanced configuration & operation" given by Pedro Gomez, the MySQL Senior Software Developer & Frédéric Descamps (lefred), the MySQL Community Manager. "InnoDB management and scalability improvements in MySQL 8." given by Sunny Bains, the Senior Software Development Director. "MySQL Shell : the best DBA tool ? - Extend the Shell with the new plugin infrastructure" given by Frédéric Descamps (lefred), the MySQL Community Manager. "MySQL 8.0 Performance: Scalability & Benchmarks" given by Dimitri Kravtchuk, the Performance Architect. "Automatic Upgrade and New Error Logging in MySQL 8.0" given by Stale Deraas, the Software Development Director. "JSON Array Indexes in MySQL" given by Norvald Ryeng, the Software Development Sr. Manager. "How to Instrument Your Code in Performance Schema" given by Georgi Kodinov, the MySQL Software Development Director.  "MySQL 8.0.18: Latest Updates" by Norvald Ryeng, the Software Development Sr. Manager. This is the very first presentation about HASH JOINS and EXPAIN ANALYZE, two major new features. We are looking forward to seeing and talking to you at PL 2019! JCConf, Taipei, Taiwan, October 4, 2019 As tradition MySQL is a Silver sponsor of this Java conference. This year you can find our team at the MySQL booth in the expo area as well as find a MySQL talk as follows: "How Java Leverage MySQL Cluster To Build Application with 99.9999% Availability" given by Ivan Tu, the MySQL Solution Engineering Manager. His talk is scheduled for 13:55-14:40. There is also a 3 minutes talk before sessions. We are looking forward to talking to you at JCConf this year!

This week you can find our MySQL & MySQL Community experts at following shows: db tech showcase, Tokyo, Japan, September 25-27, 2019 MySQL team as Silver sponsor will have a booth in the expo area and...

Announcements

Where's the MySQL Team in August & September 2019

As follow up to the previous blog announcement about the conferences and events MySQL Team is attending, we would like to inform you about where you can find us during August & September 2019. Please find the list below. August 2019: Mid-Atlantic Developer Conference, Baltimore, US, August 1-2, 2019 MySQL Community team is a Bronze sponsor of this Developer conference. Our MySQL Community Manager, David Stokes will be giving 2 sessions as follows: "MySQL & GIS" scheduled for Aug 1 @11:30-12:30pm "MySQL without the SQL — Oh My!" Aug 2 @10:15-11:15am Please do not forget to attend the MySQL sessions as well as stop by at our MySQL both in the expo area! OpenSource Conference Kyoto, Japan, August 2-3, 2019 As tradition MySQL is a Gold sponsor of this OS show in Japan. This time you can find us at the MySQL booth in the expo area as well as you can find a MySQL talk in the schedule as follows: "MySQL Development Trends-Introducing the Latest Information on Oracle/MySQL Cloud Service" given by Yuki Yamazaki. The talk is scheduled for Aug 3, @15:15-16:00. ​Kansas Linux Fest (KLF), Wichita, Kansas City, US, August 9-11, 2019 MySQL Community team became a Silver sponsor of this Linux event. You can find our MySQL Community Manager, David Stokes there talking about MySQL during his two accepted sessions. The schedule is not yet done, so please watch the conference's website for further updates on timing and place: "MySQL Without the SQL - Oh My!" "The Proper Care and Feeding of a MySQL Database for Busy Linux Administrators".  ​FrOSCon 2019, Snkt. Augustin, Germany, August 10-11, 2019 As tradition MySQL is part of this OS show in Germany. You can visit our MySQL experts at the MySQL booth in the expo area as well as you can attend a MySQL session given by Carsten Thalheimer, the MySQL Master Principal Sales Consultant. The session is: "MySQL Best Practices - In 8 Schritten zur optimierten Datenbank!", scheduled for Sun, Aug 11 @14:00-15:00. ​COSCUP, Taipei, Taiwan, August 17-18, 2019 MySQL is, same as last year, Gold sponsor of COSCUP Conference. You can find our team at the MySQL booth in the expo area as well as find multiple MySQL related talks in the schedule, see some of them below. The full schedule can be found here (Day 1) & here (Day 2). "MySQL InnoDB Custer" given by Ivan Ma, the MySQL Principal Solution Engineer. Ivan's talk is scheduled for Aug 17 @10:45-11:25am. "MySQL Performance - the Dos and Don'ts" given by Yoshiaki Yamasaki, the MySQL Senior Solution Engineer. His talk is scheduled for Aug 17 @13:25-14:05. "MySQL 8.0有那些值得注意的新發展" given by Ryusuke Kajiyama, the MySQL Sales Consulting Senior Manager. His talk is scheduled for Aug 17 @14:55-15:35. ... other MySQL related talks are scheduled for Day 2 (Aug 18) from 10:00-16:00 in IB302 room. ​FOSS4G, Tokai, Japan, August 23-24, 2019 MySQL is a partner of OSGeo.JP group which is organizing FOSS4G events. The previous FOSS4G event we also attended took place in Hokkaido last month. MySQL got an opportunity to run MySQL seminar at this show. At this moment we do not know more details, please check organizers' website for further updates. OpenSource Developer Conference, Tokyo, Japan, August 24, 2019 Same as last year we are glad to inform you that MySQL is Gold sponsor of this one day show. This year you could be again able to find our team at the MySQL booth in the expo area as well as attend the MySQL session as follows: "Not only MySQL Server, there is also MySQL Shell" given by Ikoma Tomoko. The talk is scheduled for 15:15-16:00. We are looking forward talking to you in Tokyo! September 2019: SwanseaCon, Swansea, UK, September 9, 2019 We are happy to announce that MySQL is again back in the UK for the lovely SwanseaCon event! This year our new colleague will staff the MySQL booth as well as run the MySQL talk. We are looking forward seeing you there! Please do not miss the talk as follows: "NoSQL + SQL = MySQL" given by Stuart Davey, the MySQL Principal Sales Consultant. His talk is scheduled for 11:15-12:00 FOSS4G Niigata, Japan, September 13-14, 2019 MySQL is a partner of OSGeo.JP group which is organizing FOSS4G events. MySQL got an opportunity to run MySQL seminar at this show. At this moment we do not know more details, please check organizers' website for further updates. OpenSource Conference, Hiroshima, Japan, September 15, 2019 As usual MySQL is a Gold sponsor of this OS show, this time in Hiroshima. Do not miss to stop by at our MySQL booth in the expo area as well as come to listen the MySQL talk as follows:  "Finally released! MySQL 8.0 Latest information" given by Yuka Yamazaki from Oracle/MySQL Community. The talk is scheduled for 16:10-16:55. Oracle Open World / MySQL Reception, San Francisco, US, September 16-19, 2019 Same as last year MySQL will be part of OOW in San Francisco. Right now we are planning to hold a MySQL Reception on the Sep 17, 2019 as the evening with all MySQLers coming to OOW. More details will be published once the place is fully booked. Just please mark your calendars for the date and more details will come soon! WebExpo, Prague, CZ, September 20-22, 2019 This is the fifth time MySQL is partner of WebExpo, the biggest technology conference in the Czech republic! This year, same as last year you will be able to find two teams at Oracle booth in the expo area, NetSuite (Bronto) team & MySQL. Do not forget to stop by! You can also attend the MySQL talk given by Vittorio Cioe, the Senior MySQL Sales Consultant as follows: "Modern Data Security with MySQL 8.0", scheduled for Sat, Sep 21 @14:00-14:40pm. db tech showcase, Tokyo, Japan, September 25-27, 2019 We are happy to announce that MySQL is again part of this DB show in Tokyo. We became Silver sponsor with a MySQL booth and speaking opportunity. MySQL got 2 speaking slots as well as 2 MySQL case study sessions and one session for MySQL User Group. Please watch organizers' website for further updates. PerconaLive, Amsterdam, Holland, September 30-October 2, 2019 MySQL team is going to become Silver partner of PerconaLive Amsterdam this September. The schedule and planning is not yet done, but we assume to have multiple MySQL talks as well as MySQL booth in the expo area. Do not miss to come to talk to us! We are looking forward talking to you!​​

As follow up to the previous blog announcement about the conferences and events MySQL Team is attending, we would like to inform you about where you can find us during August & September 2019. Please...

Announcements

Jun 17: Events with MySQL this week!

Just a reminder for the shows where you can find MySQL at this week, please find them below: GigaCon - OS Business, Warsaw, Poland, Jun 18, 2019 Vittorio Cioe, the Sr. MySQL Sales Consultant will talk about MySQL Enterprise during the shared slot with Linux/Cloud team. Talk is scheduled for 10:05-10:25 on Jun 18. OpenExpo Europe, Madrid, Spain, Jun 20, 2019 Find MySQL & Linux team at our shared booth at OpenExpo Europe as Gold sponsor. Planned MySQL talk: "MySQL 8.0: Highly Available, JSON , NoSQL & Document Store" by Keith Hollman, the MySQL Principal Sales Consultant. Time: 16:40-17:10. DataOps Barcelona, Spain, Jun 20-21, 2019 Do not miss the MySQL talk on: "Deep dive into MySQL Group Replication: the magic explained" given by Frederick Descamps, the MySQL Community Manager. His talk is scheduled for June 20 @11:30 in the Room A-4. RootConf 2019, Bangalore, India, Jun 21-22, 2019 There should be a MySQL 8 talk, but for some reason it is not in the official schedule. Come to our booth to ask for the talk location, hearing about the news in MySQL and talking to our MySQL experts! We are looking forward seeing you there. DevConf, Moscow, RF, Jun 21-22, 2019 Do not. miss the MySQL talk on: "NoSQL + SQL = MySQL 8 Document Store!" given by Vittorio Cioe, the Sr. MySQL Sales Consultant. Vittorio's talk is scheduled for Jun 26th @12:30pm. 

Just a reminder for the shows where you can find MySQL at this week, please find them below: GigaCon - OS Business, Warsaw, Poland, Jun 18, 2019 Vittorio Cioe, the Sr. MySQL Sales Consultant will talk...

Announcements

Where you can find MySQL this week

Our pleasure to remind everyone about three events which are happening this week and MySQL is part of. Please find them below. PerconaLive, Austin, TX, US, May 28-30, 2019 as we previously announced MySQL is Silver sponsor w/ booth and several MySQL related talks as follows: Tuesday, May 28, 2019: MySQL Tutorial on: "MySQL InnoDB Cluster in a Nutshell: The Saga Continues with 8.0, the full guide" by Frederic Descamps & Kenny Gryp. Time: 9:30-12:30pm. Wednesday, May 29: 11:00-11:50, Room: Hill Country A: "Complex Stateful Applications Made Easier with Kubernetes" by Patrick Galbraith, the Principal Member of MySQL development 11:00-11:50, Room: Texas 1: "InnoDB Management and Scalability Improvements in MySQL 8.0" by Sunny Bains, the MySQL SW Development Director 11:55-12:45, Room: Texas 1: "New Features in MySQL 8.0 Replication" by Luis Soares, the MySQL SW/Replication Development Director   14:00-14:50, Room: Texas 1: "MySQL 8.0 Performance: Scalability & Benchmarks" by Dimitri Kravtchuk, the MySQL Performance Architect 17:10-17:35, Room: Texas 7: "LATERAL Derived Tables in MySQL 8.0" by Norvald Ryeng, the Senior SW/Optimizer Development Manager 17:40-18:05, Room: Texas 7: "MySQL Shell: The Best DBA tool? How to Use the MySQL Shell as a Framework for DBAs" by Frederic Descamps, the MySQL Community Manager Thursday, May 30: 14:00-14:50, Room: Texas 1: "Automatic Upgrade and New Error Logging in MySQL 8.0" by Stale Deraas, the MySQL SW Development Director 14:55-15:45, Room: Texas 1: "MySQL Group Replication: The Magic Explained v2" by Frederic Descamps, the MySQL Community Manager. ​​Texas Linux Fest, Austin, TX, US, May 31-Jun 1, 2019 MySQL is a Silver sponsor with a booth & MySQL talks (below) given by David Stokes, the MySQL Community Manager "An Intro to MySQL", scheduled for Friday, May 31 @2:00-5:00pm, "New Features in MySQL for Developers", scheduled for Saturday, June 1 @10:00-10:45am "How to give back to Open Source", scheduled for Saturday, June 1 @4:30-5:15 ​OpenSource Conference, Hokkaido, Japan, May 31-Jun1, 2019 As we already announced MySQL is a Gold sponsor of this OS show. Our MySQL local team is going to staff the MySQL booth in the expo area as well having a MySQL talks as follows:   "MySQL Update + MySQL InnoDB Cluster" given by Daisuke Inagaki, the MySQL Principal Solutions Engineer. His talk is being hold on May 31 @13:55. "MySQL - latest information & peripheral information by Kei Skai & Yoku0825" this talk is given by MyNA (MySQL Nippon Association) by Kei Sakai & Yoku0825, the Vice Presidents of MyNA. The talk is scheduled for June 1 @11:00.​  

Our pleasure to remind everyone about three events which are happening this week and MySQL is part of. Please find them below. PerconaLive, Austin, TX, US, May 28-30, 2019 as we previously announced...

Announcements

Where you can find MySQL in June-July 2019

As continue of our previous announcement from March 14, please find below a list of shows & conferences where you can find MySQL team at: June 2019: OpenSource Conference, Hokkaido, Japan, May 31-June 1, 2019 As we already announced MySQL is a Gold sponsor of this OS show. Our MySQL local team is going to staff the MySQL booth in the expo area as well having a MySQL talks as follows: "MySQL Update + MySQL InnoDB Cluster" given by Daisuke Inagaki, the MySQL Principal Solutions Engineer. His talk is being hold on May 31 @13:55. "MySQL - latest information & peripheral information by Kei Skai & Yoku0825" this talk is given by MyNA(MySQL Nippon Association) by Kei Sakai & Yoku0825, the Vice Presidents of MyNA. The talk is scheduled for June 1 @11:00.  DOAG - Databanken, Dusseldorf, Germany, June 3-4, 2019 MySQL Community Team is Gold sponsor of this Oracle User Community event in June. We are having a booth in the expo area as well as approved MySQL talk on "MySQL Cloud/MySQL Analytic" given by Carsten Thalheimer, the MySQL Master Principal Sales Consultant. See in German DevTalks Romania, Bucharest, Romania, June 6-7, 2019 MySQL Community Team is a Silver sponsor of this show with a MySQL talks & booth in the expo area. This year we are going to share the booth with a Oracle Bronto (NetSuite Development) team. You can find two MySQL talks in the agenda, both given by Georgi Kodinov, the Team Lead, MySQL Server General Team: "What's New in MySQL 8.0 Security" scheduled for June 7 @15:40-16:20 & "MySQL Enterprise Data Masking" scheduled for June 6 @15:40-16:20. We are looking forward seeing & talking to you at DevTalks this year! BGOUG, Pravets, Bulgaria, June 7-9, 2019 As tradition MySQL Community Team & Oracle are the partners of this Bulgarian Oracle User Community event in Pravets. This year the Sr. MySQL Sales Consultant, Vittorio Cioe will be talking about "MySQL InnoDB Cluster: High availability with no stress!". Hong Kong Open Source Conference, Hong Kong, June 14-15, 2019 Again this year we are part of this biggest OS show in Hong Kong. We are Silver sponsor with a MySQL booth in the expo area. Also you can find three MySQL related talks & one talk from Oracle GraalVM on the second day morning MySQL track. We are looking forward talking to you at HKOS this year! SouthEast Linux Fest (SELF), Charlotte, US, June 14-16, 2019 We are again back at SELF as Diamond sponsor this year. We are going to have MySQL booth in the expo area as well as MySQL talk(s) hopefully to be approved. We have submitted several proposals, so please watch organizers website for schedule update to see when & where our talks will be hold. We are looking forward talking to you @SELF 2019! GigaCon - OpenSource Business, Warsaw, Poland, June 18, 2019 For the first time MySQL got an opportunity to share a talking slot with Oracle Linux/Cloud team. Vittorio Cioe, the Sr. MySQL Sales Consultant who represents MySQL will talk about MySQL Enterprise. The joined talking slot is scheduled for Jun 18 @ 10:05-10:25. OpenExpo Europe, Madrid, Spain, June 20, 2019 MySQL Community Team in cooperation with Oracle Linux team are Gold sponsor of OpenExpo Europe this year. You can find our staff at MySQL/Linux booth in the expo area as well as find MySQL & Linux talks in the schedule. For MySQL the talk will be given by Keith Hollman, the MySQL Principal Sales Consultant. Keith's talk on "MySQL 8.0: Highly Available, JSON, NoSQL & Document Store straight out-of-the-box!" is scheduled for Jun 20 @16:40-17:10. DataOps Barcelona, Barcelona, Spain, June 20-21, 2019 MySQL Community Team is a Community sponsor of DataOps Barcelona with a talk on: "Deep dive into MySQL Group Replication: the magic explained" given by Frederick Descamps, the MySQL Community Manager. His talk is scheduled for June 20 @11:30 in the Room A-4. RootConf 2019, Bangalore, India, June 21-22, 2019 MySQL Community team with the local MySQL team are Bronze partner of RootConf this year. We are going to have a MySQL booth in the expo area. We should also have an approved MySQL talk which is not yet in the schedule. Please watch organizers' website for further updates. DevConf, Moscow, RF, June 21-22, 2019 It is our pleasure to announce that one of submitted MySQL talk was accepted by DevConf conference Moscow this year! Please do not miss the opportunity to hear more about "NoSQL + SQL = MySQL 8 Document Store!" given by Vittorio Cioe, the Sr. MySQL Sales Consultant. Vittorio's talk is scheduled for Jun 26th @12:30pm.  Devoxx, Krakow, Poland, June 24-26, 2019 Oracle is a sponsor of this show and MySQL will be part of the central Oracle booth in the expo area among the Java, Graal VM, Fn & Linux teams. We are going to run MySQL demo at the demo station and our MySQL expert, Vittorio Cioe, the Sr. MySQL Sales Consultant will be there to answer your questions and discuss the MySQL topics.  MySQL User Group Frankfurt - Meetup, Germany, June 27, 2019 MySQL User Group Frankfurt organizes a Meetup with Carsten Thalheimer, the MySQL Master Principal Sales Consultant as a speaker. Carsten will talk about "MySQL 8 - The Next big Thing!" and the talk should start @7pm. Please find more details here. July 2019: Oracle Global Partnership Summit, Munich, Germany, July 9-11, 2019 Oracle University is hosting its first ever Global Partner Summit July 9-11 in Munich, Germany. Partners will have the opportunity to hear directly from Oracle Product and Oracle University leadership on FY20 strategy and product roadmaps, helping partners identify new market opportunities and also learn ways grow their business with Oracle. Rich Mason, the Senior VP and General Manager for MySQL will have a keynote & Carsten Thalheimer, the MySQL Master Principal Sales Consultant will run a technical session during this 3 day Oracle event. Learn more about the event and register now! MySQL User Group Munich - Meetup, Germany, July 11, 2019 MySQL User Group Munich organizes a Meetup with Carsten Thalheimer, the MySQL Master Principal Sales Consultant as a speaker. Carsten will talk about "MySQL 8 - The Next big Thing!" and the talk should start @7:30pm.  OpenSource Conference, Nagoya, Japan, July 13, 2019 MySQL Community team in cooperation with local MySQL are Gold sponsor of this OS show in Nagyoa. You can find us at the MySQL booth in the expo area as well as find MySQL talk in the schedule as follows: "MySQL Update" by Machiko Ikoma, the MySQL Principal Solution Engineer. We look forward talking to you at OSC Nagyoa! FOSS4G Hokkaido, Japan, July 12-13, 2019 MySQL is a partner of OSGeo.JP group which is organizing FOSS4G event. At this moment we are working on the seminar topic as well as on other benefits MySQL will get. Please stay tuned for further updates.​

As continue of our previous announcement from March 14, please find below a list of shows & conferences where you can find MySQL team at: June 2019: OpenSource Conference, Hokkaido, Japan, May 31-June...

MySQL Community Contributor Award Program 2019

We would like to announce that MySQL Community Team 2019 MySQL Contributor Reward Program winners. This award started in 2015 to identify & reward the most active community members from the MySQL Community world. MySQL Community Team let printed a limited edition of “MySQL Community Contributor” t-shirts which were already distributed to almost all winners. Same as in 2015 also now specific criteria for the nominations were wet as follows: The most active code contributor Bug reporter The most active MySQL blogger People who plays very active role in translation/documentation of MySQL articles People who provides feedback on DMR releases, Labs releases, or change proposals Anyone in the community who worked their butt off or did really useful work that you feel should be thanks publicly We are happy to announce that the people below successfully met one or more criteria above, were nominated by MySQL group and approved by our committee, please join us to congratulate to them! Laurynas Biveinis for a lot of code contributions & bug submissions Daniel Black for multiple of his code contributions & bug submissions René Cannaò for ProxySQL & for his continuous support of it Vin Chen @Tencent Games CROS DBA Team for the Instant Add Column as a main contribution to MySQL 8.0 Daniel Van Eeden, the MySQL ACE for a lot of code contributions in a lot of areas (connectors, the server, etc.), and the detailed feedback for the bugs or issues he found Gabriela D'Ávila Ferrara for interesting blogs about MySQL Bill Karwin for his active role on many MySQL forums (MySQL, Stack Overflow, Quora, &c.), as well as for multiple speeches focusing on all things SQL Alexey Kopytov for the new Sysbench code (the #1 tool for MySQL Performance evaluation) Felix Liang @Tencent Games CROS DBA Team for his active role in ACMUG (Chinese MySQL User Group) and contributions to the Instant Add Column in MySQL 8.0  Tomita Masahiro for supporting MySQL community and for the MySQL Parameters tool Giuseppe Maxia for the amazing feedback provided to us, for his blog posts & for dbdeployer Simon Mudd for his active role in Madrid MySQL UG and, for a number of bugs submitted, for contributing the original logging to syslog, and other tools such ps-top Shlomi Noach for delivering open source solutions to solve cases around MySQL and for multiple MySQL talks as well as for the tooling within the MySQL space, such as MySQL orchestrator and ghOST Zsolt Parragi for a lot of code contributions & bug submissions Alex Rubin for extensive testing of our new DD code and for bug submissions Sveta Smirnova for popularization of MySQL Performance Schema, general MySQL troubleshooting and promoting new mysql features Yura Sorokin for a lot of code contributions & bug submissions Sugu Sougoumarane for running Vitess.io and helping the users on multiple places Peter Zaitsev for his active role in MySQL world as well as for his contributions to MySQL Community Please join us to congratulate to all above!   

We would like to announce that MySQL Community Team 2019 MySQL Contributor Reward Program winners. This award started in 2015 to identify & reward the most active community members from the MySQL...

Announcements

Shows w/ MySQL this week

Just a friendly reminder for the busy week we have ahead of us... Please find below the shows you can find our MySQL staff at: First show where you can fid us at is the Oracle Code in Shenzen, China 2019, April 16, 2019  ​JSON is one of the flexible data for data exchange and storage today. MySQL X-DevAPI introduces a new modern and easy-to-learn way to work with JSON and Relational data.  Do not miss the MySQL session scheduled for 4:05pm - 4:50pm as follows: "NoSQL @ MySQL - Managing JSON Data with reliable and secured MySQL Database" by Ivan Ma, from Oracle MySQL Team & Zhou Yin Wei - Oracle MySQL ACE Director ​Second show is OpenSource 101, Columbia, SC, US, April 18, 2019 ​MySQL & Oracle Back-end IT solutions group are together attending this show. Find us at the shared booth in the expo area as well as do not miss following MySQL talk: "MySQL 8.0 New Features" by David Stokes, the MySQL Community Manager (Apr 16@1:30-2:15pm, 1C Conference Room) ​Last conference with MySQL is OpenSource Conference Okinawa, Japan, April 20, 2019 ​Do not miss the MySQL talk focused on the newest trends in MySQL development and demonstration of MySQL Document Store with Java App. The talk is given by Yoshiaki Yamasaki, the MySQL GBU. Come to talk to us at our MySQL booth in the expo area as well!  

Just a friendly reminder for the busy week we have ahead of us... Please find below the shows you can find our MySQL staff at: First show where you can fid us at is the Oracle Code in Shenzen, China...

Announcements

Where you can find MySQL in April & May 2019

.As a continue of the blog post submitted on Jan 31, we would like to share with you the list of events & conferences where you can find MySQL Community team and/or MySQL experts at. Please find below the list with all known details we have right now.  April 2019: Oracle Code, Rome, Italy, April 4, 2019 A MySQL talk was accepted for this Oracle show. Please find a talk on "NoSQL+SQL=MySQL" given by Frederick Descamps, the MySQL Community Manager. DrupalCon, Seattle, US, April 8-10, 2019 This time you can find a talk of "MySQL 8 Features for Developers" given by David Stokes, the MySQL Community Manager. PyTexas, Austin, TX, April 13-14, 2019 We are again proud to sponsor PyTexas and will have a booth there, so you can see new features in MySQL 8.0 and MySQL Document Store. FOSS4G, San Dieago, US, April 15-18, 2019 We are happy to inform you that a MySQL talk was accepted for FOSS4G-NA conference! Please find following session in the agenda: MySQL & GIS" by David Stokes, the MySQL Community Manager. His talk is scheduled for Apr 17 @11:30-12:00pm. Oracle Code, Shenzhen, China, April 16, 2019 "How to Write an Efficient SQL" by Ting Yu Yang, the MySQL SE. The talk is scheduled for 12:20-13:05. OpenSource 101, Columbia, SC, US, April 18, 2019 We are happy to announce that MySQL together with the Oracle back-end IT solutions group are going to be part of this show. You can find both groups at the Oracle/MySQL stand as well as attend MySQL talk as follows: "MySQL 8.0 New Features" given by David Stokes, the MySQL Community Manager. Talk is scheduled for 1:30-2:15pm in the 1C Conference Room We are looking forward talking to you at OS 101! OpenSource Conference Okinawa, Japan, April 20, 2019 As a tradition we are again Gold sponsor of this OS show this time in Okinawa. As usual you can find our team at MySQL booth in the expo area as well as find our MySQL talk in the schedule. We are looking forward to talking to you and seeing you at the MySQL session! Great Indian Developer Summit (GIDS), Bangalore, India, April 22-26, 2018 Oracle is going to be a sponsor of GIDS and MySQL is invited to be part of the Oracle's booth in the expo area.  Since the schedule is not yet done, please watch the organizer's website for the update on the MySQL talk in DATA track on "MySQLaaS and RAPID". We are looking forward to talking to you at GIDS this year! LinuxFest Northwest, Bellingham, US,  April 26-28, 2019 We are happy to be part of of this Linux show again. This year we are again Gold sponsor with a MySQL booth in the expo area and the talk as follows: "7 Database Mistakes You Are Making and MySQL 8 Features for Developers" given by David Stokes, the MySQL Community Manager. Since the schedule is not yet announced, please watch organizer's website for further updates. We are looking forward seeing you again and talking to you @LinuxFest Northwest! ​May 2019: Longhorn PHP, Austin, TX, US, May 2-4, 2019 This year for the second time we are Gold sponsor of Longhorn PHP show in Austin, Texas. Same as last year you can find us at MySQL booth in the expo area as well as you can find MySQL talk in the schedule as follows: "MySQL 8 Features for Developers" given by David Stokes, the MySQL Community Manager. His talk is scheduled for May 3, 2019 @2:15-3:15pm. Please do not forget to stop by at our booth, we are looking forward to talking to you there! PyConX, Florence, Italia, May 2-5, 2019 This year MySQL Community team is a Patron sponsor of this Python conference in Florence. This time without a booth but you can find a MySQL session in the schedule as follows: "Python and the MySQL Document Store" given by Frederic Descamps, the MySQL Community Manager. His talk is scheduled for Friday, May 3 @11:15 - 12:00. OpenSource Day, Warsaw, Poland, May 14, 2019 This is our third time participating and sponsoring OpenSource Day in Warsaw Poland. This year again MySQL is having a booth as well as a talk given by Vittorio Cioe, the MySQL Senior Sales Consultant. Vittorio will hold a session on "MySQL InnoDB Cluster: High Availability with no stress!" topic. Please watch organizer's website for further updates, We are looking forward to seeing & talking to you at OS Day Poland this year! PHPTek19, Atlanta, US, May 21-23, 2019 The MySQL Community team is again a proud sponsor of this great event. OpenSUSE, Nuremberg, Germany, May 24-26, 2019 As a tradition MySQL is part of the OpenSUSE conferences. This year we are again Silver sponsor but unfortunately without any talk. You can find us at the MySQL booth in the expo area. Please do not hesitate to come to our booth to discuss MySQL questions & news! PerconaLive, Austin, TX, US, May 28-30, 2019 MySQL Community team is a Silver sponsor of PerconaLive in Austin. You can find our staff at the MySQL booth in the expo area as well as find plenty of MySQL talks there. Below you can find just the ones given by our team members: Tuesday, May 28: MySQL Tutorial on: "MySQL InnoDB Cluster in a Nutshell: The Saga Continues with 8.0, the full guide", given by Frederic Descamps, the MySQL Community Manager & Kenny Gryp. The room & time is still not confirmed. Please watch organizer's website for further updates. Wednesday, May 29: 11:00-11:50: "Complex Stateful Applications Made Easier with Kubernetes" by Patrick Galbraith, the Principal Member of MySQL development 11:00-11:50: "InnoDB Management and Scalability Improvements in MySQL 8.0" by Sunny Bains, the MySQL SW Development Director 11:55-12:45: "New Features in MySQL 8.0 Replication" by Luis Soares, the MySQL SW/Replication Development Director  14:00-14:50: "MySQL 8.0 Performance: Scalability & Benchmarks" by Dimitri Kravtchuk, the MySQL Performance Architect 17:10-17:35: "LATERAL Derived Tables in MySQL 8.0" by Norvald Ryeng, the Senior SW/Optimizer Development Manager 17:40-18:05: "MySQL Shell: The Best DBA tool? How to Use the MySQL Shell as a Framework for DBAs" by Frederic Descamps, the MySQL Community Manager Thursday, May 30: 14:00-14:50: "Automatic Upgrade and New Error Logging in MySQL 8.0" by Stale Deraas, the MySQL SW Development Director 14:550-15:45: "MySQL Group Replication: The Magic Explained v2" by Frederic Descamps, the MySQL Community Manager. We are looking forward being part of this show and invite you to come to talk to our team at PerconaLive Austin! Texas Linux Fest, Austin, TX, US, May 31-June 1, 2019 We are happy to announce that MySQL is going to be a Silver sponsor of this show & hopefully we will get at least one speaking slot approved by organizers. The schedule is not yet done, so please watch organizers website for further updates. OpenSource Conference, Hokkaido, Japan, May 31-June 1, 2019 As a tradition MySQL is a Gold sponsor of this OS show in Japan. Our local MySQL team is going to staff & hold the MySQL booth as well as the MySQL session. Please watch the organizer's website for further updates. More will come soon...  

.As a continue of the blog post submitted on Jan 31, we would like to share with you the list of events & conferences where you can find MySQL Community team and/or MySQL experts at. Please find...

Announcements

FOSSASIA Summit 2019 with MySQL

MySQL Community with an APAC MySQL team are going to be part of the FOSSASIA Summit this week. We are a Bronze sponsor with a MySQL booth in the exhibition area. We are also having several talks in the Database track on Saturday, March 16, please see some of them below together with the details about the show: Name: FOSSASIA Summit 2019 Place: Singapore Date: March 14-17, 2019 MySQL talks in Database Track on Mar 16 in Training Room 2-1: "Replication: What's New in MySQL 8.0" by Narendra S Chauhan, the Principal Technical Staff @Replication Development team. The talk is scheduled for 10:55-11:20. "Upgrading to MySQL 8.0+, a more automated experience" by Nisha Gopalakrishnan, the Principal Technical Staff @MySQL Server Development team. The talk is scheduled for 11:25-11:50. "Performance Schema - A great insight of running MySQL Server" by Mayank Prasad, the Principal Technical Staff @MySQL Development team. The talk is scheduled for 14:00-14:25 "Docker Compose Setup for MySQL InnoDB Cluster" by Balasubramanian Kandasamy, the Senior Software Development Manager in MySQL Release Engineering team. Talk is scheduled for 14:30-14:55. "Utilize and take advantage of Optimizer Features in MySQL 8.0" by Amit Bhattacharya, the Senior SW Development Manager @MySQL Optimizer, InnoDB, Runtime & Server Testing team. Talk is scheduled for 15:00-15:25. "MySQL NDB Cluster: Set up a shared nothing high availability cluster in 15 minutes" by Saroj Tripathy, the QA Architect for MySQL Cluster team. Talk is scheduled for 15:45-16:10. "Using JSON in MySQL to get the best of both worlds (JSON + SQL)" by Chaithra Gopalareddy, the Senior Principal Member Technical Staff @MySQL Development. Talk is scheduled for 16:15-16:40. "Improving Database Security with MySQL 8.0" by Harin Nalin Vadodaria, the Principal MTS with MySQL engineering team. Talk is scheduled for 16:45-17:10. and more in the Database track... We are looking forward to meeting & talking to you @FOSSASIA Summit 2019!!!

MySQL Community with an APAC MySQL team are going to be part of the FOSSASIA Summit this week. We are a Bronze sponsor with a MySQL booth in the exhibition area. We are also having several talks...

Announcements

Where you can find MySQL in February & March 2019!

We continue with announcing the upcoming shows & conferences where you can find MySQL Community or MySQL Experts at. Please find the list of events with details below.  February 2019: FOSDEM 2019, Brussels, Belgium, February 1& 2-3, 2019 MySQL is again part of FOSDEM. Again this year with a MySQL booth & the whole day of MySQL dedicated talks in the MySQL track, see schedule here. There is also MySQL Pre-Fosdem Day followed by MySQL Pre-Fosdem Dinner, both planned for February 1, 2019. See more details in Fred Descamps' blog. We are really looking to meeting you at this biggest OS show in Europe! ​SunShine PHP, Miami, FL, US, February 7-9, 2019 MySQL Community team is going to be Bronze sponsor of this show with a MySQL table, MySQL tutorial and session given by David Stokes, the MySQL Community Manager & Kathy Forthe, the Solutions Architect for MySQL. Please do not miss the opportunity to talk to Dave & Kathy, attend the tutorial and sessions as follows: Tutorial: "The MySQL Document Store", scheduled for Feb 7th, 2019 @9:00-12:00 (Dave Stokes) Session: "The MySQL Document Store", scheduled for Feb 8th, 2019 @16:00-17:00 (Dave Stokes) Session: "Driving Innovation with MySQL 8.0 and Docker" scheduled for Feb 9th, 2019 @11:30-12:30 (Kathy Forte) We are looking forward to meeting you at SunShine PHP! PHP UK, London, UK, February 20-22, 2019 MySQL Community team took the opportunity to become a Silver sponsor here. This time we have no booth but a talk on "Hybrid Databases - How De-normalizing Your Data with JSON Can Boost Query Performance" given by David Stokes, the MySQL Community Manager. Please do not miss Dave's talk @PHP UK! PyCon Philippines, Makati, PH, February 23-24, 2019 MySQL is a Gold sponsor of this show with a MySQL booth & session allocated to us. You can find our booth in the expo area, please meet there MySQL staff & our local Partner IT Group there to discuss MySQL related topics. You can also find a MySQL talk on "NoSQL+SQL=MySQL" in the schedule. Talk is given by Ronen Baram, the MySQL Principal Solution Consultant.  March 2019: Southern California Linux Expo 2019 (ScaLE), Pasadena, US, March 7-10, 2019 As a tradition we are again part of ScaLE 2019 as Gold sponsor with booth & MySQL talks. Please stop by at our MySQL booth and do not miss the MySQL talks which all are scheduled for March 8th, Room 101. You can find there multiple presenters, from MySQL/Oracle team, you can find following presentations: "MySQL Document Store - A NoSQL JSON Document Database" given by David Stokes, the MySQL Community Manager. His talk is scheduled for Mar 8th, 2019 @10:00-11:30 "MySQL Security - Avoid Getting on the Front Page!" given by Michael Marx, the MySQL Senior Sales Consultant. His talk is scheduled for Mar 8th, 2019 @16:30-17:30. FOSSASIA, Singapore, March 14-17, 2019 MySQL Community with an APAC MySQL team are going to become a Bronze sponsor of this OS show in Singapore. We are going to have a MySQL booth at this show as well as several talks in the MySQL dedicated track. The schedule is not yet done, but in general there are already 9 MySQL related talks accepted and much more will come. Please watch organizers' website as well as further more details announcement about our involvement in FOSSASIA. Further events will come up later on.

We continue with announcing the upcoming shows & conferences where you can find MySQL Community or MySQL Experts at. Please find the list of events with details below.  February 2019: FOSDEM 2019,...

Announcements

MySQL Enterprise Monitor 8.0.14 has been released

The MySQL Enterprise Tools Development Team is pleased to announce the maintenance release of MySQL Enterprise Monitor 8.0.14 is now available for download on the My Oracle Support (MOS) web site. It will also be available for download via the Oracle Software Delivery Cloud in a few days. If you are not familiar with MySQL Enterprise Monitor, it is the best-in-class tool for monitoring and management of your MySQL assets and is part of MySQL Enterprise Edition and MySQL Cluster Carrier Grade Edition subscriptions. You are invited to give it a try using our 30-day free customer trial. Go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Highlights Redesigned Query Analyzer The user interface of the Query Analyzer has been redesigned, improving navigation and introducing advanced configuration options. It is now possible to customize the Query Analyzer graph and data visualization, sorting and filtering by clicking on Configure View button. When you click on a SQL statement, the Statement Details page now lets you browse all example statements in the specified time range (rather than just being shown the one with the worst run time). Drill into any of these examples to see their individual statistics, literals used, and EXPLAIN plan. Scrolling down the page, graphs show you the execution pattern of the selected query during the specified time period.  MySQL Enterprise Monitor collects non-normalized examples of statement executions each minute when collecting aggregate statement statistics. You can visualize the latency of these Examples over the specified time period in the new Statement Distribution Chart. Each point on the chart represents a specific example statement execution time. Statements with an associated EXPLAIN plan are represented by a circle in the Distribution Chart. Points which are a square had no EXPLAIN plan captured for them. The red circle or square is the SQL statement that had the longest execution time for the specified period. Clicking on a Statement Example within the Distribution Chart shows its query text in the original form, some additional execution context information, and its EXPLAIN plan.     Deleting Assets from the Inventory The MySQL Enterprise Monitor Inventory user interface got a new functionality to remove assets. Now you can select and delete one or multiple entries for clusters, topologies, agents, hosts, and instances which were monitored, but are no longer in use. Note deleting assets only removes them from the inventory, and it does not remove or uninstall assets from their installed locations.  New Views for Agents and Hosts You can now examine the configuration and current status of Agents and Hosts in great detail. The Agents view shows the MySQL Enterprise Monitor Agents currently registered with the MySQL Enterprise Service Manager. On a single screen, you see relevant information about the health of multiple agents, their versions, the number of assets monitored by each agent, last contact time, MySQL instances uptimes, versions, and data dir. You can go further and check more details of a specific agent by selecting its More Info button. The Agent details view displays JVM configuration and status, details on all MySQL connections, processes, instances, and detailed information on the host's operating system. The Hosts view shows all currently monitored hosts and their configuration. The Hosts view allows you to quickly inspect different hosts hardware configurations, their Operating Systems, number of filesystems, and number of monitored MySQL instances. To drill-down and see more details of a host, select its corresponding More Info button. In the Host detail view, you see all the filesystems, the MySQL instances, and greater detail of the hardware configuration such as RAM, CPUs, and network interfaces. Additional NDB Clusters Views The new NDB Clusters configuration view complements the NDB Cluster monitoring with the visualization of all currently monitored clusters, their membership, and configurations. The top-level list summarizes the NDB Cluster topology by displaying the number of Management, API and Data Nodes with their number of replicas. It also shows if the cluster is running on diskless mode. To inspect the status and configuration details of the NDB Cluster nodes, select the More Info button. Memory Usage The Global Memory Usage report builds upon the Memory instrumentation exposed within Performance Schema to provide greater insight into where memory is being allocated within the MySQL Instance - not just at the InnoDB Buffer Pool level, but for all memory allocations, across all connections and threads within MySQL. The report breaks down memory by allocation types, such as memory allocated for sorting, the buffer pool, or various other internal buffers used for statement processing. MySQL Server 8 MySQL Enterprise Monitor 8.0 supports monitoring MySQL Server 8.0.11+, so you can monitor MySQL Server from version 5.5 onwards. MySQL Enterprise Monitor 8.0 also has MySQL Server 8.0 as its bundled repository or you can also use MySQL Server 8.0 as an external data repository.  Download To download MySQL Enterprise Monitor, go to My Oracle Support, choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. You will also find the binaries on the Oracle Software Delivery Cloud soon. Type "MySQL Enterprise Monitor 8.0.14" in the search box. More info and feedback You can find more on the "What's New" section of the manual and more information on the contents of the 8.0.14 maintenance release in the changelog. Please open a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. Thanks and Happy Monitoring! Useful links What's New in 8.0 Changelog Installation documentation Product information Frequently Asked Questions

The MySQL Enterprise Tools Development Team is pleased to announce the maintenance release of MySQL Enterprise Monitor 8.0.14 is now available for download on the My Oracle Support (MOS) web site. It...

Announcements

Where you can find MySQL in January 2019!

We would like to continue with announcing the shows where you can find & meet MySQL Community members or MySQL experts. Please find the list below (this time only for January 2019). Further events will come up later on. Oracle OpenWorld UK/EMEA, London, UK, Jan 16-17, 2019 MySQL team is going to be part of this Oracle show in London. You can visit Oracle/MySQL booth in the Zone 2-O and you can attend a talk given by Mark Swarbrick, the MySQL Principle Presales Consultant as follows: MySQL 8.0: Top 10 Features for DBAs and Developers scheduled for Wed, Jan 16, 2019, 15:10-15:55, @Arena 6 (level 3) - ExCeL London We are really looking forward to talking to you there! MySQL Innovation Day, Stockholm, Sweden, Jan 23, 2019 If you are local, do not miss this one-day Innovation MySQL Day which main topic is: MySQL supports SQL & NoSQL! At this Innovation event you can experience first-hand how innovations, such as MySQL Document Store, InnoDB Cluster or Replication enable businesses to reach new levels of agility while embracing a database platform that delivers industry leading performance, reliability, and scalability... Since it is "invitation" only event and space is limited, please register as soon as possible! Whole agenda is available here. PHP Benelux, Edegem, Belgium, Antwerp, Jan 25-26, 2019 This year a MySQL talk was approved and will be presented by Dave Stokes, the MySQL Community Manager. His talk is on "PHP, The X Devapi, and the MySQL Document Store". Dave's talk is scheduled for Friday, Jan 25th @17:10-18:10 in Track B. Do not miss the opportunity to listen Dave's talk @PHP Benelux! OpenSource Conference Osaka, Japan, jan 25-26, 2019 as tradition MySQL is a Gold sponsor with a booth and MySQL talk. Do not miss the opportunity to discuss news about MySQL at our booth in the expo area and please check the organizer's website for the MySQL talk!  

We would like to continue with announcing the shows where you can find & meet MySQL Community members or MySQL experts. Please find the list below (this time only for January 2019). Further events...