The Ultimate Guide to High Availability with MariaDB

Comments - I know this has been asked loads before, but...

6 years, 9 months ago Simon Markham
Re: I know this has been asked loads before, but...

Will do! I'm just rebuilding from the latest image (29/11/2017).. Yours Simon M.

 
6 years, 9 months ago Simon Markham
Re: I know this has been asked loads before, but...

OK rebuilt and same result..

here are the steps

All from root

#### Installing MariaDB

apt-get install mariadb-server -y
sudo mysql_secure_installation

#### Installing phpMyAdmin

apt-get install phpmyadmin
/etc/init.d/php7.0-fpm reload && /etc/init.d/nginx reload
mysql -u root -p
use mysql;
update user set plugin = '' where User = 'root';
flush privileges;
exit;

Test phpmyadmin in the browser: http://raspberrypi/phpmyadmin/ Super double stop database!

service mysql stop && /etc/init.d/mysql stop && systemctl stop mariadb.service && systemctl stop mysql.service && systemctl stop mariadb && systemctl stop mysql then check for to see if its dead systemctl is-active mariadb.service move data rsync -a /var/lib/mysql /mnt/database/

No change, can anyone share there working my.cnf?

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.