In this file, I will present and demonstrate how to install MariaDB in an automated and easy way.
For this, I will be using the scenario described down below:
1 Linux server for ansible
1 Linux server for MariaDB (the one that we will install MariaDB using Ansible)
First of all, we have to prepare our Linux environment to use Ansible
Please have a look below how to install Ansible on CentOS/Red Hat:
yum install ansible -y
Well now that we have Ansible installed already, we need to install git to clone our git repository on the Linux server, see below how to install it on CentOS/Red Hat:
yum install git -y
Copying the script packages using git:
cd /root
git clone https://github.com/emersongaudencio/ansible-mariadb-install-standalone.git
Alright then after we have installed Ansible and git and clone the git repository. We have to generate ssh heys to share between the Ansible control machine and the database machines. Let see how to do that down below.
To generate the keys, keep in mind that is mandatory to generate the keys inside of the directory who was copied from the git repository, see instructions below:
cd /root/ansible-mariadb-install-standalone/ansible
ssh-keygen -f ansible
After that you have had generated the keys to copy the keys to the database machines, see instructions below:
ssh-copy-id -i ansible.pub 172.16.122.136
Please edit the file called hosts inside of the ansible git directory :
vi hosts
Please add the hosts that you want to install your database and save the hosts file, see an example below:
# This is the default ansible 'hosts' file.
#
## [dbservers]
##
## db01.intranet.mydomain.net
## db02.intranet.mydomain.net
## 10.25.1.56
## 10.25.1.57
[dbservers]
dblocalhost ansible_connection=local
dbmariadb101 ansible_ssh_host=172.16.122.133
dbmariadb102 ansible_ssh_host=172.16.122.134
dbmariadb103 ansible_ssh_host=172.16.122.135
dbmariadb104 ansible_ssh_host=172.16.122.136
For testing if it is all working properly, run the command below :
ansible -m ping dbmariadb104 -v
Alright finally we can install our MariaDB 10.4 using Ansible as we planned to, run the command below:
sh run_mariadb_install.sh dbmariadb104 104
| Parameter | Value | Mandatory | Order | Accepted values |
|---|---|---|---|---|
| host | dbmariadb104 | Yes | 1 | hosts who are placed inside of the hosts file |
| db mariadb version | 104 | Yes | 2 | 101, 102, 103, 104, 105 |
PS: Just remember that you can do a single installation at the time or a group installation you inform the name of the group in the hosts' files instead of the host itself.
The versions supported for this script are these between the round brackets (101, 102, 103, 104, 105).
Neste arquivo, venho apresentar e demonstrar como fazer a instalacao do MariaDB de forma automatizada e simples.
Para este post estarei utilizando o seguinte cenario:
1 servidor para o ansible
1 servidor que sera o nosso banco de dados MariaDB
Primeiramente temos que preparar nosso ambiente para utilizar o Ansible.
Veja abaixo com fazer a instalacao do Ansible no CentOS/Red Hat ou derivados:
yum install ansible -y
Bom agora que ja temos o Ansible instalado, vamos fazer o download do pacote de scripts no GitHub abaixo:
yum install git -y
Copiando o pacote de scripts com git:
cd /root
git clone https://github.com/emersongaudencio/ansible-mariadb-install-standalone.git
Bom depois de instalar o ansible, git e clonar o repositorio no servidor do ansible, vamos precisar gerar chaves ssh e compartilhar entre o servidor do ansible e o servidor de banco de dados para que possamos executar os scripts do pacote do ansible.
Para gerar as chaves dentro do diretorio que copiou o repositorio de scripts do git:
cd /root/ansible-mariadb-install-standalone/ansible
ssh-keygen -f ansible
Depois copie a
ssh-copy-id -i ansible.pub 172.16.122.136
Edite o arquivo hosts do pacote de diretorio do ansible:
vi hosts
Adicione os hosts que vai fazer a instalacao e salve o arquivo, veja o exemplo abaixo:
# This is the default ansible 'hosts' file.
#
## [dbservers]
##
## db01.intranet.mydomain.net
## db02.intranet.mydomain.net
## 10.25.1.56
## 10.25.1.57
[dbservers]
dblocalhost ansible_connection=local
dbmariadb101 ansible_ssh_host=172.16.122.133
dbmariadb102 ansible_ssh_host=172.16.122.134
dbmariadb103 ansible_ssh_host=172.16.122.135
dbmariadb104 ansible_ssh_host=172.16.122.136
Depois disso faca um teste para verificar se o ansible esta realmente conectando e funcionando corretamente com o script abaixo:
ansible -m ping dbmariadb104 -v
Agora finalmente execute o script para fazer a instalacao remota do MariaDB 10.4 no seu servidor de banco de dados:
sh run_mariadb_install.sh dbmariadb104 104
Obs: Lembrando que tambem eh possivel fazer a instalacao para todo um grupo de servidor de uma soh vez, substituindo o nome do servidor pelo nome do grupo, que no nosso exemplo eh dbservers.
Outra observacao sobre o script eh que as versoes que voce pode instalar sao essas aqui (101, 102, 103, 104, 105).