A small tweek in MySQL Data path in Linux using webmin Rumi, June 12, 2008 By default all database and data are stored in /var/lib/mysql But whenever, you’re planning to setup a virtual hosted server, it is wise to set up and configure this db to be set up in some different bigger disk space. Like I use to place this data path to /home/mysql How to change this using webmin From your webmin Servers > MySQL Database Server > MySQL Server Configuration section look for- Database files directory = /var/lib/mysql Now change this to- Database files directory = /home/mysql A small reminder- don’t forget to create “mysql” directory in /home location! It’s done! You have changed the data storage path! Precaution: It is recommended to modify or update this mysql data path on a fresh installation- without any cpanel or virtualmin server is hosted. And also don’t you forget to restart the MySQL service after this changes are made! Happy data organizing!!! 😛 Related Configurations (Linux)
Simple failover cluster using UCARP on Ubuntu (Heartbeat Alternative) January 24, 2016 In this tutorial, I’ll show you the steps to create a simple failover cluster on Ubuntu using CARP. To make the things meaningful,we’ll create the cluster for Apache service but you can use it for any other service, which relay on IP. Scenario: Here is my Setup: PrimarySrv: This is the… Read More
Percona Mysql Service Force Stop June 10, 2020 Service mysql stop is being ignored. How to fix? Try mysqladmin -u root -p shutdown Alternatively, In case you have started /etc/init.d/mysql bootstrap-pxc So in this case you should stop bootstrapped node using /etc/init.d/mysql bootstrap-stop Related Read More
XRDP in OpenSuse 11.0/11.2/11.3 September 28, 2012 This tutorial is for advanced users who prefer to skate all the detail that attaches to a "new user" Tutorial. The details (wherein lies the devil) are here: Windows Linux RDP Remote Desktop Connections using openSUSE as Client or Server (terminal server) FWIW there's also an 11.1 version there. Tested… Read More