Page 1 of 1
2 comps 1 server
Posted: Sat Apr 08, 2006 5:00 am
by Feldan
Ok have split server on too 2 different computers. DB and login on 1 and gameserver on another. Ther are literally a foot away from eachother connected with a hub.
Login server runs fine but where do i change info to make gameserver connect to new DB server? Where to enter IP in config?
Posted: Sat Apr 08, 2006 4:14 pm
by mastermind007
Look in the server.properties file for the for to following section.
Code: Select all
# Database info
Driver=com.mysql.jdbc.Driver
#Driver=org.hsqldb.jdbcDriver
#Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
URL=jdbc:mysql://localhost/l2jdb
#URL=jdbc:hsqldb:hsql://localhost/l2jdb
#URL=jdbc:sqlserver://localhost/database=l2jdb/user=sa/password=
Login=root
Password=
MaximumDbConnections=10
Remove the word
localhost and enter the IP address of the server with the DB fir whichever connection string you are using.
EXAMPLE URL=jdbc:mysql://
192.168.1.100/l2jdb
Remember to give the game server root access to the DB on the login server or will will get an error.
Posted: Sat Apr 08, 2006 7:31 pm
by Feldan
Thanks mastermind
Posted: Tue Apr 11, 2006 2:21 pm
by Fulminus
I just wonder why would you like to do this?! Gameserver has the highest load...each time a person's inventory changes, each time a person is attacked, each time he moves (well...almost...with some cache-ing) the gameserver has to write to the database. Why would you want to make that any heavier than it already is, by getting it to write across the network?! I mean, even if they are 1foot away and even if you used 1mbps ethernets...it's still more than going from the PC's memory down the bus and onto the HDD...
If anything, the gameserver should have the database locally and the loginserver should go remotely!
Well, I just had to say that. You do as you wish