We are happy to announce another MySQL Webinar on the topic of "", see details below: Date: Feb 16, 2021 Time: 2:00 pm Dubai time (GMT+4) Topic: Best practices for MySQL Performance Description: Of all the features that are available in MySQL, we will still need to optimize and fine tune our environ...

Why do Continuent customers say year after year that Tungsten Clustering is a better MySQL HA/DR/Geo-Scale clustering and replication technology - in the cloud, on-prem, hybrid-cloud, multi-cloud - compared to alternatives such as Amazon Aurora for MySQL, Galera Cluster and host of others? We have put together a comprehensive comparison so you can learn about the pros and cons of various MySQL solutions for business-critical and mission-critical apps - and make an informed decision about what’s best for your needs and environment!

Tags: MySQLmysql clusterHigh AvailabilityDisaster Recovery

Hi and thanks to all who attended my webinar on Tuesday, January 26th titled Using PMM to Identify & Troubleshoot Problematic MySQL Queries!

Like we do after all our webinars, we compile the list of questions that were answered verbally and also those that were posed yet remained unanswered since we ran out of time during the broadcast.  Before we get to the questions, I wanted to make sure to include a link to the RED Method for MySQL Queries by Peter Zaitsev, Percona’s CEO:

https://grafana.com/grafana/dashboards/12470

Hi Michael, you suggested that table create and update times should be ignored. Surely these values come from information_schema.tables? Does that not reflect what I would see if I …

Get better business insight faster by combining the data visualization and AI capabilities of Oracle Analytics Cloud with the fastest MySQL cloud service.

This on-demand webinar offers a quick introduction to the MySQL Database Service and to the Oracle Analytics Cloud Service.

• Learn the many benefits of using Oracle Analytics Cloud with MySQL Database Service and HeatWave.
• See how to get proactive insights fast with the Oracle Analytics Cloud tools for self-service visualization, powerful inline data preparation to enterprise reporting, advanced analytics, and self-learning analytics.

Watch the webinar (including demo):
Speakers:
Mandy Pang, Oracle Labs, Principal Product Manager
Alan Lee, Analytics Platform, Product Management Director
 

Presentation …

Get better business insight faster by combining the data visualization and AI capabilities of Oracle Analytics Cloud with the fastest MySQL cloud service. This on-demand webinar offers a quick introduction to the MySQL Database Service and to the Oracle Analytics Cloud Service. Learn the many benefi...

Read this blog to get a high-level introduction to AWS CloudFormation Templates, and a walkthrough on how to launch our CloudFormation template for the Tungsten Cluster AMI to run highly available MySQL database clusters in the AWS cloud.

Tags: aws cloudformationtungsten clustermysql database clustercloudformation templatehow to launch

Query attributes have in a long time been used to add metadata to queries to provide additional context such as where in the application the query was generated. The traditional way to do this is to add a comment at the start of the query with the attributes. Since the MySQL parser ignores the comment, it does not change the semantics of the query, but various tools can extract the comments.

This post looks into the reasons for using query attributes, how it is done using a comment, and the new component for MySQL 8.0.23 that provides native support for query attributes.

Advice

Query attributes are also known as query tags.

Why Query Attributes?

At the surface, it may seem that there is no major benefit from having metadata attached to a query – after all it is ignored by MySQL. However, there are good reasons. The …

Oracle Cloud Infrastructure Data Integration with MySQL Database Service and Heatwave

Virtually all data types from any data source can be integrated into the MySQL Database Service and HeatWave. When you need to collect data from diverse sources in a timely manner, Oracle Cloud Infrastructure (OCI) Data Integration, a cloud native, serverless ETL (extract, load, transform) service on the Oracle Cloud, provides a unified solution for building, deploying, and managing complex data warehouses.

Discover how its combined elements of data integration; with a graphical, no-code designer, and interactive data preparation, all powered by Spark ETL or E-LT push-down execution, ensure that information is timely, accurate, and consistent across complex systems.

Watch the full webinar (including demo):

Speakers:
Nicolas de Rico, MySQL …

Oracle Cloud Infrastructure Data Integration with MySQL Database Service and Heatwave Virtually all data types from any data source can be integrated into the MySQL Database Service and HeatWave. When you need to collect data from diverse sources in a timely manner, Oracle Cloud Infrastructure (OCI)...

MySQL 8.0.23 introduces many new improvements and updates, many of which deserve their own blog post for a deep dive into the new features.  Among the notable changes are: Invisible columns, Query attributes, several new (security, InnoDB, GIS, Replication, Group replication, X Protocol, Router, MTR Testsuite) features, and many more.

Recorded Webinar:

Our webinar covers the many new features introduced with the latest 8.0.23 release, plus the highlights of MySQL 8.0 

Top blogs:

The MySQL 8.0.23 Maintenance Release is Generally Available

A 250x improvement to …