AWS / Azure / GCP Cloud | Database | Data Analytics | LakeHouse | Machine Learning | Shrenik Parekh

MySQL 8.0.19 install | MySQL 8.0.91 configure: Install MySQL 8.0.19 Community edition: Remove Maria DB packages: # yum remove mariadb-libs.x86_64* Install MySQL 8.0.19 rpm packages: # yum install mysql-community-common-8.0.19-1.el7.x86_64.rpm # yum install mysql-community-libs-8.0.19-1.el7.x86_64.rpm # yum install mysql-community-libs-compat-8.0.19-1.el7.x86_64.rpm # yum install mysql-community-client-8.0.19-1.el7.x86_64.rpm # yum install mysql-community-embedded-compat-8.0.19-1.el7.x86_64.rpm # yum install mysql-community-devel-8.0.19-1.el7.x86_64.rpm # yum install mysql-community-server-8.0.19-1.el7.x86_64.rpm # yum install mysql-shell-8.0.19-1.el7.x86_64.rpm At this point mysql daemon is up and running at default location /var/lib/mysql at default port 3306. If you would like to customize location and port and other configuration parameters, make sure to remove directory /var/lib/mysql and kill the existing mysqld process running. Disab

Getting "sudo: a password is required\r\n", "msg": "MODULE FAILURE", "rc": 1} While running following command to run Ansible playbook getting error message "sudo: a password is required\r\n", "msg": "MODULE FAILURE", "rc": 1} $ ansible-playbook <PlayBookFileName> .yml -i <PathToHostFileName>/ hosts Means in a playbook you define to login as one user, and becoming another user while executing command on remote host, which require password as follows. Most of the organization has adopted a policy to use Active Directory to login into Linux server, during these days. remote_user: <ActiveDirectory ID> become_user: root You can use either -K , OR --ask-become-pass and ask for privilege escalation password. And your playbook will be executed successfully. Add option -K as follows $ ansible-playbook <PlayBookFileName>.yml -i <PathToHostFileName>/hosts -K

Initialize Swarm on Node 1 # docker swarm init --advertise-addr=10.86.64.236 Swarm initialized: current node (n7w1dp3ub0illangx4qh96kld) is now a manager. # docker network create -d overlay dba_test-overlay vlhzekq8v3kka6t7vns7dhnvc Node1- Add attachable network: # docker network create --driver=overlay --attachable <newtork_name> 7avvbx3tmfg36ae7bipfq0waf Run Docker Container with Overlay network: # docker run -it --name=mysql_8.0.18_1 \ --network <network_name> \ --volume= /mysql/<mysql_version>/<app_name>/data_1 :/var/lib/mysql \ --publish <UserDefinedPortNo> :3306 \ -d mysql/mysql-server: 8.0.18 Retrieve root user password for container mysql_5.7.25_2: # docker logs mysql_8.0.18_1 2>&1 | grep GENERATED [Entrypoint] GENERATED ROOT PASSWORD: 0h7eD]UbfUs&ABjuzfuM@Hogw@w # docker exec -it mysql_8.0.18_1 mysql -uroot –p mysql> alter user 'root'@'localhost' identified by 'root123#';