First Launch the EC2 Instance from the AMI Ubuntu Server 16.04 LTS (HVM), SSD Volume Type After Launching the EC2 instance, connect to the instance using the key pair, to know the default username for each operating system in the…
How Kubernetes works Kubernetes is based on a client-server model, it implements a layered architecture with master server controlling several nodes ( worker nodes ) on which containers are hosted. On each node there are a variable number of containers…
Most of the time the default location differs based on the operating system and sometimes depends on the version also the location may change, and also maybe depend on how you install the server. To get the location of postgresql.conf…
Read more here on WiredTiger Storage and the need of application consistency for the MongoDB Check here on adding your AWS account to Nimesa Nimesa supports pre and post script hooks to perform the specific operation before or after a backup,…
PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. It is a popular choice for many small and large projects and has the advantage of being standards-compliant and having many advanced…
Information managed by the MySQL server is stored under a directory known as the data directory. Data directory subdirectories. Each subdirectory of the data directory is a database directory and corresponds to a database managed by the server. All MySQL…
MongoDB is a cross-platform, document oriented database that provides, high performance, high availability, and easy scalability. MongoDB works on concept of collection and document. Database Database is a physical container for collections. Each database gets its own set of files…
Recently i posted on Installing MariaDB on AWS EC2 instance and securing the installation. After securing the installation, the root user login is failing with error Access denied for user ‘root’@’localhost’ (using password: YES) The problem is the root user…
The SPOOL is a command causes SQLPlus to write the results to a file on the operating system. Once spool is set, SQLPlus will continue to spool the output until the command SPOOL OFF. Note that the file cannot be…
Day 2 activity of the DBA’s, after setting up the database server and configured all the required privileges and applying the patch, we will create a new database Developers and SysAdmins also should know to create database. Creating database from…
