ml@winwinsol.dk 1 Posted July 17, 2012 Hello,I have setup a DayZ server and awaiting validation. While waiting, I have been messing around with a few things.DayZ server is hosted on an ibm server attached to a redundant storage SAN via. iSCSI. the IBM server runs vmware esx 4.1 and is only virtualizing 1 instance of windows 2003 server 64-bit. The server is connected to a failover/high availability vmware cluster. 2x dual core opteron 2222SE 3 ghzDatabase ServerQuad CPU Xeon Quad coreDebian Linux 6.0MySQL+redundant SAN +the works.My question is:Can i offload the DB that DayZ uses to the SQL server? I have searched in vain for a string in a config file to change from localhost to (IP of Database Server)Why do i want this?:DayZ is growing. I also begin with the end in mind. And I believe DayZ will grow to such a size, (beyond the 5 tables in the current db) that the server requirements will go up if the sql server stays where it is now: localhost, and degrade game performance. To avoid this, i might aswell offload SQL now, so i wont have to do it later.I read a post somewhere stating that localhost cannot be changed at the moment, and username/password must be root? The opst was not on an official forum, so can i get validation on this? When will this be changed if it is in effect?Cheers,MichaelWin-Win SolutionsPS:I found during my trials and tribulations, that i i specify dayz as username for the mysql client, it blatantly refuses to login. 1 Share this post Link to post Share on other sites
Rangelkent 0 Posted July 17, 2012 I guess you could do it the ugly way and point localhost to another server in your hostfile (if it doesnt break arma in some way) or setup some proxy that listens to the mysqlport and forward the traffic and put the mysql there until they fix it Share this post Link to post Share on other sites
ml@winwinsol.dk 1 Posted July 17, 2012 Hmm, you are giving me an idea. I dont think its by the book in any means and im not sure it will work. Maybe I can enable routing and remote access on the loopback interface to forward the traffic as you suggested and port forward it back. interresting! Share this post Link to post Share on other sites
facoptere 180 Posted July 17, 2012 I thought having its own hive was banned by devteam.... Share this post Link to post Share on other sites
Lith 80 Posted July 17, 2012 I thought having its own hive was banned by devteam....They can't blacklist a private database server. When they blacklist you, it's from the main hive which he already wouldn't be using. Share this post Link to post Share on other sites
Razzle Dazzle 49 Posted July 17, 2012 Hello,I have setup a DayZ server and awaiting validation. While waiting, I have been messing around with a few things.DayZ server is hosted on an ibm server attached to a redundant storage SAN via. iSCSI. the IBM server runs vmware esx 4.1 and is only virtualizing 1 instance of windows 2003 server 64-bit. The server is connected to a failover/high availability vmware cluster. 2x dual core opteron 2222SE 3 ghzDatabase ServerQuad CPU Xeon Quad coreDebian Linux 6.0MySQL+redundant SAN +the works.My question is:Can i offload the DB that DayZ uses to the SQL server? I have searched in vain for a string in a config file to change from localhost to (IP of Database Server)Why do i want this?:DayZ is growing. I also begin with the end in mind. And I believe DayZ will grow to such a size, (beyond the 5 tables in the current db) that the server requirements will go up if the sql server stays where it is now: localhost, and degrade game performance. To avoid this, i might aswell offload SQL now, so i wont have to do it later.I read a post somewhere stating that localhost cannot be changed at the moment, and username/password must be root? The opst was not on an official forum, so can i get validation on this? When will this be changed if it is in effect?Cheers,MichaelWin-Win SolutionsPS:I found during my trials and tribulations, that i i specify dayz as username for the mysql client, it blatantly refuses to login.I think there should be a master database for each server which would be hosted on the server that is running the game. and this would end the laggy hive issues. ! master database doesn't make sense for all the servers out there Share this post Link to post Share on other sites
YoChris 1 Posted July 17, 2012 I think there should be a master database for each server which would be hosted on the server that is running the game. and this would end the laggy hive issues. ! master database doesn't make sense for all the servers out therethis will mean every single new server you join you will start over again Share this post Link to post Share on other sites
Winston Whir 3 Posted July 22, 2012 I guess you could do it the ugly way and point localhost to another server in your hostfile (if it doesnt break arma in some way) or setup some proxy that listens to the mysqlport and forward the traffic and put the mysql there until they fix itI actually think you can acomplish this with iptables Share this post Link to post Share on other sites
domistyle 221 Posted July 22, 2012 (edited) Your post is not very clear.You say you wait for confirmation but you still have/want a private Hive database?What do you want now? A private Hive or a normal DayZ server connected to official Hive? Or both? Edited July 22, 2012 by DomiStyle Share this post Link to post Share on other sites
