X

MySQL and MySQL Community information

Recent Posts

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...

Announcements

Nov 5 -> Busy week for MySQL: where you can find us now?

as announced in the blog posted on Oct 18, 2018 we would like to just remind you about places and shows where you can find us this really busy week... We are ready for following shows: PerconaLive in Frankfurt, Germany on November 5-7, 2018 as previously announced there are plenty of our MySQL experts, our friends from sales & Fred Descamps representing MySQL community at PerconaLive, Frankfurt which started today. Right now Fred Descamps & Kenny Grip are having a tutorial on "MySQL InnoDB Cluster in a Nutshell : The Saga Continues with 8.0" which ends before noon. Also there are plenty of MySQL talks (you can check them either on the previous blog post or directly at PerconaLive website). From today's noon the expo is also open. MySQL is having a new designed booth there with our staff. Come to talk to us! We are looking forward to meeting you there! PHP.RUHR, Dortmund, Germany on November 8, 2018 Next show where you can find us is PHP.RUHR. This is the third time we are supporting this one-day show and same as last year we are having a MySQL talk (in Mainstage: Developer on "MySQL 8.0 - The new Developer API") & Q&A session in the expo area where you can come to ask our MySQL speaker, Mario Beck MySQL related questions.  Come to listen the news in MySQL 8.0 & talk to Mario at PHP.RUHR! ​​Highload++, Moscow, Russia on November 8-9, 2018 We are really excited about being part of this big technology show in Russia. Last week we finally got a notification about that our MySQL talk was accepted so, you can find that talk in the conference schedule as follows: "MySQL 8.0: SQL and NoSQL Scalability" given by Vittorio Cioe. Talk is scheduled for Nov 8th @14:00 Do not forget to stop by at our MySQL booth in the expo area. We are planning to have quiz for a MySQL prizes as well as InnoDB Cluster demo given by Vittorio on the first day and quiz followed by MEM demo given by Vittorio on the second day at our booth. Check the organizers' website & schedule for further updates & for sure come to our booth and MySQL session to get the latest MySQL updates and news. We are looking forward to talking to you at Highload++!!        

as announced in the blog posted on Oct 18, 2018 we would like to just remind you about places and shows where you can find us this really busy week... We are ready for following shows: PerconaLive in F...

Where you can find MySQL in October - December 2018 - part 2.

As a continue of the previous blog announcement posted on Oct 16, please find below a list of conferences & events where you can find MySQL team &/or MySQL Community during the period of Oct-Dec 2018: November 2018 - cont. PerconaLive, Frankfrurt Germany, November 5-7, 2018 We are happy to inform that MySQL is going to be Silver sponsor of PerconaLive Europe 2018! You will be able to find us on the MySQL booth in the expo hall as well as attend multiple MySQL talks given by our colleagues. The talks are scheduled as follows: Tutorial on: "MySQL InnoDB Cluster in a Nutshell : The Saga Continues with 8.0" by Frédéric Descamps, the MySQL Community Manager, scheduled for Monday, @9:00am-12:00pm. "MySQL 8.0 Performance: Scalability & Benchmarks" by Dimitri KRAVTCHUK, the Performance Architect, talk is scheduled for Tuesday @12:20-13:10. "MySQL Group Replication: the magic explained" by Frédéric Descamps, the MySQL Community Manager, scheduled for Tuesday @14:20-15:10. "Upgrading to MySQL 8.0 and a More Automated Experience" by Dmitry Lenev, the Senior Software Developer, scheduled for Tuesday @ 15:20-16:10. "More SQL in MySQL 8.0" by Norvald Ryeng, the Senior Developer Manager - Optimizer Team, scheduled for Tuesday 17:25-17:50. "The Latest MySQL Replication Features" by Jorge Tiago, the Senior Software Developer, scheduled for Wednesday @14:20-15:10. "Developing Applications with Node.js and the MySQL Document Store" by Johannes Schlüter, the Principal Software Developer, scheduled for Wednesday @17:00-17:25. Come to listen MySQL sessions & stop at our booth to talk to our staff at PerconaLive 2018! PHP.RUHR, Dortmund, Germany, November 8, 2018 MySQL team is going to be part of this technical/PHP show. You can come to listen a MySQL talk in the Mainstage: Developer as: "MySQL 8.0 - The new Developer API" given by Mario Beck, the MySQL Sales Consulting Manger for EMEA. There also will be a Q&A session in the expo area about MySQL, where you can come to ask questions. Highload++, Moscow, Russia, November 8-9, 2018 MySQL team is going to be part of this technical conference in Moscow. You can find us on our MySQL booth in the expo area as well as you should be able to find MySQL talk in the schedule (still not heard about its acceptance). We are looking forward to talking to you @ Highload++ this year!!! SeaGL, Seattle, US, November 9-10, 2018 MySQL community team supports this GNU/Linux conference in Seattle.  PHP[World], Washington DC, US, November 14-15, 2018  MySQL is a Workshop sponsor this year. Unfortunately no talk this year, but we are in the waiting list for lightening talk. Please watch the organizers' website. BGOUG, Pravets, Bulgaria, November 14-15, 2018 As a tradition MySQL is a conference sponsor of this Bulgarian Oracle User Group regular conference. This time with a following talk: "Data Masking in MySQL Enterprise 5.7 and 8" given by Georgi Kodinov, the Senior Software Developer Manager for MySQL.  Please come to listen Georgi's talk as well as ask him questions. DOAG, Nuremberg, Germany, November 20-23, 2018 Same as in previous years we are going to be part of this conference organized by German Oracle User Group. You can find MySQL staff at the Oracle booth (Place 320) as well as attend several MySQL talks. You can find the talks here. Feira do Conhecimento, Fortaleza, Brazil, November 21-24, 2018 The Science, Technology and Higher Education Secretariat (Secitece) will hold the second edition of the Knowledge Fair - Science, Technology, Innovation and Business at the Ceará Event Center (East Pavilion) and we are happy to be part of this event!! A Local MySQL Sales representative will be there to answer all MySQL related questions as well as a MySQL talk on "Innovation, Business & Technology" is approved. Please watch the organizers' website for further updates. PyCon HK, Hong Kong, November 23-24, 2018 MySQL is a Bronze sponsor of this Python show and again this year without booth, but with a MySQL talk on "NoSQL Development for MySQL Document Store using Python" by Ivan Ma, the MySQL Principal Sales Consultant. December 2018 Tech18, UKOUG, Liverpool, UK, December 3-5, 2018 As a tradition MySQL will be part of this Oracle User Group Conference in the UK. You will be able to find our staff at the Oracle booth in the expo area. IT.Tage 2018, Frankfurt, Germany, December 10-13, 2018 Our pleasure to announce that this year MySQL is again part of the IT.Tage event. This time together with Oracle Developer & Linux team. You will have an opportunity to find us all at the shared Oracle booth as well as attend several Oracle's talks.  For MySQL do not miss the opportunity to listen what is new in MySQL 8 during following session: "MySQL 8 - MySQL as a Document Store Database" given by Carsten Thalheimer, the MySQL Principal Sales Consultant, scheduled for December 12, 2018 @ 14:30-15:15 in the Database track.  We are looking forward to talking to you there! OpenSource Conference Fukuoka, Fukuoka, Japan (December 8, 2018) MySQL is Gold sponsor here. You will be able to find us at MySQL booth in expo area as well as find a MySQL talk on "State of Dolphin" given by Yoshiaki Yamasaki, the MySQL Senior Sales Consultant Asia Pacific and Japan region, during the talk general product updates will be covered. OpenSource Enterprise, Tokyo, Japan, (December 14, 2018) Again, MySQL is a Gold sponsor with MySQL booth & talk on the same topic: "State of Dolphin" by Yoshiaki Yamasaki.  We will continue updating you about upcoming events & conferences where you can find MySQL team at.       

