Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying MySQL 8 Cookbook
  • Table Of Contents Toc
  • Feedback & Rating feedback
MySQL 8 Cookbook

MySQL 8 Cookbook

By : Karthik Appigatla
3.5 (4)
close
close
MySQL 8 Cookbook

MySQL 8 Cookbook

3.5 (4)
By: Karthik Appigatla

Overview of this book

MySQL is one of the most popular and widely used relational databases in the World today. The recently released MySQL 8 version promises to be better and more efficient than ever before. This book contains everything you need to know to be the go-to person in your organization when it comes to MySQL. Starting with a quick installation and configuration of your MySQL instance, the book quickly jumps into the querying aspects of MySQL. It shows you the newest improvements in MySQL 8 and gives you hands-on experience in managing high-transaction and real-time datasets. If you've already worked with MySQL before and are looking to migrate your application to MySQL 8, this book will also show you how to do that. The book also contains recipes on efficient MySQL administration, with tips on effective user management, data recovery, security, database monitoring, performance tuning, troubleshooting, and more. With quick solutions to common and not-so-common problems you might encounter while working with MySQL 8, the book contains practical tips and tricks to give you the edge over others in designing, developing, and administering your database effectively.
Table of Contents (15 chapters)
close
close

Introduction


After setting up the database, the next important thing is to set up backups. In this chapter, you will learn how to set up various types of backups. There are two main ways to perform a backup. One is logical backup, which exports all the databases, table structures, data, and stored routines into a set of SQL statements that can be executed again to recreate the state of the database. The other type is physical backup, which contains all the files on the system that the databases used to store all the database entities:

  • Logical backup utilities: mysqldump, mysqlpump, and mydumper (not shipped with MySQL)
  • Physical backup utilities: XtraBackup (not shipped with MySQL) and flat file backup

For point-in-time recovery, the backup should be able to provide the binary log positions up to which the backups are taken. This is called a consistent backup.

It is highly recommended to take backups from a slave onto a filer mounted on it. 

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY