Page 1 of 1
mysql in another hardware [solved]
Posted: Mon Jan 10, 2011 10:59 pm
by Flaguz
If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision
Number:
L2JDP Revision
Number:
hy guys sorry for bad english . I searched the forum but no discussion has been helpful to me. how to set the server to have the mysql database to another machine? example: login and game, server 1 mysql : server 2 how i can connect ? p.s in case of wrong section move the topic . thanx all for help
Re: mysql in another hardware
Posted: Mon Jan 10, 2011 11:13 pm
by blacksea
Flaguz wrote:If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision
Number:
L2JDP Revision
Number:
hy guys sorry for bad english . I searched the forum but no discussion has been helpful to me. how to set the server to have the mysql database to another machine? example: login and game, server 1 mysql : server 2 how i can connect ? p.s in case of wrong section move the topic . thanx all for help
you can change in configs URL = jdbc:mysql://mysqlserverip/l2jdb
server.properties
loginserver.properties
Re: mysql in another hardware
Posted: Mon Jan 10, 2011 11:17 pm
by Flaguz
ok work perfect another little question i can add core buffer in nightly pack?
Re: mysql in another hardware
Posted: Mon Jan 10, 2011 11:30 pm
by momo61
Flaguz wrote:ok work perfect another little question i can add core buffer in nightly pack?
Yes, the nightlies pack have the original l2j core buffer. Try to type //spawn sheila or shiela
Re: mysql in another hardware
Posted: Mon Jan 10, 2011 11:49 pm
by Flaguz
i have tryed rin4oa buffer but in my limited harware is very slow . i can edit shiela ?
my hardare
vps
win 2000 32bit
3gbram
160 gb hd ssd
server load in 270-280 sec
Re: mysql in another hardware
Posted: Tue Jan 11, 2011 12:15 am
by momo61
Flaguz wrote:i have tryed rin4oa buffer but in my limited harware is very slow . i can edit shiela ?
my hardare
vps
win 2000 32bit
3gbram
160 gb hd ssd
server load in 270-280 sec
Yes, but its limited to how much you can edit... go to html/mods and edit the htmls there. Go to navicat and edit the custom_npcbuffer table to add/remove buffs and set prices etc.
And dont use a VPS for an l2jserver
Re: mysql in another hardware [solved]
Posted: Tue Jan 11, 2011 12:57 pm
by Flaguz
ty for help momo
but tonight i moved sql server in another server (dual xenon 12 gb ram dedicated o.s windows server 2008r2) im using win2k in login and game server because windows xp in hyper-v don't respawn mob and start in 1456 sec (gs) p.s with rhis hardware have 65 player connected without lag during attak or pvp only during class change and buffer scheme creation
little edit : im using vps because server hosted in freewebfarm i'm pay only for sql server (10€month)