It would be useful to be able to:

  • create/drop dbs
  • create users with proper permissions

That should be sufficient for most use-cases, as application-specific code could take it up from there.

Original feature request:
It would be useful to be able to provision basic mysql dbs, be able to set/reset root passwords, etc.

Comments

steven jones’s picture

steven jones commented
Status: Active » Closed (won't fix)

I'm not sure we want to turn Aegir into a MySQL manager, so I'm marking as 'won't fix'. Please provide compelling reasons to re-open if you do :)

helmo’s picture

helmo commented

One use-case for creating empty databases would probably be: #1044678: alien platform support

I agree with @Steven Jones that handling root passwords work for a MySQL manager application.

ergonlogic’s picture

ergonlogic
he/him
Primary language English
Location Montréal, Québec 🇨🇦
commented
Title: Create empty MySQL databases » Create empty databases
Version: 6.x-0.4-alpha3 » 7.x-3.x-dev
Status: Closed (won't fix) » Postponed

I'm re-opening this, because as helmo mentioned #1044678: alien platform support would benefit from this. But marking 'postponed' since it shouldn't be a priority until after Aegir 2 is released.

'root' was a mistake. I updated the description to better reflect what could be useful here.

j0nathan’s picture

j0nathan commented

#2107349: obsolete databases housekeeping could be related to this feature request.

helmo’s picture

helmo commented
Title: Create empty databases » [meta] Manage databases as separate entities

Let's generalize the title here...

What would we need:
* a content type to represent a database
** name
** server ID
** optional: resource usage (x MB storage)
* a listing of databases (views integration)
* the current text field on a site node could become an entity reference
* separate provision task to create / verify(update) / delete
* refactor db code to match
* create a queue?
** possibly integrating #2072267: Change site database password?

Not sure if there is enough motivation (developer time) to get this done... but it sounds cool.

helmo’s picture

helmo commented
Issue summary: View changes

updating description