Last week AWS didn’t have a relaxing Sunday, AWS status page announced the platform was suffering from degraded performance in its main availability zone while the AWS was experiencing the issues other sites were also hit with performance issues. The…
We have run into a situation that we generate queries to MySQL programmatically and some of the queries are not returning the expected result, we have the application logs from there we can get the generated queries, but the query…
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…
Kubernetes employs a client-server architecture, with a master managing nodes that host containerized applications. Deploying MySQL on Kubernetes requires persistent storage like Amazon EBS for data integrity. Using StatefulSets and Persistent Volume Claims (PVCs) ensures data persistence across pod lifecycles. YAML configurations for PersistentVolume (PV), PVC, and MySQL deployment outline resource definitions crucial for persistent data storage and database operation. Following best practices, including selecting the right storage classes and regular updates, enhances performance and security for MySQL on Kubernetes.
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…