1、 Fengge MySQL DBA Project Practice Series Training Course (01): Win2022+MySQL 5.7/8.0/8.4 Installation Configuration
Learning of this course:
MySQL DBA Practical Training Series (1) : Win2022+MySQL 5.7/8.0/8.4 Installation Configuration
(*) MySQL project scenario based on Windows platform
(*) MySQL database running environment preparation
(*) How to download MySQL database
(*) Install MySQL 5.7.44 on Windows Server
(*) Install MySQL 8.0.37 on Windows Server
(*) Install MySQL 8.4 on Windows Server
(*) Parameter optimization adjustment and post configuration after MySQL installation
(*) How to uninstall MySQL on Windows platform
Welcome to:
51CTO school style brother Oracle/MySQL/PG database learning dedicated QQ group: 454129134, 925203979
II Introduction and training courses of Fengge MySQL DBA project outline
In order to meet the students who want to quickly master the MySQL database installation configuration and cluster, Feng Brother specially designed a comprehensive set of MySQL installation configuration and cluster project database courses. This series includes 6 courses, and the contents are as follows:
1) Win2022+MySQL 5.7/8.0/8.4 Installation Configuration
2) MySQL 8.0 database installation configuration and version upgrade on Linux platform
3) MySQL 8.4 database installation configuration and version upgrade on Linux platform
4) Linux Platform MySQL 8.4 Database Master Slave Replication Cluster Project
5) Linux platform MySQL 8.4 MGR group replication cluster project
6) Linux Platform MySQL8.4 InnoDB Cluster Project
It is suitable for various operation and maintenance personnel/developers and can fully meet the business production environment.
Topic address: MySQL DBA project practice series [MySQL 8.4 latest version]
https://edu.51cto.com/topic/6274.html
![1717044179338021.png mysql-dba-0.png](https://s2.51cto.com/images/20240530/1717044179338021.png)
![1717044186209241.png mysql-dba-1.png](https://s2.51cto.com/images/20240530/1717044186209241.png)
Series course name | Course content |
MySQL DBA practical training series (1): Win2022+MySQL 5.7/8.0/8.4 Installation Configuration | 1.1. MySQL Project Scenario Based on Windows Platform 1.2. MySQL Database Running Environment Preparation 1.3. How to download MySQL database 1.4. Installing MySQL 5.7 on Windows Server 1.5. Install MySQL 8.0 on Windows Server 1.6. Installing MySQL 8.4 on Windows Server 1.7. Parameter Optimization Adjustment and Later Configuration after MySQL Installation 1.8. How to uninstall MySQL on Windows |
MySQL DBA practical training series (2): MySQL 8.0 database installation configuration and version upgrade on Linux platform
| 2.1. Introduction to New Features and Functions of MySQL 8.0 Database 2.2. MySQL Project Practice Based on Linux Platform 2.3. MySQL 8.0 Database Running Environment Preparation 2.4. How to download MySQL 8.0 database 2.5. Installing MySQL 8.0 in Binary File Mode on Linux Platform 2.6. Configuration and Operation Parameter Settings after MySQL 8.0 Installation 2.7. Testing and remote connection after MySQL 8.0 installation 2.8. MySQL 8.0 Upgrade Scheme and Practice on Linux Platform 2.9. About MySQL version upgrade method and precautions 2.10. Upgrade from MySQL 8.0. x to MySQL 8.0. x 2.11. MySQL 8.0 Basic Management Commands and FAQs 2.12. How to uninstall MySQL 8.0 on Linux 2.13. Instructions for installing MySQL 8.0 with source code, YUM and RPM under Linux |
MySQL DBA practical training series (3): MySQL 8.4 database installation configuration and version upgrade on Linux platform
| 3.1. MySQL 8.4 project environment preparation based on Linux platform 3.2. MySQL Database Running Environment Preparation 3.3. Install virtual machine environment and Linux operating system 3.4 Linux operating system environment parameters 3.5. How to download MySQL database 3.6. Installing MySQL 8.4 through source code on Linux platform 3.7. MySQL Database Source Code Installation Process 3.8. MySQL parameter file preparation - according to production environment standards 3.9. MySQL database initialization - according to production environment standards 3.10. Configure MySQL Startup Script 3.11. Testing and remote connection after MySQL 8.4 installation |
MySQL DBA practical training series (4): Linux Platform MySQL 8.4 Database Master Slave Replication Cluster Project
| 4.1. MySQL 8.4 Master Slave Replication Cluster Project Requirements 4.2. MySQL 8.4 Database Environment Preparation 4.3. MySQL 8.4 Master Slave Replication Configuration Process
4.4. MySQL 8.4 Master Slave Switching Process 4.5. MySQL 8.4 Application and Practice of New Functions of Master Slave Replication |
MySQL DBA practical training series (5): Linux platform MySQL 8.4 MGR group replication cluster project | 5.1. MGR Basic Knowledge of MySQL Master Slave Replication Technology 5.2. MySQL 8.4 MGR cluster project requirements and environment preparation 5.3. MySQL 8.4 MGR Group Replication Configuration Process 5.4. Modify the database configuration file (my. cnf) 5.5. Modify database server_uuid 5.6. MySQL 8.4 Configuration of the First MGR Node 5.7. MySQL 8.4 Configuration of Other MGR Nodes 5.8. MySQL 8.4 MGR Data Synchronization Test 5.9. MySQL 8.4 MGR cluster start and stop operations 5.10. MGR cluster startup and shutdown under normal conditions 5.11. MGR cluster start/stop operation under abnormal conditions 5.12. MySQL 8.4 MGR cluster adds/deletes nodes online 5.13. Online addition of nodes by MySQL MGR (clone mode) 5.14. MySQL MGR Online Delete Node |
MySQL DBA practical training series (6): Linux Platform MySQL8.4 InnoDB Cluster Project | 6.1. MySQL InnoDB Cluster Architecture Foundation 6.2. MySQL InnoDB Cluster Project Requirements and Environment Preparation 6.3. MySQL InnoDB Cluster Cluster Configuration Process 6.4. MySQL MGR cluster startup 6.5. MySQL Shell Installation and Basic Use 6.6. Creating a MySQL Innodb Cluster 6.7. Master slave switch of MySQL InnoDB Cluster cluster 6.8. Starting and Stopping the MySQL InnoDB Cluster Cluster 6.9. MySQL Router Installation Configuration 6.10. MySQL Router Installation Process 6.11. MySQL Router Configuration File Generation 6.12. MySQL Router Startup Script Configuration 6.13. InnoDB Cluster Testing 6.14. Daily Maintenance Operations of MySQL InnoDB Cluster |
3、 Fengge Oracle/MySQL/PG/NoSQL training class series courses (system, case, actual combat)
one ) Oracle Cloud database senior Engineer training course
https://edu.51cto.com/mic-position/131.html
two ) MySQL Database Senior Engineer Training Course
https://edu.51cto.com/mic-position/303.html
three ) PostgreSQL data base senior Engineer training course
https://e.51cto.com/training_1355.html
four )Database architect (Oracle+MySQL+PG) Sharing of series of training courses one point five (regularly updated)
http://www.fgedu.net.cn/oracle.html
4、 Xinchuang. Domestic Database Engineer Training Topic 2.0 (8 databases in total)
--------------------------------------------------------------------------------
Address: https://edu.51cto.com/topic/5452.html
Xinchuang. Domestic Database Engineer Training Topic 2.0 (including: Da Meng, NPC Jincang, Nanda GM, Huawei Gauss openGauss、TiDB,TDSQL,OceanBase)
5、 Big Data Operation and Maintenance Architects Practical Training Topic 2.0
--------------------------------------------------------------------------------
Address: https://edu.51cto.com/topic/4539.html
Familiar with Hadoop big data ecological technology framework, including Cloudera CDH HDFS、Yarn、Hbase、Hive、
Zookeeper, Kafka, Spark, Flink, Flume, Sqoop, ETL/Kettle, ELK, Azkaban and other groups
Component installation configuration and daily maintenance management. Including the construction and maintenance of OLAP database platforms such as Elastic Search, ClickHouse, GreenPlum, TiDB, etc.