packtpublishing / -mysql-8-for-administrators

MySQL 8 for Administrators, by Packt Publishing

MySQL 8 for Administrators [Video]

This is the code repository for MySQL 8 for Administrators [Video], published by Packt. It contains all the supporting project files necessary to work through the video course from start to finish.

About the Video Course

MySQL is the world’s most popular open source database. Since the release of MySQL 5.0 in 2003, it is MySQL 8 that comes with a major update.

This course goes over the basics of MySQL administration, through examples on MySQL 8. It also covers the differences between various MySQL versions. It starts off with the basics: Installing MySQL and Creating users. After that, we will get sysbench up and running. Sysbench, responsible for issuing queries against databases, is the de-facto benchmarking tool for MySQL. With that hands-on lab environment at hand, we will learn about various database administration topics like backups, replication, monitoring, point in time recovery, switchovers, user management and version upgrades.

Upon completing this course, you will be able to set up new MySQL databases and perform basic administration tasks using the latest version.

What You Will Learn

• Install and setup MySQL 8 to explore basic administration tasks.
• Handle MySQL user management.
• How to back up and restore MySQL databases
• How to set up and operate MySQL replication, including moving to GTID based replication
• How to perform a point in time recovery
• How to set up monitoring for MySQL databases
• How to perform switchovers (promote a slave to master database)
• How to handle MySQL version upgrades.

Instructions and Navigation

Assumed Knowledge

To fully benefit from the coverage included in this course, you will need:
To fully benefit from the coverage included in this course, you will need: ● Be comfortable using Linux operating system from the command line. ● Know SQL basics (the course won’t cover what a SELECT is

Technical Requirements

This course has the following software requirements:
This course has the following software requirements: ● Vagrant ● VirtualBox 5.2.10

Related Products

• MySQL 8 Administrator's Guide

• MySQL 8 Cookbook

• MySQL 8 for Administrators [Video]

-mysql-8-for-administrators's Issues

ansible MySQL installation problem lab2a , lab2b

Hello,
Lab2a and lab2b get an error like below ;

TASK [common : enable mysql80-community repo] **********************************
changed: [lab2b]

TASK [common : Install mysql community server 8.0] *****************************
[DEPRECATION WARNING]: Invoking "yum" only once while using a loop via
squash_actions is deprecated. Instead of using a loop to supply multiple items
and specifying name: "{{ item }}", please use name: ['mysql-community- server-8.0.11-1.el7.x86_64'] and remove the loop. This feature will be removed
in version 2.11. Deprecation warnings can be disabled by setting
deprecation_warnings=False in ansible.cfg.
failed: [lab2b] (item=[u'mysql-community-server-8.0.11-1.el7.x86_64']) => {"changed": false, "item": ["mysql-community-server-8.0.11-1.el7.x86_64"], "msg": "Error: mysql-community-client-plugins conflicts with mysql-community-server-8.0.11-1.el7.x86_64\n", "rc": 1, "results": ["Loaded plugins: fastestmirror\nLoading mirror speeds from cached hostfile\n * base: mirror.ni.net.tr\n * epel: mirror.bytemark.co.uk\n * extras: centos.turhost.com\n * updates: mirror.isimtescil.com.tr\nResolving Dependencies\n--> Running transaction check\n---> Package mysql-community-server.x86_64 0:8.0.11-1.el7 will be installed\n--> Processing Dependency: mysql-community-common(x86-64) = 8.0.11-1.el7 for package: mysql-community-server-8.0.11-1.el7.x86_64\n--> Processing Dependency: mysql-community-client(x86-64) >= 8.0.0 for package: mysql-community-server-8.0.11-1.el7.x86_64\n--> Running transaction check\n---> Package mysql-community-client.x86_64 0:8.0.25-1.el7 will be installed\n--> Processing Dependency: mysql-community-client-plugins = 8.0.25-1.el7 for package: mysql-community-client-8.0.25-1.el7.x86_64\n--> Processing Dependency: mysql-community-libs(x86-64) >= 8.0.11 for package: mysql-community-client-8.0.25-1.el7.x86_64\n---> Package mysql-community-common.x86_64 0:8.0.11-1.el7 will be installed\n--> Running transaction check\n---> Package mariadb-libs.x86_64 1:5.5.60-1.el7_5 will be obsoleted\n--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: perl-DBD-MySQL-4.023-6.el7.x86_64\n--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-7.el7.x86_64\n--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: sysbench-1.0.14-2.el7.x86_64\n--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: MySQL-python-1.2.5-1.el7.x86_64\n--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: perl-DBD-MySQL-4.023-6.el7.x86_64\n--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-7.el7.x86_64\n--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: sysbench-1.0.14-2.el7.x86_64\n--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: MySQL-python-1.2.5-1.el7.x86_64\n---> Package mysql-community-client-plugins.x86_64 0:8.0.25-1.el7 will be installed\n---> Package mysql-community-libs.x86_64 0:8.0.25-1.el7 will be obsoleting\n--> Running transaction check\n---> Package Percona-XtraDB-Cluster-shared-compat-57.x86_64 0:5.7.33-31.49.1.el7 will be obsoleting\n---> Package postfix.x86_64 2:2.10.1-7.el7 will be updated\n---> Package postfix.x86_64 2:2.10.1-9.el7 will be an update\n---> Package sysbench.x86_64 0:1.0.14-2.el7 will be updated\n---> Package sysbench.x86_64 0:1.0.20-6.el7 will be an update\n--> Processing Conflict: mysql-community-client-plugins-8.0.25-1.el7.x86_64 conflicts mysql-community-server < 8.0.21\n--> Finished Dependency Resolution\n You could try using --skip-broken to work around the problem\n You could try running: rpm -Va --nofiles --nodigest\n"]}
to retry, use: --limit @/ansible/master_local.retry

PLAY RECAP *********************************************************************
lab2b : ok=7 changed=3 unreachable=0 failed=1

Ansible failed to complete successfully. Any error output should be
visible above. Please fix these errors and try again.
burakyilmaz@BURAKs-MBP lab2b %

Issue in lab4c

Hi,

I am facing the following issue while installing lab4c

TASK [Stream backup to target] *************************************************
fatal: [lab4c-db1]: FAILED! => {"changed": true, "cmd": "mysqldump --all-databases --triggers --routines --events --master-data=1 --single-transaction | socat -u - tcp:lab4c-db2:4444", "delta": "0:00:00.245405", "end": "2021-08-19 17:21:29.571576", "msg": "non-zero return code", "rc": 1, "start": "2021-08-19 17:21:29.326171", "stderr": "2021/08/19 17:21:29 socat[8271] E write(5, 0x555aaf71f2a0, 2613): Broken pipe\nmysqldump: Got errno 11 on write", "stderr_lines": ["2021/08/19 17:21:29 socat[8271] E write(5, 0x555aaf71f2a0, 2613): Broken pipe", "mysqldump: Got errno 11 on write"], "stdout": "", "stdout_lines": []}

Regards
Swami