As a continue of the previous blog announcement posted on Oct 16, please find below a list of conferences & events where you can find MySQL team &/or MySQL Community during the period of Oct-Dec 2018: N...

Announcements

MySQL Enterprise Monitor 8.0.3 has been released

The MySQL Enterprise Tools Development Team is pleased to announce the maintenance release of MySQL Enterprise Monitor 8.0.3 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. 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.3" in the search box. You can find the highlights of MySQL Enterprise Monitor 8.0 on the "What's New" section of the manual and more information on the contents of the 8.0.3 maintenance release in the change log. Please open a bug or 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 Change log 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.3 is now available for download on the My Oracle Support (MOS) web site. It...

Where you can find MySQL in October - December 2018 - part 1.

We would like to announce the shows & conferences where you can find MySQL Community Team or MySQL representatives at. Please be aware that the list below could be subject of change. October 2018 GITEX, Dubai, United Arab Emirates, October 14-18, 2018 Same as last year Oracle & MySQL are part of GITEX converence. There is an Oracle booth (Stand A5-01, Hall 5) as well as MySQL one (POD2, Hall 5) where you can find us.  ZendCon, Las Vegas, US, October 15-17, 2018 We are Exhibitor sponsor same as last year, however newly this year we are going to have a new very cool booth design! Come to check and talk to us there! Also if you are around, do not miss the sessions by David Stokes, The MySQL Community Manager as follows:  "MySQL without the SQL -- Oh my!" scheduled for today @11:30-12:30pm "MySQL 8 performance tuning" scheduled for tomorrow, Oct 17 @4:00-5:00pm We are looking forward to seeing and talking to you at ZendCon! JCConf, Taipei, Taiwan, October 19, 2018 Same as last year we are again supporting Java Community Conference (JCConf) in Taiwan. This year you can find our staff at Oracle/MySQL booth in expo area and listen following MySQL & Oracle talks: "How MySQL support NoSQL with Java applications" by Ivan Tu, the Principal Sales consultant, MySQL APAC. "GraalVM (polyglot environment supports Oracle, MySQL and Java)" given by Yudi Zheng, Senior researcher at Oracle Lab organization. We are looking forward to talking to you there! Oracle Open World & MySQL Community Reception, San Francisco, October 22-25, 2018 MySQL is again part of the OOW show, please check the website for a MySQL talks in the agenda. And same as last year MySQL Community organizes a MySQL Reception. It is an evening event organized by MySQL Community on October 23rd at Samovar Tea Lounge at 730 Howard St., San Francisco, CA from 7-9 pm.  Join the MySQL team at the MySQL Reception to celebrate the dynamics and growth of the MySQL community! Forum PHP, Paris, France, October 25-26, 2018 We are a Bronze sponsor of Forum PHP this year with an approved talk on: "MySQL 8.0: What's new". Please check the organizers' website for further details JSFoo, Bangalore, India October 26-27, 2018 This is the first time we are attending this JavaScript conference, this year we are having just a talk there. The talk is scheduled for Sat, Oct 27, 2018 @13:40-14:10 with the topic of: "MySQL 8 loves JavaScript". The speaker is Sanjay Manwani, Developer Evangelism at Oracle. November 2018 Madison PHP, Madison, US, November 2-3, 2018 MySQL Community Team is a Community Sponsor of Madison PHP conference this year again. MOPCON 2018, Taipei, Taiwan, November 3-4, 2018 This year for the first time we are going to have a talk at MOPCON 2018. Please do not miss the opportunity to listen the talk given by Ivan Tu, the MySQL Principal Consultant Manager as follows: "The mobile application supported by new generation MySQL 8.0" scheduled for Nov 4, @11:05-11:45am in BigData track. ​​We are looking forward to meeting & talking to you there! ..More shows to be announced soon....

We would like to announce the shows & conferences where you can find MySQL Community Team or MySQL representatives at. Please be aware that the list below could be subject of change. October 2018 GITEX,...

MySQL Enterprise

MySQL Enterprise Monitor 8.0.1 has been released

We are pleased to announce that MySQL Enterprise Monitor 8.0.1 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. MySQL Enterprise Monitor is the best-in-class tool for monitoring and management of your MySQL assets and is included with your MySQL Enterprise Edition and MySQL Enterprise Carrier Grade subscriptions. You can find more information on the contents of this release in the change log. Highlights of MySQL Enterprise Monitor 8.0 include: MySQL Enterprise Monitor 8.0 supports monitoring MySQL Server 8.0.11 and later. You can also use MySQL Server 8.0 as an external data repository for MySQL Enterprise Monitor 8.0. Significant improvements have been made to the performance and user interface of the Query Analyzer. When you click on a SQL statement, the new Statement Details page enables you to browse all example statements in the specified time range, rather than just the one with the worst run time. Drill into any of these examples to see their individual statistics, literals used, and EXPLAIN plan. Graphs display the execution pattern of the selected query during the specified time period. For more information, see Section 30.3.1, "Detailed Query Information". The new 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 type, such as memory allocated for sorting, the buffer pool, or various other internal buffers used for statement processing. For more information, see Section 28.6, "Memory Usage Report". You will find binaries for the new release on 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.1" in the search box, or enter a license name to find Enterprise Monitor along with other MySQL products: "MySQL Enterprise Edition" or "MySQL Cluster Carrier Edition".  Then select your platform. Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 8.0 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 8.0.1 is now available for download on the My Oracle Support (MOS) web site. It will also be available for download via the Oracle Software...

