Tag: MySQL 5.7

Feed: Planet MySQL; Author: Shree Nair; MySQL 8 introduced a number of enhancements to improve both replication performance and the monitoring thereof. Improvements included more efficient replication of small updates on big JSON documents, the addition of Performance Schema tables for slave performance metrics, tracing and debug logging improvements, among others. With regards to monitoring, Group Replication has been improved by introducing new replication timestamps, additional columns to the performance schema, as well as by making the relationship between replication threads more efficient. We covered the various improvements to replication performance in the Replication Performance Enhancements in MySQL 8 blog ... Read More

Feed: Planet MySQL; Author: MySQL High Availability; Further to our earlier blog post about Fail-safe enhancements to Group Replication, where we discussed enhancements against data modification in members which are not ONLINE, we now present here additional changes to protect data from being accidentally modified by asynchronous replication channels. Asynchronous replication is one of the pillars of MySQL and widely used with MySQL databases. They are also widely used across Group Replication clusters to scale out the reads by connecting asynchronous read slaves to a group and to bind groups together with circular replication for the wide area clusters. We ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Vadim Tkachenko | July 13, 2018 |  Posted In: Benchmarks, MySQL, MySQL 8.0, Percona Server for MySQL PREVIOUS POST Recently, Dimitri published the results of measuring MySQL 8.0 on Intel Optane storage device. In this blog post, I wanted to look at this in more detail and explore the performance of MySQL 8, MySQL 5.7 and Percona Server for MySQL using a similar set up. The Intel Optane is a very capable device, so I was puzzled that Dimitri chose MySQL options that are either not safe or not recommended for production workloads. Since we have an ... Read More

Feed: Planet MySQL; Author: Alexander Rubin; Alexander Rubin | July 12, 2018 |  Posted In: Benchmarks, MySQL, MySQL 8.0 PREVIOUS POST MySQL stored procedures, functions and triggers are tempting constructs for application developers. However, as I discovered, there can be an impact on database performance when using MySQL stored routines. Not being entirely sure of what I was seeing during a customer visit, I set out to create some simple tests to measure the impact of triggers on database performance. The outcome might surprise you. Why stored routines are not optimal performance wise: short version Recently, I worked with a customer to profile ... Read More

Feed: Planet MySQL; Author: The Pythian Group; Scary movies for teenagers and database administration tasks share some common traits. Usually, the movie starts with a group of teens making unwise choices. Maybe you, as a DBA, are no longer a teenager, but you shouldn’t underestimate your ability to do the same. $ sudo su - Darrera entrada: ds jun 2 14:43:53 UTC 2018 des de a a pts/0 [root@mysql ~]# cd /var/lib/mysql [root@mysql mysql]# df -h . Filesystem Size Used Avail Use% Mounted on /dev/mapper/VolGroup00-LogVol00 38G 35G 3G 92% / [root@mysql mysql]# Back to the movie…today is just another regular ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Michael Coburn | July 6, 2018 |  Posted In: Events and Announcements, MariaDB, MongoDB, MySQL, Percona Server for MongoDB, Percona Server for MySQL, Percona Toolkit PREVIOUS POST Percona announces the release of Percona Toolkit 3.0.11 on July 6, 2018. Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL®, MongoDB® and system tasks that are too difficult or complex to perform manually. With over 1,000,000 downloads, Percona Toolkit supports Percona Server for MySQL, MySQL®, MariaDB®, Percona Server for MongoDB and MongoDB ... Read More

Feed: Planet MySQL; Author: Mike Frank; There could be from one to over ten ports used within your MySQL ecosystem.  It really depends on what you have enabled, which components you are using, how your applications connect, and other characteristics of your environment. From a security point, these ports need to be opened just wide enough to allow the various components  that should communicate to talk while blocking out anything else trying to hack its way in – the goal being to enforce the security principle of “least privilege”.  Obviously, what you should not do is open everything to get things ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Francisco Bordenave | July 9, 2018 |  Posted In: Group Replication, High-availability, InnoDB, MySQL PREVIOUS POST Since MySQL 5.7 we have a new player in the field, MySQL InnoDB Cluster. This is an Oracle High Availability solution that can be easily installed over MySQL to get High Availability with multi-master capabilities and automatic failover. This solution consists in 3 components: InnoDB Group Replication, MySQL Router and MySQL Shell, you can see how these components interact in this graphic: In this three blog post series, we will cover each of this components to get a sense of ... Read More

Feed: Planet MySQL; Author: Alexander Rubin; Alexander Rubin | July 4, 2018 |  Posted In: Amazon Aurora, Amazon RDS, Insight for DBAs, MySQL, Replication PREVIOUS POST Amazon RDS Aurora (MySQL) provides its own low latency replication. Nevertheless, there are cases where it can be beneficial to set up replication from Aurora to an external MySQL server, as Amazon RDS Aurora is based on MySQL and supports native MySQL replication. Here are some examples of when replicating from Amazon RDS Aurora to an external MySQL server can make good sense: Replicating to another cloud or datacenter (for added redundancy) Need to use an independent ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Spyros Voultepsis | July 3, 2018 |  Posted In: Insight for DBAs, MySQL, MySQL 8.0, Percona Server for MySQL, Percona XtraDB Cluster, XtraDB Cluster PREVIOUS POST In this post we will review the most important Linux settings to adjust for performance tuning and optimization of a MySQL database server. We’ll note how some of the Linux parameter settings used OS tuning may vary according to different system types: physical, virtual or cloud. Other posts have addressed MySQL parameters, like Alexander’s blog MySQL 5.7 Performance Tuning Immediately After Installation. That post remains highly relevant for the latest versions of MySQL, 5.7 ... Read More