Scribd Logo
Upload

Welcome to Scribd!

  • 5K views

    MySQL DBA Syllabus

    Uploaded by

    Remote MySQL DBA
    This document outlines the phases of a MySQL DBA training program. Phase I covers basic Linux commands, installing MySQL, starting and stopping MySQL, basic queries, logs, client programs, upgrading, and locking. Phase II covers storage engines, InnoDB configuration, table maintenance, the information and performance schemas, backups and recovery, replication architectures, user management, and resource allocation. Phase III addresses the MySQL architecture, security, query optimization, optimizing variables, tools for performance, shell scripting, MariaDB multi-master replication, the future of MySQL, and interview questions. The training is designed by expert MySQL DBAs for MySQL DBAs to develop skills needed for a career as a MySQL DBA.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    MySQL DBA Syllabus

    Uploaded by

    Remote MySQL DBA
    5K views14 pages
    This document outlines the phases of a MySQL DBA training program. Phase I covers basic Linux commands, installing MySQL, starting and stopping MySQL, basic queries, logs, client programs, upgrading, and locking. Phase II covers storage engines, InnoDB configuration, table maintenance, the information and performance schemas, backups and recovery, replication architectures, user management, and resource allocation. Phase III addresses the MySQL architecture, security, query optimization, optimizing variables, tools for performance, shell scripting, MariaDB multi-master replication, the future of MySQL, and interview questions. The training is designed by expert MySQL DBAs for MySQL DBAs to develop skills needed for a career as a MySQL DBA.

    Original Description:

    MySQL DBA Training Syllabus interested people can mail us at [email protected]

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document outlines the phases of a MySQL DBA training program. Phase I covers basic Linux commands, installing MySQL, starting and stopping MySQL, basic queries, logs, client programs, upgrading, and locking. Phase II covers storage engines, InnoDB configuration, table maintenance, the information and performance schemas, backups and recovery, replication architectures, user management, and resource allocation. Phase III addresses the MySQL architecture, security, query optimization, optimizing variables, tools for performance, shell scripting, MariaDB multi-master replication, the future of MySQL, and interview questions. The training is designed by expert MySQL DBAs for MySQL DBAs to develop skills needed for a career as a MySQL DBA.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    5K views14 pages

    MySQL DBA Syllabus

    Uploaded by

    Remote MySQL DBA
    This document outlines the phases of a MySQL DBA training program. Phase I covers basic Linux commands, installing MySQL, starting and stopping MySQL, basic queries, logs, client programs, upgrading, and locking. Phase II covers storage engines, InnoDB configuration, table maintenance, the information and performance schemas, backups and recovery, replication architectures, user management, and resource allocation. Phase III addresses the MySQL architecture, security, query optimization, optimizing variables, tools for performance, shell scripting, MariaDB multi-master replication, the future of MySQL, and interview questions. The training is designed by expert MySQL DBAs for MySQL DBAs to develop skills needed for a career as a MySQL DBA.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 14

    MySQL DBA

    Training
    Designed By Expert MySQL DBAs For MySQL DBAs
    Remotemysqldba.blogspot.in
    MYSQL DBA
    Industry needs more MySQL DBAs. Need for MySQL
    DBAs has increased a lot in the last decade. MySQL
    DBAs has a very good growth in carrer. Industry expects a
    MySQL DBA to be good at new MySQL forks and MySQL
    tools beyond normal a DBA. MySQL adoption is taking
    place in all areas it is a Golden Age for MySQL DBAs.
    Remotemysqldba.blogspot.in
    About This Course
    MYSQL DBA TRAINING PHASE - I
    MYSQL DBA TRAINING PHASE - II
    MySQL DBA TRAINING PHASE - III
    Remotemysqldba.blogspot.in
    MYSQL DBA TRAINING
    PHASE - I
    1)Basic Linux commands.
    About Linux
    Why DBA Needs Linux Command ?
    Command Types
    2)Installing MySQL.
    MySQL Installation
    Windows Installation
    Linux RPM Installation
    Linux Binary Installation
    Source Installation
    3)Starting and stopping MySQL
    Four different methods to start MySQL in Linux
    MySQL Stopping
    Remotemysqldba.blogspot.in
    MYSQL DBA TRAINING
    PHASE - I
    4) Basic MySQL Queries
    DML Queries
    DDL Queries
    TCL Queries
    Types of Joins
    Unions
    5)Various logs in MySQL and its uses.
    MySQL Logs
    Error Log
    Query Log
    Slow Query Log
    Binlog and its format
    Relay Log
    6)MySQL client Programs
    MySQL Server/Client Architecture
    MySQL Client Programs
    MySQL Commands
    MySQL Non-Client Programs
    Remotemysqldba.blogspot.in
    MYSQL DBA TRAINING
    PHASE - I
    7)Upgrading MySQL.
    Why Upgradation ?
    Checklist
    MySQL Upgradation
    8)Mysqladmin commands.
    MySQL Admin Commands
    Workbench MySQL
    9)Locking in MySQL
    Locking in MySQL
    Internal Locking
    Table level Locking
    Row level Locking
    External Locking
    Dead Lock
    Remotemysqldba.blogspot.in
    MYSQL DBA TRAINING
    PHASE - II
    1)Storage engines in MySQL
    What is a Engine?
    Different Engines
    Engines Characteristics
    Disk Layout of engines
    Third Party Engines(XtraDB,MariaDB,TokuDB)
    2)Innodb Configuration
    InnoDB I/O Configuration
    The innodb transaction log
    Log file size & log buffer
    How InnoDB flushes the log buffer
    The InnoDB tablespace
    The doublewrite buffer
    Remotemysqldba.blogspot.in
    MYSQL DBA TRAINING
    PHASE - II
    3)MySQL Table maintenance
    Table Maintenance
    Analyze Table
    Backup Table
    Check Table
    Checksum Table
    Optimize Table
    Repair Table
    Restore Table
    Moving Tablespace
    4)Information Schema and Performance Schema
    MySQL Information_schema
    Tables in Information_schema
    MySQL Performance schema
    Remotemysqldba.blogspot.in
    MYSQL DBA TRAINING
    PHASE - II
    5)MSQL backup and Recovery.
    MySQL Backup
    MySQL Backup Types
    MySQL backup factors
    MySQL Backup Tools
    MySQL Dump
    MySQL Recovery
    MySQL Recovery Factors
    Load data infile & select into outfile
    6) MySQL Replication and different Replication Architecture
    MySQL Replication
    MySQL Replication Architecture
    MySQL Replication Basics
    MySQL Replication Types
    Master-Slave Replication Setup
    Master-Slave Replication Filters
    Master-Master Replication
    Remotemysqldba.blogspot.in
    MYSQL DBA TRAINING
    PHASE - II
    7)MySQL User Management and Routines &Triggers
    User Account Management
    User Privileges
    Administrative Privileges
    Database Access Privileges
    Creating and Rename User Account
    Drop User Account
    Grant Privileges
    Revoke Privileges
    Routines and Triggers
    8)MySQL Resource allocation
    MySQL Memory Consumption
    MySQL Memory Limitations
    Remotemysqldba.blogspot.in
    MYSQL DBA TRAINING
    PHASE - III
    1) MySQL Architecture
    Introduction
    MySQL Architecture Diagram
    MySQL Architecture Explanation
    MySQL Logical Layer Architecture
    MySQL Logical Layer Explanation
    2) Securing MySQL
    Operating System Security
    File System Security
    Log Files & Security
    Network Security
    3) Optimizing queries
    Identifying Candidate
    Using EXPLAIN
    Using Show Warnings
    Remotemysqldba.blogspot.in
    MYSQL DBA TRAINING
    PHASE - III
    4) Optimizing MySQL Variables effectively
    Different Variables
    How to tune Variables
    5) Tools for high performance
    Percona toolkit Installation
    Pt-query-digest
    Pt-table-checksum
    Pt-table-sync
    Pt-kill
    Mytop
    Innotop
    6) Shell scripting for automation
    Basic Scripting
    Automation
    Remotemysqldba.blogspot.in
    MYSQL DBA TRAINING
    PHASE - III
    7) MariaDB Multi master replication
    Replication Architecture
    Replication setup
    8) Future of MySQL
    MariaDB
    Percona
    TokuDB
    Oracle MySQL
    Interview Questions
    THANK YOU

    You might also like