Becoming a Production MySQL DBA

Focused View

Abid Malik | DevOps & AWS Cloud Automation using Terraform, Ansible

14:59:53

123 View

1 - Introduction

1 - Course Introduction.mp4

05:17

2 - Why MySQL.mp4

03:29

2 - mariadb enterprise open source database.zip

2 - official website of mysql server.zip

2 - percona the database performance experts.zip

3 - Meet Bob The Future DBA.mp4

01:33

4 - COURSE.zip

4 - Download Course Slides.html

2 - MySQL Server Installation

5 - Installing MySQL Server Community Edition.mp4

04:53

5 - mysql community edition installation.zip

6 - Installing MariaDB Database Server.mp4

05:04

6 - mariadb-installation.zip

7 - Installing Percona Server for MySQL Server.mp4

03:52

7 - percona mysql installation.zip

7 - percona-installation.zip

8 - Removing MySQL.mp4

04:35

8 - remove mysql.zip

9 - Installing Specific Version of MySQL.mp4

02:04

9 - customized-installation.zip

10 - Demo Installing Specific Version of MySQL.mp4

06:13

10 - installing specific version of mysql.zip

11 - Manually Download RPMs and Locally Install.mp4

03:20

11 - manually download rpms.zip

12 - Demo Manually Download RPMs and Locally Install.mp4

03:44

13 - Performing MySQL Secure Installation.mp4

02:11

14 - Demo Performing MySQL Secure Installation.mp4

04:23

14 - mysqlsecureinstallation.zip

15 - Linux Utilities.mp4

02:14

16 - Demo Linux Utilities.mp4

04:20

16 - linuxutilities.zip

17 - Section Recap What Bob has learned so for.mp4

01:28

3 - Exploring MySQL Server

18 - MySQL Architecture.mp4

04:22

19 - MySQL Installed File Locations.mp4

02:48

20 - Demo MySQL Installed File Locations.mp4

02:52

21 - MySQL Executable Programs.mp4

02:02

22 - MySQL Service under SystemD.mp4

04:28

23 - MySQL Shell Commands.mp4

03:09

24 - Demo MySQL Shell Commands.mp4

03:24

25 - MySQL Socket File.mp4

01:22

26 - Demo MySQL Socket File.mp4

03:00

27 - MySQL GLOBAL Variables.mp4

01:46

28 - Demo Global Variables.mp4

03:25

29 - MySQL SESSION Variables.mp4

02:00

30 - Demo MySQL SESSION Variables.mp4

02:06

31 - Getting System Variables Help.mp4

03:30

31 - system variables.zip

32 - MySQL SHOW Command.mp4

01:06

33 - Demo MySQL SHOW Command.mp4

02:24

34 - MySQL System Databases.mp4

02:53

35 - Demo MySQL System Databases.mp4

04:17

36 - MySQL Local vs Remote Connections.mp4

02:14

37 - Demo MySQL Local vs Remote Connections.mp4

02:09

38 - MySQL Shell.mp4

02:13

38 - mysql shell.zip

39 - Section Recap What Bob has learned.mp4

01:36

4 - Basic MySQL Database Administration

40 - Storing MySQL Authentication Credentials.mp4

02:10

41 - Assignment Login to MySQL Without Credentials.mp4

03:29

41 - mysqlconfigeditor.zip

42 - mysqladmin MySQL Administration Program.mp4

01:50

43 - Assignment Perform DBA tasks with mysqladmin.mp4

01:49

43 - mysqladmin.zip

44 - Executing SQL Files.mp4

03:17

45 - Assignment Execute employeessql SQL File.mp4

05:44

45 - execute sql file.zip

46 - Importing data with mysqlimport.mp4

03:19

47 - Assignment Import stafftxt file.mp4

07:25

47 - mysqlimport.zip

47 - staff.zip

48 - Maintaining Integrity with mysqlcheck.mp4

02:25

49 - Assignment Perform mysqlcheck on staff table.mp4

01:14

49 - mysqlcheck.zip

50 - Displaying useful Information with mysqlshow.mp4

01:39

51 - Assignment Get Report on employees database and its tables.mp4

02:39

51 - mysqlshow.zip

52 - Time Zone Tables.mp4

02:18

