mumble
mumble copied to clipboard
DB transitions/migration system for server
Most of murmur admins start their server with SQLite, sometimes when server is growing, SQLite is not providing necessary performance and freezes server. It would be cool to have migration system for eg. migrating SQLite to PGSQL or MariaDB.
Workaroundish migration makes maintenance pain in ass and creates bugs like #4292
In #4292 @Krzmbrzl stated it would be cool to have it so I'm creating this issue to make it not disappear :D
The ToDo-list for the pending DB-rewrite keeps growing xD
When do you start seeing issues?
Sqlite runs entirely in memory, so really, the overhead is much smaller using it as a data storage. And with only a single process using the database, there is no need for db user access synchronization.
@Kissaki doubt I had problems with IO overload on my server and pgsql fixed the issue on mumble. I also saw similar comments but for mariadb instead of sqlite. I had to wait few seconds eg. when switching between channels.
I had to wait few seconds eg. when switching between channels.
Out of the top of my head I would say that for this action there is no DB access involved though
I had to wait few seconds eg. when switching between channels.
Out of the top of my head I would say that for this action there is no DB access involved though
Well, keeping track of channel changes and last channel writes to DB afaik ;P And.. practice shows other thing ;) moving to pgsql solved all problems.
Anyway: I think it's offtopic here.
Out of the top of my head I would say that for this action there is no DB access involved though
Isn't murmur logging to the database too?
Isn't murmur logging to the database too?
Indeed, it is