Author: MySQL Planet

Feed: Planet MySQL; Author: Dimitri Kravtchuk; 2018-08-14 15:00 | MySQL, Performance, InnoDB, Benchmarks, Sysbench, IO-bound, Optane, DoubleWrite, Binlog This article is inspired by Percona blog post comparing MySQL 8.0 and Percona Server 5.7 on IO-bound workload with Intel Optane storage. There are several claims made by Vadim based on a single test case, which is simply unfair. So, I'll try to clarify this all based on more test results and more tech details.. But before we start, some intro : InnoDB Parallel Flushing -- was introduced with MySQL 5.7 (as a single-thread flushing could no more follow), and implemented as ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Peter Zaitsev | August 9, 2018 |  Posted In: Containers, Docker, MySQL, Percona Monitoring and Management, PMM PREVIOUS POST When deployed through Docker Percona Monitoring and Management (PMM) uses environment variables for its configuration For example, if you want to adjust metrics resolution you can pass -e METRICS_RESOLUTION=Ns  as  an option to the docker run  command: docker run -d -p 80:80 --volumes-from pmm-data --name pmm-server --restart always -e METRICS_RESOLUTION=2s percona/pmm-server:latest docker run -d   -p 80:80   --volumes-from pmm-data   --name pmm-server   --restart always   -e METRICS_RESOLUTION=2s   percona/pmm-server:latest You would think if you want to change the setting for existing installation you can ... Read More

Feed: Planet MySQL; Author: FromDual; A while ago we released our FromDual Backup and Recovery Manager (brman) 2.0.0 for MariaDB and MySQL. So what are the new cool features of this new release?First of all brman 2.0.0 is compatible with MariaDB 10.3 and MySQL 8.0: shell> bman --target=brman:secret@127.0.0.1:3318 --type=full --mode=logical --policy=daily Reading configuration from /etc/mysql/my.cnf Reading configuration from /home/mysql/.my.cnf No bman configuration file. Command line: /home/mysql/product/brman-2.0.0/bin/bman.php --target=brman:******@127.0.0.1:3318 --type=full --mode=logical --policy=daily Options from command line target = brman:******@127.0.0.1:3318 type = full mode = logical policy = daily Resulting options config = target = brman:******@127.0.0.1:3318 type = full mode = logical policy ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Dimitri Vanoverbeke | August 13, 2018 |  Posted In: AWS, MySQL, MySQL 8.0, Technical Webinars PREVIOUS POST Please join Percona’s Solution Engineer, Dimitri Vanoverbeke as he presents Amazon Migration Service: The Magic Wand to Migrate Away from Your Proprietary Environment to MySQL on Tuesday, August 14th, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). In this talk, we will learn about the Amazon Migration Tool. The talk will cover the possibilities, potential pitfalls prior to migrating and a high-level overview of its functionalities. Register Now PREVIOUS POST Dimitri VanoverbekeAt the age of 7, ... Read More

Feed: Planet MySQL; Author: Kedar Vaijanapurkar; In this post we will see a case study of a Galera Cluster migration to AWS Aurora and quick solution to the replication issue. A friend received an error in a Master-Master replication as follows: Could not execute Write_rows event on table _database._table; Duplicate entry '65eJ8RmzASppBuQD2Iz73AAy8gPKIEmP-2018-08-03 08:30:03' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log mysql-bin-changelog.000010, end_log_pos 1107814 We talked about it and I immediately started blabbering cons of writing on both masters, how to handle, roles of apps and so on. He intervened and revealed, it is Galera Cluster ... Read More

Feed: Planet MySQL; Author: EverSQL; Introduction The goal of this article is to evaluate and highlight the main similarities and differences between the MySQL Server Database and the MariaDB Server Database. We’ll look into performance aspects, security, main features, and list all aspects which need to be considered before choosing the right database for your requirements. Who is using MySQL and MariaDB? Both MySQL and MariaDB publish a respectful list of customers who are using their database as their core data infrastructure.You can speed up any SQL query, automatically. Try it now for free. For MySQL, we can see names ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; In my recent blog posts I presented lists of bugs, fixed and not yet fixed, as usual. Working on these lists side tracked me from the main topic of this summer - problems in Oracle's way of handling MySQL. Time to get back on track!Among things Oracle could do better for MySQL I mentioned QA: "Oracle's internal QA efforts still seem to be somewhat limited. We get regression bugs, ASAN failures, debug assertions, crashes, test failures etc in the official releases, and Oracle MySQL still relies a lot on QA by MySQL Community (while ... Read More

Feed: Planet MySQL; Author: Colin Charles; Colin Charles | August 10, 2018 |  Posted In: Events and Announcements, MariaDB, MongoDB, MySQL, PostgreSQL, ProxySQL PREVIOUS POST Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. The call for submitting a talk to Percona Live Europe 2018 is closing today, and while there may be a short extension, have you already got your talk submitted? I suggest doing so ASAP! I’m sure many of you have heard of cryptocurrencies, the blockchain, and so on. But how many of you realiize that Coinbase, an ... Read More

Feed: Planet MySQL; Author: Yves Trudeau; Yves Trudeau | August 9, 2018 |  Posted In: MySQL, Percona XtraDB Cluster, Security PREVIOUS POST Recently, I wrote a blog post showing how to enforce SELinux with Percona XtraDB Cluster (PXC). The Linux distributions derived from RedHat use SELinux. There is another major mandatory discretionary access control (DAC) system, AppArmor. Ubuntu, for example, installs AppArmor by default. If you are concerned by computer security and use PXC on Ubuntu, you should enforce AppArmor. This post will guide you through the steps of creating a profile for PXC and enabling it. If you don’t want to waste ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Tate McDaniel | August 9, 2018 |  Posted In: Amazon Aurora, AWS, Events and Announcements, MySQL, Percona Monitoring and Management, PMM, Technical Webinars PREVIOUS POST Please join Autodesk’s Senior Database Engineer, Vineet Khanna, and Percona’s Sr. MySQL DBA, Tate McDaniel as they present Migrating to Aurora and Monitoring with PMM on Thursday, August 9th, 2018, at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4). Amazon Web Services (AWS) Aurora is one of the most popular cloud-based RDBMS solutions. The main reason for Aurora’s success is because it’s based on InnoDB storage engine. In this session, ... Read More