53 - Assignment Load Time Zone Tables into MySQL.mp4

02:50

53 - timezone.zip

54 - MySQL Example Databases.mp4

01:33

55 - Assignment Download World Database.mp4

01:49

55 - worlddb.zip

56 - Listing Binary Logs Events with mysqlbinlog.mp4

02:06

57 - Assignment Investigate When Database was dropped.mp4

02:35

58 - Section Recap What Bob has learned.mp4

01:40

5 - MySQL Storage Engines

59 - Storage Engines.mp4

02:51

59 - storage engines.zip

60 - Exploring Storage Engines.mp4

03:23

61 - FEDERATED Storage Engine.mp4

03:23

62 - MEMORY Storage Engine.mp4

02:09

63 - Assignment MEMORY Storage Engine.mp4

03:57

63 - memory engine demo.zip

64 - BLACKHOLE Storage Engine.mp4

02:22

65 - Assignment BLACKHOLE Storage Engine.mp4

01:37

66 - CSV Storage Engine.mp4

01:53

67 - Assignment CSV Storage Engine.mp4

03:07

68 - MyISAM Storage Engine.mp4

03:30

69 - Assignment MyISAM Storage Engine.mp4

02:56

70 - ARCHIVE Storage Engine.mp4

02:33

71 - Assignment ARCHIVE Storage Engine.mp4

03:46

72 - InnoDB Storage Engine.mp4

03:06

73 - Assignment InnoDB Storage Engine.mp4

04:37

74 - Checking Storage Engine Status.mp4

06:37

75 - Switching Storage Engine.mp4

03:22

76 - Installing New Storage Engine.mp4

03:29

77 - Disabling Storage Engine.mp4

04:34

78 - Section Recap What Bob has learned.mp4

01:06

6 - MySQL User Administration

79 - DBA Account.mp4

01:35

80 - MySQL Permissions.mp4

03:49

81 - WITH GRANT OPTION.mp4

01:26

82 - Assignment Create DBA Account.mp4

05:56

82 - createdbauser.zip

83 - Connecting to MySQL.mp4

07:32

83 - mysqlsh.zip

84 - Exploring MySQL Workbench.mp4

06:39

85 - Creating Regular MySQL Users.mp4

05:13

86 - Grant Permissions.mp4

05:23

87 - LockUnlock MySQL Account.mp4

03:26

88 - mysqlnativepassword cachingsha2password auth plugins.mp4

05:08

89 - MySQL Roles.mp4

04:04

90 - Assignment MySQL Roles.mp4

03:16

90 - mysql roles.zip

91 - Section Recap What Bob has learned.mp4

02:28

7 - MySQL Server Configuration

92 - MySQL Default Configuration File.mp4

06:43

92 - mycnf.zip

93 - Assignment Locate Default Option File.mp4

03:52

93 - mysql configuration.zip

94 - MySQL OptionConfiguration File Syntax.mp4

05:20

95 - Assignment ReWrite Default Option File.mp4

04:41

96 - Variable or Option in Option File.mp4

01:42

97 - Changing Default Option Files Location.mp4

01:18

97 - mysql configuration.zip

98 - Assignment Change Default Location of Option File.mp4

01:50

99 - STRACE LSOF With MySQL.mp4

02:15

100 - Demo STRACE LSOF.mp4

06:25

100 - strace.zip

101 - Option File Inclusions.mp4

02:55

101 - modified-cnf-file.zip

102 - Assignment Option File Inclusions.mp4

01:58

103 - DATADIR MySQL Data Directory.mp4

03:15

104 - Assignment Move DATA DIRECTORY.mp4

02:47

104 - data directory.zip

105 - Binary Log Files.mp4

08:17

106 - Purging Binary Log Files.mp4

04:22

107 - Assignment Disable Binary Logging.mp4

03:52

107 - binary-logs-location.zip

108 - Assignment Enable Binary Logging.mp4

06:19

109 - Binary Logs Retention.mp4

03:29

110 - MySQL Error Log File.mp4

03:21

111 - Assignment Change MySQL Error Log File Location.mp4

03:30

112 - Adjusting Timestamp of MySQL Error Log File.mp4

02:17

113 - MySQL TEMP Directory.mp4

01:52

114 - Assignment Change TMPDIR Location.mp4

