The MySQL root password allows the root user full access to the MySQL database. If you do not remember the root password of the mysql …
Read More »How To Backup MySQL Databases With mysqldump
Mysql database should be backed up daily or periodically. It is possible to back up regularly with a script that we will create in the …
Read More »How To Enable MongoDB Sharded Cluster Authorization
Once MongoDB is installed, by default, authentication is not enabled, users can login without specifying user name / password. Authorization is extremely important for security …
Read More »How To Install MongoDB Sharded Cluster
In my previous articles, I talked about MongoDB Community Edition installation and MongoDB Sharded Cluster components in general. You can access these posts below: “How …
Read More »How To Install Mongodb Sharded Cluster with Keyfile Access Control on Red Hat or CentOS
As you know security is one of the key points during database administration. In MongoDB sharded clusters security between components of the cluster is provided …
Read More »MongoDB Sharded Cluster Components
MongoDb Sharding is a method used to distribute data to multiple machines. Sharding improves data access performance. if you want to install Sharded Cluster you …
Read More »How To Install MongoDB Community Edition
This article describes how to install MongoDB Community Edition on CentOS Linux. The same installation applies to RedHat Linux versions. Versions: Operating System: CentOS Linux …
Read More »How To Install Streaming Replication in PostgreSQL 12
I will tell about changes in replication and replication installation in PostgreSQL 12 in this article. This article assumes that you are familiar with PostgreSQL …
Read More »Diagsnap in Oracle 12c
What is Diagsnap in Oracle 12c Diagsnap is a new feature introduced in 12.1.0.2 GI, which manages the diagsnap resource, which collects additional operating system …
Read More »How To List Applied Patches in Oracle
You can list applied patches in Oracle by query except for “opatch”. You can use DBA_REGISTRY_HISTORY for databases 11g and earlier, and DBA_REGISTRY_SQLPATCH for databases …
Read More »