Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2024-03-28, 22:45:43

Author Topic: kloxo mr end php en mariadb error conectet database  (Read 8739 times)

0 Members and 1 Guest are viewing this topic.

Offline asqard

  • Junior Member
  • *
  • Posts: 17
  • Karma: +0/-0
    • View Profile
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

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: kloxo mr end php en mariadb error conectet database
« Reply #1 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.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline asqard

  • Junior Member
  • *
  • Posts: 17
  • Karma: +0/-0
    • View Profile
Re: kloxo mr end php en mariadb error conectet database
« Reply #2 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

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: kloxo mr end php en mariadb error conectet database
« Reply #3 on: 2015-05-25, 08:53:20 »
This issue still happens?.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline murshed

  • Valuable Member
  • *
  • Posts: 93
  • Karma: +0/-0
  • Gender: Male
    • View Profile
Re: kloxo mr end php en mariadb error conectet database
« Reply #4 on: 2015-05-25, 09:41:52 »
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!

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: kloxo mr end php en mariadb error conectet database
« Reply #5 on: 2015-05-25, 09:45:03 »
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).
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline murshed

  • Valuable Member
  • *
  • Posts: 93
  • Karma: +0/-0
  • Gender: Male
    • View Profile
Re: kloxo mr end php en mariadb error conectet database
« Reply #6 on: 2015-05-25, 09:57:47 »
Its OpenVZ

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: kloxo mr end php en mariadb error conectet database
« Reply #7 on: 2015-05-25, 10:39:00 »
Backup process tend to high resource usage.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline murshed

  • Valuable Member
  • *
  • Posts: 93
  • Karma: +0/-0
  • Gender: Male
    • View Profile
Re: kloxo mr end php en mariadb error conectet database
« Reply #8 on: 2015-05-25, 21:58:11 »
Backup process tend to high resource usage.

yes you are right. im disable every backup options.

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: kloxo mr end php en mariadb error conectet database
« Reply #9 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.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline murshed

  • Valuable Member
  • *
  • Posts: 93
  • Karma: +0/-0
  • Gender: Male
    • View Profile
Re: kloxo mr end php en mariadb error conectet database
« Reply #10 on: 2015-05-30, 07:40:16 »
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 :(

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: kloxo mr end php en mariadb error conectet database
« Reply #11 on: 2015-05-30, 07:48:20 »
Find out something to mysql log and or optimize mysql with mysql-tuner.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline murshed

  • Valuable Member
  • *
  • Posts: 93
  • Karma: +0/-0
  • Gender: Male
    • View Profile
Re: kloxo mr end php en mariadb error conectet database
« Reply #12 on: 2015-05-30, 07:51:26 »
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?

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: kloxo mr end php en mariadb error conectet database
« Reply #13 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.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

 


MRatWork Affiliates:    BIGRAF(R) Inc.    House of LMAR    EFARgrafix
Click Here

Page created in 0.044 seconds with 18 queries.

web stats analysis