MariaDB Master-Slave replication checklist
This is MariaDB (MySQL) checklist for setting up Master-Slave replication.
Author: b0001o0001u78078
Quotas in LXC unprivileged container
Getting filesystem quotas work inside of a LXC unprivileged container is relatively a big problem, because linux kernel and LXC currently play against us (= they do not support this yet). But, workaround exists !
Partitions of LVM logical volume
Quick how-to for registering and unregistering partitions on LVM logical volume (yes, event that is possible ;).
TUN in LXC unprivileged container
VPN in container requires tun/tap device – if you don’t have one you have to create it with mknod command. But, there is the problem – in the LXC (Proxmox) unprivileged container is mknod (as syscall) not allowed, because this would introduce possible security problems (see this article).
Postgresql upgrade checklist
Checklist for major postgresql database upgrade: shutdown standby servers on each standby perform pg_upgrade shutdown master perform pg_upgrade if pg_upgrade fails on postgres database with encoding mismatch, re-init database with initdb start master verify master is ok check if recovery.conf present in slave datadir start slaves one-by-one check if slaves are live and recovering if […]
Setting up own mail server
This post describes all the things you will have to do, after (or before) installing and configuring your mail server, because that is where it all starts. Without it, you might have problems sending mail, because remote domains might think your server sends spam or is not delegated to send emails for your domain…
Extracting Oracle high_value from user_tab_partitions
As always with Oracle its pretty ‘easy‘ and ‘straightforward‘ – you have to convert the high_value to XML and then extract it using XPATH (omg!). Let me guess, it would cost a fortune to provide native function/view that could do that…
No more systemd on server.
Some time ago I’ve tried to solve a ‘funny’ issue with PowerDNS. It refused to start on one of my backup VPS. After apt-get dist-upgrade, it first stopped to work with very meaningful ‘Failed at step ADDRESS_FAMILIES‘ error. Well, I’ve managed to solve it somehow, but then another ‘funny’ problem popped out…
SOLR DataImportHandler performance tunning
Some hopefully useful tips on speeding up data import via SOLR DataImportHandler.
PostgreSQL and user restrictive view with functions involved
In PostgreSQL it’s quite easy to restrict access for user to some tables: create restrictive view grant usage on view schema grant select on view to restricted user done Really easy. And it’s not working when the restrictive view, is selecting from another view that is using function(s)!