dbbot Configuration and Single-Node Deployment Demo

Example goal: Concurrently deploy MySQL standalone instances (5.7.39, port 3310) on three machines.

1. Optional: Upload the installation package in advance

If fcs_auto_download_packages: true in common_config.yml, it can be downloaded automatically. Offline scenes can be manually uploaded to:

/usr/local/dbbot/mysql_ansible/downloads

Example filename:

mysql-5.7.39-linux-glibc2.12-x86_64.tar.gz

2. Configure host inventory `inventory/hosts.ini`

[dbbot_mysql]
192.0.2.131 ansible_user=root ansible_ssh_pass="'<your_password>'"
192.0.2.132 ansible_user=root ansible_ssh_pass="'<your_password>'"
192.0.2.133 ansible_user=root ansible_ssh_pass="'<your_password>'"

Note:

Currently only root is supported for deployment.
It is recommended to keep the password writing method in the form of "'password'".

3. Configure public parameters

Edit playbooks/common_config.yml:

mysql_version: "5.7.39"
mysql_port: 3310

advanced_config.yml is an advanced option and cannot be modified by default.

Default password notes:

dbbot’s public default passwords follow Dbbot_<user>@8888 / Dbbot_<linux_user>@9999.
The default is fcs_allow_dbbot_default_passwd: false, so if you do not change these passwords, the standalone demonstration will also be intercepted by pre_tasks.
Only for quick validation in the experimental environment, it is recommended to explicitly add a line: fcs_allow_dbbot_default_passwd: true.

4. Perform standalone deployment

cd /usr/local/dbbot/mysql_ansible/playbooks
ansible-playbook single_node.yml

5. Validation example

mysql -uadmin -h127.0.0.1 -P3310 -pDbbot_admin@8888 -e "select @@version"

If quick login is enabled, you can also:

su mysql
db3310

Pre-deployment checklist

inventory/hosts.ini host information is correct.
playbooks/common_config.yml common parameters are correct.
playbooks/vars/var_xxx.yml proprietary parameters are filled in according to the script.
(Optional) playbooks/advanced_config.yml Advanced parameter confirmation.