MySQL Enterprise

MySQL Enterprise Monitor 4.0.5 has been released

We are pleased to announce that MySQL Enterprise Monitor 4.0.5 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. Important: MySQL Enterprise Monitor (MEM) 8.0 offers many significant improvements over MEM 3.4 and 4.0 and we highly recommend that you consider upgrading. More information on MEM 8.0 is available here: What's new in MySQL Enterprise Monitor 8.0? MySQL Enterprise Monitor MySQL Enterprise Monitor Frequently Asked Questions MySQL Enterprise Monitor Change History Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 4.0 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 4.0.5 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and...

MySQL Enterprise

MySQL Enterprise Monitor 3.4.8 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.4.8 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. Important: MySQL Enterprise Monitor (MEM) 8.0 offers many significant improvements over MEM 3.4 and 4.0 and we highly recommend that you consider upgrading. More information on MEM 8.0 is available here: What's new in MySQL Enterprise Monitor 8.0? MySQL Enterprise Monitor MySQL Enterprise Monitor Frequently Asked Questions MySQL Enterprise Monitor Change History Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 3.4 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 3.4.8 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and...

Where you can find MySQL in June

As follow up to the previous message posted on June 4, 2018 please find below the shows where you can find MySQL during June this year: DataOps in June 21-22, 2018 in Barcelona, Spain ​MySQL is a Community sponsor of this event where our colleague Fred Descamps, the MySQL Community Manager is having following talk: "MySQL 8.0 Document Store: NoSQL with all the benefits of a RDBMS", scheduled for Jun 21, 2018 @​12:20pm ​​There are also other talks on MySQL which I would really recommend you to attend: ​"A quick tour of MySQL 8.0 roles" by Giuseppe Maxia, scheduled for June 21@11:00 "MySQL High Availability at GitHub" by Shlomi Noach, scheduled for June 21@14:50 "MySQL Group Replication - Ready For Production?" by Kenny Gryp, scheduled for June 21@16:50 "dbdeployer: the future of MySQL sandboxes" by Giusepe Maxia, scheduled for June 22@11:00 ...and much more, see the full schedule here. Hong Kong Open Source Conference, June 16-17, 2018, Hong Kong ​See details in Fred Descamps' blog OpenSource Developer Conference Okinawa, Japan, June 16, 2018, Okinawa, Japan MySQL team is a Gold sponsor of this OS conference with a following MySQL talk given by Yoshiaki Yamasaki, the MySQL Senior Sales Consultant, Asia Pacific & Japan: What's new in MySQL 8.0 PyCon Thailand, Bangkok, June 16-17, 2018, Bangkok, Thailand We are currently Silver sponsor of this PyCon with an approved talk by Ronen Baram, the MySQL Principle Sales Consultant as follows:  "​Build dynamically scaled highly available python application with MySQL", scheduled for Jun 16, 2018 @11:55am. Please find Ronen there for any kind of MySQL discussion. Ronen is always happy to help!  

As follow up to the previous message posted on June 4, 2018 please find below the shows where you can find MySQL during June this year: DataOps in June 21-22, 2018 in Barcelona, Spain ​MySQL is a...

Busy week for MySQL - where you can find us!

This week is going to be a bit busy for MySQL team. We are going to be present at four conferences in Europe and two in the US. Please find them below: ​International PHP Conference, Berlin Germany, June 4-8, 2018 This time we are going to have a booth on the Bronze level in the expo area. The exhibition is only on Jun 5-6, 2018. You can find our colleague Mario Beck, the MySQL Sales Consulting Manager for EMEA at the stand. Come to our MySQL booth!! OpenExpo Europe, Madrid, Spain, June 6-7, 2018 Do not miss to come to the biggest OS show in Madrid! MySQL and Linux team will be there at the shared MySQL&Linux booth in the expo area. Also you can find our talks as follows in the schedule: "The Revolutionary MySQL 8.0" by Abel Florez, the MySQL Technical Account Manager. His talk is scheduled for June 6, 2018 @16:05-16:35. "Operating on your Choice of Hardware, in your Data Center or in the Cloud" by Simon Coter, the Director of Product Management, Oracle VM & VirtualBox. "Oracle Cloud Infrastructure for Cloud Native Applications" by Vittorio Garbuglio, the Cloud Solutions Architect. Come to talk to our experts, we are looking forward to meeting you there! Bulgarian Oracle User Group Conference (BGOUG), Borovets, Bulgaria, June 8-10, 2018 As a tradition we are supporting and actively attending this User Group event organized by the local Oracle User Group. Please do not miss the MySQL talk given by Georgi Kodinov, the MySQL Senior SW Development Manager as follows: "The New Data Dictionary in MySQL 8.0: what does it mean to you?" June 9, 2018 @14:30-15:15 in the Hall Rila 1.  ​DevTalks Bucharest, Romania, June 8, 2018 We got to this show on the last minute! You can find our MySQL staff at MySQL booth in the exhibition area as well as find the MySQL talk given by Vittorio Cioe, the Sr. Sales Consultant, Oracle, MySQL: "Better DevOps with MySQL 8.0", scheduled for June 8, 2018 @14:05-14:50 in the DevOps track We are looking forward to meeting & talking to you there! SyntaxCon, Charlestown, SC, US, June 6-8, 2018 We are attending and speaking at the SyntaxCon conference this year. You can find the MySQL talk in the schedule as follows: "MySQL 8 -- A New Beginning" given by Dave Stokes, the MySQL Community Manager. The talk is scheduled for June 7, 2018 @11:15-12:15pm. Come to listen the MySQL 8.0 news and discuss your questions with Dave @SyntaxCon! Southeast Linux Fest (SELF), Charlotte, US, June 8-10, 2018 As tradition we are going to attend SELF! This year we become Diamond sponsor and you will be able to find us at MySQL booth in the expo hall as well as find following MySQL talks in the two day Zero to DBA Hero track: "20 Years of MySQL, 20 Years of PHP, and 10 Years of SELF - What the heck has been going on?" given by Dave Stokes, the MySQL Community Manager. The talk is scheduled for June 8, 2018 @ 9:00-10:00am. "MySQL Without the SQL - Oh My!" by Dave Stokes, talk is scheduled for June 8 @1:30-2:30 pm. The next shows in June we are attending are: DataOps in June 21-22, 2018 in Barcelona,Spain, Hong Kong Open Source Conference, June 16-17, 2018, OpenSource Conference Okinawa, Japan, June 16, 2018, PyCon Thailand, Bankok, June 16-17, 2018.

