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 applications/services deployed in the US-EAST-1 faced the issue and a lot of internet companies were…
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 and the parameter value are logged in a different line, some of the queries have…
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 AWS read here Update your system repo Install the dependencies Before we start with 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 Execute the query show config_file; will give you the location of the conf file Run…
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, example if your Instance is running Oracle and you want to enable hot backup mode…
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 features like reliable transactions and concurrency without read locks. During the COVID-19 Quarantine days, I…
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 installations have certain standard databases: The mysql directory corresponds to the MySQL system database, which…
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 on the file system. A single MongoDB server typically has multiple databases. Collection A collection…