Tag: MySQL 5.7

Feed: Planet MySQL; Author: ScaleGrid.io; In this blog post, we review some of the important aspects of configuring and managing SSL in MySQL hosting. These would include the default configuration, disabling SSL, and enabling and enforcing SSL on a MySQL server. Our observations are based on the community version of MySQL 5.7.21. Default SSL Configuration in MySQL By default, MySQL server always installs and enables SSL configuration. However, it is not enforced that clients connect using SSL. Clients can choose to connect with or without SSL as the server allows both types of connections. Let’s see how to verify this ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Jericho Rivera | September 17, 2018 |  Posted In: MySQL, Percona Server for MySQL, Security PREVIOUS POST This is the first of a two-part series on using the keyring_vault plugin with Percona Server for MySQL 5.7. The second part will walk you through on how to use Percona Xtrabackup to backup from this instance and restore to another server and set it up as a slave with keyring_vault plugin. What is the keyring_vault plugin? The keyring_vault is a plugin that allows the database to interface with a Hashicorp Vault server to store and secure encryption keys ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Abbas Ahmed | September 13, 2018 |  Posted In: Amazon Aurora, Amazon RDS, AWS, MySQL, Percona Toolkit, Performance Tuning PREVIOUS POST In this blog post we shall discuss how you can analyze slow query logs from Amazon Aurora for MySQL, (referred to as Amazon Aurora in the remaining blog). The tools and techniques explained here apply to the other MySQL compatible services available under Amazon Aurora. However, we’ll focus specially on analyzing slow logs from Amazon Aurora version 2 (MySQL 5.7 compatible) using pt-query-digest. We believe there is a bug in Aurora where it logs really ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Borys Belinsky and Dmitriy Kostiuk | September 12, 2018 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona Software PREVIOUS POST Percona announces the release of Percona Server for MySQL 5.7.23-23 on September 12, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.7.23, including all the bug fixes in it. Percona Server for MySQL 5.7.23-23 is now the current GA release in the 5.7 series. All of Percona’s software is open-source and free. New Features The max_binlog_files variable is deprecated, and the binlog_space_limit variable should be used instead of it. The ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . The following is a list of incompatibilities and feature differences between MariaDB 10.3 and MySQL 5.7 Storage Engines In addition to the standard MyISAM, BLACKHOLE, CSV, MEMORY, ARCHIVE, and MERGE storage engines, the following are also available with MariaDB 10.3: Speed Improvements Many optimizer enhancements. Subqueries are more usable. The complete list and a comparison with MySQL is here. Instant ADD COLUMN DDL Fast Fail - WAIT/NOWAIT Faster and safer replication: Group commit for the binary log. This makes many setups that use replication and lots of updates more than 2x times ... Read More

Feed: Planet MySQL; Author: Kentoku SHIBA; MySQL 5.7 and 8.0 have an issue of stopping replication on all slaves. An issue of all slaves stop replication from Kentoku ... Read More

Feed: Planet MySQL; Author: EverSQL; This is the first part of our SQL Performance Tuning series. In this article, we’ll focus and MySQL related examples, but the same concepts can be applied to many other relational databases. Now more than ever, software engineers need to have vast knowledge in SQL performance tuning.The shift is happening in both small startups and large enterprises. Nowadays, developers are the ones writing the SQL queries and database access layer.You can speed up any SQL query, automatically. Try it now for free. As technology advances, even the most novice end-users are becoming impatient and will ... Read More

Feed: Planet MySQL; Author: Jean-François Gagné; A colleague brought an article to my attention.  I did not see it on Planet MySQL where I get most of the MySQL news (or it did not catch my eye there).  As it is interesting replication stuff, I think it is important to bring it to the attention of the MySQL Community, so I am writing this short post.The surprising part for me is that it uses my 4-year-old work for online migration to GTID with MySQL 5.6.  This is a completely unforeseen use case of my work as I never thought that my ... Read More

Feed: Planet MySQL; Author: Codership; Codership is pleased to announce the release of Galera Replication library 3.24, implementing wsrep API version 25.  The new release includes improved deadlock error management with foreign keys and security fixes. As always, Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Red Hat, Debian, CentOS, OpenSUSE and SLES, as well as FreeBSD. Obtaining packages using a package repository removes the need to download individual files and facilitates the easy deployment and upgrade of Galera Cluster nodes. This release incorporates all changes up to MySQL ... Read More

Feed: Planet MySQL; Author: HowToForge; Ghost is a powerful open source publishing and blog platform based on nodejs. It's well designed and easy to use. The ghost platform is written in JavaScript and uses node.js as a runtime environment. The first Ghost version released in 2013 under the MIT license.. Traefik is modern HTTP reverse proxy and load balancer for microservices. Traefik makes all microservices deployment easy, integrated with existing infrastructure components such as Docker, Swarm Mode, Kubernetes, Amazon ECS, Rancher, Etcd, Consul etc. In this tutorial, we will show step-by-step how to install and configure Ghost as a Docker ... Read More