MRatWork Forum by Mustafa Ramadhan

Sawo Project - Kloxo-MR Discussions => Kloxo-MR Technical Helps => Topic started by: asqard on 2015-05-24, 15:34:28

Title: kloxo mr end php en mariadb error conectet database
Post by: asqard on 2015-05-24, 15:34:28

happens once a day so that all parties operating on php + mysql lose its connection and database support if this is a configuration error kloxo - mr

Title: Re: kloxo mr end php en mariadb error conectet database
Post by: MRatWork on 2015-05-24, 16:13:54

Try 'sh /script/cleanup' and see in last step where all services restarted. Find out kloxo, mysql and php restarted without error.

Title: Re: kloxo mr end php en mariadb error conectet database
Post by: asqard on 2015-05-25, 08:48:58

I did as you say but does not have any bugs is nicely clean and logs are stored somewhere with kloxo - mr

Title: Re: kloxo mr end php en mariadb error conectet database
Post by: MRatWork on 2015-05-25, 08:53:20

This issue still happens?.

Title: Re: kloxo mr end php en mariadb error conectet database
Post by: murshed on 2015-05-25, 09:41:52

Quote from: asqard on 2015-05-24, 15:34:28

happens once a day so that all parties operating on php + mysql lose its connection and database support if this is a configuration error kloxo - mr

last two days, i got this problem also. my server automatically down (only mysql/mariadb). then need to reboot.

i see huge resource usages every 5:00AM. I dont know why!

Title: Re: kloxo mr end php en mariadb error conectet database
Post by: MRatWork on 2015-05-25, 09:45:03

Quote from: murshed on 2015-05-25, 09:41:52

Quote from: asqard on 2015-05-24, 15:34:28

happens once a day so that all parties operating on php + mysql lose its connection and database support if this is a configuration error kloxo - mr

last two days, i got this problem also. my server automatically down (only mysql/mariadb). then need to reboot.

i see huge resource usages every 5:00AM. I dont know why!

If not OpenVZ, run 'sh /script/clearcache3; sh /script/restart-all -y' everyday (bettter execute from cronjob).

Title: Re: kloxo mr end php en mariadb error conectet database
Post by: murshed on 2015-05-25, 09:57:47

Its OpenVZ

Title: Re: kloxo mr end php en mariadb error conectet database
Post by: MRatWork on 2015-05-25, 10:39:00

Backup process tend to high resource usage.

Title: Re: kloxo mr end php en mariadb error conectet database
Post by: murshed on 2015-05-25, 21:58:11

Quote from: MRatWork on 2015-05-25, 10:39:00

Backup process tend to high resource usage.

yes you are right. im disable every backup options.

Title: Re: kloxo mr end php en mariadb error conectet database
Post by: MRatWork on 2015-05-26, 02:57:50

Better enable backup and create cronjob for restart-all. Let say backup in 2 PM and set restart in 3 PM.

Title: Re: kloxo mr end php en mariadb error conectet database
Post by: murshed on 2015-05-30, 07:40:16

Quote from: MRatWork on 2015-05-26, 02:57:50

Better enable backup and create cronjob for restart-all. Let say backup in 2 PM and set restart in 3 PM.

Please do something, i disable every backup but everyday mysql down! then need restart or cronjob restart command. i set it every 2hour :(

Title: Re: kloxo mr end php en mariadb error conectet database
Post by: MRatWork on 2015-05-30, 07:48:20

Find out something to mysql log and or optimize mysql with mysql-tuner.

Title: Re: kloxo mr end php en mariadb error conectet database
Post by: murshed on 2015-05-30, 07:51:26

Quote from: MRatWork on 2015-05-30, 07:48:20

Find out something to mysql log and or optimize mysql with mysql-tuner.

Could you please describe about mysql-tuner or how to use this?

Title: Re: kloxo mr end php en mariadb error conectet database
Post by: MRatWork on 2015-05-30, 07:56:18

1. Install with 'yum install mysqltuner -y'
2. Run with 'mysqltuner --user root --pass ROOTPASSWORD' (find out root password in /usr/local/lxlabs/kloxo/etc/slavedb/dbadmin).
3. Change/add variable according mysqltuner recommendation in /etc/my.cnf.d/server.conf.