Search Unity

  1. Welcome to the Unity Forums! Please take the time to read our Code of Conduct to familiarize yourself with the forum rules and how to post constructively.
  2. We have updated the language to the Editor Terms based on feedback from our employees and community. Learn more.
    Dismiss Notice
  3. Join us on November 16th, 2023, between 1 pm and 9 pm CET for Ask the Experts Online on Discord and on Unity Discussions.
    Dismiss Notice
New Forum User Notice Update to the Unity Editor Software Terms Unite 2023 - Ask the Experts Online

Database for MMO?

Discussion in 'Multiplayer' started by jaekx, Oct 19, 2015.

  1. jaekx

    jaekx

    Joined:
    Dec 15, 2014
    Posts:
    27
    What is the best database to use for an mmo? Is XML acceptable? I see a lot of people suggest SQL, but im quite new to SQL.. Just wondering if SQL is significantly better and worth learning in depth. (I know SQL is worth learning at some point - my question is should i start learning NOW because SQL really is the best for mmos... Or can I use XML and be fine.) Thanks for the replies! :D

    -jaek
     
    jaekx, Oct 19, 2015
    #1

  2. Que

    Que

    Joined:
    Mar 14, 2014
    Posts:
    135
    Great question.
    I would like to know it too.

    Thanks in advance.
     
    Que, Oct 19, 2015
    #2

  3. Whippets

    Whippets

    Joined:
    Feb 28, 2013
    Posts:
    1,775
    I use a MySQL database hosted remotely along with the game servers. SQL language isn't hard to learn, and front-ends like heidiSQL make life much easier.

    It takes time to read and interpret an XML text file, make changes and save it, as it does to connect to a remote database, issue commands, and get responses. How much data you need to store, how often that data needs accessing, what other systems need to access that data, and overal extensibility are things to take into account.
     
    Whippets, Oct 19, 2015
    #3
    BackwoodsGaming likes this.

  4. seanr

    seanr

    Unity Technologies

    Joined:
    Sep 22, 2014
    Posts:
    669
    seanr, Oct 19, 2015
    #4
    Katie-GameSparks likes this.

  5. MMOInteractiveRep

    MMOInteractiveRep

    Joined:
    Apr 7, 2015
    Posts:
    88
    Really it depends on what your goals are. If your doing a Lobby based game where Players are able to host their own servers you prob. want to go with XML or a text based no-sql solution as players will want to get the server running with the least amount of steps required...

    Something like these:
    http://www.iboxdb.com/
    https://www.assetstore.unity3d.com/en/#!/content/7383

    However if your doing an actual MMO where you host the servers and you have the servers spread out across multiple Physical Servers in a cluster that all need access to the Database I would recommend mySQL or postgresql.
     
    MMOInteractiveRep, Oct 20, 2015
    #5

  6. Katie-GameSparks

    Katie-GameSparks

    Joined:
    Oct 2, 2015
    Posts:
    13
    Hi
    Katie from gamesparks here.
    Gamesparks provides database's for games. We use mongoDB.
    It is easy to learn, we have a nosql interface that you can use to manage and edit database's.
    Check out www.gamesparks.com if you're interested
    Thanks
    Katie
     
    Katie-GameSparks, Oct 22, 2015
    #6
    jaekx likes this.

  7. jaekx

    jaekx

    Joined:
    Dec 15, 2014
    Posts:
    27
    Awesome I will definitely be checking this out, its optimized enough to support a small scale mmo and possible growth?
     
    jaekx, Oct 22, 2015
    #7

  8. Katie-GameSparks

    Katie-GameSparks

    Joined:
    Oct 2, 2015
    Posts:
    13
    Hi @jaekx using cloud based services like gamesparks mean that scalability is not an issue. Many games big and small already run on Gamesparks successfully.
    Thanks
    Katie
     
    Katie-GameSparks, Oct 22, 2015
    #8