Posts

Showing posts from December, 2019

MySQL backup tips

From https://hackernoon.com/elephant-in-the-room-database-backup-574da50e6d88 For instance, mysqldump will take dumps conforming to the client’s character set, and your favorite emojis such as 🍣 and 🍺 in utf8mb4 could be corrupt and replaced by  ? in the backup. If you have never checked, do it right now. Just set --default-character-set=binary option — you’re welcome. Or if you missed the --single-transaction option, you are likely to have inconsistent backups (e.g. item changed hands but money didn’t transfer) that are never easy to spot even if you regularly test the recovery procedure manually.

Postgresql tips and links

Free training material (documentation) in French: https://public.dalibo.com/exports/formation/manuels/formations/ Free book: https://books.goalkicker.com/PostgreSQLBook Documentation about the internals of PostgreSQL:  The internals of PostgreSQL  Configuration wizards https://pgconfigurator.cybertec-postgresql.com/ https://pgtune.leopard.in.ua/ https://postgresqlco.nf / is a bit different, but can help https://pgmetrics.io/   Not a wizard, but provides many info about PG instance  Troubleshooting Observability: what function gives information about which component/process? https://pgstats.dev/     https://postgresqlco.nf/  You can upload your configuration, get recommendations, etc  Clients psql: PostgreSQL-provided client (command-line) pgcli CLI client with auto-completion and syntax highlighting   https://www.pgcli.com/ "Full" list Toad for PostgreSQL Kangaroo https://dbkangaroo.github.io/ Backups barman https://sourceforge.net/projects/pgbarman/files/2