Tag: MySQL 5.7

Feed: Planet MySQL; Author: MC Brown; Clickhouse is a relatively new analytics and datawarehouse engine that provides for very quick insertion and analysing of data. Like most analytics platforms it’s built on a column-oriented storage basis and unlike many alternatives is completely open source. It’s also exceedingly fast, even on relatively modest platforms.Clickhouse does have some differences from some other environments, for example, data inserted cannot easily be updated, and it supports a number of different storage and table engine formats that are used to store and index the information. So how do we get into that from our MySQL transactional ... Read More

Feed: Planet MySQL; Author: ScaleGrid.io; Have you been experiencing slow MySQL startup times in GTID mode? We recently ran into this issue on one of our MySQL hosting deployments and set out to solve the problem. In this blog, we break down the issue that could be slowing down your MySQL restart times, how to debug for your deployment, and what you can do to decrease your start time and improve your understanding of GTID-based replication. How We Found The Problem We were investigating slow MySQL startup times on a low-end, disk-based MySQL 5.7.21 deployment which had GTID mode enabled. The system ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST Percona announces the release of Percona Server for MySQL 5.7.24-26 on December 4, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.7.24, including all the bug fixes in it. Percona Server for MySQL 5.7.24-26 is now the current GA release in the 5.7 series. All of Percona’s software is open-source and free. This release includes fixes to the following upstream CVEs (Common Vulnerabilities and Exposures): CVE-2016-9843, CVE-2018-3155, CVE-2018-3143, CVE-2018-3156, CVE-2018-3251, CVE-2018-3133, CVE-2018-3144, CVE-2018-3185, CVE-2018-3247, CVE-2018-3187, CVE-2018-3174, CVE-2018-3171. For more information, see Oracle Critical Patch Update Advisory – October 2018. Improvements PS-4790: ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; For some reason the Committee of FOSDEM 2019 MySQL, MariaDB & Friends Devroom of all my talks submitted picked up the one on how to create a useful MySQL bug report, so I have no options but continue to write about MySQL bugs, as long and MySQL Community wants and even prefers to listen and read about them... That's what I do, with pleasure.Today I'll continue my series of posts about community bug reports I am subscribed to with the review of bugs reported since October 1, 2018, starting from the oldest and skipping ... Read More

Feed: Planet MySQL; Author: Jesper Krogh; Maybe the biggest new feature in MySQL 8 is the new transaction data dictionary that improves the consistency of schema objects among other things. To further protect the data in the data dictionary, the data dictionary tables are hidden and their content only exposed through the Information Schema. (One exception is when you use the debug binary, then it is possible to get direct access to the data dictionary tables. This is not recommended at all on production systems!) A side effect of the data dictionary tables being hidden is that those that have ... Read More

Feed: Planet MySQL; Author: Marcelo Altmann; PREVIOUS POST Continuing on the series of blog posts about MySQL High Availability, today we will talk about stale reads and how to overcome this issue. The Problem Stale reads is a read operation that fetches an incorrect value from a source that has not synchronized an update operation to the value (source Wiktionary). A practical scenario is when your application applies INSERT or UPDATE data to your master/writer node, and has to read it immediately after. If this particular read is served from another server in the replication/cluster topology, the data is either not ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; In the first part of this howto, I illustrated how to setup two MySQL InnoDB Cluster linked by an asynchronous replication. In that solution, I didn’t use any replication filters to ignore the replication of the InnoDB Cluster’s metadata (mysql_innodb_cluster_metadata), but I used the same metadata tables with two different clusters in it. The benefit is that this allows to backup everything from any node in any of the data center, it works also in MySQL 5.7, and there is not risk to mess up with the replication filters. In this blog I will ... Read More

Feed: What's New. RDS on VMware also enables low-cost, high-availability hybrid deployments, database disaster recovery to AWS, and long-term database archival in Amazon Simple Storage Service (Amazon S3). It will soon expand to support, among other features, more extensive data recovery; geoproximal read and migration functionality, including hybrid RDS snapshots and hybrid read replicas (datacenter to/from datacenter and datacenter to/from AWS region); one-click read replica promotion; and cross-cluster high availability. RDS on VMware will be generally available soon and will support Microsoft SQL Server, Oracle, MySQL, PostgreSQL, and MariaDB databases in customer-owned private cloud environments, including for workloads that need ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST The settings of MySQL configuration variables have a fundamental impact on the performance of your database system. Sometimes it can be a little tricky to predict how changing one variable can affect others, and especially when dealing with cases like the one I’ll describe in this post, where the outcome is not very intuitive. So here, we’ll look at what happens when you set innodb_open_files higher than the open_files_limit. We can set the maximum number of open files in our MySQL configuration file using: open_files_limit=10000 open_files_limit=10000 If this isn’t set, then ... Read More

Feed: Planet MySQL; Author: Andrew Grimo; Features and capabilities continue to arrive in MySQL 8.0, most recently noted in the GA release of MySQL 8.0.13.  The mysql-shell 8.0.12 release introduced a number of things, an important part was a cross-platform mysql-shell secure password handling facility.  The MySQL Login-paths are a part of that security focus.  Here we will look at where InnoDB Cluster 8.0, is going, and focus on the enhanced Devops-focused alignment that MySQL is putting forward. Particularly InnoDB Cluster command structure introduced in MySQL-Shell 8.0.13. By aiming to look at the big picture, we can more confidently think about our own technology ... Read More