This post is for the backup script for MySQL database on Linux with mail. It’s a linux shell script for taking logical backup using mysqldump and sending status email. The backup shell script works as follows: – The script takes backup using mysqldump and compresses it. – Upon success, it will attempt to ship the […]
10 Older Entries »
You say you want a Replication?
One of the best features of MySQL is the ability to use MySQL‘s built-in database replication feature to automatically replicate data from one server (source/master) to another (slave/replica). Group Replication was added in MySQL 5.7 as a way to provide a high-availability solution using a new variation of MySQL replication.
(In some earlier posts, I explained how to setup Group Replication using three MySQL database servers and how to …[Read more]
This tutorial is for you that is trying to import your current
database into a Google Cloud SQL instance,
that will be setup for replication purposes.
According to the documentation, you will need to run:
mysqldump \ -h [MASTER_IP] -P [MASTER_PORT] -u [USERNAME] -p \ --databases [DBS] \ --hex-blob --skip-triggers --master-data=1 \ --order-by-primary --compact --no-autocommit \ --default-character-set=utf8 --ignore-table [VIEW] \ --single-transaction --set-gtid-purged=on | gzip | \ gsutil cp - gs://[BUCKET]/[PATH_TO_DUMP]
mysqldump parameters are:
-hthe hostname or IPV4 address of the
-Pthe port or the
primaryserver, usually …
How to Restore A Table / Database From Full Backup using MySQL Grants & mysqldump.
Percona announces the release of Percona Server for MySQL 5.6.36-82.0 on May 12, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository.
Based on MySQL 5.6.36, and including all the bug fixes in it, …[Read more]
is a utility that performs logical backups (which means backing up your data as SQL statements instead of a raw copy of data files). It was added in MySQL Server version 5.7.8, and can be used to dump a database or a set of databases to a file and then loaded on another SQL server (not necessarily a MySQL server).
Its usage is similar to
, but it includes a new set of features. Many of the options are the same, but it was written from scratch to avoid being limited to
compatibility. The Main Features Include:
- To make the dump process faster, it allows parallel processing of databases and objects within databases. …
Percona announces the GA release of Percona Server for MySQL 5.7.17-13 on April 5, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository.
Based on MySQL 5.7.17, including all the bug fixes in it, Percona Server for MySQL 5.7.17-13 is the current GA release in the Percona Server for MySQL 5.7 series. Percona’s …[Read more]
Percona announces the release of Percona Server 5.6.35-81.0 on March 24, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository.
Based on MySQL 5.6.35, and including all the bug fixes in it, Percona …[Read more]
Most users of MySQL utilize the mysqldump utility to backup their database. While mysqldump is handy and easy-to-use (and free), if you have data which is important to your business, then you should take a look at the MySQL Enterprise Edition – and use MySQL Enterprise Backup instead. The MySQL Enterprise Backup allows you to backup your database without the table locking you get with mysqldump. And, it is extremely fast – especially when you have to restore your database. Here is a sample speed comparison between MySQL Enterprise Backup and …[Read more]
10 Older Entries »