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

    ukballer1012

    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

    Snear

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

    ukballer1012

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

    Xmillsa

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

    McLuke500

    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
    http://pr3datorcraft.com/gametime.php using logblock
    http://pr3datorcraft.com/mcmmo.php using mcmmo
    http://pr3datorcraft.com/kdratio.php using a simple plugin I made
    http://pr3datorcraft.com/chestshop.php using chestshop
    http://pr3datorcraft.com/vote.php 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

    strontkever

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

    Sushi

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

Share This Page