Hey, I had an incident earlier this week in which the default sqlite DB got corrupted and had to rollback to an earlier one... The backups some of them were corrupted aswell, since I basically copy the sqlite file with the WAL+SHM files, yet it didn't quite work in the first place. Already fixed it and it is not the main focus on this thread, just a context.
I'm wondering how easy is to migrate the same database to a MySQL DB or even a PostGresSQL DB. Can anyone guide it through it? I already know how to dump SQLITE into SQL and then load into a new MySQL database, but the issue is how to do it in TeaSpeak server configurations. I've seen that some people recommend starting the server on a blank MySQL DB and then waiting until the voice server creates the default tables. Then dump the content of the sqlite and import only the content (not the scheme) into the MySQL tables. Is it the correct way to do it?
And also, how would TeaServer work when upgrading the database itself? Will it create and manage tables itself?
This would also make a new issue: how many queries to the DB TeaSpeak do per minute and how much is the acceptable ping between the TeaServer host and the DB host would be? This is because im thinking on splitting those two so that I can have lets say one DB machine for multiple locations of TeaServer software sharing the same MySQL Server (not database itself, but the server), and if something goes wrong with the TeaServer the database doesn't get corrupted aswell.
Also, in the MySQL/PostGreSQL setup, is there a problem when dumping the database into a backupfile, is the backup be ready to use when loaded back into the production database?
Back to SQLite, anyone can share which method you guys use to backup your servers? I actually run 3x/day a backup that contains the sqlite/WAL/SHM, protoco_key, configs and the files directory. Then after each backup I do a dump of a snapshot of every active server if I need to revert a server individually.
Willing to change the way I backup the files to a incremental backup since my files backup actually have grown up to 1.5gb per backup (500mb the database itself).
And for last but not least: which database you hosters use? The default? MySQL? Tell us
Thanks for the attention.
I'm wondering how easy is to migrate the same database to a MySQL DB or even a PostGresSQL DB. Can anyone guide it through it? I already know how to dump SQLITE into SQL and then load into a new MySQL database, but the issue is how to do it in TeaSpeak server configurations. I've seen that some people recommend starting the server on a blank MySQL DB and then waiting until the voice server creates the default tables. Then dump the content of the sqlite and import only the content (not the scheme) into the MySQL tables. Is it the correct way to do it?
And also, how would TeaServer work when upgrading the database itself? Will it create and manage tables itself?
This would also make a new issue: how many queries to the DB TeaSpeak do per minute and how much is the acceptable ping between the TeaServer host and the DB host would be? This is because im thinking on splitting those two so that I can have lets say one DB machine for multiple locations of TeaServer software sharing the same MySQL Server (not database itself, but the server), and if something goes wrong with the TeaServer the database doesn't get corrupted aswell.
Also, in the MySQL/PostGreSQL setup, is there a problem when dumping the database into a backupfile, is the backup be ready to use when loaded back into the production database?
Back to SQLite, anyone can share which method you guys use to backup your servers? I actually run 3x/day a backup that contains the sqlite/WAL/SHM, protoco_key, configs and the files directory. Then after each backup I do a dump of a snapshot of every active server if I need to revert a server individually.
Willing to change the way I backup the files to a incremental backup since my files backup actually have grown up to 1.5gb per backup (500mb the database itself).
And for last but not least: which database you hosters use? The default? MySQL? Tell us
Thanks for the attention.