I need a MySQL database for MC plugins

[Thanh]

I am making a Minecraft server for people to build on and the plugin recommends having a MySQL database since it needs to store some player data. The company hosting my server doesn't even provide MySQL as an option and I talked to the owner, but the company isn't offering me MySQL. Since I got this server for free from them (I work as a support agent which is kinda funny) for them, I don't want to reject an offer for a free server. I have a MySQL installation which I could use, but since it's located in Canada and the server is in the U.K. I am afraid that there will be latency issues.

What I need is for someone who has a MySQL database in the U.K. to offer me a MySQL service so I could use it for plugins. And possibly offering this for free? I could possibly provide you some stuff I'm offering on our website (https://minegical.tk, just started on the project so it's pretty messy). I'm not gonna use the MySQL database for anything else besides for the Minecraft plugins and therefore, there won't be intense strains on your server.

I don't expect offers, but if you don't mind lending me a MySQL database than that would be much appreciated.

 

[abstraq]

Use flatfile.

 

[Aerial Servers]

If you purchase a small minecraft server you can get free web hosting and then use that and make a remote database.

 

[Blowns]

http://www.freemysqlhosting.net/

 

[Thanh]

http://www.freemysqlhosting.net/

Oh cool! Thank you very much the website.

 

[Aerial Servers]

Oh cool! Thank you very much the website.

That is only 5MB of storage by the way. You will use that in a heartbeat.

 

[Thanh]

That is only 5MB of storage by the way. You will use that in a heartbeat.

I saw that when creating the database, but I hope it's just enough just to start off with. I will definitely be looking for a much better solution once I need more.

 

[Wvisoecj]

You don't need to worry about latency issues? Assuming the plugin is updating the database every 15 minutes, and it isn't crucial that you have to have up to date information you'll be fine. JDBC requires async calls to your database and is built over TCP so you're not going to lose any information. I don't see why you need low latency for a database.

 

[FTSOwner]

If you purchase a small minecraft server you can get free web hosting and then use that and make a remote database.

It seem a like a "smart idea" but I bet you some companies don't let their customers do this act according to AUP.

Fadehost is an example that explicitly state that the website must be related to the rental AND that it cannot be used as a remote DB.

 

[Thanh]

You don't need to worry about latency issues? Assuming the plugin is updating the database every 15 minutes, and it isn't crucial that you have to have up to date information you'll be fine. JDBC requires async calls to your database and is built over TCP so you're not going to lose any information. I don't see why you need low latency for a database.

Never knew that. Thank you for the heads up.

 

[Wvisoecj]

Use flatfile.

I didn't mean to mark your post as funny! Thanh does the plugin not support flatfile or SQLite storage?

 

[Thanh]

I didn't mean to mark your post as funny! Thanh does the plugin not support flatfile or SQLite storage?

Not sure about flatfile and never heard about it until abstraq mentioned it. SQLite probably works as well, but I don't have a SQLite database.

 

[Wvisoecj]

Not sure about flatfile and never heard about it until abstraq mentioned it. SQLite probably works as well, but I don't have a SQLite database.

SQLite is served on your server. If you switch your plugin to use SQLite it'll work fine. SQLite is basically a MySQL database in a file on your server.

Will have lower latency too

 

[Thanh]

SQLite is served on your server. If you switch your plugin to use SQLite it'll work fine. SQLite is basically a MySQL database in a file on your server.

Will have lower latency too

Oh cool! I could use that then. Thank you.