Synology servers allow users to run a native MySQL server directly on the NAS, and also allow management of it with phpMyAdmin.
Is it at all possible to configure a manually installed PLEX instance on a Synology NAS to use a MySQL server as the database backend?
(Having recently had to rebuild my media server due to a corrupted Plex DB issue, I'm pretty sure it's currently using files as the DB system, ... by default.)
Is it at all possible to configure a manually installed PLEX instance on a Synology NAS to use a MySQL server as the database backend?
Nope
(Having recently had to rebuild my media server due to a corrupted Plex DB issue, I'm pretty sure it's currently using files as the DB system, ... by default.)
Name on database engine, that doesn't do that ;)
And FUI, Plex use SQLite
/T
I'd love to have Plex use something other than SQLite as the database backend. Personally I'd prefer that it was PostgreSQL, but I could live with MySQL as well.
I moved all of Plex's data from the local SSD (everything in /var/lib/plexmediaserver) on my Plex server to my Ceph cluster. My Ceph cluster isn't very fast so I've been having problems with pauses and it seems to be because Plex can't access it's database fast enough (lots of "Sqlite3: Sleeping for 200ms to retry busy DB.") I'm going to move the databases back to the SSD but it'd be really nice if I could switch to a "real" SQL backend.
I understand the reasons that they use SQLite - it's easy to use because the user doesn't have to do anything to set it up. Performance is limited though.
Yeah, using anything other than SQLite3 would be nice, but it appears that Plex are only after bling, they don't appear to be concerned about performance at all.
Huh.....
For the task of running PMS, SQLite is more than up to the job.
Another reason why SQLite is a nice choice is, that it is supported on so many platforms, as well as on mobile devices.
And SQLite is very easy to configure for an app developer
In my book, a perfect choice.
/T
"Sqlite3: Sleeping for 200ms to retry busy DB."
Did you try and optimize the database?
https://support.plex.tv/hc/en-us/articles/200392106
/T
It’s because the developers made poor decisions on database selection initially assuming everyone would be running the database calls for a single user, on their phone, etc.
sqlite is ■■■■ for any real database use. Now you’ll get the devs that chime in & defend that ■■■■ because they have to keep pushing poor decisions as a full rewrite isn’t an option.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
