The MySQL Engineering team is proud to announce the Data Import feature in MySQL Database Service (MDS) and HeatWave.

The new Data Import enables faster and easier migrations to the MySQL Database Service. You can migrate from virtually any MySQL source, like AWS RDS/Aurora or MySQL on-premise, and from different versions, including 8.0, 5.7, or 5.6, directly to MySQL Database Service.

To migrate your existing MySQL databases, you perform two easy steps, in sequence or in parallel:

1. Use MySQL Shell to export data from an existing MySQL source into an OCI Object Storage bucket;
2. In MDS, create a new MySQL DB System referencing the bucket using a Pre-Authenticated Request (PAR). The data is imported automatically!

Together with MySQL Shell, MDS Data Import functionality dramatically reduces …

On March 31st, 2021, MySQL introduced a new MySQL Database Service (MDS) option named MDS High Availability (MDS H/A).

“The High Availability option enables applications to meet higher uptime requirements and zero data loss tolerance. When you select the High Availability option, a MySQL DB System with three instances is provisioned across different availability or fault domains. The data is replicated among the instances using a Paxos-based consensus protocol implemented by the MySQL Group Replication technology. Your application connects to a single endpoint to read and write data to the database. In case of failure, the MySQL Database Service will automatically failover within minutes to a secondary instance without data loss and without requiring to reconfigure the application. See the documentation to learn more about MySQL Database Service High Availability.” From: …

We are pleased to announce that MySQL Database Service with HeatWave is now available in 22 regions worldwide. 

With the introduction of 10 new regions, MySQL Database Service is now present in all Oracle Cloud Infrastructure commercial regions:

North America  US East (Ashburn)  US West (Phoenix)  US West (San Jose)  Canada Southeast (Toronto)  Canada Southeast (Montreal) Latin America  Brazil East (Sao Paulo)  Chile Central (Santiago) EMEA  UK South (London)  UK West (Newport)  Germany Central (Frankfurt)  Switzerland North (Zurich)  Netherlands Northwest (Amsterdam)  Saudi Arabia West (Jeddah)  UAE East (Dubai) APAC  Japan East (Tokyo)  Japan Central (Osaka)  South Korea Central (Seoul)  South Korea North (Chuncheon)  Australia East (Sydney)  Australia Southeast (Melbourne)  India West (Mumbai)  India South …

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

HeatWave is a new, massively parallel in-memory query engine developed by Oracle Labs designed for accelerating analytic workloads. HeatWave provides 100x-1000x acceleration over MySQL and MySQL compatible databases like Aurora. 

There are four key architecture choices which provide compelling performance with HeatWave:

1. An in-memory hybrid columnar format which is conducive to vector processing.
2. A massively parallel architecture which is enabled by a massively partitioned architecture.
3. State of …

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), …

MySQL Database Service is now also available in India (Mumbai) and Canada (Toronto) Regions. These are additions to the Regions where the Service is already available: Brazil (Sao Paulo), Germany (Frankfurt), Japan (Tokyo), United Kingdom (London), United States East (Ashburn), and United States West (Phoenix).

If you want to test for free, go to oracle.com/cloud/free and get access to a wide range of Oracle Cloud services for 30 days, including MySQL Database Service in Ashburn, Frankfurt, London, Mumbai, Phoenix, Tokyo, and Toronto. Check the documentation for the quick steps to create your MySQL databases.

More Regions are coming soon. Stay tuned!

You are also welcome to register for the live MySQL Database Service webinar series: …

The MySQL team is thrilled to invite customers to use the new MySQL Database Service also in OCI Japan East (Tokyo) Region. This is an addition to the Regions where the Service is already available: US East (Ashburn), United Kingdom (London), Germany (Frankfurt), Brazil (Sao Paulo), and the US West (Phoenix).

If you want to test for free, go to oracle.com/cloud/free and get access to a wide range of Oracle Cloud services for 30 days, including MySQL Database Service in Ashburn, Frankfurt, London, Phoenix, and Tokyo Regions. Check the documentation for the quick steps to create your MySQL databases.

We continue our expansion journey and more Regions are coming soon!

You are also welcome to register for the live MySQL Database Service webinar …

MySQL Database Service is expanding to more Oracle Cloud Infrastructure Regions. In addition to the US East (Ashburn), we are rolling out the Service to the United Kingdom (London), Germany (Frankfurt), Brazil (Sao Paulo), and the US West (Phoenix).

Go to oracle.com/cloud/free and get access to a wide range of Oracle Cloud services for 30 days, including MySQL Database Service in Ashburn and Frankfurt Regions. Check the documentation for the quick steps to create your MySQL databases.

We will be rolling out even more Regions soon. Stay tuned!

Don’t forget to register for the live MySQL Database Service webinar series: 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 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 …

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 …