This week is going to be a bit busy for MySQL team. We are going to be present at four conferences in Europe and two in the US. Please find them below: ​International PHP Conference, Berlin Germany,...

Announcements

MySQL Cluster 7.6 is now Generally Available

      Bernd Ocklin | MySQL Cluster Engineering Director It gives us great pleasure to announce that the 7.6 release of MySQL Cluster is GA and now ready for prime time.  MySQL Cluster is a distributed database combining linear scalability and high availability. An ultra-high speed database, MySQL Cluster provides in-memory real-time access with transactional consistency across partitioned and distributed data sets designed for highly available mission critical applications. MySQL Cluster’s shared nothing architecture delivers an incredible 99.9999% availability and is used within the core of systems that serve billions of mobile phone users, leading online-games and high demand web services.  This new MySQL Cluster 7.6 version is all about supporting and optimizing performance on the latest off the shelf hardware, increasing its ability to both scale up on ever performant hardware and scale out within and across data centers, while at the same time increasing ease of use and lowering maintenance overhead. MySQL Cluster 7.6 now enables databases sizes beyond tens of Terabytes on modern hardware and with awareness and optimization for cloud infrastructures.  MySQL Cluster’s disk recovery system has undergone a complete redesign, dramatically improving restart and recovery times by up to 4x. A host of algorithms in version 7.6 have greatly improved concurrency and load balancing making optimized use of all hardware resources available. New and improved parallel query processing runs distributed cross-shard (partitioned) joins often doubling performance.  To make it simpler to move data into the MySQL Cluster we have added a new import tool, designed to load massive data files in cluster at maximum parallel speed, increases your ability to blast data into your MySQL Cluster Databases. New inter node connectors move traffic between co-located nodes from the network stack to faster shared memory, significantly improving performance by lowering latency. Availability domains now make cluster cloud infrastructure topology aware allowing for seamless optimal query routing. To learn more about the features added please check  https://mysqlhighavailability.com/mysql-cluster-7-6-is-ga  Download Now >>  https://dev.mysql.com/downloads/cluster/ 

      Bernd Ocklin | MySQL Cluster Engineering Director It gives us great pleasure to announce that the 7.6 release of MySQL Cluster is GA and now ready for prime time.  MySQL Cluster is a distributed...

MySQL Enterprise

MySQL Enterprise Monitor 4.0.4 has been released

We are pleased to announce that MySQL Enterprise Monitor 4.0.4 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. Important: MySQL Enterprise Monitor (MEM) 8.0 offers many significant improvements over MEM 3.3, 3.4, and 4.0 and we highly recommend that you consider upgrading. More information on MEM 8.0 is available here: What's new in MySQL Enterprise Monitor 8.0? MySQL Enterprise Monitor MySQL Enterprise Monitor Frequently Asked Questions MySQL Enterprise Monitor Change History Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 4.0 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 4.0.4 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and...

MySQL Enterprise

MySQL Enterprise Monitor 3.4.7 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.4.7 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. Important: MySQL Enterprise Monitor (MEM) 8.0 offers many significant improvements over MEM 3.3, 3.4, and 4.0 and we highly recommend that you consider upgrading. More information on MEM 8.0 is available here: What's new in MySQL Enterprise Monitor 8.0? MySQL Enterprise Monitor MySQL Enterprise Monitor Frequently Asked Questions MySQL Enterprise Monitor Change History Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 3.4 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 3.4.7 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and...

MySQL Enterprise

MySQL Enterprise Monitor 3.3.9 has been released

We are pleased to announce that MySQL Enterprise Monitor 3.3.9 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log. You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet. Important: MySQL Enterprise Monitor (MEM) 8.0 offers many significant improvements over MEM 3.3, 3.4, and 4.0 and we highly recommend that you consider upgrading. More information on MEM 8.0 is available here: What's new in MySQL Enterprise Monitor 8.0? MySQL Enterprise Monitor MySQL Enterprise Monitor Frequently Asked Questions MySQL Enterprise Monitor Change History Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 3.3 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are pleased to announce that MySQL Enterprise Monitor 3.3.9 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and...

List of Conferences & Events w/ MySQL, April - June 2018! - continued

As an update to the blog posted on April 4, 2018 we would like to update the list of events where you can find MySQL. Please see the four new conferences below:  DevTalks, Cluj-Napoca, Romania, May 16, 2018 MySQL became a customized sponsor of this show. We will have  MySQL keynote given by Georgi Kodinov, the MySQL Senior SW Development Manager. We are still working on the topic, please watch the organizers’ website for further updates.  SyntaxCon,  Charleston, SC, US, June 6-8, 2018   MySQL Community team is going to be Bronze sponsor of SyntaxCon conference. This time we are going without booth, but with already approved MySQL talk. Please find the talk in the schedule, David Stokes, the MySQL Community Manager will be talking about “MySQL 8 - A New Beginning”. Talk is scheduled for Thursday, June 7 @1:15pm   PyCon Thailand, Bangkok, Thailand, June 16-17, 2018  MySQL is going to support & attend this conference. This time we are going without booth, but with "on site" staffing by Ronen Baram, the Principal Sales Consultant. Ronen also submitted a MySQL talk and we hope it will be approved. Please watch organizers website for further updates.   DataOps Barcelona, Spain, June 21-22, 2018 We are happy to announce that MySQL Community team is going to be Community sponsor of DataOps Barcelona. The MySQL Community Manager, Fred Descamps will be talking about MySQL 8.0, Cluster & Document store. Please do not miss his and others' well known MySQL speakers's talks which will be announced in the schedule section of the conference website. Please be aware that the list does not have to be final, during the time more events could be added or some of them removed. We will keep you informed!    

As an update to the blog posted on April 4, 2018 we would like to update the list of events where you can find MySQL. Please see the four new conferences below:  DevTalks, Cluj-Napoca, Romania, May...

MySQL Enterprise

Backup of External Tablespaces in MySQL 8.0

