MySQL Newsletter June 2021 - Smooth Sailing with MySQL Kubernetes Operator

Oracle MySQL Newsletter June 2021

Smooth Sailing with MySQL Kubernetes Operator

Upcoming webinar:Introduction to MySQL Kubernetes Operator
Customer Highlight: RTTS(North America), SSG(APAC)
New video Interview Series & Webinar
Upcoming LIVE Webinars
Upcoming Virtual events
Recent Blogs
Tip of the Month

Upcoming webinar: Introduction to Oracle MySQL Kubernetes Operator

June 30, 2021 - 9:00 a.m. PST

Develop and deploy modern micro-services applications with Kubernetes and MySQL Kubernetes Operator.

Learn how to:

Support for OCI Container Engine for Kubernetes (OKE), K3s and MiniKube
Initial deployment of an InnoDB Cluster with MySQL Routers
Scale up/down the cluster
Automatic InnoDB Cluster healing in case of faults and crashes
Support for rolling upgrades

Introduction to Oracle MySQL Kubernetes Operator in French

Découvrez le nouvel opérateur Kubernetes de MySQL
Thu, July 22, 11:00 EDT / 17:00 CEST

On-demand webinar MySQL Operator for Kubernetes in German

You can watch the video at anytime on Oracle Video Hub.

Watch now

Customer Highlights

RTTS’ QuerySurge Automates Data Testing with MySQL Embedded as Powerful Backend

“MySQL is the engine that drives our business, handles computationally intensive queries, and performs all the testing in terms of executing tasks and producing valuable results for users. It's the engine that drives QuerySurge."

SSG Builds Online Shopping Mall using MySQL Enterprise Edition

"When integrating 14 eCommerce sites into one homepage, MySQL Enterprise Edition provided us with maximum availability, high performance, and powerful tools for managing these critical platforms, which ultimately increased customer satisfaction and market share."

New MySQL Interview Series "HeatWave" with Nipun Agarwal

This short 15 minute interview by Shane Atherholt covers:
1. What is MySQL HeatWave
2. Trends that are we seeing already
3. How are customers doing?
4. New features
5. How can people get started

Watch now

Upcoming LIVE Webinars

Upcoming Cloud webinars:

[Hands-on-lab] Run Your Analytics with Astonishing Performances Leveraging HeatWave
Thu, June 24, 10:30 CEST

[Hands-on-lab] Integrate MySQL Database Service with any External Data Source with Oracle Data Integrator Cloud
Thu, July 1, 10:30 CEST

[Webinar] Conheça o novo Oracle MySQL Kubernetes Operator
Wed, July 7, 10:00 GMT-3

[Hands-on-lab] Replicate MySQL Database to MySQL Database Service on Oracle Could Infrastructure
Thu, July 8, 10:30 CEST

[Webinar] Découvrez le nouvel opérateur Kubernetes de MySQL
Thu, July 22, 11:00 EDT / 17:00 CEST

Full list of webinars at: https://www.mysql.com/news-and-events/web-seminars/

Upcoming virtual events

OpenSource Summit
June 23 - 25, 2021, Miami, United States

Full list of events at: https://www.mysql.com/news-and-events/events/

Recent Blogs

Deploying Joomla! on OCI and MDS
Deploy Magento on MDS & HeatWave
Deploy Moodle on OCI with MDS
Enable https to our Moodle
Deploy on OCI using Ampere Compute Instances !
Use Matomo Website Analytics on OCI with MDS
Deploy your own PHP application on OCI and MDS
Migrating Users from Aurora to MDS
By Frederic Descamps

JSON Validation and ALGORITHM = Instant
Extending the MySQL Shell with Python
What Does This Query Really Do?
Need a quick row number on your query output?
It Is Time To Double Check Your Backups
By David Stokes

Asynchronous Replication Connection Failover – Automatic source list
By MySQL HA Team Hemant Dangi

MySQL Time Zone Support (with examples)
Cloning MySQL InnoDB Cluster data-at-rest encrypted tables
By Mirko Ortensi

Tip of the Month

For performance, having a warm InnoDB Buffer Pool is very important. A warm buffer pool means that the most used pages (working set) required by the production workload are already loaded in memory (in the buffer pool). If so, MySQL doesn’t need to read the pages from disk every time it requires the most used page and speeds up the process when the needed data is already in memory.
When you start MySQL, by default the InnoDB Buffer Pool is cold and the warm up process can even take days sometimes…
So, you can already conclude that restarting mysqld is a source of having a cold Buffer Pool as it will start empty. Another reason to have a non optimal Buffer Pool is to load it unnecessary pages. This can happen during a logical dump or load. If you regularly do a mysqldump for example (don’t forget that MySQL Shell dump & load is better if you do logical dumps, but introduces also the same effect).
There are multiple ways to work on the InnoDB Buffer Pool dump and load, discover some scenarios.

https://lefred.be/content/mysql-dump-load-innodb-buffer-pool/

Helpful Links

How to Buy MySQL Products and Services
How to Become a MySQL Partner
MySQL's Customers

Download
Try MySQL Database Service
Download MySQL Enterprise Edition Trial
Download MySQL Community Server
Download MySQL Cluster
Download MySQL Workbench
Download MySQL Installer for Windows

Download White Papers

Subscribe to our monthly MySQL Newsletter

Stay Connected

This email was sent to you because you subscribed to this newsletter.

Copyright © 2021, Oracle and/or its affiliates. All rights reserved. Oracle Corporation - Worldwide Headquarters, 2300 Oracle Way, Austin, TX 78741, United States