Kuberdock for private MySQL ?
Forum
  1. Forums
  2. General
  3. General Discussion
  1. Richard Hordern
  2. Tuesday, 27 October 2015
  3.  Subscribe via email
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 cPanel's 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 ?

Kuberdock's current approach is good for sysadmins but isn't good enough yet for a user that want's to have a simple WordPress.

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

If it's too close to using Docker, then I'm worried that sysadmins might just take their own VPS and install docker themselves.

Thanks ;)
Rate this post:
  1. 27.10.2015 14:10:10
  2. # 1
Igor Seletskiy Accepted Answer
Posts: 1200
Joined: 09.02.2010
0
Votes
Undo
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\'t 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 customer\'s 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.
  1. 27.10.2015 14:10:33
  2. # 2
Richard Hordern Accepted Answer
Posts: 219
Joined: 19.03.2011
0
Votes
Undo
OK thanks for these answers.

Yes I\'ve 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 we\'ve been debugging a customer\'s 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.

I\'m thinking more of running MySQL on Raid 10 SSD\'s 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\'t that slow but it must add some latency.
  1. 27.10.2015 15:10:03
  2. # 3
Igor Seletskiy Accepted Answer
Posts: 1200
Joined: 09.02.2010
0
Votes
Undo
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.
  1. 28.10.2015 15:10:44
  2. # 4
Richard Hordern Accepted Answer
Posts: 219
Joined: 19.03.2011
0
Votes
Undo
We\'ve 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 it\'s own private mysql instance on a Raid 10 server with 12 or 36 SSD\'s.

I don\'t think they use CEPH for mysql databases on shared hosting.
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!
Guest
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.