What books or video tutorials are there on MySQL and PostgreSQL databases for a system administrator?

Question

linux

The fact is that for all the time of his career as a system administrator, he has never encountered databases. In general, at all enterprises where I worked with databases, either another person worked or everything was already set up before me. I found the book MySQL Administrator's Guide Artemenko Yu.N., but it is 2005.
Interested in administering the database in the linux environment. It is also possible to provide a list of what the administrator needs to know (eg. 1. User creation. 2. Replication, etc.) for self-study

Answer 1

I will be responsible for PostgreSQL.
If you are interested in materials on the theory of Databases (not DBMS), I can add.

Answer 2

I think it’s worth starting with the documentation - for both DBMS it is very decent and detailed ...
but further with the nuances of setting up for highload and understanding the nuances of the work of the DBMS themselves - it’s already more difficult, it’s gained mainly only by experience based on specific cases and finding solutions for them.

Answer 3

Yes, first of all, you should read the docks and perform tasks from the simplest to the most complex gradually. This will give the most productive result.
dev.mysql.com/doc/mysql-linuxunix-excerpt/5.5/en

Answer 4

On MySQL, I recently found a course on youtube from the UC Specialist. I really liked it. That's right from the basics - and to the basics of optimization. And the lecturer is good.