High reliability PostgreSQL cluster based on Patroni, Haproxy, Keepalived
Recently I faced a task: to configure the most reliable …
High reliability PostgreSQL cluster based on Patroni, Haproxy, Keepalived Read More »
Databases
Articles dedicated to SQL and non-Sql databases/
How to change Porstgresql default password
Switch to user root Login to psql using the postgres …
how to export mysql database from docker container
In order to export the base from the docker container, …
how to export mysql database from docker container Read More »
how to install firebird server on Debian 10
In this article, we will describe the minimum set of …
how to find size of the database via mysql console
There are a bunch of different tools with a graphical …
how to find size of the database via mysql console Read More »
How to create Dblink between Oracle & PostgreSQL
One of our databases was migrated from Oracle to Postgresql, …
How to create Dblink between Oracle & PostgreSQL Read More »
How to replace MySQL with Percona Server on Debian or Ubuntu
You can safely replace MySQL with Percona Server without lossing …
How to replace MySQL with Percona Server on Debian or Ubuntu Read More »
how to Upgrade MariaDB 10.1 to 10.5 on Debian Stretch
These instructions detail the upgrade from a previous version of MariaDB Community Server to MariaDB …
how to Upgrade MariaDB 10.1 to 10.5 on Debian Stretch Read More »
How to add remote MySQL database server VestaCP
1. It is assumed you already have your second server …
howto upgrade mariadb 10.x to 10.3.x on Centos 7
#1: Perform a full backup The first thing to do …
howto upgrade mariadb 10.x to 10.3.x on Centos 7 Read More »
how to restore postgreSQL database with template using pg_dump
Import a PostgreSQL database dump There are two ways to …
how to restore postgreSQL database with template using pg_dump Read More »
How to disable MySQL Strict Mode?
Q: I’m going to start handling my own data validation …