[kwlug-disc] I need Painfully simple load balancing.

[Fernando Duran]

Hi,

I replied in another email trying to make sense of "sqlite load balancing", but this (minecraft) is very different (you want to "load balance" the application).

As I understand minecraft is a Java app that stores user's progress on a file per user (I haven't installed a minecraft server and I'm not very familiar with it) and it can use sqlite or mysql for extra info. Surely other people had thought and implemented solutions specifically for minecraft but as a high level I see two options to "load balance" minecraft (the app, not the "database").

You can keep particular players and their worlds on specific servers and just add more servers for new players/new worlds. Basically user provisioning management (not load balancing). You'd need to write your own push or pull Linux script to identify when a server is "getting full" by translating that into specific RAM memory levels, response times etc, and/or using if possible a minecraft facility that tells you the number of users (being a Java app you are probably RAM-bound and memory is directly proportional to users). Then you can present the info in a web page so users know what server to use, this is more or less how it was done in other games I used to play some 10 years ago.


Another option is to separate the java app from the data files, having several minecraft app servers connected to a single data file (plus sqlite/mysql) server (using remote filesystem), this way users can use any minecraft server but I don't know how the network lag would affect the responsiveness for the gameplay.(You'd still need to write or find a polling script for app server utilization).

Cheers,

---------------------
Fernando Duran
http://www.fduran.com


>________________________________
> From: Chamunks Arkturus <chamunks at gmail.com>
>To: KWLUG discussion <kwlug-disc at kwlug.org> 
>Sent: Thursday, December 20, 2012 5:29:18 PM
>Subject: Re: [kwlug-disc] I need Painfully simple load balancing.
> 
>
>Its a cluster of minecraft gaming servers again.  Basically the port is 25565 and we are trying to occupy one server at a time but if load gets too full on one server send the players to a new node.  Then if the nodes are all getting packed too full let us know so that we can order more nodes brought online.
>
>
>
>On Thu, Dec 20, 2012 at 12:27 PM, Fernando Duran <liberosec at yahoo.ca> wrote:
>
>Not sure if this could help http://sqlrelay.sourceforge.net/about.html
>>
>>
>>
>>
>>---------------------
>>Fernando Duran
>>http://www.fduran.com
>>
>>
>>>________________________________
>>
>>> From: Chamunks Arkturus <chamunks at gmail.com>
>>>To: KWLug Discussion <kwlug-disc at kwlug.org>
>>>Sent: Thursday, December 20, 2012 6:19:33 AM
>>>Subject: [kwlug-disc] I need Painfully simple load balancing.
>>>
>>>
>>
>>>I need a load balancer that can react to queries from a sqlite database.  It basically needs to check a sql database for server capacity levels and if the capacity gets close to being reached send players to another server.
>>>
>>>
>>>Then it also needs to react to people wanting to directly move from target point to target point.
>>>
>>>
>>>is there something that could do this?
>>>
>>>
>>
>>>_______________________________________________
>>>kwlug-disc mailing list
>>>kwlug-disc at kwlug.org
>>>http://kwlug.org/mailman/listinfo/kwlug-disc_kwlug.org
>>>
>>>
>>> 
>>
>>_______________________________________________
>>kwlug-disc mailing list
>>kwlug-disc at kwlug.org
>>http://kwlug.org/mailman/listinfo/kwlug-disc_kwlug.org
>>
>
>_______________________________________________
>kwlug-disc mailing list
>kwlug-disc at kwlug.org
>http://kwlug.org/mailman/listinfo/kwlug-disc_kwlug.org
>
>
>