Advantages of using mySQL databases for plugins?

Discussion in 'Bukkit Help' started by ukballer1012, Aug 8, 2012.

Thread Status:
Not open for further replies.
  1. Offline


    I have plenty of experience administrating my centos server and with bukkit, but I've never had to use a mySQL database for a plugin, except logblock. I know how to set them up, as I also have experience administrating web servers but are there any advantages of using them with plugins? Obviously organization would be a big plus but what are all the other advantages of using them with plugins (performance, storage, etc)?
  2. Offline


    MySQL is there to save you power for your server by letting something else hold and manage resource intensive information.
  3. Offline


    Significantly? And what would you classify as resource intensive information?
  4. Offline


    Logging lots of block changes made by many users, constantly over days, weeks, months or even years.
  5. Offline


    And for my plugin playerlogger it's good for logging lots of changes such as chat commands block breaks kills effeciently.
    Also you can do cool stuff such as using logblock using mcmmo using a simple plugin I made using chestshop using votefier

    All of those pages access the MySQL database, and is super fast. To search through like 1 million rows in MySQL takes like half a second (correct me if I'm wrong)

    For those pages our web server just had a rollback to a few weeks before but when I get to my computer I'll readd them and tag you.

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
    Last edited by a moderator: May 27, 2016
  6. Offline


    its also easy to backup, edit and make web-stats out of the databases
  7. Offline


    Speed, stability, and security.
Thread Status:
Not open for further replies.

Share This Page