Introduction We can categorize the InnoDB tablespaces created by users, broadly in following categories. File-per-table Tablespace - A single, file-per-table tablespace created in the datadir, which contains only one table. General Tablespace   - A shared tablespace created in the datadir, which may contain multiple tables. External File-per-table Tablespace - A single, file-per-table tablespace created outside of the datadir, which contains only one table. External General Tablespace - A shared tablespace created outside of the datadir, which may contain multiple tables. External tablespaces are sometimes called remote tablespaces, but both refer to a single or shared, file-per-table tablespace outside of the datadir. Prior to MySQL 8.0, the server creates an InnoDB Symbolic Link (*.isl) file in the datadir to locate the external tablespaces. MEB copies the *.isl files as *.bl files into the backup for those MySQL server versions.  At the time of copy back, MEB copies the *.bl files to the target datadir as the *.isl files. It then copies the corresponding external tablespaces to the location pointed by the *.isl files. In MySQL 8.0, the use of *.isl files has been removed for InnoDB, as per WL#6416. This change raises the question: how would MEB find the external tablespaces and copy them back to their respective locations? This article attempts to answer these questions. tablespaces_tracker file MEB has introduced a new file in the backup named 'tablespaces_tracker'. It is a JSON file that is created only if at least one external tablespace is included in the backup. The file contains metadata about the backed-up external tablespaces.  The file contains an array named "tablespace_list", which contains a list of the external tablespace objects and the following properties for each external tablespace. "server_file_path" : External tablespace location at the sever "backup_file_path" :  External tablespace location in the backup "space_id”: A tablespace identifier. "Flags”:  As of now these are the possible flag values. GENERAL: If it is a shared tablespace. SINGLE: If it is a file-per-table tablespace. REMOTE: If it is an external tablespace. The file is present in the datadir of the backup. At the time of copy-back operation, it is copied to the server datadir. Backup of external tablespaces In MySQL 8.0, the only source of truth for tablespace information is the transactional data dictionary.  InnoDB keeps the metadata about all tablespaces in the data dictionary tables. Thanks to the new data dictionary, querying of the INFORMATION_SCHEMA has also improved tremendously. MEB queries the information schema to find out the information about all tablespaces to be backed up.  It then locates all tablespaces on the server and copies them to the backup. Now, how will MEB be able to copy back the external tablespaces to their respective target locations given that copy-back is an offline operation (except the TTS backups)?  Well, the answer is, with the help of 'tablespaces_tracker' file. The following is a discussion of a backup of external tablespaces. Start the MySQL server with an external directory explicitly specified with the --innodb_directories option. Refer to the server manual for information on this option.  mysqld.exe --no-defaults --datadir=D:\trunk_datadir  --console --innodb_directories='D:\rsisondi\80' Create the following two external tablespaces: mysql> CREATE TABLESPACE 80_rem_gen_ddl_ts1  ADD DATAFILE  'D:/rsisondi/80/80_rem_gents1.ibd'; Query OK, 0 rows affected (0.14 sec) mysql> CREATE TABLE 80_extern_table (c1 INT) ENGINE=InnoDB  DATA DIRECTORY = 'D:/rsisondi/80'; Query OK, 0 rows affected (0.11 sec) Take a simple directory backup: > mysqlbackup.exe -ubackup_user --backup-dir=D:\rsisondi\backup backup MySQL Enterprise Backup version 8.0.12-tr Windows-10.0.14393-AMD64 [2018-04-02  09:01:58] Copyright (c) 2003, 2018, Oracle and/or its affiliates. All Rights Reserved. A thread created with Id '38700' Starting with following command line ...  mysqlbackup.exe –ubackup_user --backup-dir=D:\rsisondi\backup backup   <snip>   -------------------------------------------------------------    Parameters Summary         -------------------------------------------------------------    Start LSN                  : 19189248    End LSN                    : 19189656 -------------------------------------------------------------   mysqlbackup completed OK! Navigate to the backup directory and notice the file 'tablespaces_tracker'. It has the metadata about the external tablespaces JSON format as shown below: {     "version": 1.0,     "HowTo": "Update server_file_path if and only if it is needed for each tablespace to restore an external tablespace to a different location; make sure correct database folder is given for each per-table tablespace.",     "tablespace_list": [         {             "server_file_path": "D:/rsisondi/80/80_rem_gents1.ibd",             "backup_file_path": "D:/rsisondi/backup/datadir/meb#8_80_rem_gents1.ibd",             "space_id": 8,             "Flags": [                 "GENERAL",                 "REMOTE"             ]         },         {             "server_file_path": "D:/rsisondi/80/test_80/80_extern_table.ibd",             "backup_file_path": "D:/rsisondi/backup/datadir/test_80/80_extern_table.ibd",             "space_id": 9,             "Flags": [                 "SINGLE",                 "REMOTE"             ]         }     ] Notice from above that the file name on the server is 80_remote_gents1.ibd but it has been renamed in the backup. InnoDB allows creation of shared tablespaces with the same name at different locations. This could cause conflicts during directory backups as MEB copies all shared tablespaces into the datadir inside backup. Therefore, a prefix meb#<space_id>_ is appended to the general tablespaces file names in the backup. Next, drop an existing external tablespace and create a new. mysql> DROP TABLE 80_extern_table; Query OK, 0 rows affected (0.17 sec)   mysql> CREATE TABLE 80_new_extern_table (c1 INT) ENGINE=InnoDB DATA DIRECTORY = 'D:/rsisondi/80'; Query OK, 0 rows affected (0.07 sec)   Take a simple incremental directory backup >  mysqlbackup.exe -ubackup_user backup --incremental --incremental-backup-dir=D:\rsisondi\incr --incremental-base=history:last_backup MySQL Enterprise Backup version 8.0.12-tr Windows-10.0.14393-AMD64 [2018-04-02  09:01:58] Copyright (c) 2003, 2018, Oracle and/or its affiliates. All Rights Reserved. A thread created with Id '36608' Starting with following command line ...  mysqlbackup.exe -ubackup  backup --incremental         --incremental-backup-dir=D:\rsisondi\incr         --incremental-base=history:last_backup               <snip>   -------------------------------------------------------------    Parameters Summary         -------------------------------------------------------------    Start LSN                  : 19189657    End LSN                    : 19218134 -------------------------------------------------------------              mysqlbackup completed OK!  Navigate to the datadir in the backup directory and notice the file 'tablespaces_tracker’.  Notice that the information about the dropped table is not present in the tracker file while the information about the newly added file is present. {     "version": 1.0,     "HowTo": "Update server_file_path if and only if it is needed for each tablespace to restore an external tablespace to a different         location; make sure correct database folder is given for each per-table tablespace.",     "tablespace_list": [         {             "server_file_path": "D:/rsisondi/80/80_rem_gents1.ibd",             "backup_file_path": "D:/rsisondi/incr/datadir/meb#8_80_rem_gents1.ibd",             "space_id": 8,             "Flags": [                 "GENERAL",                 "REMOTE"             ]         },         {             "server_file_path": "D:/rsisondi/80/test_80/80_new_extern_table.ibd",             "backup_file_path": "D:/rsisondi/incr/datadir/test_80/80_new_extern_table.ibd",             "space_id": 10,             "Flags": [                 "SINGLE",                 "REMOTE"             ]         }     ] } Copy-back of external tablespaces The copy-back operation of external tablespaces relies solely on the ‘tablespaces_tracker’ file.  As mentioned before, the ‘tablespaces_tracker’ file is copied into the target datadir as well. It helps MEB to resolve external tablespaces conflicts during the copy-back operation from the incremental backups into the target datadir. For instance, some external tablespaces could have been created/renamed/dropped after the previous backup and before the incremental backup. Therefore, you should never delete the 'tablesapces_tracker' file from either the backup or datadir after a copy-back operation. Let us perform a copy-back operation with the backups taken in the previous section. Stop the server and move/rename the previous external tablespaces directories in case they are still present. Restore the full backup: > mysqlbackup.exe -ubackup_user  --backup-dir=D:\rsisondi\backup copy-back-and-apply-log --datadir=D:\rsisondi\datadir MySQL Enterprise Backup version 8.0.12-tr Windows-10.0.14393-AMD64 [2018-04-02  09:01:58] Copyright (c) 2003, 2018, Oracle and/or its affiliates. All Rights Reserved. A thread created with Id '27600' Starting with following command line ... mysqlbackup.exe –ubackup_user --backup-dir=D:\rsisondi\backup          copy-back-and-apply-log --datadir=D:\rsisondi\datadir   <snip>   180402 20:52:32 MAIN    INFO: Apply-log operation completed successfully. 180402 20:52:32 MAIN    INFO: Full Backup has been restored successfully.   mysqlbackup completed OK! Notice the ‘tablespaces_tracker’ file in the target datadir. It has the same content as it does in the backup. {     "version": 1.0,     "HowTo": "Update server_file_path if and only if it is needed for each tablespace to restore an external tablespace to a different         location; make sure correct database folder is given for each per-table tablespace.",     "tablespace_list": [         {             "server_file_path": "D:/rsisondi/backup/datadir/meb#8_80_rem_gents1.ibd",             "backup_file_path": "D:/rsisondi/80/80_rem_gents1.ibd",             "space_id": 8,             "Flags": [                 "GENERAL",                 "REMOTE"             ]         },         {             "server_file_path": "D:/rsisondi/backup/datadir/test_80/80_extern_table.ibd",             "backup_file_path": "D:/rsisondi/80/test_80/80_extern_table.ibd",             "space_id": 9,             "Flags": [                 "SINGLE",                 "REMOTE"             ]         }     ] } Now, restore the incremental backup that was taken in the above step. > mysqlbackup.exe --defaults-file=D:\rsisondi\incr\backup-my.cnf -ubackup_user --backup-dir=D:\rsisondi\incr copy-back-and-apply-log --datadir=D:\rsisondi\datadir --incremental   MySQL Enterprise Backup version 8.0.12-tr Windows-10.0.14393-AMD64 [2018-04-02  09:01:58] Copyright (c) 2003, 2018, Oracle and/or its affiliates. All Rights Reserved.   A thread created with Id '33576' Starting with following command line ...  mysqlbackup.exe --defaults-file=D:\rsisondi\incr\backup-my.cnf –ubackup_user         --backup-dir=D:\rsisondi\incr copy-back-and-apply-log         --datadir=D:\rsisondi\datadir --incremental   <snip>   180402 20:52:37 MAIN    INFO: Apply-log operation completed successfully. 180402 20:52:37 MAIN    INFO: Incremental backup applied successfully.   mysqlbackup completed OK! Check the contents of the ‘tablespaces_tracker’ file in the datadir. In this case, it is the same as it was in the incremental backup.  But the contents could be an aggregation of the tracker files that is in the target datadir and tracker file that is in the backup directory. It really depends on what external tablespaces are included in the incremental backup. {     "version": 1.0,     "HowTo": "Update server_file_path if and only if it is needed for each tablespace to restore an external tablespace to a different         location; make sure correct database folder is given for each per-table tablespace.",     "tablespace_list": [         {             "server_file_path": "D:/rsisondi/incr/datadir/meb#8_80_rem_gents1.ibd",             "backup_file_path": "D:/rsisondi/80/80_rem_gents1.ibd",             "space_id": 8,             "Flags": [                 "GENERAL",                 "REMOTE"             ]         },         {             "server_file_path": "D:/rsisondi/incr/datadir/test_80/80_new_extern_table.ibd",             "backup_file_path": "D:/rsisondi/80/test_80/80_new_extern_table.ibd",             "space_id": 10,             "Flags": [                 "SINGLE",                 "REMOTE"             ]         }     ] } Copy-back of external tablespaces to non-default location There could be a situation in which you want to restore the external tablespace to some other location than its original location. For instance, you are restoring the backup to a new location or preparing a clone. In such cases, you would want to copy the external tablespaces to a different location. It is possible to achieve the same using the following steps. Modify the value of "server_file_path" property of the tablespace that you wish to change in the ‘tablespaces_tracker’ file in backup. Make sure that the proper directory hierarchy exists on the target server for the tablespace to be restored. Start server with the --innodb-directories option. Specify the directories pertaining to all external tablespaces to this option. For more information refer to the server manual. Conclusion With the previous versions of server, the external tablespaces metadata is scattered around the server datadir and also in the backup.  Restoring multiple external tablespaces to the non-default location is cumbersome as you have to modify the .isl files corresponding to the tablespaces. With 8.0 version, server keeps all tablespaces information in the transactional data dictionary and, MEB keeps all external tablespaces information in one metadata file. Also, it is easier to modify the restore location of the external tablespaces because it is at one place. We encourage you to give this a try and provide us feedback on how it works for your data. For more details, please see the MySQL Enterprise Backup Guide

