Raised This Month: $ Target: $400
 0% 

Moving data from MySQL to nVault


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Author Message
-hi-
Member
Join Date: Jul 2006
Old 09-10-2007 , 19:09   Moving data from MySQL to nVault
Reply With Quote #1

I recently got into hosting my own server again. The problem is I cannot host a MySQL database on the same machine as HLDS. The MySQL DB is a remote connection that goes cross-country for each query. Every time a query is performed there is a small lag spike. If there's a bit of lag on the query, the server locks up for a few seconds (very annoying).

I'm looking at two options: using threaded queries with SQLX or using nVault so the data can be stored locally on the server.

My main question with the threaded queries is this: What happens at mapchange? My plugins do a lot of queries in the plugin_end() function. How does this work when the map is changing? When the query comes back, what if the server has changed the map?

Also, if I am not interested in the results of a threaded query, how does that work? Do I just create a handler that does nothing?

As for using nVault, is there an easy way to move data from MySQL to nVault? The only way I can think of is to create a flat file with one record per line, then write a plugin to parse the file. Is there an easier way?
-hi- is offline
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 22:30.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode