Get the App
SLTechnology News&Howtos  ›  Database  › 

Introduction to Percona installation, configuration and Management of Linux platform _ MySQL Database Foundation and Project practice 05

Shulou Source: shulou.com Published: 2022-06-01 13:53:43 10月02日 Update

Introduction to Percona installation, configuration and Management of Linux platform _ MySQL Database Foundation and Project practice 05

Video tutorial learning address

Http://edu.51cto.com/course/12557.html

Oracle/MySQL database learning special QQ group: 336282998, 189070296

I. course content

1. Introduction of Percona project scenario based on Linux platform.

2. Percona database runtime environment preparation-optimal configuration

2.1) how to check the official documentation to understand the environmental requirements

2.2) install the virtual machine environment and operating system

2.3) 9 steps for optimal configuration of operating system

2.4) preparation of operating system YUM environment

2.5) the most standardized configuration of disks and partitions required for Percona

3. How to download Percona database

4. Install Percona by binary file under Linux platform

4.1) pre-installation configuration

4.2) preparation of Percona parameter files-according to production environment standards

4.3) Percona database initialization-according to production environment standard

4. 4) Percona boot auto startup configuration

4.5) important configuration and password issues in the later stage of Percona

4.6) Percona start and stop log analysis

4.7) Percona remote connection and testing

5. Install Percona through source code on Linux platform

5.1) pre-installation configuration and required software package check

5.2) preparation of Percona parameter files-according to production environment standards

5.3) Percona database initialization-by production environment standard

Percona Boot Auto start configuration

Important configuration and password problems in the later stage of Percona

5.6) Percona start and stop log analysis

5.7) Percona remote connection and testing

6. Install Percona through YUM/RPM on Linux platform

6.1) Environmental preparation

6.2) download yum repository

Download the rpm software package

6.4) install mysql

6.5) later configuration and testing

7. Configuration and running parameter settings of Percona after installation

8. Test and remote connection after Percona installation

9. Introduction of Percona basic management commands

10. How to uninstall the Percona version on the Linux platform

10.1) Uninstall the binary installation mode

10.2) Uninstall the source code installation method

10.3) Uninstall the YUM/RPM installation mode

II. Special topic recommendation

Video tutorial on MySQL High availability replication and distributed Cluster Architecture (Special Series)

Http://edu.51cto.com/topic/1622.html

This series of courses, the only one in the network, is the mainstream architecture of Internet MySQL at present, involving multiple servers, nearly 100 databases, and project experiments with tens of millions of data.

Tags: Configuration environment data database platform method preparation standard environmental standard test production project operating system parameter file system management important thematic binary Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno vpn Huawei NVidia macOS OPPO Reno