In this tutorial, we will show you how to create a backup of MySQL databases on an Ubuntu 20.04 VPS, ...
The post How to Create a Backup of MySQL Databases Using mysqldump on Ubuntu 20.04 appeared first on RoseHosting.
In this tutorial, we will show you how to create a backup of MySQL databases on an Ubuntu 20.04 VPS, ...
The post How to Create a Backup of MySQL Databases Using mysqldump on Ubuntu 20.04 appeared first on RoseHosting.
The MySQL team is proud to announce the general availability of version 8.0.21 of the MySQL Shell.
MySQL Shell Logical Dump and Load Utilities
A new suite of logical dump utilities was introduced in MySQL
Shell 8.0.21.
util.dumpInstance(),
util.dumpSchemas() and
util.loadDump()…
Facebook Twitter LinkedIn
The backup and restore of a complete database is an extensive exercise. But what if you need to restore just one table which has been mistakenly modified by an incorrect query? Help is at hand with Percona XtraBackup.
For our purpose, we will take a test database having tables created by the sysbench tool. The 8.0 versions of Percona XtraBackup and Percona Server for MySQL have been used in this test.
Restore Single Table
Here we will take the backup of the sbtest2 table and restore it. The initial checksum of the table is given below:
8.0.19>CHECKSUM TABLE sbtest2; +--------------+-----------+ | Table | Checksum | …[Read more]
The importance of having periodic backups is a given in Database life. There are different flavors: binary ones (Percona XtraBackup), binlog backups, disk snapshots (lvm, ebs, etc) and the classic ones: logical backups, the ones that you can take with tools like mysqldump, mydumper, or mysqlpump. Each of them with a specific purpose, MTTRs, retention policies, etc.
Another given is the fact that taking backups can be a very slow task as soon as your datadir grows: more data stored, more data to read and backup. But also, another fact is that not only does data grow but also the amount of MySQL instances available in your environment increases (usually). So, why not take advantage of more MySQL instances to take logical backups in an attempt to make this operation faster?
Distributed Backups (or Using all the Slaves Available)
…
[Read more]
If you want to back up your table and views, stored procedures,
or stored function definitions, you can use
mysqldump
or mysqlpump
to export the
schema without the data. However, if you just want the views you
need to look for another option. This blog shows how MySQL Shell
comes to the rescue.
Backup the view definition using MySQL Shell
There are a couple of approaches to get the view definitions. One
option is to consider the information_schema.VIEWS
view which has the following columns:
mysql> SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'information_schema' AND TABLE_NAME = 'VIEWS' ORDER BY ORDINAL_POSITION; …[Read more]
In a MySQL 5.7 master-slave setup that uses the default semisynchronous replication setting for rpl_semi_sync_master_wait_point, a crash of the master and failover to the slave is considered to be lossless. However, when the crashed master comes back, you may find that it has transactions that are not present in the current master (which was previously a slave). This behavior may be puzzling, given that semisynchronous replication is supposed to be lossless, but this is actually an expected behavior in MySQL. Why exactly this happens is explained in full detail in the …
[Read more]In my previous blog, I have explained how the MySQL clone plugin works internally. In this blog, I am going to do a comparison of Backup and Recovery speed of MySQL clone plugin with other available mysql open source backup tools.
Below tools are used for speed comparison of Backup and Recovery,
Test …
[Read more]I miss a proper database related newsletter for busy people. There’s so much happening in the space, from tech, to licensing, and even usage. Anyway, quick tab sweep.
Paul Vallée (of Pythian fame) has been working on Tehama for sometime, and now he gets to do it full time as a PE firm, bought control of Pythian’s services business. Pythian has more than 350 employees, and 250 customers, and raised capital before. More at Ottawaâ€s Pythian spins out software platform Tehama.
Database leaks data on most of Ecuador’s citizens, including 6.7 million children – ElasticSearch.
Percona has …
[Read more]We have been working with PMM for quite a long time, we do most of the performance analysis with PMM for most of our clients. It also provides the flexibility that we have built our own custom dashboard. PMM has many advantages
Highly recommended for any production deployments its equivalent to Enterprise-grade monitoring and graphing tool.
Recently we have been working for our client on MySQL Consulting to scale peak sale of the year. Wherein we have deployed PMM to view the performance …
[Read more]Percona is glad to announce the release of Percona XtraBackup 8.0.7 on August 7, 2019. You can download it from our download site and apt and yum repositories.
Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, it …
[Read more]