Return on experience, migration from MySQL to Postgresql

fyah · October 13, 2021, 6:32am

Hi Larry,
No the estimates where rigth, Ieft the migration go on for a full day.
What bother me is the maintenance window beeing to long where I could not use the server

As for the motivation to switch to pg, I read several articles mentioning the better performance of pg

github.com/nextcloud/server

Recommend PostgreSQL instead of MariaDB/MySQL

opened 09:03PM - 27 Jul 17 UTC

closed 06:05AM - 28 Jul 17 UTC

enoch85

enhancement technical debt

I wish PostgreSQL in general was better supported. In MariaDB/MySQL you have to …mess around with UTF8mb4 if you want 4-byte support, which is default in PostgreSQL UTF8. PostgreSQL feels like a better DB in general. Would be nice if Nextcloud decided to go down that path instead of recommending a less advanced (and IMHO) worse DB. I'm writing this after I have been messing with MariaDB for hours to activate 4 byte support, which only took a few minutes in PostgreSQL (aka apt install postgresql). According to the IRC channel (#posgresql) UTF8mb4 is just something that MariaDB/MySQL came up with becuase they messed up the original code and had to make a quick fix to solve it. That doesn't sound good to me. Also UTFmb4 is considered "experimental" according to docs which isn't the case with PostgreSQL as it just works out of the box. @MorrisJobke [said](https://github.com/nextcloud/vm/pull/277#issuecomment-310527005) that MariaDB/MySQL was performing better when tested in a clustered environment, but my guess is that that test was some time ago. Maybe you should consider making PostgreSQL the recommended DB after all? Also, this is not just about UTF8mb4, I'm talking generally. There are a lot to gain in using PSQL any other DB IMHO. According to several hours of reading I did comparing and testing the alternatives. Taken from here: https://github.com/nextcloud/server/issues/5909#issuecomment-318454705

not to mention that I use pg for work on a daily basis …