03:25

115 - Removing DoubleEntry for MySQL Error Log File.mp4

02:33

116 - Section Recap What Bob has learned.mp4

02:54

8 - InnoDB Storage Engine Configuration

117 - InnoDB Storage Engine.mp4

03:57

118 - InnoDB Architecture.mp4

03:58

119 - InnoDB Buffer Pool.mp4

04:39

120 - Demo InnoDB Buffer Pool.mp4

06:08

121 - InnoDB Log Buffer.mp4

04:42

122 - Assignment InnoDB Log Buffer.mp4

02:15

123 - InnoDB Flush Method.mp4

02:29

124 - ODIRECT OR ODIRECTNOFSYNC.mp4

03:39

125 - Assignment Change InnoDB Flush Method.mp4

02:29

126 - Doublewrite Buffer.mp4

06:01

127 - Assignment Doublewrite Buffer.mp4

06:15

128 - Flushing Logs at Transaction Commit.mp4

04:41

129 - Assignment Setting value of innodbflushlogattrxcommit.mp4

01:50

130 - InnoDB Redo Log Files.mp4

06:10

131 - Assignment 1 InnoDB Redo Log Files.mp4

02:24

131 - innodb redo log files.zip

132 - Assignment 2 InnoDB Redo Log Files.mp4

01:25

132 - innodb redo log files.zip

133 - Assignment 3 InnoDB Redo Log Files.mp4

06:41

133 - redo log files.zip

134 - System Tablespace.mp4

04:39

135 - Assignment System Tablespace.mp4

07:37

135 - system tablespace.zip

136 - Undo Tablespaces.mp4

02:40

137 - Demo Undo Tablespaces.mp4

07:04

137 - undo tablespaces.zip

138 - Temporary Tablespaces.mp4

03:03

139 - General Tablespaces.mp4

01:57

140 - FilePerTable Tablespaces.mp4

04:56

141 - Dedicated MySQL Server.mp4

04:42

142 - Turning Dedicated Server ON.mp4

04:28

143 - Overriding Dedicated Server Settings.mp4

03:09

144 - Section Recap What Bob has learned.mp4

01:46

9 - MySQL Backup Restore

145 - MySQL Backups.mp4

02:54

146 - PhysicalCold Backup.mp4

03:07

147 - Assignment Perform PhysicalCold Backup.mp4

05:59

148 - Assignment Restore From PhysicalCold Backup.mp4

08:36

149 - Files needed for Cold Backup.mp4

01:15

150 - Logical Backups.mp4

02:03

151 - MySQLDUMP Backup Program.mp4

03:08

152 - Assignment Take Backup with MySQLDUMP.mp4

06:45

153 - Restoring from MySQLDUMP.mp4

03:05

154 - MySQLPUMP Backup Program.mp4

06:23

155 - Demo 1 MySQLPUMP.mp4

04:04

156 - Demo 2 MySQLPUMP.mp4

02:55

157 - Assignment Backing Up MySQL Accounts.mp4

04:08

158 - Assignment Restore MySQL Account.mp4

05:07

159 - Compressing MySQL Backups.mp4

02:52

160 - Assignment Compress MySQL Backup.mp4

03:12

161 - Assignment Restore MySQL Compressed Backup.mp4

02:37

162 - Creating Consistent Data Dump.mp4

01:34

163 - CREATE TABLE LIKE SQL Statement.mp4

03:01

164 - MySQL Hot Backup.mp4

04:05

165 - MySQL Hot Backup Tools.mp4

04:20

166 - XtraBackup Hot Backup Tool.mp4

02:43

166 - install xtrabackup.zip

166 - xtrabackup.zip

167 - Assignment Download Install XtraBackup.mp4

05:59

168 - Assignment Backup with XtraBackup.mp4

07:14

169 - Assignment XtraBackup Backup Files.mp4

04:30

170 - Preparing Hot Backup Restore.mp4

05:53

171 - Assignment Restore From Hot Backup.mp4

08:38

171 - restore xtrabackup.zip

172 - Section Recap What Bob has learned.mp4

03:51

10 - MySQL Server Replication

173 - Replication Concepts.mp4

04:57

174 - Replication Methods.mp4

05:07

175 - Replication Formats.mp4

03:28

