Skip to content

Config: Make PhotoPrism compatible with MariaDB 11 #3443

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
3 tasks done
lastzero opened this issue Jun 2, 2023 · 2 comments
Closed
3 tasks done

Config: Make PhotoPrism compatible with MariaDB 11 #3443

lastzero opened this issue Jun 2, 2023 · 2 comments
Assignees
@lastzero
Labels
enhancement Enhancement or improvement of an existing feature released Available in the stable release

Comments

@lastzero
Copy link
Member

lastzero commented Jun 2, 2023

While testing the upcoming MariaDB release, we noticed that it is no longer fully compatible with mysql - at least as far as commands are concerned.

As a result, we will now use:

  • mariadb instead of mysql for the client binary
  • mariadb-dump instead of mysqldump for the backup binary
  • and mariadbd instead of mysqld for the server binary

If you know of any other changes that should be implemented or have found an incompatibility, please let us know so we can update our application and/or Docker image. Thank you!
@lastzero lastzero added important enhancement Enhancement or improvement of an existing feature labels Jun 2, 2023
@lastzero lastzero self-assigned this Jun 2, 2023
lastzero added a commit that referenced this issue Jun 2, 2023
@lastzero
Config: Make PhotoPrism compatible with MariaDB 11 #3443
bff6494 
Signed-off-by: Michael Mayer <michael@photoprism.app>
@lastzero lastzero added please-test Ready for acceptance test and removed important labels Jun 2, 2023
@lastzero
Copy link
Member Author

lastzero commented Jun 2, 2023

Our config examples at https://dl.photoprism.app/docker/ have been updated. To update your existing docker-compose.yml file, replace command: mysqld with command: mariadbd, otherwise the database server might fail to start.

@lastzero
Copy link
Member Author

lastzero commented Jun 2, 2023

The MariaDB Troubleshooting Guide in our documentation has been updated accordingly:

https://docs.photoprism.app/getting-started/troubleshooting/mariadb/#version-upgrade

@lastzero lastzero added tested Changes have been tested successfully released Available in the stable release and removed please-test Ready for acceptance test tested Changes have been tested successfully labels Jun 3, 2023
@lastzero lastzero closed this as completed Jun 3, 2023
@lastzero lastzero moved this to Released 🌈 in Roadmap 🚀✨ Jun 8, 2023
grooverdan added a commit to grooverdan/photoprism that referenced this issue Dec 1, 2023
@grooverdan
Docker: mariadb container don't need command: mariadbd
724fada 
The photoprism#3443 compatibility missed an important simplification,
the mariadbd/mysqld was never needed on the command.

Remove this from the simple cases.

Signed-off-by: Daniel Black <daniel@mariadb.org>
@grooverdan grooverdan mentioned this issue Dec 1, 2023
Merged
5 tasks
lastzero pushed a commit that referenced this issue Dec 4, 2023
@grooverdan
Mariadb docker-compose simplification (#3928)
cd014f0 
* Docker: mariadb container don't need command: mariadbd

The #3443 compatibility missed an important simplification,
the mariadbd/mysqld was never needed on the command.

Remove this from the simple cases.

Signed-off-by: Daniel Black <daniel@mariadb.org>

* Docker: mariadb - bump latest to 11.2

Latest GA MariaDB is currently 11.2

Signed-off-by: Daniel Black <daniel@mariadb.org>

* Docker: mariadb - eol for 10.7/10.8 - 10.11 is lts

As the 10.7 and 10.8 where short term releases and are now end of life,
remove those and replace with 10.11, a LTS version.

Signed-off-by: Daniel Black <daniel@mariadb.org>

---------

Signed-off-by: Daniel Black <daniel@mariadb.org>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@lastzero lastzero

Labels
enhancement Enhancement or improvement of an existing feature released Available in the stable release
Projects
Roadmap 🚀✨
Status: Release 🌈
Milestone
No milestone
Development

No branches or pull requests
1 participant
@lastzero