Description
To become proficient in administering a MySQL database server, hands-on training is recommended. This training will cover aspects of server installation, configuration, InnoDB settings, access rights management, data backup and restoration, as well as production management. Through this hands-on training, you will gain practical expertise in MySQL database administration, and you will be better equipped to effectively handle administration tasks for this type of server. Online resources such as specialized courses and books can also help you improve your knowledge in this area.
Who is this training for ?
For whom ?
System administrators and database administrators.
Prerequisites
Required knowledge of the SQL language or knowledge equivalent to that provided by the "SQL for MySQL and PostgreSQL" course (Ref. MYP).
Training objectives
Training program
- Introduction et installation
- Versions and license types.
- Tools mysql, mysqlshow, myphpadmin.
- Server settings (my.cnf, sql_mode, strict mode...).
- Startup/stop.
- Installations (binary, from sources...).
- Mysqladmin.
- Installation of MySQL Workbench.
- Version changes, migration.
- Objects of a MySQL database
- Table types (MyISAM, MEMORY, MERGE...).
- Modifying the definition of a table.
- Index.
- View management.
- Base information_schema.
- Connections, access rights, security
- User authentication.
- Structure of MySQL database tables.
- Management of users and their privileges.
- Rights on stored views and processing.
- Using SSL.
- Storage engines and plug-ins
- MyISAM, InnoDB storage engines.
- InnoDB architecture and configuration.
- Transactional operation of the InnoDB engine.
- Table locking.
- Plug-ins: configuration and startup.
- Maintaining a MySQL server
- Session state (variables,
- Loading: LOAD DATA, myimport, SELECT INTO OUTFILE, mysqldump.
- Backup strategies.
- InnoDB Hot Backup, mysqlbinlog.
- Backup and recovery incremental.
- Planning.
