Advanced 4.2
12 months 30 days
$299.00 $239.00
0 Learners 19 Reviews 0 Favorites
- Overview
- Outline
- Reviews
- Packages
This course will learn to install and use PXC in a Linux environment, and will also allow students to learn to build a PXC cluster with three high characteristics. In addition, we will also learn to use PXC clusters to solve some difficult problems in the database field, such as separation of hot and cold data, big data archiving, massive data import, etc. These are all hot issues that every large-scale system database will encounter. Through this course, you will find reasonable solutions. The last part of this course will lead you to understand many options for database architecture design.
Course summary
- course guiding14:44
- Development environment requirements20:45
Create a PXC cluster
- CentOS installs PerconaServer database16:00
- Install PXC and form a cluster17:56
- Common management of PXC clusters-database cluster usage22:33
- Common management of PXC clusters-status parameters11:56
- Launch and shutdown of PXC nodes23:38
- Comparison of MySQL cluster middleware13:32
- Configure MyCat Load Balancer14:24
- data segmentation26:58
- parent-son list11:59
- Build a dual-machine hot standby MyCat cluster-Build a highly available MyCat cluster16:46
- Build a MyCat cluster with dual-machine hot standby-use keepalived to seize virtual IP15:15
- Sysbench Benchmark-Install Sysbench28:16
- Sysbench Benchmarking-Using Sysbench25:30
- Tpcc-mysql stress test12:38
Principles of PXC clustering
- binlogs24:59
- PXC synchronization principle20:51
Business requirements and MySQL architecture design
- 5 special architectural designs for MySQL13:34
- Database design principles28:54
Common database business processing
- Import large amounts of data into a cluster-understand the basic Xtend syntax29:04
- Importing large amounts of data into a cluster-data ready to be imported into the cluster13:08
- Import large amounts of data into a cluster-Import data into a PXC cluster10:41
- Importing large amounts of data into clusters-execution and summary21:15
- Paged query optimization17:06
- Duplicate writes caused by high concurrency22:30
- High concurrency access optimization25:23
- Big Data Archive-Separation of Hot and Cold Data10:08
- Big Data Archive-Build a Replication Cluster16:02
- Big Data Archive-Perform Big Data Archive24:39
- Data partitioning-Understanding table partitioning17:16
- Data partition-Range partition21:45
- Data partition-LIST partition13:43
- Data Partition-Hash Partition10:32
- Data Partition-Key Partition28:51
- Data Partition-Manage Range Table Partition12:19
- Data Partition Summary28:29
data backup and recovery
- Cold backup and hot backup of database25:07
- Online Cold Backup-Data Table Defragmentation10:11
- Online Cold Backup-Cold Backup PXC Nodes11:49
- Online Cold Backup-Cold Restore16:05
- XtraBackup hot backup principles.mp412:59
- Full Hot Backup-Common Commands25:57
- Full hot backup-writing shell scripts15:49
- full cold recovery24:53
- Incremental Hot Backup-Considerations26:14
- Incremental hot backup-Cron expression syntax26:57
- Java program timed incremental hot backup database10:21
- incremental cold reduction29:11
- Misoperation Recovery_Delay Node Solution19:04
- Misoperation recovery_Recovery of the main node mistakenly deleted fault26:40
- Misoperation Recovery_Log Flashback Solution15:29
course summary
- PXC Course Summary29:04
