After testing an upgrade we deployed a new virtual machine with Azure with Ubuntu 18.04 for our database. The old A0 VM is actually costs a few pesos more than the new B1s VM which makes this new platform more cost effective. The CPU load for the blade server is reduced considerably as well which …
Category: MySQL
UPGRADING OUR DATABASE SERVER
We updated our Linux VM from Ubuntu 16.04 to 18.04 so that we could be ready for another few years without problems. Unfortunately the update reset the config file so we had to hunt around to fix it. sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf We had to change bind-address = 127.0.0.1 to 0.0.0.0 so our sites would connect, fixed …
WEB SERVER PERFORMANCE
Web servers today are a real mixed bag as prices for services have come down so much. To run a successful server swarm needs some resources. Blade servers are the most common hardware available. Most individual machines can be equipped with at least 128GB of memory. With dual sockets and modern 8 core 16 core …
OPENSSL 1.1.0.b
Another vulnerability has been discovered and patched for OpenSSL https://www.openssl.org/news/secadv/20160926.txt For LAMP users there is also a new version of MySQL available, it updated our server without problem sudo apt update sudo apt full-upgrade reboot your server to be sure the stack is clean sudo reboot
MOVE MySQL TO NEW SERVER
Ubuntu LTS is supported for 5 years. This means that occasionally a new server has to be created and the database copied. It will take some time depending on several factors. mysqldump -u root -p –opt [database name] > [database name].sql The dump SQL file can then be copied to the new machine (disk). Then …
UBUNTU 16.04 MYSQL DATABASE
Azure does not have a branded MySQL so we had to setup a Linux virtual machine. Azure bought ClearDB but they are unsuitable. We are using Ubuntu Server 16.04 LTS and the comments here are tested with that version of Linux. Other distributions may differ slightly. Ubuntu supports LTS releases for 5 years which cuts …
MYSQL SUPPLEMENTAL STORAGE
UNDER CONSTRUCTION A basic Azure Linux virtual machine can be used for a smaller database. As the tables grow there are some options, with low traffic and a large table extra storage is lower cost than a larger virtual machine. First some tools are needed. sudo apt install mysql-utilities Now its possible to determine how …
MYSQL
MySQL has been the default open source database for many years. Its part of the LAMP stack which is the most popular role for Linux web server appliances. Microsoft has changed the database availability in 2016 so that even the F1 service (free) can now have a small 20MB database so that WordPress users like …