• How to use the function "Auto re-Start MySQL Server"

  • Members help others by posting how to use VPSSIM.

Members help others by posting how to use VPSSIM.
 #1633  by nguyenoanh
 14 Aug 2018 16:40
When the MySQL service on the VPS is dead, we visit the website on the browser we will see error:

https://vpssim.vn/wp-content/uploads/2014/12/loi-Error-establishing-a-database-connection.png

To fix this error, we should start MySQL service:
Code: Select all
service mysql start
or on centos 7:
Code: Select all
systemctl start mysql.service
We can config VPSSIM auto do this by using the function: Auto re-Start MySQL Server

The function path: VPSSIM menu ==> Database manage ==> Auto re-Start MySQL Server

To enable this function:

=========================================================================
             VPSSIM - Manage VPS/Server by VPSSIM.COM (4.5.0.8)
=========================================================================
                           Database Manage
=========================================================================
     Total Databases Size: 50M | Total Backup Files Size: 13M
=========================================================================
How to use: http://go.vpssim.vn/howdata
=========================================================================
1) Create Database		     9) Copy Backup To Root Of Domain
2) Delete Database		    10) Delete All Backup Files
3) Backup 1 Database		    11) View Database's Infomation
4) Backup All Databases		    12) View MySQL Root's password
5) Backup & Restore FULL (1 File)   13) Re-Config MySQL
6) Auto Backup Database		    14) Auto re-Start MySQL Server
7) Restore Database		    15) List & Size of All Databases
8) Get Link Download Backup
Type in your choice (0-Exit): 14
=========================================================================
With less RAM server, sometime free RAM is too low, MySQL service is stop
-------------------------------------------------------------------------
After you enable [Auto re-start MySQL Server] function
-------------------------------------------------------------------------
VPSSIM will check MySQL status every 5 minutes, If MySQL service stop
-------------------------------------------------------------------------
VPSSIM will re-Start it within a maximum of 5 minnutes.
=========================================================================
How to use: http://go.vpssim.vn/autostartmysql
=========================================================================
You want to enable [Auto re-start MySQL Server] function ?  [y/N] y
Result:
=========================================================================
Enable [Auto re-start MySQL Server] function successfully !
=========================================================================
             VPSSIM - Manage VPS/Server by VPSSIM.COM (4.5.0.8)
=========================================================================
                           Database Manage
=========================================================================
     Total Databases Size: 50M | Total Backup Files Size: 13M
=========================================================================
How to use: http://go.vpssim.vn/howdata
=========================================================================
1) Create Database		     9) Copy Backup To Root Of Domain
2) Delete Database		    10) Delete All Backup Files
3) Backup 1 Database		    11) View Database's Infomation
4) Backup All Databases		    12) View MySQL Root's password
5) Backup & Restore FULL (1 File)   13) Re-Config MySQL
6) Auto Backup Database		    14) Auto re-Start MySQL Server
7) Restore Database		    15) List & Size of All Databases
8) Get Link Download Backup
Type in your choice (0-Exit):
To disable this function, we run this function once again.
Get 25 USD Free To USE VPSSIM