- Home
- Tag: mysqldump
Posts tagged mysqldump
Tag: mysqldump
Backup/Restore Performance Conclusion: mysqldump vs MySQL Shell Utilities vs mydumper vs mysqlpump vs XtraBackup

Feed: Planet MySQL; Author: MySQL Performance Blog; A little bit ago, I released a blog post comparing the backup performance of different MySQL tools such as mysqldump, the MySQL Shell feature called Instance Dump, mysqlpump, mydumper, and Percona XtraBackup. You can find the first analysis here: Backup Performance Comparison: mysqldump vs. MySQL Shell Utilities vs. mydumper vs. mysqlpump vs. XtraBackup However, we know the backups are just the first part of the story. What about the restore time? And which tool performs better for the complete operation (backup+restore)? Let’s see the results and the conclusion in the following sections. Benchmark Results ... Read More
Backup Performance Comparison: mysqldump vs MySQL Shell Utilities vs mydumper vs mysqlpump vs XtraBackup

Feed: Planet MySQL; Author: MySQL Performance Blog; In this blog post, we will compare the performance of performing a backup from a MySQL database using mysqldump, MySQL Shell feature called Instance Dump, mysqlpump, mydumper, and Percona XtraBackup. All these available options are open source and free to use for the entire community. To start, let’s see the results of the test. Benchmark Results The benchmark was run on an m5dn.8xlarge instance, with 128GB RAM, 32 vCPU, and 2xNVMe disks of 600GB (one for backup and the other one for MySQL data). The MySQL version was 8.0.26 and configured with 89Gb ... Read More
mysqldump Best Practices: Part 2 – Migrations Guide

Feed: Planet MySQL; Author: ScaleGrid.io; In the second and final part of our mysqldump best practices we will talk about how to handle the migration and import for stored program objects and views from your MySQL database. To read more about the prerequisites for a successful dump and restore operation for large MySQL databases, check out the first part of this 2-part blog series. Importing your stored procedures, functions and triggers By default, mysqldump imports views and triggers. However it does not import procedures, functions and events. To import procedures and functions, the --routines option should be specified, and to ... Read More
How to Rename a MySQL Database?

Feed: Planet MySQL; Author: Alena Subotina; Eventually, it appears necessary to change the name of a database in MySQL. For that purpose, we used to apply a simple RENAME DATABASE command that existed in earlier versions of MySQL. However, it became no longer available in the newer versions as it posed risks. The reason was that the RENAME DATABASE query could result in the loss of essential database contents, which clearly was undesirable. Renaming Tables Method There is a way to perform this task quite easily. In fact, MySQL version 5.5 (and later) has InnoDB Storage Engine as the default ... Read More
Galera Cluster for MySQL 5.6.51, 5.7.33, and 8.0.23 released
Feed: Planet MySQL; Author: Codership; Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 5.6, 5.7 and 8.0, consisting of MySQL-wsrep 5.6.51 (release notes, download), 5.7.33 (release notes, download) and 8.0.23 (release notes, download) with Galera replication library 3.33 (release notes, download) implementing wsrep API version 25, and Galera replication library 4.8 (release notes, download) implementing wsrep API version 26 for 8.0. This release incorporates all changes to MySQL 5.6.51, 5.7.33 and 8.0.23 respectively, adding a synchronous option for your MySQL High Availability solutions. Throughout the entire packages, for the binary ... Read More
Percona XtraBackup Point-In-Time Recovery for the Single Database

Feed: Planet MySQL; Author: Sveta Smirnova; Recovering to a particular time in the past is called Point-In-Time Recovery (PITR). With PITR you can rollback unwanted DELETE without WHERE clause or any other harmful command. PITR with Percona XtraBackup is pretty straightforward and perfectly described in the user manual. You need to restore the data from the backup, then apply all binary logs created or updated after the backup was taken, but skip harmful event(s). However, if your data set is large you may want to recover only the affected database or table. This is possible but you need to be ... Read More
MySQL Backup setup, automation using Holland, mysqldump on Ubuntu
Feed: Planet MySQL; Author: Kedar Vaijanapurkar; This post will guide you to set up and automate the MySQL logical backups using mysqldump on Ubuntu Linux. We will set-up MySQL backup using mysqldump and automate it with Holland backup framework on Ubuntu. Towards the end of the post, you have the steps to be executed in a single block which includes steps for Xtrabackup configuration. Though this post is for Ubuntu Linux with holland + mysqldump while we already have an old post to set-up Holland with Xtrabackup on Redhat / CentOS. Let’s begin the execution. root@nitty-witty:~# . /etc/os-release root@nitty-witty:~# cat ... Read More
#WDILTW – Creating examples can be hard
Feed: Planet MySQL; Author: Ronald Bradford; This week I was evaluating AWS QLDB. Specifically the verifiable history of changes to determine how to simplify present processes that perform auditing via CDC. This is not the first time I have looked at QLDB so there was nothing that new to learn. What I found was that creating a workable solution with an existing application is hard. Even harder is creating an example to publish in this blog (and the purpose of this post). First some background. Using MySQL as the source of information, how can you leverage QLDB? It’s easy to ... Read More
#WDILTW – What can I run from my AWS Aurora database
Feed: Planet MySQL; Author: Ronald Bradford; When you work with AWS Aurora you have limited admin privileges. There are some different grants for MySQL including SELECT INTO S3 and LOAD FROM S3 that replace the loss of functionality to SELECT INTO OUTFILE and mysqldump/mysqlimport using a delimited format. While I know and use lambda capabilities, I have never executed anything with INVOKE LAMDBA directly from the database.This week I found out about INVOKE COMPREHEND (had to look that product up), and INVOKE SAGEMAKER (which I used independently). These are machine learning capabilities that enable you to build custom integrations using ... Read More
Make way for the High Performance Parallel Dump & Load Utilities + How to use them

Feed: Planet MySQL; Author: Andrew Grimo; MySQL-Shell has had a set of “Util” object functions for almost a year as of this post. It is this added functionality that negates any reason someone would still need to use the old mysqldump client. It (mysqldump) helped the MySQL Community for a long, long time. It also introduced a large amount of garbage and messiness in with those bloated data files, as it really belongs to an older era. We can now move on ahead without it. This process of “moving ahead” is what I will demonstrate in this blog post. Note: ... Read More
Recent Comments