MYSQL Problems with 2 servers running?

General discussion about Life is Feudal MMO and Life is Feudal: Your Own, The main section and backbone of the forums.
User avatar
Vagabonden
 
Posts: 30
Joined: 24 Sep 2014, 12:20

MYSQL Problems with 2 servers running?

Post by Vagabonden » 28 Sep 2014, 19:13

Hey, im trying to setup a new server. So i can have 2 running.

Only problem is, it keeps going to seach for database Lif_1 when i startup the server? how do i change it to look for the database i have created? i allready changed my.ini but didnt seems to work? :O (it was innodb) before i changed it..

Anyone knows?

User avatar
Vagabonden
 
Posts: 30
Joined: 24 Sep 2014, 12:20

Re: MYSQL Problems with 2 servers running?

Post by Vagabonden » 29 Sep 2014, 08:54

Anyone knows? :D

I want to have a pve and pvp server running on the same time :(!
Should be easy enough :)

User avatar
Vagabonden
 
Posts: 30
Joined: 24 Sep 2014, 12:20

Re: MYSQL Problems with 2 servers running?

Post by Vagabonden » 29 Sep 2014, 20:13

No one knows how to setup 2 servers In one database?


MH6
 
Posts: 29
Joined: 22 Sep 2014, 14:59

Re: MYSQL Problems with 2 servers running?

Post by MH6 » 29 Sep 2014, 20:53

Not sure off-hand, but is your second server using world_2.xml? I'd assume that would make it point at lif_2 instead of lif_1. So pass -worldID 2 as a command line param to your second server.


Spazfokel
 
Posts: 12
Joined: 24 Sep 2014, 15:09
Location: Germany

Re: MYSQL Problems with 2 servers running?

Post by Spazfokel » 29 Sep 2014, 22:26

what MH6 said, plus make sure to use a different port. It seems it will not generate a new database if the port is the same. So if you use for example 28000 for world 1, use 29000 for world 2 (dont forget to open that port +2)

Edit: I see that in the tutorials available it is stated to use param "-world 1", which isnt exactly correct. It should be "-worldID 1", "-worldID 2" etc....

"-world 1" only picks the default, i.e. ID1


GrimmLiberty
 
Posts: 66
Joined: 20 Sep 2014, 14:13

Re: MYSQL Problems with 2 servers running?

Post by GrimmLiberty » 30 Sep 2014, 02:36

yuppers,

World_2.xml is needed and the second server Port MUST be at least 3 higher than the first server.

Make a batch file using "start ddctd_cm_yo_server.exe -worldID 2"

LiF_2 database needs to be created, using the same steps you followed for your first one, including not just new.sql but also update.sql


You will also need roughly 10gb of memory totally free and available, between sql and the two exe usages.

I might also suggest bumping this up in(or adding it to) you my.ini file in your Mariadb\data folder....
innodb_buffer_pool_size=1024M

AND in system performance options for your OS, under Advanced, changing you system to Allocate for background services.


Spazfokel
 
Posts: 12
Joined: 24 Sep 2014, 15:09
Location: Germany

Re: MYSQL Problems with 2 servers running?

Post by Spazfokel » 30 Sep 2014, 09:56

GrimmLiberty wrote:I might also suggest bumping this up in(or adding it to) you my.ini file in your Mariadb\data folder....
innodb_buffer_pool_size=1024M


I assume here, the more the merrier? My setting is 1,5gb for 2 dbs, which should be enough at 10mb max packet size. Any input?


GrimmLiberty
 
Posts: 66
Joined: 20 Sep 2014, 14:13

Re: MYSQL Problems with 2 servers running?

Post by GrimmLiberty » 30 Sep 2014, 12:32

Spazfokel wrote:
GrimmLiberty wrote:I might also suggest bumping this up in(or adding it to) you my.ini file in your Mariadb\data folder....
innodb_buffer_pool_size=1024M


I assume here, the more the merrier? My setting is 1,5gb for 2 dbs, which should be enough at 10mb max packet size. Any input?


Yuppers, that works fine. The 10mb pack size is the game's db limiter, so you really don't need more than 2gb even if you were running 5 or 6 servers...

Generally 'the more the merrier' works... However, anything over 4gb on this setting is overkill and a waste of resources for something this small scale.

User avatar
Vagabonden
 
Posts: 30
Joined: 24 Sep 2014, 12:20

Re: MYSQL Problems with 2 servers running?

Post by Vagabonden » 30 Sep 2014, 12:36

I have port 26000-26010 which i use for world_2 now and i have 28010-28015 for backup..

But even when i did the mysql.
It gives me the error:

ECHO 2014-09-30 14:33:54.905 {02} <initServer> Loading CmConfiguration
ECHO 2014-09-30 14:33:54.905 {02} <initServer> Init of DB interface
WARN 2014-09-30 14:33:54.919 {02} <initServer> CmServerInfoManager::loadLocalWorldsList() - world# 1 already registered. Skip config/world_2.xml
ERRR 2014-09-30 14:33:54.919 {02} <initServer> CmServerInfoManager::processLocalWorlds() - local world not found (id=2)
ERRR 2014-09-30 14:33:54.935 {02} <initServer> Fatal: Can't init local world (id=2). Terminating.
ECHO 2014-09-30 14:33:54.935 {00} <NOSCOPE> Engine initialized...
core/scripts/server/server.cs (77): Unable to find function destroyWorld

The server has 64gb ram and 1gb internet + ssd so hardware should not be a problem for my.. The only thing that is running on the hole server right now is 1 LIF yo server...

i can easy create a new VM and just setup a new server. But i want to see if i can have them all running on 1 VM:)

Found the issue :D!
ID insite the world_2 was set to 1:)

There we go! 4 servers up and running now:) Thanks guys!!!:) much appreciated :) !


GrimmLiberty
 
Posts: 66
Joined: 20 Sep 2014, 14:13

Re: MYSQL Problems with 2 servers running?

Post by GrimmLiberty » 30 Sep 2014, 13:21

Glad to be of service. And I hope your servers end up full of good players. It can be a lot of work being an Admin with more than one server... lol

User avatar
Vagabonden
 
Posts: 30
Joined: 24 Sep 2014, 12:20

Re: MYSQL Problems with 2 servers running?

Post by Vagabonden » 30 Sep 2014, 13:30

GrimmLiberty wrote:Glad to be of service. And I hope your servers end up full of good players. It can be a lot of work being an Admin with more than one server... lol


its a danish community i have running, so its RP,PVP,PVE and just a test server :)

My first one has about 1-20 players in each day so its abit different from time to time :) Maeby i make a Scandinavian server too :)

Return to General Discussion