Try following script , This script will take mysql database backup automatically and remove the old backup file which is over 3 days and once backup is completed means it will send mail confirmation If you know the mysql root password you …
This script can be used to check on mariaDB, apache2, or whatever service you want. This is not meant to be a SOLUTION to services that are crashing, but rather a notification and a temporary restart until you can solve …
Respected Sir/madam, This is Nijamutheen , I have 6+ years of experience in PostgreSQL database administrator as well as PostgreSQL Architect , Linux admin , web hosting – apache server , Oracle ,mySQL, Mriadb, MSSQL & Server security as well …
Tips for MariaDB Server performance tuning & optimization Agenda MariaDB Performance Tuning: Common Principles and Best Practices Server Hardware and OS MariaDB Configuration Settings Database Monitoring Query Tuning Why Tune? The task of scalable server software is to maintain top …
What is AWS? – Amazon Web Services(AWS) is a cloud service from Amazon, which provides services in the form of building blocks, these building blocks can be used to create and deploy any type of application in the cloud. These services …
The benefit of a synchronous PostgreSQL replication over an asynchronous is that in case of master PostgreSQL database server failure you are sure you did not lose any data. The database client connected to the master PostgreSQL database gets a …
I have a table name is nijam, that table contains 63017 records and have csv excel data contains 586128 records so want to append the data in nijam table for this task you have to following below steps Sample DATA …
Postgres by BigSQL includes the PostGIS extension, version 2.2 & 2.3, a powerful open source spatial and geographic data management package. PostGIS enables mapping, distance calculations, and geometry functions such as identifying if a point is within a polygon. Install …
Check the status of the firewalld service: systemctl status firewalld.service The status displays as active (running) or inactive (dead). If the firewall is active / running, enter this command to stop it: systemctl stop firewalld.service To completely disable the firewalld …
In this shell script will be helpful for monitoring RAM usage,DISK size,how many queries is running more than 5 minutes in a postgres cluster and how many dead tuble is occurred particular database in cluster, How to create & run …
Difference between View vs Materialized View in database Based upon on our understanding of View and Materialized View, Let’s see, some short difference between them : 1) The first difference between View and materialized view is that In Views query …
Below steps will be helpful to improve your postgres database performance so faster than earlier. First you have to issue the top command then see the process which one process is taking more CPU utilization then note that PID, if that is postgres …
You can use INSERT INTO statement by selected specific table column or use * for selecting all column dblink also will server purpose even if it is remote database.. with condition X server is able to reach Y. # you can …
In this post, i will explain how to setup a streaming replication with PostgreSQL 10. I will explain how to install PostgreSQL 10 on your system and how to monitor the postgres replication server and how many ways is there …
PostgreSQL 10.3 installation steps: In this tutorial i will explain how to install postgreSQL 10 on Red Hat Enterprise Linux Server release 7.3 Beta (Maipo),How to make network configuration and linux partition for DATA,ARCHIVE,BACKUP, and how to configure postgreSQL cascading …
Login with Google