I'm a Senior #Software Engineer with 20+ years of professional experience.

I have primarily worked with web technologies such as #JavsScript, #HTML, #CSS, #nodejs, and #typescript.

My last job was as a Senior #React Engineer.

I've worked with #Postgres, #MySQL, and #MSSQL databases.

Backend tech includes C#, Go, PHP, and ASP.

Countless projects ranging from SPAs to $100 million ecommerce sites to enterprise level software.

#getfedihired

I'm a Senior #Software Engineer with 20+ years of professional experience.

I have primarily worked with web technologies such as #JavsScript, #HTML, #CSS, #nodejs, and #typescript.

My last job was as a Senior #React Engineer.

I've worked with #Postgres, #MySQL, and #MSSQL databases.

Backend tech includes C#, Go, PHP, and ASP.

Countless projects ranging from SPAs to $100 million ecommerce sites to enterprise level software.

#getfedihired

Do you want MySQL with the best possible performance? Then stick to version 5.6, as long as you don't mind it's been EOL for 12 years. 5.7 also has better performance than newer versions, although not as good as 5.6. Some performance regressions are just not being fixed.

https://smalldatum.blogspot.com/2025/08/sysbench-for-mysql-56-thru-94-on-small.html

^^ Veteran database performance guru, Mark Callaghan, former tech lead for MySQL at Facebook and Google, is now an independent consultant who blogs about database benchmarking.

(For my own account as a MariaDB fanboy I must add that another option could be migrating to MariaDB which is a plug-in replacement for MySQL 5.6, as MariaDB has done a better job at avoiding and fixing performance regressions.)

#mysql #benchmarking

Do you want MySQL with the best possible performance? Then stick to version 5.6, as long as you don't mind it's been EOL for 12 years. 5.7 also has better performance than newer versions, although not as good as 5.6. Some performance regressions are just not being fixed.

https://smalldatum.blogspot.com/2025/08/sysbench-for-mysql-56-thru-94-on-small.html

^^ Veteran database performance guru, Mark Callaghan, former tech lead for MySQL at Facebook and Google, is now an independent consultant who blogs about database benchmarking.

(For my own account as a MariaDB fanboy I must add that another option could be migrating to MariaDB which is a plug-in replacement for MySQL 5.6, as MariaDB has done a better job at avoiding and fixing performance regressions.)

#mysql #benchmarking

Has your OS ever refused to install the MariaDB client package or the MySQL client package due to a conflict with the other?

It feels like it should be possible to have both, but unfortunately I have yet to see a solution for this.

For a subset of these cases, all that you want is just to have the client tools such as the mariadb/ mysql CLI and the mariadb-dumper/ mysqldumper backup programs co-existing on the same OS. (I.e. you don't care about the static/dynamic libmariadbclient/libmysqlclient libs etc).

So, I decided to write up my solutions for this:
https://dbdemon.com/installing_mariadb_and_mysql_clients_on_same_unix_host/

#mariadb #mysql #pkg #rpm #packaging

Has your OS ever refused to install the MariaDB client package or the MySQL client package due to a conflict with the other?

It feels like it should be possible to have both, but unfortunately I have yet to see a solution for this.

For a subset of these cases, all that you want is just to have the client tools such as the mariadb/ mysql CLI and the mariadb-dumper/ mysqldumper backup programs co-existing on the same OS. (I.e. you don't care about the static/dynamic libmariadbclient/libmysqlclient libs etc).

So, I decided to write up my solutions for this:
https://dbdemon.com/installing_mariadb_and_mysql_clients_on_same_unix_host/

#mariadb #mysql #pkg #rpm #packaging

I've used #MySQL before (last time was 2016, I think), but today I'm mostly onto #Postgres (and sometimes, #SQLite). I know PG is superior to MySQL is pretty much all aspect I could think of, but still, it seems that MySQL still has a quite big user base.

What's the catch? What am I missing here? Why would someone use MySQL over Postgres to build smt since Postgres [apparently] is better than MySQL in every single possible aspect?

It's a honest question. Please help me understand it – and perhaps, consider modern MySQL/MariaDB in next projects. :)