Jump to content

Writing a MySQL Database Deployment Module


Recommended Posts



I am working on a Server Provisioning module for our WHMCS system (and to distribute on the WHMCS forums) that will allow for us to easily deploy a MySQL Database install to a variety of locations. Currently our customers must request their Free MySQL Database, then our techs must manually set it up using a small web script we have written.


So far everything is looking great, but I have ran into one small issue. I have setup each one of our locations that we offer MySQL Databases as a separate Server in WHMCS. This has the root username/password for the MySQL Database and the IP of it, all of which are needed to create the database.


However, I would like to make the location a configurable option where the user can choose where to install it. I don't know how to tie the location in a Config Option with the corresponding Server entry in WHMCS though.


What would be the best way to do this?

Link to comment
Share on other sites

server groups for your locations, configurable options for selecting the locations, sadly there is currently no way around you needing to hook the data you need out of the form, hopefully this is a coming feature as more and more of us deploy a business model that covers many geographical locations as well as multiple clusters.


I think this is one of those features that if realised will really open up the flood gates to what we can do with whmcs.



I for one use this business model, the only way i have for this is to manually accept the orders for products that have multiple locations, i have ofcourse been thinking about database clusters, as well private mail servers, physical geo-located name servers and such, but without a costly development process this isnt going to be plausible in the near future for my business. Although, i think if there is a good call for it, then the cost can be offset quite quickly, so who knows.

Edited by disgruntled
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated