Ir para o conteúdo principal

Instalação do Percona MySQL

Instalação Percona MySQL.

sudo su
apt update && apt upgrade
wget https://repo.percona.com/apt/percona-release_latest.$(lsb_release -sc)_all.deb
dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb
percona-release setup ps80
apt install percona-server-server
mysql_secure_installation

Responsa o seguinte questionário:

  • Enter password for user root: digitar a senha temporária informada
  • Press y|Y for Yes, any other key for No: : Y
  • Change the password for root ? ((Press y|Y for Yes, any other key for No) : Y
  • New password: digite a nova senha novamente
  • Re-enter new password: repita a nova senha novamente
  • Remove anonymous users? (Press y|Y for Yes, any other key for No) : Y
  • Disallow root login remotely? (Press y|Y for Yes, any other key for No) : No
  • Remove test database and access to it? (Press y|Y for Yes, any other key for No) : Y
  • Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Y

Continue, executando os seguintes comandos abaixo:

mysql -u root -p -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -u root -p -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -u root -p -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"
crudini --set /etc/mysql/mysql.conf.d/mysqld.cnf mysqld sql_mode STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
crudini --set /etc/mysql/mysql.conf.d/mysqld.cnf mysqld max_allowed_packet 64M
crudini --set /etc/mysql/mysql.conf.d/mysqld.cnf mysqld bind-address 0.0.0.0
crudini --set /etc/mysql/mysql.conf.d/mysqld.cnf mysqld skip-external-locking 1
crudini --set /etc/mysql/mysql.conf.d/mysqld.cnf mysqld skip-host-cache 1
crudini --set /etc/mysql/mysql.conf.d/mysqld.cnf mysqld skip-name-resolve 1
crudini --set /etc/mysql/mysql.conf.d/mysqld.cnf mysqld performance_schema 1
crudini --set /etc/mysql/mysql.conf.d/mysqldump.cnf mysqldump quick 1
crudini --set /etc/mysql/mysql.conf.d/mysqldump.cnf mysqldump quote-names 1
crudini --set /etc/mysql/mysql.conf.d/mysqldump.cnf mysqldump max-allowed-packet 128M
sed -i -e "s/.*skip-external-locking.*/skip-external-locking/" /etc/mysql/mysql.conf.d/mysqld.cnf
sed -i -e "s/.*skip-host-cache.*/skip-host-cache/" /etc/mysql/mysql.conf.d/mysqld.cnf
sed -i -e "s/.*skip-name-resolve.*/skip-name-resolve/" /etc/mysql/mysql.conf.d/mysqld.cnf
sed -i -e "s/.*performance_schema.*/performance_schema/" /etc/mysql/mysql.conf.d/mysqld.cnf
sed -i -e "s/.*quick.*/quick/" /etc/mysql/mysql.conf.d/mysqldump.cnf
sed -i -e "s/.*quote-names.*/quote-names/" /etc/mysql/mysql.conf.d/mysqldump.cnf
service mysql restart
mysql -u root -p mysql -e "UPDATE user SET Host = '%' WHERE user.Host  = 'localhost' AND user.User  = 'root' LIMIT 1"

Continue, executando os seguintes comandos abaixo para definir a senha do root (a mesma definida no MySQL Secure Installation):
Se houver uma exclamação ( !senha ), deverá colocar o contra barra antes ( \!senha ).

mysql -u root -p mysql -e "ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'SENHA';"

Observe que este comando poderá retornar um erro, e você deverá executar novamente para confirmar a operação, onde retornará mensagem de sucesso.

service mysql restart
LC_ALL=C.UTF-8 add-apt-repository ppa:ondrej/php
LC_ALL=C.UTF-8 add-apt-repository ppa:tomvlk/php-archive
apt update && apt upgrade
apt install nginx git curl
apt install php7.3-fpm php7.3-cli php7.3-mysql php7.3-gd php7.3-curl php7.3-imap php7.3-ldap php7.3-odbc php-pear php7.3-xml php7.3-xmlrpc php7.3-mbstring php7.3-sybase php7.3-snmp php7.3-soap php7.3-tidy php7.3-sqlite
apt install php7.3-dev libmcrypt-dev libzip-dev
pecl channel-update pecl.php.net
pecl install mcrypt-1.0.2
pecl install zip
pecl install apcu

Continue, executando os seguintes comandos abaixo:

bash -c "echo extension=/usr/lib/php/20180731/zip.so > /etc/php/7.3/cli/conf.d/zip.ini"
bash -c "echo extension=/usr/lib/php/20180731/mcrypt.so > /etc/php/7.3/cli/conf.d/mcrypt.ini"
bash -c "echo extension=/usr/lib/php/20180731/apcu.so > /etc/php/7.3/cli/conf.d/apcu.ini"
bash -c "echo extension=/usr/lib/php/20180731/zip.so > /etc/php/7.3/fpm/conf.d/zip.ini"
bash -c "echo extension=/usr/lib/php/20180731/mcrypt.so > /etc/php/7.3/fpm/conf.d/mcrypt.ini"
bash -c "echo extension=/usr/lib/php/20180731/apcu.so > /etc/php/7.3/fpm/conf.d/apcu.ini"
service nginx start
service php7.3-fpm start

Voltar ao topo