Unraid PhotoPrism SQLite to MariaDB

由于安装 PhotoPrism 的时候使用了默认的 sqlite，性能实在是拉垮，归档照片的时候总是提示 database is locked。

参考：https://docs.photoprism.app/getting-started/advanced/databases/

MariaDB

When creating a new database, make sure to set the charset and collation as follows:


CREATE DATABASE photoprism
CHARACTER SET = 'utf8mb4'
COLLATE = 'utf8mb4_unicode_ci';

Now create a user and grant privileges for this new database:


CREATE USER 'photoprism'@'%' IDENTIFIED BY 'insecure';
GRANT ALL PRIVILEGES ON photoprism.* to 'photoprism'@'%';
FLUSH PRIVILEGES;

安装迁移工具

docker pull sineverba/sqlite3-to-mysql:latest

https://hub.docker.com/r/sineverba/sqlite3-to-mysql/tags

迁移


docker run -it -v /mnt/user/appdata/photoprism:/usr/src/app --rm sineverba/sqlite3-to-mysql:latest sh 
sqlite3mysql -f index.db -d photoprism -u root --mysql-password 'insecure'

设置 docker 启动参数

切换为 mysql 并配置连接 dsn

root:photoprism@tcp(photoprism-db:3306)/photoprism?charset=utf8mb4,utf8&parseTime=true