Tag: MySQL 5.7

Feed: What's New. If you are migrating a MySQL 5.5, 5.6, or 5.7 database to Aurora with MySQL compatibility or RDS for MySQL, you can copy database backups to an Amazon S3 bucket and restore them for a faster migration. Both full and incremental backups of your database can be restored. Restoring backups can be considerably quicker than moving data using the mysqldump utility, which replays SQL statements to recreate the database ... 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.43 and MySQL-wsrep 5.7.25 with a new Galera Replication library 3.26 (release notes, download), implementing wsrep API version 25. This release incorporates all changes to MySQL 5.6.43 (release notes, download) and 5.7.25 respectively (release notes, download). The Galera Replication library compared to to the previous 3.25 release has a few new features and enhancements: GCache page store fixes around an early release of the GCache page, a check for duplicate UUIDs to ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; I have not much yet to say on a populartopic of upgrading everything to MySQL 8, so let me just continue reviewing public MySQL bug reports that I've subscribed to recently. After my previous post at least one bug, Bug #94747, got enough comments and clarifications (up to specific commit that introduced this regression pointed out by Daniel Black!) to have it re-classified and verified as InnoDB code bug. So, I see good reasons to continue attracting wide public attention to selected MySQL bugs - this helps to make MySQL better eventually. As usual, ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; In MySQL, historically GROUP BY was used to provide sorting as well. If a query specified GROUP BY, the result was sorted as if ORDER BY was present in the query. mysql-5.7> CREATE TABLE t (id INTEGER, cnt INTEGER); Query OK, 0 rows affected (0.03 sec) mysql-5.7> INSERT INTO t VALUES (4,1),(3,2),(1,4),(2,2),(1,1),(1,5),(2,6),(2,1),(1,3),(3,4),(4,5),(3,6); Query OK, 12 rows affected (0.02 sec) Records: 12 Duplicates: 0 Warnings: 0 mysql-5.7> SELECT id, SUM(cnt) FROM t GROUP BY id; +------+----------+ | id | SUM(cnt) | +------+----------+ | 1 | 13 | | 2 | 9 | | ... Read More

Feed: Planet MySQL; Author: HowToForge; Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on an Ubuntu 18.04 LTS server with PHP 7.2 support (through PHP-FPM) and MySQL support (LEMP = Linux + nginx (pronounced "engine x") + MySQL + PHP). Prerequisites Ubuntu 18.04 LTS Server Root privileges What we will do? Install Nginx Install MySQL Install PHP-FPM Configure Nginx and PHP-FPM Install PhpMyAdmin Configure PhpMyAdmin Testing Step 1 - Install Nginx Nginx or engine x is a high-performance HTTP ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; I've got few comments to my post on references to MariaDB in MySQL bug reports (not in the blog, but via social media and in personal messages), and all but one comments from current and former colleagues whose opinion I value a lot confirmed that this really looks like a kind of attempt to advertise MariaDB. So, from now on I'll try to keep my findings on how tests shared by MySQL bug reporters work in MariaDB for myself, MariaDB JIRA and this blog (where I can and will advertise whatever makes sense to ... Read More

Feed: Planet MySQL; Author: Vlad Mihalcea; (Last Updated On: April 2, 2019) Introduction In this article, we are going to see how a relational database executes SQL statements and prepared statements. SQL statement lifecycle The main database modules responsible for processing a SQL statement are: the Parser, the Optimizer, the Executor. A SQL statement execution looks like in the following diagram. Parser The Parser checks the SQL statement and ensures its validity. The statements are verified both syntactically (the statement keywords must be properly spelled and following the SQL language guidelines) and semantically (the referenced tables and column do exist ... Read More

Feed: Planet MySQL; Author: Giuseppe Maxia; In the previous post about the dbdeployer recipes we saw the basics of using the cookbook command and the simpler tutorials that the recipes offer.Here we will see some more advanced techniques, and more demanding examples.We saw that the recipe for a single deployment would get a NOTFOUND when no versions were available, or the highest MySQL version when one was found.$ dbdeployer cookbook show single | grep version= version=$1 [ -z "$version" ] && version=8.0.16But what if we want the latest Percona Server or MariaDB for this recipe? One solution would be to ... Read More

Feed: Planet MySQL; Author: Jesper Krogh; Today is World Backup Day, so I thought I would use the opportunity to discuss some best practices and general considerations regarding backing up MySQL instances. While I focus on MySQL, several of these tips apply to backups in general. Backup you dataBefore heading into the gory details, let’s first take a look at the best practices at a high level: Make sure you can restore your backups:Document and script the restore procedures. Do you know the steps required to restore a full backup – or a single table?Keep copies of the backups off-site ... Read More

Feed: Planet MySQL; Author: Severalnines; Why Choose MySQL Replication? Some basics firast about the replication technology. MySQL Replication is not complicated! It is easy to implement, monitor, and tune as there are various resources you can leverage - google being one. MySQL Replication does not contain a lot of configuration variables to tune. SQL_THREAD and IO_THREAD's logical errors aren't that hard to understand and fix. MySQL Replication is very popular nowadays and offers a simple way of implementing database High Availability. Powerful features such as GTID (Global Transaction Identifier) instead of the old-fashioned binary log position, or lossless Semi-Synchronous Replication ... Read More