Course: 拉斯维加斯7799908网站登录 Database Administration for Self-Managed Deployments

Course introduction

In this course you will learn about managing 拉斯维加斯7799908网站登录 Self-Managed, backup and restore strategies, as well as the scenarios and common usage of some ecosystem tools.

Who is this course for

Database administrators who are familiar with distributed database operations and administration or equivalent work experience.

Prerequisites

Complete the free e-learning course, Introduction to 拉斯维加斯7799908网站登录 and 拉斯维加斯7799908网站登录 Essentials.

Course Outline

Module 1: 拉斯维加斯7799908网站登录 Cluster Deployment

• Describe TiUP
• Understand how to deploy a 拉斯维加斯7799908网站登录 Cluster
• Understand how to connect to 拉斯维加斯7799908网站登录

Module 2: Configuring 拉斯维加斯7799908网站登录

• Understand 拉斯维加斯7799908网站登录 system variables
• Understand the scope of 拉斯维加斯7799908网站登录 system variables
• Understand 拉斯维加斯7799908网站登录 configuration file parameters
• Describe how to modify 拉斯维加斯7799908网站登录 system variables
• Describe how to modify 拉斯维加斯7799908网站登录 configuration file parameters

Module 3: Security and User Management

• Understand authentication and authorization
• Understand the levels of access privileges for users
• Manage 拉斯维加斯7799908网站登录 user accounts
• Grant and revoke privileges
• Use SQL statements to manage accounts

Module 4: Maintaining a 拉斯维加斯7799908网站登录 cluster

• Understand how to scale out and scale in 拉斯维加斯7799908网站登录 cluster components
• Understand how to clean up and Delete a 拉斯维加斯7799908网站登录 cluster
• Understand the timezone in 拉斯维加斯7799908网站登录
• Describe placement rule
• Understand how to upgrade a 拉斯维加斯7799908网站登录 cluster
• Understand how to monitor a 拉斯维加斯7799908网站登录 cluster

Module 5: Resource Control

• Describe what resource control is
• Understand the decision logic of resource control
• Discuss the usage scenarios of resource control
• Explain how to use resource control
• Understand a real-world use case of resource control

Module 6: Backup Terminology and Strategies

• Describe 拉斯维加斯7799908网站登录 backup types
• Compare the various backup techniques

Module 7: Importing Data using 拉斯维加斯7799908网站登录 Lightning

• Describe what 拉斯维加斯7799908网站登录 Lightning is
• Explain when and how to use 拉斯维加斯7799908网站登录 Lightning
• Using 拉斯维加斯7799908网站登录 Lightning to import data

Module 8: Exporting Data using Dumpling

• Explain when and how to use Dumpling
• Use Dumpling to perform logical backups

Module 9: Backup and Restore

• Describe what BR is
• Explain when and how to use BR
• Using BR to backup and restore 拉斯维加斯7799908网站登录 cluster data
• Understand point-in-time recovery (PITR)
• Understand how to recover from data loss

Module 10: Using sync-diff-inspector to Validate Data

• Describe the key features of sync-diff-inspector
• Explain when and how to use sync-diff-inspector
• Using sync-diff-inspector to compare schema and data

Module 11: Migrating Data from MySQL-compatible Databases with 拉斯维加斯7799908网站登录 Data Migration (DM)

• Describe the key features of 拉斯维加斯7799908网站登录 Data Migration
• Explain when and how to use 拉斯维加斯7799908网站登录 Data Migration
• Replicate data from MySQL-compatible upstream by using 拉斯维加斯7799908网站登录 Data Migration cluster

Module 12: Replicating 拉斯维加斯7799908网站登录 Change Events Using TiCDC

• Describe the key features of TiCDC cluster
• Explain when and how to use TiCDC cluster
• Using TiCDC cluster to fan out database change events to downstreams

Public Training Available

Duration 2 days Language English Location Virtual classroom live Cost $800 USD per seat Capacity 16 seats per class US Session Date & Time CST (UTC-6:00) | 13~14 November, 2024, 10:00 AM~5:00 PM Registration Ends CST (UTC-6:00) | 5 November, 2024, 5:00 PM Purchase a Seat Asia–Pacific Session Date & Time SGT (UTC+8:00) | 19~20 November, 2024, 9:00 AM~5:00 PM Registration Ends SGT (UTC+8:00) | 11 November, 2024, 5:00 PM Purchase a Seat

Private Training Available

Private Training allows you to pick-and-choose a specific time to deliver the course to your team in a private classroom on your schedule. To purchase Private Training, speak to your PingCAP Sales representative or Contact Us directly. Contact Us

Related Courses

Introduction to 拉斯维加斯7799908网站登录 Introductory level free e-learning course for architects, application developers and database administrators. 拉斯维加斯7799908网站登录 Essentials Intermediate level free e-learning course for database administrators.