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 …
[Read more]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)...
Overview If you are using ProxySQL 2.0.16 in front of MySQL 5.7/5.6 servers or even in front of MySQL 8.0.0, please check your ProxySQL error logs for the message below to ensure that you are not experiencing the MySQL bug #102266: 2021-06-23 02:38:18 MySQL_Session.cpp:2798:handler_again___status_CHANGING_USER_SERVER(): Error during change user: 1045, Access denied for user 'mary'@'172.21 If
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
[Read more]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 …
[Read more]There are several ways to deploy ProxySQL between your applications and the database servers. A common approach is to have a floating virtual IP (VIP) managed by keepalived as the application endpoint. The proxies have to be strategically provisioned to improve the resiliency of the solution (different hardware, network segments, etc,).
When we consider cloud environments, spreading instances across many availability zones (AZ) is considered a best practice, but that presents a problem regarding VIP handling.
Per definition, VPC subnets have to be created in a specific AZ, and subnet IP ranges can’t overlap with one another. An IP address cannot simply be moved to an instance on a different AZ, as it would end up in a subnet that doesn’t include it.
So in order to use the VIP method, we …
[Read more]The MySQL team is proud to announce the general availability of version 8.0.23 of the MySQL Shell.
In addition to a considerable number of bugs fixed, the following changes were introduced.
Improved Import Table
The importTable utility continues getting better, the following enhancements:
… Facebook Twitter LinkedIn