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

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 …

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

MySQL Firewall is an enterprise security solution providing ease of mind while protecting your database from rogue queries. Sometimes granting wide-style access privileges may feel a bit too generous, and leaves you wondering whether you could do something more. Join us as we explore Firewall, and (in particular) using Group profiles.…

Facebook Twitter LinkedIn

In March 2020, my book MySQL 8 Query Performance Tuning (Apress) was released. That book with its more than 900 pages in 27 chapters covered a wide range of topics from executing benchmarks with sysbench over indexes and the optimizer to query rewriting, replication, and caching. Some time later my editor Jonathan Gennick suggested to take a limited set of the topics and go into more detail. We settled on locks and transactions which together have become MySQL Concurrency.

If you have already read MySQL 8 Query Performance Tuning, you may wonder what the new book offers compared to the previous one. In some way, you can think of MySQL Concurrency to be a second and expanded edition for the content on locks and transactions. Of course, given MySQL Concurrency is limited to those two topics, it has also been …