Tag: MySQL 8.0

Feed: Planet MySQL; Author: Andrew Grimo; MySQL-Shell has had a set of “Util” object functions for almost a year as of this post. It is this added functionality that negates any reason someone would still need to use the old mysqldump client. It (mysqldump) helped the MySQL Community for a long, long time. It also introduced a large amount of garbage and messiness in with those bloated data files, as it really belongs to an older era. We can now move on ahead without it. This process of “moving ahead” is what I will demonstrate in this blog post. Note: ... Read More

Feed: Planet MySQL; Author: Severalnines; A hybrid cloud database is a mix of active hosts residing on both on-premises and cloud infrastructures, working as a single operational system. It helps implement a high availability environment, and since both database and applications need to be portable in order to work on on-prem and cloud, it also reduces dependency on a particular cloud vendor (cloud vendor lock-in). Deploying this kind of environment is not that straightforward though. In this blog post, we are going to look into using ClusterControl to Deploy a Hybrid Cloud MySQL Database, between on-premises and cloud infrastructure running ... Read More

Feed: Planet MySQL; Author: Joshua Otwell; Most developers use some form of auto-incrementing integer counter for a given database table, ensuring uniqueness among the rows. Several of the popular SQL dialects implement this facility. For instance, MySQL’s AUTO_INCREMENT attribute is used to provide a unique identity for a table row. What exactly is the behavior of AUTO_INCREMENT? Can you explicitly use a value of your choosing for it if you need to? How does it count? Continue reading and know the answers to these questions and more… OS and DB used: Linux Mint 20 Ulyana MySQL 8.0.23 Self-Promotion: If you ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; MySQL 5.6.51 is the last release of the MySQL 5.6 series. Oracle will no longer provide updates or security fixes for this version. Following Percona’s Release Lifecycle policies, the Percona Server for MySQL 5.6 series has reached End of Life (EOL) as well, and we will no longer provide public builds for bugs and security fixes. We recommend that you upgrade to MySQL 5.7 or Percona Server for MySQL 5.7, or for the latest features, MySQL 8.0 or Percona Server for MySQL 8.0. Suppose you have not upgraded because you have off-the-shelf applications ... Read More

Feed: Planet MySQL; Author: MyDBOPS; From MySQL 5.7, we had a Multi-threaded Slave (MTS) Applier mechanism called LOGICAL_CLOCK to overcome the problems of parallel replication within a database. To further improve the parallelisation mechanism, from MySQL 8 (5.7.22) we have write-set replication, so before going further , lets look at the difference between Logical clock (LC) and Writeset. LOGICAL_CLOCK Transactions that are part of the same binary log group commit on a master are applied in parallel on a slave. The dependencies between transactions are tracked based on their timestamps to provide additional parallelisation where possible. WRITESET Write-set is a mechanism ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; This post was written by: Nicolas De Rico: Oracle Cloud Solutions Engineer - MySQL Sergio J Castro: Oracle Cloud Solutions Engineer - Networking   From RDS to MDS   When an application reaches the maximum capabilities offered by Amazon Web Services (AWS) RDS, it is often recommended to migrate to the AWS Aurora service.   However, Aurora is based on an older version of MySQL.  Aurora still does not support MySQL 8.0, which was released in April 2018.  Therefore, it may be difficult to port applications to Aurora, and later, out of Aurora because of its ... Read More

Feed: Planet MySQL; Author: Jesper Krogh; 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 ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; 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. Live Webinar: Our webinar will cover the many new features introduced with the latest 8.0.23 release, plus the highlights of MySQL 8.0  Date: February 11, 2021. 11AM PT. Register now   Top blogs: The MySQL 8.0.23 Maintenance Release is Generally Available A 250x improvement ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Percona XtraBackup 8.0.23 enables the “lock-ddl” option by default to ensure any DDL events do not corrupt the backups. Any DML events continue to occur, and only DDL events are blocked. A DDL lock protects the definition of tables and views. With the “–lock-ddl” option disabled, Percona XtraBackup allows backups while concurrent DDL events continue to happen. These backups are invalid and fail at the Prepare stage. If DDL events have occurred without the backup user’s knowledge, they may be unaware the backup is corrupt. MySQL 8.0 introduced “Lock Instance for Backup”. This ... Read More

Feed: Planet MySQL; Author: Yngve Svendsen; When MySQL 5.6 went GA back in 2013, it was a major milestone for MySQL, with a large number of improvements and new features in areas such as InnoDB, partitioning, performance schema, optimizer, and GIS. And not least, 5.6 came with much improved security features and characteristics. But all things eventually come to an end. The baton passed to MySQL 5.7 and then 8.0, and as of February 5 2021, 5.6 will in practice reach its end of life. You will still be able to access pre-existing update releases, documentation and  other support materials ... Read More