176 - Replication Formats Comparison.mp4

07:18

177 - General Replication Setup Requirements.mp4

03:14

178 - Primary Server.mp4

03:17

179 - Assignment Configure Primary Server.mp4

09:00

180 - Cleanup Options from Option File.mp4

01:20

181 - Demo 1 Install MySQL On Replica Server.mp4

06:49

182 - Demo 2 Install MySQL On Replication Server.mp4

03:29

183 - Start MySQL on Replica.mp4

03:46

184 - Hot Backup on Primary for Replication.mp4

03:13

185 - Copy Hot Backup from Primary to Replica.mp4

05:57

186 - Restore Hot Backup on Replica.mp4

09:35

187 - Replica Server Configuration.mp4

03:16

188 - Assignment Configure Replica.mp4

05:15

189 - Configure Binary Log Position Based Replication.mp4

00:54

190 - Assignment Configure Binary Log Replication.mp4

07:56

191 - Set Report Host on Replica.mp4

04:20

192 - SHOW REPLICA STATUS.mp4

07:31

193 - Demo Replica IOTHREAD.mp4

02:35

194 - Demo Replica SQLTHREAD.mp4

02:49

195 - Demo Ignore Database.mp4

03:35

196 - Demo Ignore Table.mp4

04:18

197 - Cleanup Traditional Replication.mp4

06:14

198 - Setting up GTID Replication.mp4

02:26

198 - setting-up-gtid-replication.zip

199 - GTID Replication Requirements.mp4

02:17

200 - Prepare GTID Replication.mp4

04:29

201 - Assignment Setup GTID Replication.mp4

05:09

202 - Start Replica Until Command.mp4

03:22

203 - Demo Start Replica with Until.mp4

07:22

204 - Primary Replica Failover.mp4

03:21

205 - Prepare Primary Replica Failover.mp4

04:42

206 - Assignment Failover Primary to Replica.mp4

09:00

207 - Assignment Configure Old Primary to Replica.mp4

05:42

208 - Section Recap What Bob has learned.mp4

01:26

11 - Upgrading MySQL Server

209 - Types of MySQL Version Upgrades.mp4

01:20

210 - Preparing for Minor Version Upgrade.mp4

03:00

211 - Assignment Perform Minor Version Upgrade.mp4

06:04

211 - mysql minor upgrade.zip

212 - Demo Primary Replica Version Compatibility.mp4

02:07

213 - Installing MySQL 57.mp4

05:06

213 - install mysql 57.zip

214 - Download World Example Database.mp4

01:43

215 - mysqlcheck PreUpgrade Check.mp4

02:37

216 - mysqlsh script PreUpgrade Check.mp4

06:18

217 - Demo Perform MySQL Major Version Upgrade.mp4

06:52

218 - Section Recap What Bob has learned.mp4

02:15

12 - Docker and MySQL

219 - Introduction.mp4

02:15

220 - Install Docker.mp4

06:25

220 - install docker.zip

221 - Pull Inspect MySQL Docker Image.mp4

07:22

221 - search mysql image.zip

222 - Run MySQL as Container.mp4

10:20

223 - MySQL Container Logs.mp4

04:20

224 - MySQL Container Host.mp4

06:31

225 - Removing MySQL Container.mp4

04:02

226 - Exposing Port From Container to Host.mp4

06:14

226 - exposing container port.zip

227 - Create DBA User Bob.mp4

03:20

228 - Remotely Login to MySQL Container.mp4

04:18

229 - Demo Data Loss at Container Removal.mp4

05:31

230 - Bind Volume For Data Persistence.mp4

06:24

231 - Demo Persistant Volume.mp4

03:32

232 - Section Recap What Bob has learned.mp4

01:06

13 - DBA Tips Tricks Club

233 - Welcome to the DBA Club.mp4

01:25

234 - DBA Tip Customizing MySQL Prompt.mp4

01:40

235 - Demo Customizing MySQL Prompt.mp4

01:56

14 - Course Completion

236 - Thank You Goodbye.mp4

00:37

Description

An awesome journey towards world's most popular open source database to become a Production MySQL DBA.

What You'll Learn?

