Отдельный сервер MySQL и CL / db_governor
Форум
  1. Forums
  2. CloudLinux and Control Panels
  3. CloudLinux and cPanel
  1. Christos Panagiotakis
  2. Friday, 12 April 2013
  3.  Subscribe via email
First of all I didn\'t try it so I was wondering if anyone is using separate server for mysql if it really worth it.
(the \"Setup Remote Mysql Server\" in WHM) using cloudlinux in front cpanel server.

And if it worth it (faster loading, less cpu, more accounts on the same servers etc), can db governor work
in the separate mysqld system (cloudlinux on the mysql server) ?
Rate this post:
  1. 12.04.2013 07:04:26
  2. # 1
Igor Seletskiy Accepted Answer
Posts: 1200
Joined: 09.02.2010
0
Votes
Undo
Christos,
DB governor will work with separate MySQL system, but CL has to be installed on that system (CL kernel needed for throttling to be possible).

I cannot comment on having remote MySQL server -- it depends on quite a few things, and I seen companies running MySQL both ways with quite good results.
  1. 21.04.2013 06:04:18
  2. # 2
Przemek Peron Accepted Answer
Posts: 5
Joined: 14.04.2013
0
Votes
Undo
I\'m thinking about the following config:
3 DA servers with Cloudlinux + 1 remote MySQL server

All 3 DirectAdmin servers will use the same MySQL server. I was using such config without CL installed in the past but will db_governor work in such configuration where db_governor on all 3 servers checks one MySQL server. I don\'t know exactly how db_governor works and am affaid whether db_governor from one DA server will not interfere with another one.
  1. 21.04.2013 08:04:53
  2. # 3
Igor Seletskiy Accepted Answer
Posts: 1200
Joined: 09.02.2010
0
Votes
Undo
You would need to install governor on MySQL server only. It has to reside on the same server as MySQL
  1. 04.05.2013 15:05:28
  2. # 4
Przemek Peron Accepted Answer
Posts: 5
Joined: 14.04.2013
0
Votes
Undo
If I install governor on MySQL server only then how will it restrict the users on DA server to LVE id 3?

Or you mean I should install the plugin on the MySQL server and the db_governor service on the DA server? But then the db_governor service could interfere if run in parallel on different DA servers.
  1. 04.05.2013 16:05:43
  2. # 5
Igor Seletskiy Accepted Answer
Posts: 1200
Joined: 09.02.2010
0
Votes
Undo
MySQL governor should be installed on the same server as MySQL server.
You can control settings for LVE 3 using command line interface.
  1. 08.05.2013 07:05:19
  2. # 6
Przemek Peron Accepted Answer
Posts: 5
Joined: 14.04.2013
0
Votes
Undo
When db_governor is running on MySQL server and it decides to restrict user \"abc\" it will try to put \"abc\" user into LVE 3 on MySQL server but .... the user doesn\'t exist on DB server but on DirectAdmin server.
  1. 08.05.2013 09:05:29
  2. # 7
Igor Seletskiy Accepted Answer
Posts: 1200
Joined: 09.02.2010
0
Votes
Undo
LVE #3 is a \'MySQL Abusers\' LVE -- where all abusers will be placed. It doesn\'t matter if MySQL server is on another machine. It has no relationship to system user.
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!
гость
Submit Your Response
Upload files or images for this discussion by clicking on the upload button below. Supports gif,jpg,png,zip,rar,pdf
• Insert • Remove Upload Files (Maximum File Size: 2 MB)
Captcha
To protect the site from bots and unauthorized scripts, we require that you enter the captcha codes below before posting your question.