Tag: MySQL 5.7

Feed: Recent Announcements. You can use Aurora to add machine learning (ML) based predictions to your applications, using a simple, optimized, and secure integration with Amazon SageMaker and Amazon Comprehend. Aurora machine learning is based on the familiar SQL programming language, so you don’t need to build custom integrations, move data around, learn separate tools, or have prior machine learning experience. This functionality is also available for Aurora with MySQL 5.7 compatibility. Aurora machine learning supports any ML model available in SageMaker, or you can run sentiment analysis using Comprehend. It’s available for PostgreSQL 10 and 11, with no additional ... Read More

Feed: Recent Announcements. Microsoft Active Directory authentication provides the benefits of single sign-on and centralized authentication of MySQL users. Keeping all user credentials in the same Active Directory will save you time and effort as you have a centralized location for storing and managing them for multiple DB instances.  You can enable database users to authenticate against Amazon RDS for MySQL using either the credentials stored in the AWS Directory Service for Microsoft Active Directory, or the credentials stored in your on-premises Microsoft Active Directory, with forest trust relationship established between your on-premise Active Directory and an AWS Managed Active ... Read More

Feed: Planet MySQL; Author: Colin Charles; Codership is pleased to announce a new Generally Available (GA) release of Galera Cluster for MySQL 5.6 and 5.7, consisting of MySQL-wsrep 5.6.47 (release notes, download) and MySQL-wsrep 5.7.29 (release notes, download) with a new Galera Replication library 3.29 (release notes, download), implementing wsrep API version 25. This release incorporates all changes to MySQL 5.6.47 and 5.7.29 respectively. A highlight for improved WAN performance (great for cloud environments, well-tuned networks will perform faster) in Galera Replication library 3.29 is there is a new setting for socket.recv_buf_size set to auto which allows the underlying kernel (be it ... Read More

Feed: Planet MySQL; Author: Colin Charles; Codership is pleased to announce a new Generally Available (GA) release of Galera Cluster for MySQL 5.6 and 5.7, consisting of MySQL-wsrep 5.6.47 (release notes, download) and MySQL-wsrep 5.7.29 (release notes, download) with a new Galera Replication library 3.29 (release notes, download), implementing wsrep API version 25. This release incorporates all changes to MySQL 5.6.47 and 5.7.29 respectively. A highlight for improved WAN performance (great for cloud environments, well-tuned networks will perform faster) in Galera Replication library 3.29 is there is a new setting for socket.recv_buf_size set to auto which allows the underlying kernel (be it ... Read More

Feed: Planet MySQL; Author: Ivan Ma; This is the tutorial and serves as a sample ONLY.  Every environment can be different.  It is a test trial for the Upgrade MySQL InnoDB Cluster with version 5.7.25 to MySQL 8.0.19 where the MySQL InnoDB Cluster Metadata has changed from V1 to V2 in 8.0.19. 1.      Assuming the following SETUP            i.              MySQL Server 5.7.25           ii.              MySQL Shell : 8.0.15         iii.              MySQL Router : 8.0.15 2.      3 nodes are running on the same machine for this tutorial            i.              Port : 3310, 3320 and 3330           ii.              Hostname : primary   (or ... Read More

Feed: Planet MySQL; Author: Jean-François Gagné; In my previous post (Puzzled by MySQL Replication), I describe a weird, but completely documented, behavior of replication that had me scratching my head for hours because it was causing data corruption.  I did not give too many details then as I also wanted allowing you to scratch your head if you wished.  In this post, I describe this behavior in more details. But first I need to apologize to my readers: I was planning to release this post a few days after the previous one and it took me more time to finalize ... Read More

Feed: Planet MySQL; Author: Severalnines; April 2018 is not just a date for the MySQL world. MySQL 8.0 was released there, and more than 1 year after, it’s probably time to consider migrating to this new version. MySQL 8.0 has important performance and security improvements, and, as in all migration to a new database version, there are several things to take into account before going into production to avoid hard issues like data loss, excessive downtime, or even a rollback during the migration task. In this blog, we’ll mention some of the new MySQL 8.0 features, some deprecated stuff, and ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; If you’re using MySQL’s Performance Schema you may use “query digests” as IDs to identify specific query patterns in the events_statements_summary_by_digest Performance Schema Table.You might assume these hashes are stable between different versions, so, for example, when upgrading from MySQL 5.7 to MySQL 8, you can compare the query response time and other execution details for the same hashes as part of your upgrade process and have confidence that queries run the same (or better) after the upgrade.   Unfortunately, you can’t.For some reason, the hashing algorithm is different between MySQL 5.6,  MySQL ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; I'd like to continue reviewing MySQL bug reports from Community users that I considered interesting and subscribed to. Unlike in the previous post in this series, I am not going to check test cases on any competitor product, but will use only recently released MySQL 5.7.29 and 8.0.19 for checks, if any. This time I'll concentrate on bugs reported in November 2019.As usual, I mostly care about optimizer, InnoDB and replication related bugs. Here is the list:Bug #97476 - "Range optimizer skips rows". This bug reported by Ilya Raudsepp looks like a clear regression in ... Read More

Feed: Recent Announcements. The READ COMMITTED isolation level is available with Aurora MySQL engine version 1.21 and above, compatible with MySQL 5.6, and with engine version 2.07 and above, compatible with MySQL 5.7. You can read the Aurora documentation to learn more. Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to five times better throughput than standard MySQL together with increased scalability, durability, and security ... Read More