lesedev317
U P L O A D E R
Becoming A Production Mysql Dba
Last updated 2/2025
Created by Abid Malik
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Expert | Genre: eLearning | Language: English + subtitle | Duration: 293 Lectures ( 19h 30m ) | Size: 5 GB
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
Requirements
You must have basic understanding of MySQL or any RDBMS
You must know the basics of linux operating system.
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 IntroductionWhy MySQL?Meet Bob, The future DBAMySQL WebsitesMySQL Server InstallationInstalling MySQL Server Community EditionInstalling MariaDB Database ServerInstalling Percona MySQL Serverinstalling Specific MySQL VersionRemoving MySQLExploring MySQL ServerMySQL ArchitectureMySQL Installed File LocationsMySQL Executable ProgramsMySQL Shell CommandsMySQL Socket FileMySQL Global & Session VariablesMySQL Remove vs Local ConnectionsMySQL User AdministrationMySQL AccountsCreating DBA Account WITH GRANT OPTIONMySQL RolesGranting Permissions to RolesGranting Roles to UsersMySQL Database AdministrationStoring Auth Credentials using mysql_config_editorMySQL Administrative Programsmysqlimport, mysqlshow, mysqlcheck utilitiesLoading Time Zone DataDownloading Example DatabasesMySQL Server ConfigurationMySQL Default Option FilesAdding Option FilesOption File InclusionsMySQL Error LogMySQL Binary Log FilesRelocating InnoDB System TablespacesMoving Redo Log FilesUpgrading MySQL ServerPerforming MySQL Minor Version UpgradePerforming MySQL Major Version UpgradeRunning Pre-Upgrade ChecksVersion Comparison Between Primary & ReplicaMySQL ReplicationPerforming Traditional Position-Based RelicationPerforming GTID ReplicationIgnoring Databases for ReplicationExcluding Tables from ReplicationMySQL Storage EnginesBLACKHOLE MEMORYINNODBCSVMySQL InnoDB Storage Engine ConfigurationInnoDB ArchitectureMemory-Based ArchitectureInnoDB Buffer PoolDedicated ServerDoublewrite BufferSystem TablespacesMySQL Backup & RestorePerforming Hot BackupPerforming Cold BackupPerforming Logical BackupsRestoring from Hot/Cold BackupsRunning MySQL on DockerInstalling Docker EnginePulling MySQL ImageRunning MySQL ContainerDBA Tips & Tricks ClubCustomizing MySQL Prompt******* January 2023 - Course Update *******SECTION: Running MySQL on DockerLessons Added:Converting MySQL Instance to ContainerInstalling MySQL Server on Docker HostDemo - Attach Container to Instance******* Feburary 2023 - Course Update *******NEW SECTION: Cloud Database AdministrationLessons Added:Cloud Database Lab SetupCreating Droplets on DigitalOceanDisabling SELINUXGTID Based Replication SetupOnline Data Duplication using xbstreamSetting up AWS Cloud ReplicaNEW SECTION: Database ScriptingLessons Added:Introduction to Shell ScriptingShell Script PermissionsBash Shell ShebangMixing Text with Shell CommandsShell Script ArgumentsShell VariablesOutput of Command as VariableFor Loop in Shell ScriptingAssignment: Create Shell Sript to Create MySQL AccountsAssignment: Create Shell Script to Download Example DatabaseAssignment: Create Shell Script to Create tables in specific databasesIntroduction to Percona ToolkitInstalling Percona Toolkitpt-mysql-summary pt-summaryWe will be adding more content to this course soon...
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.
Homepage
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
