Mysql For Database Administrator

Oracle MySQL for DBA

What you'll learn

Learn to manage MySQL Database Administration

Understanding MySQL Architecture

Configuring MySQL like a Professional

Securing MySQL

Configuring a Replication Topology

Administering a Replication Topology

High Availability with MySQL InnoDB Cluster

Requirements

RDBMS Knowledge

MySQL Database Basic idea

Description

Learn about the MySQL database, which is the world’s most popular open-source database and the best database for web based applications, powering leading websites worldwide, including Facebook, Twitter, and YouTube. MySQL is a well-known open source structured database because of its performance, easiness to use, and reliability. This is the most common choice of web applications for a relational database. In the current market, thousands of web-based applications rely on MySQL including giant industries such as Facebook, Twitter, and Wikipedia. It has also proven to be the database choice for Software as a Service (SaaS) based applications such as Twitter, YouTube, SugarCRM, Supply Dynamics, Workday, RightNow, Omniture, Zimbra, and many more. We will discuss this in detail in the use cases of MySQL section later in the chapter. MySQL was developed by MySQL AB, a Swedish company, and now it is distributed and supported by Oracle Corporation. MySQL carries a valuable history with it.Let's take an in-depth look at MySQL 8 new features, benefits, use cases along with a few limitations of MySQL 8 after we have an overview of MySQL. This is going to be exciting, let's get prepared. Many industries prefer open source technology because of the technology's flexibility and cost-saving features, while MySQL has put its footprint in the market by becoming the most popular relational database for web applications. Open source means that you can view the source of MySQL and customize it based on your needs without any cost. You can download the source or binary files from its site and use them accordingly.The MySQL server is covered under the General Public License (GNU), which means that we can freely use it for web applications, study its source code, and modify it to suit our needs. It also has the Enterprise Edition as well with advanced features included. Many enterprises still purchase the support contract from MySQL to get ssistance on various issues.

Overview

Section 1: Introduction

Lecture 1 Introduction to MySQL Lab Environment

Section 2: Installing and Upgrading MySQL

Lecture 2 Installation and Upgrade MySQL

Lecture 3 Install MySQL on Linux

Lecture 4 Installing MySQL

Lecture 5 Installed Files and Directories

Lecture 6 Connecting to MySQL

Lecture 7 Configuring the MySQL Service

Lecture 8 Upgrading MySQL

Lecture 9 Deploying MySQL with Docker

Section 3: Understanding MySQL Architecture

Lecture 10 Configuring Tablespaces

Lecture 11 Configuring the Buffer Pool

Section 4: Configuring MySQL

Lecture 12 Modifying a Setting by Using Command-Line Arguments

Lecture 13 Modifying the Configuration File

Lecture 14 Changing Dynamic Settings

Lecture 15 Persisting Global Variables

Lecture 16 Configuring the Client

Lecture 17 Running Multiple MySQL Servers on the Same Host

Section 5: Monitoring MySQL

Lecture 18 Configuring the Slow Query Log

Lecture 19 Identify Slow Query Log

Lecture 20 Installing MySQL Enterprise Monitor

Lecture 21 Monitoring Server Activity

Section 6: Managing MySQL Users

Lecture 22 Creating Users and Roles

Lecture 23 Granting Permissions

Section 7: Securing MySQL

Lecture 24 Enabling SSL for Secure Connections

Lecture 25 Enabling SSL for Secure Connections_Demo

Lecture 26 Encrypting MySQL Data-at-Rest

Lecture 27 Configuring MySQL Enterprise Firewall

Professional DBA,Database Administrator,MySQL DBA,MySQL Database Administrator