Introduction We can categorize the InnoDB tablespaces created by users, broadly in following categories. File-per-table Tablespace - A single, file-per-table tablespace created in the datadir,...

MySQL Enterprise

MySQL Enterprise Monitor 8.0.0 GA has been released

We are very happy to announce the general availability of MySQL Enterprise Monitor, Version 8.0. MySQL Enterprise Monitor is the best-in-class tool for monitoring and management of your MySQL assets and is included with your MySQL Enterprise Edition and MySQL Enterprise Carrier Grade subscriptions. You can find more information on the contents of this release in the change log. Highlights of MySQL Enterprise Monitor 8.0 include: MySQL Enterprise Monitor 8.0 supports monitoring MySQL Server 8.0.11 and later. You can also use MySQL Server 8.0 as an external data repository for MySQL Enterprise Monitor 8.0. Significant improvements have been made to the performance and user interface of the Query Analyzer. When you click on a SQL statement, the new Statement Details page enables you to browse all example statements in the specified time range, rather than just the one with the worst run time. Drill into any of these examples to see their individual statistics, literals used, and EXPLAIN plan. Graphs display the execution pattern of the selected query during the specified time period. For more information, see Section 30.3.1, "Detailed Query Information". The new 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 type, such as memory allocated for sorting, the buffer pool, or various other internal buffers used for statement processing. For more information, see Section 28.6, "Memory Usage Report". You will find binaries for the new release on 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.0" in the search box, or enter a license name to find Enterprise Monitor along with other MySQL products: "MySQL Enterprise Edition" or "MySQL Cluster Carrier Edition".  Then select your platform. Please open a bug or a ticket on My Oracle Support to report problems, request features, or give us general feedback about how this release meets your needs. If you are not a MySQL Enterprise customer and want to try the Monitor and Query Analyzer using our 30-day free customer trial, go to http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact. Thanks and Happy Monitoring! - The MySQL Enterprise Tools Development Team Useful URLs What's New in 8.0 Change log Installation documentation Complete documentation Product information Frequently Asked Questions

