This tutorial shows how to install an Apache web server on CentOS 7 server with PHP (mod_php) and MySQL database. The acronym LAMP is short for Linux, Apache, MySQL, PHP.
This tutorial shows the installation of the latest PHP version 7.3 on CentOS 7.6 Continue reading “How to install Apache, PHP 7.3 and MySQL on CentOS 7.6 (LAMP)”
MySQL replication is a process that enables data from one MySQL database server (the master) to be copied automatically to one or more MySQL database servers (the slaves). Replication is asynchronous by default. Slaves do not need to be connected permanently to receive updates from the master. Depending on the configuration, you can replicate all databases, selected databases, or even selected tables within a database.
Continue reading “How to set up master slave replication in MySQL”
Magento is an open-source e-commerce platform written in PHP. The software was originally developed by Varien, Inc, a US private company headquartered in Culver City, California, with assistance from volunteers.
Continue reading “How to install latest Magento 2 CMS in Debian 9”
This tutorial shows how to install an Apache web server on CentOS 7 server with PHP (mod_php) and MySQL database. The acronym LAMP is short for Linux, Apache, MySQL, PHP.
This tutorial shows the installation of the latest PHP version 7.2 on CentOS 7.5 Continue reading “How to install Apache, PHP 7.2 and MySQL on CentOS 7.5 (LAMP)”
Hello,
DirectAdmin announced that all DirectAdmin and CustomBuild 2.0 now support MySQL 5.7.
Related changes done to DirectAdmin to support it:
https://www.directadmin.com/features.php?id=1840
It was actually added back in DA 1.52.0 (October 2017), while DA 1.53.0 is the current version, but wasn’t announced right away to give time for proper testing, which seems to all check out now.
MAKE SQL BACKUPS BEFORE UPGRADING see below.
CustomBuild 2.0 should automatically set the mysql_milestone_16=1 directadmin.conf value for you, so as long as CB2 does the upgrade, you should be fine.
To do the upgrade from an older MySQL version to MySQL 5.7, run:
cd /usr/local/directadmin/custombuild ./build set mysql 5.7 ./build set mysql_inst mysql ./build set mysql_backup yes ./build update #make a backup that wont be overwritten, rename the folder ./build mysql_backup mv mysql_backups mysql_backups.`date +%F` ./build mysql ./build php n service httpd restart
Related guide:
https://help.directadmin.com/item.php?id=240
If you’re running MariaDB, then switching to MySQL might not be 100% straightforward, as higher versions of MariaDB cannot be directly switched over. But (for example), if you’re running a working MariaDB 5.5, then switch to MySQL 5.5, then switch to MySQL 5.7.
