Brief Introduction
A beginner’s guide to the upgraded version of MySQL 8 AdministrationDescription
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.
About The Author
Peter Boros has more than 10 years of MySQL administration experience. Peter has also taught Oracle University courses about MySQL across EMEA, later he was a Principal Architect at Percona, a company specializing in MySQL consulting. Apart from this, he has worked with a few of the world’s largest MySQL deployments, belonging to prestigious web properties. This course is a product of Peter’s immense work experience and his expertise on the subject.
Requirements
- Requirements
- Basic knowledge of MySQL is required
Packt Publishing
3.8 Raiting
The Complete Java Certification Course
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Become a confident industry ready core Java developer and get certified as a Java professional! LAST UPDATED: November 2020 - Latest updates include Lambdas and Streams with Java 9 Features....
Statistical Data Analysis with Java
- 4
-
![]()
![]()
![]()
![]()
![]()
Analyze your data efficiently with Java and visualize it in no time! Then this course is for you! Then you'll learn about how to obtain, understand, and evaluate the text....
Excel Exam MO-201: Microsoft Excel Expert (2019/Office 365)
- 4.8
-
![]()
![]()
![]()
![]()
![]()
Ace the Excel MO-201 Exam and earn your Microsoft Expert Certification, with full practice tests + study guides EXCEL EXAM MO-201: MICROSOFT EXCEL EXPERT Analyzing data with formulas & macros...
U101: Understanding College and College Life
- 4.6
-
![]()
![]()
![]()
![]()
![]()
College can be confusing and intimidating, but U101 can help. At the conclusion of the course, learners should: 1. Understand the basics of how colleges and universities operate....
