-MySQL-8-for-Administrators

KO | EN

gitlite — search

#python #java #python3 #arduino #golang #machine-learning #rust #html #flask #javascript #seismology #nodejs

-MySQL-8-for-Administrators

★ 12 Open GitHub ↗

MySQL 8 for Administrators, by Packt Publishing

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# MySQL 8 for Administrators [Video]
This is the code repository for [MySQL 8 for Administrators [Video]](https://www.packtpub.com/big-data-and-business-intelligence/mysql-8-administrators-video?utm_source=github&utm_medium=repository&utm_campaign=9781788398329), published by [Packt](https://www.packtpub.com/?utm_source=github). It contains all the supporting project files necessary to work through the video course from start to finish.
## About the Video Course
MySQL is the world’s most popular open source database. Since the release of MySQL 5.0 in 2003, it is MySQL 8 that comes with a major update.

This course goes over the basics of MySQL administration, through examples on MySQL 8. It also covers the differences between various MySQL versions. It starts off with the basics: Installing MySQL and Creating users. After that, we will get sysbench up and running. Sysbench, responsible for issuing queries against databases, is the de-facto benchmarking tool for MySQL. With that hands-on lab environment at hand, we will learn about various database administration topics like backups, replication, monitoring, point in time recovery, switchovers, user management and version upgrades.

Upon completing this course, you will be able to set up new MySQL databases and perform basic administration tasks using the latest version.

<H2>What You Will Learn</H2>
<DIV class=book-info-will-learn-text>
<UL>
<LI>Install and setup MySQL 8 to explore basic administration tasks.
<LI>Handle MySQL user management.
<LI>How to back up and restore MySQL databases
<LI>How to set up and operate MySQL replication, including moving to GTID based replication
<LI>How to perform a point in time recovery
<LI>How to set up monitoring for MySQL databases
<LI>How to perform switchovers (promote a slave to master database)
<LI>How to handle MySQL version upgrades. </LI></UL></DIV>

## Instructions and Navigation
### Assumed Knowledge
To fully benefit from the coverage included in this course, you will need:<br/>
To fully benefit from the coverage included in this course, you will need:
●	Be comfortable using Linux operating system from the command line.
●	Know SQL basics (the course won’t cover what a SELECT is

### Technical Requirements
This course has the following software requirements:<br/>
This course has the following software requirements:
●	Vagrant
●	VirtualBox 5.2.10

## Related Products
* [MySQL 8 Administrator's Guide](https://www.packtpub.com/big-data-and-business-intelligence/mysql-8-administrator’s-guide?utm_source=github&utm_medium=repository&utm_campaign=9781788395199)

* [MySQL 8 Cookbook](https://www.packtpub.com/big-data-and-business-intelligence/mysql-8-cookbook?utm_source=github&utm_medium=repository&utm_campaign=9781788395809)

* [MySQL 8 for Administrators [Video]](https://www.packtpub.com/big-data-and-business-intelligence/mysql-8-administrators-video?utm_source=github&utm_medium=repository&utm_campaign=9781788398329)

-MySQL-8-for-Administrators

Explore Similar Repositories

Was this content helpful?

Recent Feedback

Download README