MySQL
-
MySQL Log all queries to file and table
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…
-
Restore MySQL dump in the background
Remote SSH to the Linux servers will get disconnected for multiple reasons, if you have a huge dump of MySQL database and want to restore the database using the MySQL…
-
Kubernetes MySQL POD with Persistent EBS Volume in EKS
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…
-
Setup MySQL Master-Slave Replication
Replication enables the data from one MySQL database server (master)to be copied to one or more servers ( slaves ). MySQL Replication is Async by default; slaves do not need…
-
Change the data directory of MySQL / MariaDB Database Server
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…
-
The relationship of RDBMS terminology with MongoDB
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…
-
Application consistent protection of MySQL databases: Nimesa approach
Nimesa supports application-consistent backup of MSSQL databases with the recovery options from instance to table level. Recently we launched the MySQL application consistent backup to the beta customers Application consistency…
-
Protect your WordPress website hosted in Amazon EC2
All websites available on the internet are vulnerable to hacking attempts, DDOS attack, Data loss, This could happen to WordPress websites as well. WordPress has core files, the wp-content folder…
-
MySQL application consistent backup using pre and post script with Nimesa Data Protection
In recent posts, we have discussed adding your AWS account to Nimesa to do the data protection. In this post, we will discuss application-consistent backups of your MySQL on EC2…