Tag: Binary Log

Feed: Planet MySQL; Author: ScaleGrid.io; Have you been experiencing slow MySQL startup times in GTID mode? We recently ran into this issue on one of our MySQL hosting deployments and set out to solve the problem. In this blog, we break down the issue that could be slowing down your MySQL restart times, how to debug for your deployment, and what you can do to decrease your start time and improve your understanding of GTID-based replication. How We Found The Problem We were investigating slow MySQL startup times on a low-end, disk-based MySQL 5.7.21 deployment which had GTID mode enabled. The system ... Read More

Feed: Planet MySQL; Author: Severalnines; Delayed replication allows a replication slave to deliberately lag behind the master by at least a specified amount of time. Before executing an event, the slave will first wait, if necessary, until the given time has passed since the event was created on the master. The result is that the slave will reflect the state of the master some time back in the past. This feature is supported since MySQL 5.6 and MariaDB 10.2.3. It can come in handy in case of accidental data deletion, and should be part of your disaster recovery plan. The ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; The MySQL, MariaDB and Friends devroom was once again flooded with submissions. The committee, consisting of community members Daniël van Eeden, Art van Scheppingen, Giuseppe Maxia and Aurélien Lequoy, as well as Tom de Cooman for Percona, Vicentiu Ciorbaru for MariaDB and Nuno Carvalho for MySQL/Oracle, had the difficult job of whittling down 67 submissions into the final 17. The following sessions were selected: Session Speaker Start End Welcome Frédéric Descamps and Ian Gilfillan 10h00 10h30 Patterns and anti-patterns in OSS participation – Lessons from MySQL AB, the MariaDB Foundation, and others Zak Greant ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST Percona announces the release of Percona Server 5.6.42-84.2 on November 29, 2018 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.6.42, including all the bug fixes in it, Percona Server 5.6.42-84.2 is the current GA release in the Percona Server 5.6 series. All of Percona‘s software is open-source and free. Improvements PS-4790: Improve user statistics accuracy Bugs Fixed Slave replication could break if upstream bug #74145 (FLUSH LOGS improperly disables the logging if the log file cannot be accessed) occurred in master. Bug fixed PS-1017 (Upstream #83232). The binary log could be corrupted when the disk partition used for temporary. files (tmpdir system ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; It's time to continue my review of MySQL bug reports that I considered interesting for some reason recently. I had not got any notable reaction from Oracle engineers to my previous post about recent regression bugs in MySQL 8.0.13, so probably this topic is not really that hot. In this boring post I'll just review some bugs I've subscribed to since August that are still not closed, starting from the oldest.Let me start with a couple of bug reports that remain "Open":Bug #91959 - "UBSAN: signed integer overflow in lock_update_trx_age". It's really unusual to see ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST Percona announces the release of Percona Server for MySQL 5.5.62-38.14 on November 21, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.5.62, including all the bug fixes in it. Percona Server for MySQL 5.5.62-38.14 is now the current GA release in the 5.5 series. All of Percona’s software is open-source and free. Note that Percona Server for MySQL 5.5.62-38.14 is the last release of the 5.5 series. This series goes EOL on December 1st, 2018. Improvements #4790: The accuracy of user statistics has been improved Bugs ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST In this Checklist for Success series, we will discuss reducing unknowns when hosting in the cloud using and migrating to Amazon Aurora. These tips might also apply to other database as a service (DBaaS) offerings. Previous blogs in the migrating to Amazon Aurora series: The whole premise of a database as a service offering is that you do not need to worry about the operating the service, you just need to use it. But all DBaaS offerings have limitations as well as strengths. You should not get too comfortable with all ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; PREVIOUS POST In this Checklist for Success series, we will discuss reducing unknowns when hosting in the cloud using and migrating to Amazon Aurora. These tips might also apply to other database as a service (DBaaS) offerings. In our previous article, we discussed the importance of continuous query performance analysis, especially in Amazon Aurora where there is less diagnostic visibility compared to running on EC2 or on-premise. Aside from uptime though, we need a lot more from our data, and we definitely cannot isolate it in Aurora. Next on our checklist is that ... Read More

Feed: Planet MySQL; Author: Jean-François Gagné; This is Part #2 of the MySQL Master Replication Crash Safety series.  In the previous post, we explored the consequence of reducing durability on masters with slaves using legacy file+position replication.  The consequences are data inconsistencies with a clear warning sign: the slaves stop replicating and report an error.  In this post, we extend our understanding of the impact of running a master with sync_binlog != 1 by considering lagging slaves that are using file+position replication.  This introduces a new inconsistency scenario without replication breakage, which is trickier to detect.  But let's start with some reminders ... Read More

Feed: Planet MySQL; Author: Dave Stokes; JSON has proven to be a very import data format with immense popularity. A good part of my time for the last two or so years has been dedicated to this area and I even wrote a book on the subject.  This is a comparison of the implementations of handling JSON data in MySQL and MariaDB. I had requests from the community and customers for this evaluation. JSON Data Types Are Not All Equal MySQL added a JSON data type in version 5.7 and it has proven to be very popular.  MariaDB has  JSON ... Read More