You will learn how to install latest version of MySQL Server including MariaDB and Percona Server for MySQL.
You will learn how to secure the installation of MySQL and how to start/stop/restart MySQL service using systemd.
You will learn how to customize MySQL server configuration, how to store InnoDB log files, binary log files, MySQL server log files in separate locations.
You will learn how to connect to MySQL locally as well as remotely and how to perform database administration.
You will learn how to perform minor and major MySQL upgrades, how to install new components and remove plugins.
You will learn how to setup GTID-based master-slave replication, and how to setup filtered replication.
You will learn how to take logical as well as physical backup, how to restore MySQL backups, how to setup a new slave from backup.
You will learn how to troubleshoot MySQL server issues.
You will learn how to run MySQL in Docker

Who is this for?

Junior MySQL DBAs looking to improve and advance their DBA skills.

Anyone interested to jump start their career as a Database Administrator.

System Administrators looking to learn Database Administration skills.

More details

Description
*** Course Overview *
Welcome to this amazing course on MySQLÂ Server Administration. You will learn all aspects of MySQL Server including setting it up, managing it, troubleshooting it. You will learn how to upgrade MySQL, how to setup replication, how to migrate to AWS cloud, and much more!

* Course Contents *
MySQL Server Introduction
Why MySQL?
Meet Bob, The future DBA
MySQL Websites
MySQL Server Installation
Installing MySQL Server Community Edition
Installing MariaDB Database Server
Installing Percona MySQLÂ Server
installing Specific MySQL Version
Removing MySQL

Exploring MySQL Server
MySQL Architecture
MySQL Installed File Locations
MySQLÂ Executable Programs
MySQL Shell Commands
MySQLÂ Socket File
MySQLÂ Global &Â Session Variables
MySQLÂ Remove vs Local Connections
MySQL User Administration
MySQL Accounts
Creating DBA Account WITHÂ GRANTÂ OPTION
MySQL Roles
Granting Permissions to Roles
Granting Roles to Users
MySQL Database Administration
Storing Auth Credentials using mysql_config_editor
MySQL Administrative Programs
mysqlimport, mysqlshow, mysqlcheck utilities
Loading Time Zone Data
Downloading Example Databases
MySQL Server Configuration
MySQLÂ Default Option Files
Adding Option Files
Option File Inclusions
MySQL Error Log
MySQL Binary Log Files
Relocating InnoDB System Tablespaces
Moving Redo Log Files
Upgrading MySQL Server
Performing MySQL Minor Version Upgrade
Performing MySQL Major Version Upgrade
Running Pre-Upgrade Checks
Version Comparison Between Primary &Â Replica
MySQL Replication
Performing Traditional Position-Based Relication
Performing GTIDÂ Replication
Ignoring Databases for Replication
Excluding Tables from Replication
MySQLÂ Storage Engines
BLACKHOLEÂ
MEMORY
INNODB
CSV
MySQL InnoDB Storage Engine Configuration
InnoDB Architecture
Memory-Based Architecture
InnoDB Buffer Pool
Dedicated Server
Doublewrite Buffer
System Tablespaces
MySQL Backup & Restore
Performing Hot Backup
Performing Cold Backup
Performing Logical Backups
Restoring from Hot/Cold Backups
Running MySQL on Docker
Installing Docker Engine
Pulling MySQL Image
Running MySQL Container
DBA Tips &Â Tricks Club
Customizing MySQL Prompt

* January 2023 - Course Update *
SECTION: Running MySQL on Docker
Lessons Added**:
Converting MySQL Instance to Container
Installing MySQL Server on Docker Host
Demo - Attach Container to Instance
Who this course is for:
Junior MySQL DBAs looking to improve and advance their DBA skills.
Anyone interested to jump start their career as a Database Administrator.
System Administrators looking to learn Database Administration skills.

User Reviews

Rating

average 0

Total votes0

Focused display

MySQL

Abid Malik | DevOps & AWS Cloud Automation using Terraform, Ansible

Instructor's Courses

I'm Abid Malik, a Senior Database Administrator with over 15 years of experience in database administration, infrastructure solutions, cloud migrations, and providing 24X7 production support.I have worked in some of the top companies in the United States like Verizon, ChannelAdvisor, Cengage Learning. I am passionate about learning new technology and teaching.I have extensive experience in MySQL, MongoDB and supporting them on AWS Cloud.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.