Kuberdock for private MySQL ?

[clm]

Hello,

We are currently looking into prividing private mysql/mariadb instances for our customers. Our needs will be :

1) Ability to automaticaly setup a docker mysql server for each customer, this server will be included in the hosting plan pricing
2) Ability to automate, updates, upgrades and backups
3) PHPMyAdmin access to each mysql instance
4) Automate DB user password changes

The current preconfigured apps go in the right direction, but still give users too many options. Our non sysadmin customers need an admin to create a database and user with password hiding all the complexity of Kubes and hourly invoicing.

Do you have any plans to make it this easy for non sysadmin users ? (IE replace cPanels interface with our own one ?)

We are currently looking into creating our own tool for adding new mysql servers with phpmyadmin instances etc. and would like to know if there is still a point of us doing this ourselves or if kuberdock will be the solution for this ?

Kuberdocks current approach is good for sysadmins but isnt good enough yet for a user that wants to have a simple WordPress.

Also I see no mention of backups. Each type of application will need different backup types so that its possible to restore in case of a disaster.

If its too close to using Docker, then Im worried that sysadmins might just take their own VPS and install docker themselves.

Thanks

[iseletsk]

This is something where we are driving. It might not happen right away, but in 3-6 months we should be there.

#1 should be possible with some post-account creation scripting
#2 automatic docker updates coming soon, though how automated do you want it to be? I am sure user doesn want it update in the middle of the day... so, when, how to decide. backups -> snapshots can be done with ceph, but once again, not ready
#3 This is easy/can be done today, via separate container or image that has both, still can be install/update under the same / similar schedule. Off course you can install phpmyadmin inside customers account, but that would be separate scripting
#4 Cronjob/script within account? Though it would need to change passwords for every script that uses that mysql as well.

And have you seen last version of predefined apps? We are removing more and more choices as we go, letting admin make those choices for the user.

[clm]

OK thanks for these answers.

Yes Ive seen the latest version which seems to make it much more usable for users with a small amount of sysadmin knowledge.

About CEPH snapshots, whe are not sure if ceph is the right storage for mysql.

For instance weve been debugging a customers WooCommerce site, when you click on the orders button, even with only 10 orders it does 400 mysql queries.

On our local MySQL server we can do these in 0.3 seconds, on a server thats 3ms away with local SSD storage it takes 1 second to run these queries.

Im thinking more of running MySQL on Raid 10 SSDs for shared hosting and running a backup every X hours so we could quickly restore data if there was an issue with a database. Maybe ceph isn that slow but it must add some latency.

[iseletsk]

Richard,

Yes, we need a bit more. We will be working on stabilizing what we have for the next 2 weeks, and tuning that simple pre-defined app interface. When I am done with it, no user input would be required to setup MySQL+PHP Admin.

Backups are an issue though. We are playing with ZFS which allows snapshots on local storage as well. That can be turned into solution for backups. Of Course you might want full blown backup solution instead.

[clm]

Weve see some suppliers move from ZFS snapshots for mysql to docker with mysqldump cron and sftp access to mysql backups for users.

Thanks to using private mysql instance and docker each website gets its own private mysql instance on a Raid 10 server with 12 or 36 SSDs.

I don think they use CEPH for mysql databases on shared hosting.