SpigotMC
spigotmc.org › threads › what-exactly-is-mysql.22388
What Exactly Is MySQL? | SpigotMC - High Performance Minecraft Software
June 30, 2014 - Can someone explain to me (in the most noobiest terms) what MySQL is? I know it's a database, that's about it. I get to use it with my server host but...
Fandom
mcserverguide.fandom.com › wiki › MySQL_Databases_Explained
MySQL Databases Explained | The Minecraft Server Guide Wiki | Fandom
If you only use MySQL databases for data that is optional to backup (such as CoreProtect or world mapping plugins) then you don't need to create MySQL database backups. If you decide to switch Minecraft hosts you'll need to learn how to backup your MySQL database to your computer then upload it to your new MC host's MySQL database (if you need the data on your new MC host).
Do you use MySQL?
Yes, PEX, and a dozen custom plugins. After 8 years of using mysql, 3 of which in minecraft plugins. I start to understand more, that in many cases it's better to use flatfiles. There are pros and cons to each. If your plugin simply just has player information to store (like money), flatfile is faster, This is because you are telling the computer EXACTLY where to look for the information. Where as if you have an SQL database, it's much slower for such a simple query. SQL however has an API that can be used in just about any application, like websites. Also if you need to order data (For instance display player with highest money) SQL is significantly faster. In both cases however, they can be run off the main minecraft thread in a background task. So neither if used properly would cause lag on a minecraft servers. Though I'm sure 50% of the time it's not used properly. My only concern with sql is how slow it is. I've a fully optimized database/server using 10 gigs/ram, and the queries can never keep up during peak hours. It's very difficult to master SQL More on reddit.com
16
2
October 20, 2014What is Minecraft's database? - Game Development Stack Exchange
I was wondering, what kind of database does Minecraft use? Is it a relational database, maybe something common like MySQL? Do we even know what he's using? And maybe even a better question, SHOUL... More on gamedev.stackexchange.com
What can databases be used for?
Thanks for being a part of | r/Admincraft | ! | We'd love it if you also joined us on Discord! Join thousands of other Minecraft administrators for real-time discussion of all things related to running a quality server. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns. More on reddit.com
16
2
July 5, 2022should i use mysql for my server?
You don't need a database to run a Minecraft Server. More on reddit.com
7
3
July 5, 2022Videos
Setup A MySQL Database For Your Minecraft Server (Tutorial)
02:39
How to create a MySQL database for your Minecraft server - YouTube
00:37
MySQL Databases Overview at Apex Minecraft Hosting - YouTube
02:37
How To Setup A MySQL Database For Minecraft Server - YouTube
40:13
Ep69. MySQL & SQLite Databases (Full Guide) - Minecraft Plugin ...
Minecraft Forum
minecraftforum.net › home › minecraft forum › support › server support and administration › what is mysql?
What is MySQL? - Server Support and Administration - Support - Minecraft Forum - Minecraft Forum
June 8, 2012 - This will be used to store large amounts of information such as Logblock/Hawkeye logging, Hunger Game plugins, and many other plugins that REQUIRE a database. Though, you might not need it now, for only two extra dollars you will be covered just in case you end up needing to use a MySQL.
GGServers
help.ggservers.com › en-us › article › what-is-a-mysql-database-and-what-is-it-used-for-9l5sep
What Is a MySQL Database and What Is It Used For? | GGServers Old Helpdesk
October 6, 2022 - MySQL is one of the most popular database systems, widely used in applications, websites, and Minecraft plugins and mods.
Shockbyte
shockbyte.com › help › knowledgebase › articles › how-to-use-a-mysql-database-on-your-minecraft-server
How to Use a MySQL Database on Your Minecraft Server | Shockbyte
September 11, 2024 - MySQL Databases are one of the many ways to store server data, commonly available for plugins. Your Shockbyte server comes with a free MySQL database that can be used to store new or existing data.
Madelinemiller
madelinemiller.dev › maddy miller › posts › minecraft › should you use mysql with a minecraft plugin? | minecraft
Should you use MySQL with a Minecraft plugin? | Minecraft
September 16, 2021 - While configuring a plugin, you'll ... of an external database such as MySQL is to offload data fetching, allowing high-speed access to small sections of a large amount of data....
Reddit
reddit.com › r/admincraft › do you use mysql?
r/admincraft on Reddit: Do you use MySQL?
October 20, 2014 -
How do use it? (Edit files, add files, ect.) What do you use it for? (PEX, Ontime, mcMMO)
Edit: How can I access the files? What do I download?
Top answer 1 of 3
7
Yes, PEX, and a dozen custom plugins. After 8 years of using mysql, 3 of which in minecraft plugins. I start to understand more, that in many cases it's better to use flatfiles. There are pros and cons to each. If your plugin simply just has player information to store (like money), flatfile is faster, This is because you are telling the computer EXACTLY where to look for the information. Where as if you have an SQL database, it's much slower for such a simple query. SQL however has an API that can be used in just about any application, like websites. Also if you need to order data (For instance display player with highest money) SQL is significantly faster. In both cases however, they can be run off the main minecraft thread in a background task. So neither if used properly would cause lag on a minecraft servers. Though I'm sure 50% of the time it's not used properly. My only concern with sql is how slow it is. I've a fully optimized database/server using 10 gigs/ram, and the queries can never keep up during peak hours. It's very difficult to master SQL
2 of 3
1
Yes, the server I work with uses MySQL. We use it currently just for LogBlock & BeardStat. We do have PEX on the server, but running it using FlatFiles as our server population is not unwieldy (less than 2,000 total players) and so the FlatFile is big, but maneable. As for your other questions, MySQL doesn't work the same as operating with FlatFiles. You don't just "add files" to the server, or just open files and edit them. MySQL is a Relational Database Management System (RDBMS) and you interact with it very differently than FlatFiles. With FlatFiles, you just open up NotePad or whatever and edit the text. With MySQL, you connect to the database and run queries which will Read and update Tables. This may sound foreign, and frankly it is quite a bit different from operating using FlatFiles. You might spend some time researching what an RDBMS and then learn a little about querying one ( http://www.w3schools.com/SQl/default.asp ) if you want to get good with it. Most plugins authors that utilize MySql don't expect you to have to connect directly to the database to modify configuration. Most should have in-game commands for doing most everything that you should need to do. If you go read up about writing SQL queries, you'll see its more advanced than just tweaking a flat file. At any rate, should you want to target your database directly, the program that I use for connecting to our database is "SQLyog Community Edition". There's tons out there that can connect to MySQL databases, that's just the one I use. As for the conversations below about speed, its all going to be dependent on more factors than just "Files are Slow" or "Databases are Slow". Databases are designed to operate on large amounts of relational data. Our LogBlock database, for instance, has an entry for every single block that is modified on the server. Imagine for a moment a flat file that contained all this information. The file would get so large that working with it would be unwieldy. With a database like MySQL, operations that allow this are not only possible, but quite fast, IMHO. There's loads more that goes into tuning, optimizing databases, much of which is the responsibility of plugin developer.
SimpleGameHosting
help.simplegamehosting.com › how-to-use-a-mysql-database-with-your-minecraft-server
How To Use a MySQL Database with Your Minecraft Server | SimpleGameHosting Help Center
Using a MySQL server with a Minecraft server can be a great way to quickly and efficiently store large amounts of data. It can also be very useful in transferring and syncing data between multiple servers.
Nodecraft
nodecraft.com › support › minecraft › setup › how to add a mysql database to your minecraft server
How to Add a MySQL Database to Your Minecraft Server | Setup | Knowledgebase Article - Nodecraft
June 27, 2025 - MySQL databases are a great and efficient way to store and access data, typically from various plugins. Databases are also useful in server networks to sync information such as players ranks or any in-game currency.
ServerMiner
serverminer.com › article › how-to-create-and-use-a-mysql-database
How to create and use a MySQL Database for your Minecraft Server
January 27, 2021 - Follow these simple steps to create and use a MySQL Database for your Minecraft Server. First, login to the SMpicnic Control Panel and navigate to your Server Manager page. Click on the Database tab. ... Finished! Your Database has now been created. You can then copy the database information to the plugin configuration file.
YouTube
youtube.com › watch
How to make a local MYSQL database for Minecraft! (Free) - YouTube
Follow me on Twitter to talk to me! ► https://twitter.com/EasyRoast This is an easy way to create a mysql database for any Minecraft plugin!Xampp Download Li...
Published May 25, 2013
Apex Hosting
apexminecrafthosting.com › how-to-add-a-mysql-database-to-your-minecraft-server
How To Add a MySQL Database To Your Minecraft Server - Apex Hosting
December 6, 2021 - Discover how to set up a database for your Minecraft hosting account. Some plugins require that a MySQL connection is established to store the data.
Sparked Host
help.sparkedhost.com › en › article › how-to-setup-a-mysql-database-for-minecraft-server-71ssz1
How to Setup a MySQL Database for Minecraft Server | Sparked Host Knowledge Base
The disk space on your host might be limited. This ensures that you aren't using too much precious host disk space by putting that somewhere else more manageable. MySQL is an open-source database management system. It's commonly used by many Minecraft plugins and mods to store data in.
Shockbyte
shockbyte.com › billing › knowledgebase › 104
How to Use a MySQL Database on Your Minecraft Server - Knowledgebase - Shockbyte
Once you've created a MySQL database, to use it you simply need to provide your database information on the configuration file of a plugin that supports storing of data into a MySQL database. Generally, the information required are the host, username, password, and the name of the database. Note: The example below assumes your server is running Bukkit or Spigot.
Reddit
reddit.com › r/admincraft › what can databases be used for?
r/admincraft on Reddit: What can databases be used for?
July 5, 2022 -
I've heard of people using databases for plugins and other things but never really understood the point. Could someone explain the different things you can do with databases.
Top answer 1 of 7
5
Databases are mathematically extremely efficient at storing, retrieving and sharing data access, when coupled with a programming Language it can also rapidly manipulate data as well. here are some very basic examples, database's are a world of their own as much as assembly language or Artificial Intelligence Store) you can save a lot of space (flat data vs related data) Share) It could allow you to send data across plugins or servers on the same machine or a different one. Retrieve) Pull specific data reports, get the exact amount of users that joined on a saturday and voted within an hour. manipulate) add 12.15% to everyone's balance if their balance is less than $10,000.
2 of 7
3
mostly depends on the database but its faster/better/easier for saving big amounts of data
Reddit
reddit.com › r/mysql › should i use mysql for my server?
r/mysql on Reddit: should i use mysql for my server?
July 5, 2022 -
so long story short, my friends and i are trying to start a minecraft server for us to play on together, and we decided to use a third-party hosting site. im creating the server right now, and it gave me the option to include mysql for free.
i've been trying to do research to figure out if it's right for us. i know it's free, but i dont really want to bother including it if we won't need it. we don't plan on using mods or anything, just a group of ~20 people playing vanilla 1.19. if anyone could help i would really appreciate it! :)
SpigotMC
spigotmc.org › wiki › bbcode.1786 › archive
MySQL Storage System | SpigotMC - High Performance Minecraft Software
The Claims table is used to store world data, Such as what chunks are owned by which clans. As well as in what world the chunks are claimed. MySQL Storage System | Configuration: As you may well know by now, The connection settings for connecting to your MySQL Database are available in the ...
SpigotMC
spigotmc.org › wiki › connecting-to-databases-mysql
Connecting to databases - MySQL | SpigotMC - High Performance Minecraft Software
February 9, 2025 - Want a better Minecraft server? Read about SpigotMC here! ... Introduction / What can I expect. Databases are often crucial when it comes to storing data. This tutorial aims to get you ready to store your data in your MariaDB or MySQL database. We will start with some general preconditions we need to clarify and make some preparations.
Nodecraft
nodecraft.com › support › control panel › basic mysql tutorial
Basic MySQL Tutorial | Control Panel | Knowledgebase Article - Nodecraft
March 14, 2022 - MySQL is a relational database that is optimized for quick CRUD operations (Create, Read, Update, Delete). MySQL servers use SQL (Structured Query Language) to request data and write changes to the database.