About MySQL and Sqlite
I have a 'bank' that saves in MYSQL, but sometimes MYSQL is off, would I be able to use SQLITE and MYSQL together?
If by chance MYSQL does not respond, save in SQLITE, and every X seconds send the SQLITE data to the MySQL server Or is it not possible to connect 2 banks at the same time? or if you have another solution. |
Re: About MySQL and Sqlite
|
Re: About MySQL and Sqlite
Don't bother, because if MySQL server is not on the same machine with Game Server you will always have problems with querry, i use a lot of MySQL but only on the same hawk as the Game Server, otherwise it doesn't respond verry well.
Just sain |
Re: About MySQL and Sqlite
Quote:
|
Re: About MySQL and Sqlite
Save to a vault file. I don't see why you would need a MySQL database for that if you are using it only in the game server itself. You're just adding an extra overhead that is not needed at all.
|
Re: About MySQL and Sqlite
Quote:
Quote:
|
Re: About MySQL and Sqlite
Quote:
https://github.com/ShadowsAdi/MostVa...ble_player.sma And I use curl instead of grip for some projects and it works well, except for some incorrect buffers which seems to be intended ( https://github.com/Polarhigh/AmxxCurl/issues/11): https://github.com/Polarhigh/AmxxCurl |
Re: About MySQL and Sqlite
In order to keep both databases with fresh stats you must connect to both sources and refresh their data so whenever one fails, the other one can get you the answer to your query. I'd suggest a table on both databases that saves the integer of current systime so you know which one was updated recently in order to get what you need from that db and not the old one.
|
| All times are GMT -4. The time now is 11:39. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.