We are very happy to announce the general availability of MySQL Enterprise Monitor, Version 8.0. MySQL Enterprise Monitor is the best-in-class tool for monitoring and management of your MySQL assets...

MySQL

Announcing General Availability of MySQL 8.0

MySQL adds NoSQL and many new enhancements to the world’s most popular open source database: NoSQL Document Store gives developers the flexibility of developing traditional SQL relational applications and NoSQL, schema-free document database applications.  This eliminates the need for a separate NoSQL document database.  SQL Window functions, Common Table Expressions, NOWAIT and SKIP LOCKED, Descending Indexes, Grouping, Regular Expressions, Character Sets, Cost Model, and Histograms. JSON Extended syntax, new functions, improved sorting, and partial updates. With JSON table functions you can use the SQL machinery for JSON data. GIS Geography support. Spatial Reference Systems (SRS), as well as SRS aware spatial datatypes,  spatial indexes,  and spatial functions. Reliability DDL statements have become atomic and crash safe, meta-data is stored in a single, transactional data dictionary  Observability Performance Schema, Information Schema, Invisible Indexes,  Error Logging. Manageability Persistent Configuration Variables, Undo tablespace management, Restart command, and New DDL. High Availability InnoDB Cluster delivers an integrated, native, HA solution for your databases. Security OpenSSL improvements, new default authentication, SQL Roles, breaking up the super privilege, password strength, authorization. Performance Up to 2x faster than MySQL 5.7. Developer Features MySQL 8.0 delivers many new features requested by developers in areas such as SQL, JSON and GIS. Developers also want to be able to store Emojis, thus UTF8MB4 is now the default character set in 8.0. NoSQL Document Store MySQL Document Store gives developers maximum flexibility developing traditional SQL relational applications and NoSQL, schema-free document database applications.  This eliminates the need for a separate NoSQL document database.  The MySQL Document Store provides multi-document transaction support and full ACID compliance for schema-less JSON documents. SQL Window Functions MySQL 8.0 delivers SQL window functions in MySQL.   Similar to grouped aggregate functions, window functions perform some calculation on a set of rows, e.g. COUNT or SUM. But where a grouped aggregate collapses this set of rows into a single row, a window function will perform the aggregation for each row in the result set. Window functions come in two flavors: SQL aggregate functions used as window functions and specialized window functions. Common Table Expression MySQL 8.0 delivers [Recursive] Common Table Expressions (CTEs) in MySQL.  Non-recursive CTEs can be explained as “improved derived tables” as it allow the derived table to be referenced more than once. A recursive CTE is a set of rows which is built iteratively: from an initial set of rows, a process derives new rows, which grow the set, and those new rows are fed into the process again, producing more rows, and so on, until the process produces no more rows. MySQL CTE and Window Functions in MySQL Workbench 8.0 NOWAIT and SKIP LOCKED MySQL 8.0 delivers NOWAIT and SKIP LOCKED alternatives in the SQL locking clause. Normally, when a row is locked due to an UPDATE or a SELECT ... FOR UPDATE, any other transaction will have to wait to access that locked row. In some use cases there is a need to either return immediately if a row is locked or ignore locked rows. A locking clause using NOWAIT will never wait to acquire a row lock. Instead, the query will fail with an error. A locking clause using SKIP LOCKED will never wait to acquire a row lock on the listed tables. Instead, the locked rows are skipped and not read at all. Descending Indexes MySQL 8.0 delivers support for indexes in descending order. Values in such an index are arranged in descending order, and we scan it forward. Before 8.0, when a user create a descending index, we created an ascending index and scanned it backwards. One benefit is that forward index scans are faster than backward index scans. GROUPING MySQL 8.0  delivers GROUPING(), SQL_FEATURE T433. The GROUPING() function distinguishes super-aggregate rows from regular grouped rows. GROUP BY extensions such as ROLLUP produce super-aggregate rows where the set of all values is represented by null. Using the GROUPING()function, you can distinguish a null representing the set of all values in a super-aggregate row from a NULL in a regular row. JSON MySQL 8.0 adds new JSON functions and improves performance for sorting and grouping JSON values. Extended Syntax for Ranges in JSON path expressions MySQL 8.0 extends the syntax for ranges in JSON path expressions. For example SELECT JSON_EXTRACT('[1, 2, 3, 4, 5]', '$[1 to 3]');results in [2, 3, 4]. The new syntax introduced is a subset of the SQL standard syntax, described in SQL:2016, 9.39 SQL/JSON path language: syntax and semantics. JSON Table Functions MySQL 8.0 adds JSON table functions which enables the use of the SQL machinery for JSON data. JSON_TABLE() creates a relational view of JSON  data. It maps the result of a JSON data evaluation into relational rows and columns. The user can query the result returned by the function as a regular relational table using SQL, e.g. join, project, and aggregate. JSON Aggregation Functions MySQL 8.0 adds the aggregation functions JSON_ARRAYAGG() to generate JSON arrays and JSON_OBJECTAGG() to generate JSON objects . This makes it possible to combine JSON documents in multiple rows into a JSON array or a JSON object. JSON Merge Functions The JSON_MERGE_PATCH() function implements the semantics of JavaScript (and other scripting languages) specified by RFC7396, i.e. it removes duplicates by precedence of the second document. For example, JSON_MERGE('{"a":1,"b":2 }','{"a":3,"c":4 }'); # returns {"a":3,"b":2,"c":4}. JSON Improved Sorting MySQL 8.0 gives better performance for sorting/grouping JSON values by using variable length sort keys. Preliminary benchmarks shows from 1.2 to 18 times improvement in sorting, depending on use case. JSON Partial Update MySQL 8.0 adds support for partial update for the JSON_REMOVE(), JSON_SET() and JSON_REPLACE() functions.  If only some parts of a JSON document are updated, we want to give information to the handler about what was changed, so that the storage engine and replication don’t need to write the full document. GIS MySQL 8.0 delivers geography support. This includes meta-data support for Spatial Reference System (SRS), as well as SRS aware spatial datatypes,  spatial indexes,  and spatial functions. Character Sets MySQL 8.0 makes UTF8MB4 the default character set. UTF8MB4 is the dominating character encoding for the web, and this move will make life easier for the vast majority of MySQL users. Cost Model Query Optimizer Takes Data Buffering into Account MySQL 8.0 chooses query plans based on knowledge about whether data resides in-memory or on-disk. This happens automatically, as seen from the end user there is no configuration involved. Historically, the MySQL cost model has assumed data to reside on spinning disks. The cost constants associated with looking up data in-memory and on-disk are now different, thus, the optimizer will choose more optimal access methods for the two cases, based on knowledge of the location of data. Optimizer Histograms MySQL 8.0 implements histogram statistics. With Histograms, the user can create statistics on the data distribution for a column in a table, typically done for non-indexed columns, which then will be used by the query optimizer in finding the optimal query plan. The primary use case for histogram statistics is for calculating the selectivity (filter effect) of predicates of the form “COLUMN operator CONSTANT”. Reliability Transactional Data Dictionary MySQL 8.0 increases reliability by ensuring atomic, crash safe DDL, with the transactional data dictionary. With this the user is guaranteed that any DDL statement will either be executed fully or not at all. This is particularly important in a replicated environment, otherwise there can be scenarios where masters and slaves (nodes) get out of sync, causing data-drift. Observability Information Schema (speed up) MySQL 8.0 reimplements Information Schema. In the new implementation the Information Schema tables are simple views on data dictionary tables stored in InnoDB. This is by far more efficient than the old implementation with up to 100 times speedup. Performance Schema (speed up) MySQL 8.0 speeds up performance schema queries by adding more than 100 indexes on performance schema tables.  Manageability INVISIBLE Indexes MySQL 8.0 adds the capability of toggling the visibility of an index (visible/invisible). An invisible index is not considered by the optimizer when it makes the query execution plan. However, the index is still maintained in the background so it is cheap to make it visible again. The purpose of this is for a DBA / DevOp to determine whether an index can be dropped or not. If you suspect an index of not being used you first make it invisible, then monitor query performance, and finally remove the index if no query slow down is experienced. 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. Security features OpenSSL by Default in Community Edition MySQL 8.0 is unifying on OpenSSL as the default TLS/SSL library for both MySQL Enterprise Edition and MySQL Community Edition.  SQL roles MySQL 8.0 implements SQL Roles. A role is a named collection of privileges. The purpose is to simplify the user access right management. One can grant roles to users, grant privileges to roles, create roles, drop roles, and decide what roles are applicable during a session. Performance MySQL 8.0 is up to 2x faster than MySQL 5.7.  MySQL 8.0 comes with better performance for Read/Write workloads, IO bound workloads, and high contention “hot spot” workloads. Scaling Read/Write Workloads MySQL 8.0 scales well on RW and heavy write workloads. On intensive RW workloads we observe better performance already from 4 concurrent users  and more than 2 times better performance on high loads comparing to MySQL 5.7. We can say that while 5.7 significantly improved scalability for Read Only workloads, 8.0 significantly improves scalability for Read/Write workloads.  The effect is that MySQL improves  hardware utilization (efficiency) for standard server side hardware (like systems with 2 CPU sockets). This improvement is due to re-designing how InnoDB writes to the REDO log. In contrast to the historical implementation where user threads were constantly fighting to log their data changes, in the new REDO log solution user threads are now lock-free, REDO writing and flushing is managed by dedicated background threads, and the whole REDO processing becomes event-driven.  Utilizing IO Capacity (Fast Storage) MySQL 8.0 allows users to use every storage device to its full power. For example, testing with Intel Optane flash devices we were able to deliver 1M Point-Select QPS in a fully IO-bound workload. Better Performance upon High Contention Loads (“hot rows”) MySQL 8.0 significantly improves the performance for high contention workloads. A high contention workload occurs when multiple transactions are waiting for a lock on the same row in a table,  causing queues of waiting transactions. Many real world workloads are not smooth over for example a day but might have bursts at certain hours. MySQL 8.0 deals much better with such bursts both in terms of transactions per second, mean latency, and 95th percentile latency. The benefit to the end user is better hardware utilization (efficiency) because the system needs less spare capacity and can thus run with a higher average load. MySQL 8.0 Enterprise Edition For mission critical applications, MySQL Enterprise Edition provides the following additional capabilities: MySQL Enterprise Backup for full, incremental and partial backups, Point-in-Time Recovery and backup compression. MySQL Enterprise High Availability for integrated, native, HA with InnoDB Cluster. MySQL Enterprise Transparent Data Encryption (TDE) for data-at-rest encryption. MySQL Enterprise Encryption for encryption, key generation, digital signatures and other cryptographic features. MySQL Enterprise Authentication for integration with existing security infrastructures including PAM and Windows Active Directory. MySQL Enterprise Firewall for real-time protection against database specific attacks, such as an SQL Injection. MySQL Enterprise Audit for adding policy-based auditing compliance to new and existing applications. MySQL Enterprise Monitor for managing your database infrastructure. Oracle Enterprise Manager for monitoring MySQL databases from existing OEM implementations. MySQL Cloud Service Oracle MySQL Cloud Service is built on MySQL Enterprise Edition and powered by Oracle Cloud, providing an enterprise-grade MySQL database service. It delivers the best in class management tools, self service provisioning, elastic scalability and multi-layer security. Resources MySQL Documentation MySQL Downloads

MySQL adds NoSQL and many new enhancements to the world’s most popular open source database: NoSQL Document Store gives developers the flexibility of developing traditional SQL relational...