AMP icon indicating copy to clipboard operation
AMP copied to clipboard

Feature Request: MySQL integration

Open Lostepic opened this issue 5 years ago • 16 comments

It would be great to MySQL integrated so that you could connect amp to mysql and then have amp creat users a database like how another popular MC panel does.

A lot of game server can use mysql databases for plugins etc so thought it would be good :)

Lostepic avatar Jan 30 '20 07:01 Lostepic

I second this! I'm currently using the standard MySQL software but agree this would be super convenient to include it as a feature of AMP. A one stop shop for all server needs. Seems to be the direction AMP is going for. A MySQL option would be a fantastic addition.

hellot1m avatar Jan 30 '20 18:01 hellot1m

This largely depends on what kind of integration is needed. Something that can straight up databases and table schemas would be too much work to be viable. If it just needs to be be able to create a blank database with a set of login details then that's possible.

PhonicUK avatar Jan 30 '20 18:01 PhonicUK

I mean as the other panel does all it needs is the following,

To create a database and a user as well have show these in the panel, also a link to phpmyadmin install.

This could be done with just a option under an instance that we can select press create database and in return we are given the user, pass and link to phpmyadmin.

I suppose we could have this in 2 ways, the first could be a simple settings page that allows us to input MySQL details of a user that can create delete and modify users as needed and an input box for phpmyadmin.

The other would have it all built into the installer so that along with amp, everything will be installed however as this is a feature not everyone will use I believe that it will be better to do the latter and have just a how to on installing MySQL and phpmyadmin etc, hope this helps

Lostepic avatar Jan 30 '20 19:01 Lostepic

This largely depends on what kind of integration is needed. Something that can straight up databases and table schemas would be too much work to be viable. If it just needs to be be able to create a blank database with a set of login details then that's possible.

That would plenty. Most of what MySQL is used for with gaming is very basic. Most of the other features aren't really needed.

hellot1m avatar Jan 30 '20 19:01 hellot1m

What would the database be used for. Any server info or something because currently ark doesnt utilize db though maybe other supported games do idk

MjolnirMouse avatar Feb 07 '20 08:02 MjolnirMouse

Some Minecraft plugins support using MySQL to store data.

PhonicUK avatar Feb 07 '20 08:02 PhonicUK

Why has this not been added yet? Pterodactyl does this and it is free

funnycubeguy avatar Apr 02 '24 01:04 funnycubeguy

Priorities mainly. It's in the plans but takes time to get right.

IceOfWraith avatar Apr 02 '24 02:04 IceOfWraith

It's more that there needs to be a general purpose 'service instance' system for stuff that isn't an actual application. Ptero is just a docker frontend so it doesn't care (or know) what's running in those containers. AMP is more sophisticated and needs more information about what the containers are doing.

It does mean that AMPs implementation of this will also be limited to running these kinds of services in Docker containers too rather than try and make them work the way AMP does for the actual applications.

PhonicUK avatar Apr 15 '24 12:04 PhonicUK