Tag: MySQL 5.7

Feed: Clustrix Blog. Author: Shane Johnson. COVID-19 has changed everything. That isn’t news. In May 2020, MariaDB conducted a global survey that looked at the initial COVID-19 impact on businesses moving to the cloud and IT professionals’ attitudes on what has changed – and what they think will change as a result of COVID-19.One trend we saw is that the global crisis is driving cloud adoption. 40% said COVID-19 is accelerating their move to the cloud. It makes sense. The cloud lets companies increase capacity without investing in hardware and facilities. Additionally, there is less need to add staff if ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; In my previous post in this series I've commented on some interesting MySQL bug reports that were added during the second half of April. Time to move on to bugs reported in May, 2020, as we are quickly approaching MySQL Bug #100000 soon and I want to write a separate post for this great achievement :) Here is the list:Bug #99432 - "Improving memory barrier during rseg allocation". Nice contribution by my former colleague in Percona, Krunal Bauskar, who now works on making MySQL better for ARM processors. According to his findings, the use ... Read More

Feed: Planet MySQL; Author: Codership; We recently covered Installing Galera Cluster 4 with MySQL 8 on Ubuntu 18.04 , the new Galera version for MySQL High Availability. We got a request to see if we would be able to install it on Amazon Linux 2, and the short answer is yes, we are able to deploy Galera Cluster on Amazon Linux 2. We have even published Installing a Galera Cluster on AWS guide for Geo-distributed MySQL Multi-master clustering which covers how to install a 3-node Galera Cluster on CentOS 7 to achieve disaster recovery . It turns out, Amazon Linux 2 ... Read More

Feed: Planet MySQL; Author: Yves Trudeau; In this post, the third in a series explaining the internals of InnoDB flushing, we’ll focus on tuning. (Others in the series can be seen at InnoDB Flushing in Action for Percona Server for MySQL and Give Love to Your SSDs – Reduce innodb_io_capacity_max!)Understanding the tuning process is very important since we don’t want to make things worse or burn our SSDs. We proceed with one section per variable or closely-related variables. The variables are also grouped in sections based on the version of MySQL or Percona Server for MySQL where they are valid. A ... Read More

Feed: Planet MySQL; Author: MyDBOPS; Human geography examines the dynamics of cultures, societies and economies, and physical geography examines the dynamics of physical landscapes and the environment. In this blog i am going to explain what are the new Geography features available in MySQL 8.0 Major Difference in MySQL 5.7 & 8.0 Geography : There is a big change from MySQL 5.7 to 8.0 when it comes to spatial data, it’s support, multiple spatial reference systems and geographic computations. This means that the SRIDs of geometries actually have meaning and affect computations. In 5.7 and earlier, however, the SRIDs(spatial reference ... Read More

Feed: Planet MySQL; Author: Kasra Madadipouya; In one of the latest post, I discussed how to transform a large MySQL table to JSON using Apache Spark. Well, that approach works for any tables with any volume. But it’s an overkill for simple and small tables. The good news is MySQL by default has a feature for that. In this article, I cover how to export MySQL query results as JSON. We will use two aggregate functions of MySQL that are JSON_ARRAYAGG and JSON_OBJECTAGG. They are introduced in MYSQL 5.7.22. So the solution works on any MySQL >= 5.7.22. To have ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; Time for the next blog post about MySQL bugs! The previous one covered some bugs I considered interesting in March, this one will be about community bug reports that I've picked up since March 26, 2020. I'd better review bug fixed in MySQL 5.7.30 instead of this, but it is still not released, even though we know it must get some important security fixes based on "Oracle Critical Patch Update Advisory - April 2020" recently published.As usual, I am mostly interested in replication, InnoDB, optimizer and few more categories. Here is the list:Bug #99082 - ... Read More

Feed: Planet MySQL; Author: Alexander Rubin; Alexander Rubin and Alexandre Vaniachine  | April 23, 2020 |  Posted In: Intermediate Level, MySQL, Percona Server for MySQLUsually one would expect that ALTER TABLE with ALGORITHM=COPY will be slower than the default ALGORITHM=INPLACE. In this blog post we describe the case when this is not so.One of the reasons for such behavior is the lesser known limitation of ALTER TABLE (with default ALGORITHM=INPLACE) that avoids REDO operations. As a result, all dirty pages of the altered table/tablespace have to be flushed before the ALTER TABLE completion.Some historyA long time ago, all “ALTER TABLE” (DDLs) operations ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; The other day on a call, a client asked me an interesting question.  We were discussing some testing they were doing in Amazon Relational Database Service (RDS).  The question came up “since RDS is managed, how can I prove to my security team that the data is actually encrypted?”  We’ve all read whitepapers and blogs that talk about encryption in the cloud, but it is something I’ve not needed to validate before.  Instead, I just enable encryption when I create an RDS instance and move along to the next steps of the setup ... Read More

Feed: Planet MySQL; Author: Kedar Vaijanapurkar; Recently, we were affected by an ignored configuration option introduced in MySQL 5.6. This incident caused us to perform extended planning of downtime and the rebuilding of the slave. In this post, we’ll discuss our encounter with binlog_error_action and likely bad default. The incident started with an alert from our monitoring platform that a check failed to verify a MySQL master’s binary log coordinates. My colleague working from the other side of the globe observed the following: mysql> show master status; Empty set (0.00 sec) mysql> show binary logs; ERROR 1381 (HY000): You are ... Read More