Diferències

Ací es mostren les diferències entre la revisió seleccionada i la versió actual de la pàgina.

Enllaç a la visualització de la comparació

--- tech:vagrant:casosuso:mysql [03/05/2019 01:34] – creat mate
+++ tech:vagrant:casosuso:mysql [16/11/2021 02:55] (actual) – suprimit mate
@@ Línia 1: / Línia 1: @@
-= vagrant mysql
-los ficheros necesarios se han servido desde un pequeño contenedor (por restricciones de licencia o firewall),
-<code bash>docker run -d -p 9090:80 -v $PWD:/http tiagoad/nginx-index</code>
-== con docker
-(problema sin resolver, la VM arranca bien el mysql la primera vez, pero no las posteriores)
-<code yaml; Vagrantfile>
-IP = '192.168.1.20'
-VERSION = '5.5'
-NAME = "mysql-#{VERSION}"
-Vagrant.configure("2") do |config|
-  config.vm.box = "altrankas/mysql5"
-  config.vm.hostname = NAME
-  config.vm.define NAME
-  config.vm.network "private_network", ip: "#{IP}"
-  config.vm.network "forwarded_port", guest: 3306, host: 3306
-  config.vm.synced_folder ".", "/vagrant"
-  config.vm.provider :virtualbox do |v|
-    v.gui = true
-    v.linked_clone = true
-    v.name = NAME
-  end
-  config.vm.provision "shell", path: "../../common/setup-mysql.sh", args: "#{VERSION}"
-  config.vm.provision "shell", path: "../../common/setup-vagrant.sh"
-  config.vm.provision "docker" do |d|
-    d.run "mysql_#{VERSION}", image: "mysql:#{VERSION}",
-      args: "-p 3306:3306 -v /data/#{VERSION}:/var/lib/mysql --env MYSQL_ROOT_PASSWORD=admin"
-  end
-end
-</code>
-== 5.5 standalone
-el fichero **tar.gz** ya está descargado, pero está preparado para depender del nginx.
-<code yaml; Vagrantfile>
-Vagrant.configure("2") do |config|
-  config.vm.box = "peru/ubuntu-18.04-desktop-amd64"
-  config.vm.box_version = "20190401.01"
-  config.vm.provision "file", source: "../../common/addroot.sql", destination: "/tmp/addroot.sql"
-  config.vm.provision "file", source: "./mysql-5.5.62-linux-glibc2.12-x86_64.tar.gz", destination: "/tmp/mysql-5.5.62-linux-glibc2.12-x86_64.tar.gz"
-  config.vm.network "private_network", ip: "192.168.1.5"
-  config.vm.network "forwarded_port", guest: 3306, host: 3306
-  config.vm.provider :virtualbox do |v|
-    v.name = "altrankas-mysql-5.5"
-    v.linked_clone = true
-    v.memory = 2048
-    v.cpus = 2
-  end
-  config.vm.provision "shell", path: "install.sh"
-#  config.vm.provision "shell", path: "../../common/addInsecureKey.sh"
-end
-</code>
-<code bash; install.sh>
-#!/bin/bash
-# https://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.62-linux-glibc2.12-x86_64.tar.gz
-MYSQL_FOLDER="mysql-5.5.62-linux-glibc2.12-x86_64"
-MYSQL_TGZ="${MYSQL_FOLDER}.tar.gz"
-MYSQL_URL_DOWNLOAD="https://dev.mysql.com/get/Downloads/MySQL-5.5/${MYSQL_TGZ}"
-MYSQL_HOME="/usr/local/mysql"
-DEBIAN_FRONTEND=noninteractive
-sudo apt-get -y update
-sudo apt-get install -y wget libaio1 > /dev/null 2>&1
-sudo debconf-set-selections <<< 'mysql-community-server mysql-community-server/root-pass password admin'
-sudo debconf-set-selections <<< 'mysql-community-server mysql-community-server/re-root-pass password admin'
-#sudo wget -O /tmp/${MYSQL_TGZ} ${MYSQL_URL_DOWNLOAD}
-sudo tar zxf /tmp/${MYSQL_TGZ} -C /tmp/
-sudo mv /tmp/${MYSQL_FOLDER} ${MYSQL_HOME}
-sudo groupadd mysql
-sudo useradd -r -g mysql -s /bin/false mysql
-sudo chown -R mysql:mysql ${MYSQL_HOME}
-cd ${MYSQL_HOME}
-sudo ${MYSQL_HOME}/scripts/mysql_install_db --basedir=${MYSQL_HOME} --user=mysql
-sudo chown -R root ${MYSQL_HOME}
-sudo chown -R mysql ${MYSQL_HOME}/data
-sudo cp ${MYSQL_HOME}/support-files/my-medium.cnf /etc/my.cnf
-sudo cp ${MYSQL_HOME}/support-files/mysql.server /etc/init.d/mysql.server
-sudo mkdir /var/run/mysql
-sudo chown -R mysql /var/run/mysql
-cd ${MYSQL_HOME}
-sudo ${MYSQL_HOME}/bin/mysqld_safe --user=mysql --basedir=${MYSQL_HOME} &
-sleep 10
-${MYSQL_HOME}/bin/mysqladmin -u root password 'admin'
-sudo ${MYSQL_HOME}/bin/mysql -u root --password=admin mysql < /tmp/addroot.sql
-sudo update-rc.d mysql.server defaults
-#sudo systemctl restart mysql.service
-sudo locale-gen es_ES
-echo "setxkbmap -layout 'es,es' -model pc105" >> /home/vagrant/.bashrc
-sudo echo "PATH=\"${PATH}:${MYSQL_HOME}/bin\"" >> /etc/environment
-</code>
-== 5.6 standalone
-el Vagrantfile se readapta, pequeños cambios (el **name** y el fichero **tar**):
-<code yaml>  config.vm.provision "file", source: "./mysql-server_5.6.43-1ubuntu14.04_amd64.deb-bundle.tar", destination: "/tmp/mysql-server_5.6.43-1ubuntu14.04_amd64.deb-bundle.tar"</code>
-<code bash; install.sh>
-#!/bin/bash
-# https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-server_5.6.43-1ubuntu14.04_amd64.deb-bundle.tar
-MYSQL_TGZ="mysql-server_5.6.43-1ubuntu14.04_amd64.deb-bundle.tar"
-MYSQL_URL_DOWNLOAD="https://dev.mysql.com/get/Downloads/MySQL-5.6/${MYSQL_TGZ}"
-DEBIAN_FRONTEND=noninteractive
-sudo apt-get -y update
-sudo apt-get install -y wget > /dev/null 2>&1
-sudo debconf-set-selections <<< 'mysql-community-server mysql-community-server/root-pass password admin'
-sudo debconf-set-selections <<< 'mysql-community-server mysql-community-server/re-root-pass password admin'
-#sudo apt-get install -y mysql-server > /dev/null 2>&1
-#sudo wget -O /tmp/${MYSQL_TGZ} ${MYSQL_URL_DOWNLOAD}
-sudo mkdir /tmp/mysql
-sudo tar xf /tmp/${MYSQL_TGZ} -C /tmp/mysql
-sudo dpkg -i /tmp/mysql/*.deb
-sudo apt-get install -fy
-sudo rm -rf /tmp/mysql
-sudo rm -f /tmp/${MYSQL_TGZ}
-#sudo sed -i.bak "s|127.0.0.1|0.0.0.0|g" /etc/mysql/mysql.conf.d/mysqld.cnf
-sudo mysql -u root --password=admin mysql < /tmp/addroot.sql
-sudo systemctl restart mysql.service
-sudo locale-gen es_ES
-echo "setxkbmap -layout 'es,es' -model pc105" >> /home/vagrant/.bashrc
-</code>
-== 5.7 standalone
-versión Vagrantfile más reducida
-<code yaml; Vagrantfile>
-Vagrant.configure("2") do |config|
-  config.vm.box = "peru/ubuntu-18.04-desktop-amd64"
-  config.vm.box_version = "20190401.01"
-  config.vm.provision "file", source: "../../common/addroot.sql", destination: "/tmp/addroot.sql"
-  config.vm.provider :virtualbox do |v|
-    v.name = "altrankas-mysql-5.7"
-    v.linked_clone = true
-    v.memory = 2048
-    v.cpus = 2
-  end
-  config.vm.provision "shell", path: "install.sh"
-  config.vm.provision "shell", path: "../../common/addInsecureKey.sh"
-end
-</code>
-<code bash; install.sh>
-#!/bin/bash
-DEBIAN_FRONTEND=noninteractive
-sudo apt-get -y update
-sudo debconf-set-selections <<< 'mysql-server mysql-server/root_password password admin'
-sudo debconf-set-selections <<< 'mysql-server mysql-server/root_password_again password admin'
-sudo apt-get install -y mysql-server > /dev/null 2>&1
-sudo sed -i.bak "s|127.0.0.1|0.0.0.0|g" /etc/mysql/mysql.conf.d/mysqld.cnf
-sudo mysql -u root --password=admin mysql < /tmp/addroot.sql
-sudo systemctl restart mysql.service
-sudo locale-gen es_ES
-echo "setxkbmap -layout 'es,es' -model pc105" >> /home/vagrant/.bashrc
-</code>
-== ficheros comunes
-<code sql; addroot.sql>
-CREATE USER 'root'@'%' IDENTIFIED BY 'admin';
-GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
-</code>
-<code bash; addInsecureKey.sh>
-#!/bin/bash
-su - vagrant
-echo "ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAQEA6NF8iallvQVp22WDkTkyrtvp9eWW6A8YVr+kz4TjGYe7gHzIw+niNltGEFHzD8+v1I2YJ6oXevct1YeS0o9HZyN1Q9qgCgzUFtdOKLv6IedplqoPkcmF0aYet2PkEDo3MlTBckFXPITAMzF8dJSIFo9D8HfdOV0IAdx4O7PtixWKn5y2hMNG0zQPyUecp4pzC6kivAIhyfHilFR61RGL+GPXQ2MWZWFYbAGjyiYJnAmCP3NOTd0jMZEnDkbUvxhMmBYSdETk1rRgm+R4LOzFUGaHqHDLKLX+FIPKcF96hrucXzcWyLbIbEgE98OHlnVYCzRdK8jlqm8tehUc9c9WhQ== vagrant insecure public key
-" >> .ssh/authorized_keys
-</code>