Here are some frequently asked questions (FAQs) about managing databases on Linux that may help you get a better understanding of the processes and best practices:
sudo apt update
sudo apt install mariadb-server
sudo apt install postgresql
sudo yum install mariadb-server
sudo yum install postgresql-server
mysql_secure_installation script helps harden MySQL installations.Use systemd to manage database services:
sudo systemctl start mysql
sudo systemctl start postgresql
sudo systemctl stop mysql
sudo systemctl stop postgresql
sudo systemctl status mysql
sudo systemctl status postgresql
You can access databases through their command-line clients:
mysql -u username -p
psql -U username -d dbname
mongo
mysqldump for backups:mysqldump -u username -p database_name > backup.sql
mysql -u username -p database_name < backup.sql
pg_dump for backups:pg_dump dbname > backup.sql
psql dbname < backup.sql
my.cnf for MySQL, postgresql.conf for PostgreSQL).EXPLAIN in MySQL/PostgreSQL to analyze slow queries.CHANGE MASTER TO command and the replication user.postgresql.conf and use pg_basebackup to set up replicas.mysqldump, pg_dump, mongodumpphpMyAdmin, pgAdmin, AdminerMySQLTuner (MySQL), pg_stat_statements (PostgreSQL)Prometheus, Nagios, Zabbix