Assigning Databases by API
Posted: March 20th, 2023, 6:40 am
Hello,
We are currently trailing JetBackup. The product seems to do everything we want except one thing. We would like to be able to assign mysql databases to users via an API.
We currently use a shared hosting management platform called ServerPilot. This is how databases are associated with users. We can query ServerPilot to find out the names of any mysql databases associated with a given user.
Manually assigning databases using the 'Manage Databases' plugin isn't really suitable, and using the automatic mode and then manually renaming all the database to username_<db> isn't really suitable either. We have a number of shared hosting machines running Ubuntu and it would be quite time consuming and error prone to do this by hand.
Using a hook script to mysqldump each users databases into their home directories before the backup task would work but it would also consume a lot of disk space, so we'd rather not do that.
We have a capable PHP programmer here, so we could also write our own plugin, unfortunately we can't seem to find any useful documentation on doing that, and the Manage Databases plugin is DRMed with Ioncube.
Another idea we had was could we provide the database information to JetBackup in a format that mimics cpanel somehow? Do your engineers have any idea about doing this?
The bottom line is the product is great and suits our needs but we need to integrate it with our existing multi user management system for it to be useful.
Kind regards,
We are currently trailing JetBackup. The product seems to do everything we want except one thing. We would like to be able to assign mysql databases to users via an API.
We currently use a shared hosting management platform called ServerPilot. This is how databases are associated with users. We can query ServerPilot to find out the names of any mysql databases associated with a given user.
Manually assigning databases using the 'Manage Databases' plugin isn't really suitable, and using the automatic mode and then manually renaming all the database to username_<db> isn't really suitable either. We have a number of shared hosting machines running Ubuntu and it would be quite time consuming and error prone to do this by hand.
Using a hook script to mysqldump each users databases into their home directories before the backup task would work but it would also consume a lot of disk space, so we'd rather not do that.
We have a capable PHP programmer here, so we could also write our own plugin, unfortunately we can't seem to find any useful documentation on doing that, and the Manage Databases plugin is DRMed with Ioncube.
Another idea we had was could we provide the database information to JetBackup in a format that mimics cpanel somehow? Do your engineers have any idea about doing this?
The bottom line is the product is great and suits our needs but we need to integrate it with our existing multi user management system for it to be useful.
Kind regards,