Current time: 11-11-2024, 07:42 AM Hello There, Guest! (LoginRegister)


Post Reply 
PATCH: Multi-Server ispCP!
Author Message
zmediaguru Offline
Junior Member
*

Posts: 16
Joined: Jan 2007
Reputation: 0
Post: #1
PATCH: Multi-Server ispCP!
[Feb 13, 2008 Update, I have just posted a new patch for RC7here.]

All,

By way of introduction, I have used VHCS2 (heavily modded) in a production environment for several years, and have been following this ispCP project since it was started. I have installed most of the Release Candidates on various test environments as they were released and am impressed with the improvements that have been made to the project - good work!

For some time, I have been pondering the best route to enhance ispCP so that it can manage users and resellers across multiple servers. After much thought I have begun putting this together.

Here's how it works:

ispCP already allows you to create multiple IP addresses, and designate which IP addresses Resellers and Users can use with their accounts. I have simply built an additional table in the database and added one other column to an existing table to assign each IP address to a specific host server.

Yesterday, I completed mods to the GUI to allow for managing the hosts, and assigning each IP address to a specific host. See screenshots attached below:

.gif  ispcp_manage_hosts.gif (Size: 9.33 KB / Downloads: 379)
.gif  ispcp_manage_ips.gif (Size: 18.46 KB / Downloads: 334)

The concept is that each server (host) will have ispCP installed on it, with the daemon running and the back-end perl engine scripts to build/manage the various server configuration files. The perl engine scripts (ispcp-rqst-mngr, etc.) will be modded slightly with a JOIN added to each query to limit results and operations to only domains assigned to it's local host (server).

The GUI function call to the daemon will also be adjusted to have it connect to each host IP address (as necessary) to trigger the Request Manager on each server whenever changes are made through the centralized GUI.

I will have more details on exactly how this is done as I complete more of the work. Once completed, I will be happy to submit my mods back to the project if the dev team is interested.

This may not be the optimal setup for everyone, but it seems like it will fit in with our infrastructure perfectly. Any thoughts and additional ideas building on what I have presented here would be appreciated!

If anyone is interested in testing this out once I get my mods to a fully-working condition, let me know!

I will report back in here when I have more hammered out.
(This post was last modified: 02-14-2009 04:44 AM by zmediaguru.)
08-13-2008 02:10 AM
Find all posts by this user Quote this message in a reply
RatS Offline
Project Leader
******

Posts: 1,854
Joined: Oct 2006
Reputation: 17
Post: #2
RE: Multi-Server ispCP!
zmediaguru Wrote:Once completed, I will be happy to submit my mods back to the project if the dev team is interested.
Of course, we are interested! We are proud of our community doing great things.
(This post was last modified: 01-30-2009 12:53 AM by RatS.)
08-13-2008 05:37 AM
Visit this user's website Find all posts by this user Quote this message in a reply
simple Offline
Junior Member
**
Graph Team

Posts: 143
Joined: Dec 2006
Reputation: 0
Post: #3
RE: Multi-Server ispCP!
Nice addition, I'll surely do a testdrive once you have the code ready, since a multiserver-singleGui-Interface has many benefits and very little disadvantages.
08-13-2008 03:31 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Ballistic509 Offline
Junior Member
*

Posts: 24
Joined: May 2007
Reputation: 0
Post: #4
RE: Multi-Server ispCP!
That seems amazing. I have plenty of extra boxes around here that need to be put to work!
08-13-2008 06:02 PM
Find all posts by this user Quote this message in a reply
BioALIEN Offline
Public Relations Officer
*****
Dev Team

Posts: 620
Joined: Feb 2007
Reputation: 5
Post: #5
RE: Multi-Server ispCP!
This seems promising. Keep us updated Smile
08-17-2008 03:14 PM
Find all posts by this user Quote this message in a reply
ephigenie Offline
Project Leader
*******
Administrators

Posts: 1,578
Joined: Oct 2006
Reputation: 15
Post: #6
RE: Multi-Server ispCP!
Hey there Wink

i think this is an nice approach - although there'll be some problems with statistics and so on (everything which should flow back to the "master" host ... )

And of course then we really really need to optimize the traffic calculation because now the master mysql gets really loaded if you switch to a reseller which can have 2000 domains because all of them are on 4 servers or so ...
08-23-2008 06:49 PM
Visit this user's website Find all posts by this user Quote this message in a reply
pgentoo Offline
Member
*****
Dev Team

Posts: 326
Joined: Mar 2007
Reputation: 0
Post: #7
RE: Multi-Server ispCP!
This sounds great. Keep up the good work! Smile
08-24-2008 05:35 AM
Find all posts by this user Quote this message in a reply
zmediaguru Offline
Junior Member
*

Posts: 16
Joined: Jan 2007
Reputation: 0
Post: #8
RE: Multi-Server ispCP!
Update: Sorry for the delay. I was gone for about a week, and was not able to pick up and work on this project again until today.

Progress: With the GUI mods already in place (see attached graphics on my previous post), today I completed the initial mods to the ispcp-rqstmngr engine script. What I did was modify the query that looks for any domains that do not have a status of 'ok', refining it to only pull results for domains which are assigned to this server.

I went ahead and setup a second web server, installed ISP-CP, and applied my mod (gui & engine components) to this new server, and pointed it to use the ispcp database on the first primary server.

Success: Today I was able to successfully able to deploy domains across 2 separate web servers from a single GUI!.

With the second web server in place, I was able to add hosts in the control panel GUI, assign IPs to that host, and add a domain user to either of the first or second web servers.

I don't yet have all automation in place for calling the daemon on each web server, so once I've added a domain through the GUI, I still need to manually run the ispcp-rqst-mngr script on whichever server the domain was added to. However, I've already poked around at that code, and have a good idea how to have it call the Request Manager on each node via the daemon once a change is saved in the GUI.

Once I get some more of the initial issues worked out, and also apply some similar modifications to the mailbox process, I will hopefully figure out how to package up my mods as a patch for others to begin testing with.

Interestingly, with ISP-CP fully installed on both server, the GUI can now be accessed from either web server as well - this may be nice down the road implementing some form of load-balancing, etc.
(This post was last modified: 09-04-2008 09:27 AM by zmediaguru.)
09-04-2008 09:26 AM
Find all posts by this user Quote this message in a reply
FeG Offline
Banned

Posts: 222
Joined: Aug 2007
Post: #9
RE: Multi-Server ispCP!
This sounds very, very nice. Thank you for your great work!
09-04-2008 07:36 PM
Find all posts by this user Quote this message in a reply
DiXeoN Offline
Member
***

Posts: 284
Joined: Feb 2008
Reputation: 2
Post: #10
RE: Multi-Server ispCP!
Really niice!

I really cant wait for this to finish!
09-08-2008 05:34 PM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)