Martin Wendler

Martin Wendler

📍 Germany

MariaDB: The usage of MARIADB_AUTO_UPGRADE

When you're running MariaDB and keep it up to date, binaries are updated (either because of updates running within OS update, or by updating Docker containers), and you won't have to do anything - it just works. In MySQL, this isn't a problem; the

Flashback: HP Jornada 720

Many years ago, I installed NetBSD on a HP Jornada

Flashback: Sun SPARCstation 20 running OpenBSD as mail server

En the early 2000s, when I was in education, I had to complete a project by my own. As I somehow got a Sun SPARCstation 20, with a few GB of disk and - as I remember - 256 MB of RAM. The CPU was a SPARC 32bit. I decided

PostgreSQL: How to solve collation mismatch

This is how to solve a collation mismatch in your PostgreSQL database

PostgreSQL: Update extensions

This is how to update an extension in PostgreSQL

Oracle: How to solve ORA-16810 ORA-16809 ORA-16854 in DataGuard

When moving Oracle manual standby database, I got these eror: [...] Error: ORA-16810: multiple errors or warnings detected for the member [...] Warning: ORA-16854: apply lag could not be determined [...] ERROR I tried several things, like clearing log files: SQL> alter database clear logfile group 1; But I get this error:

Oracle: Apply many OneOff patches at once

This is how to apply different OneOff patches at one time

Oracle: Database Appliance (ODA) used for other things

My thoughts on what you could also do with your ODA

The Ten Commandments for DBAs

I recently read a great blog entry from Fritz Lechnitz, who wrote about the Ten Commandments for a SQL Server DBA. As I am - and mostly was over many years - an Oracle DBA, who had some excursions to other RDBMS (SQL Server, DB/2, Informix, MySQL, PostgreSQL ), I&