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…
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 command in the background and should not affect if your session terminates, follow the below steps First, start your restore process using the usual MySQL…
Typical MariaDB Server installations have the MySQL data directory located in /var/lib/mysql. The data directory contains the data of the databases and the size increases depending on the usage. In this post, you will learn how to move the MariaDB Server data directory to a new mounted EBS Volume. This is useful to separate the…
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.
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 to be connected permanently to receive updates from a source. Replication can be configured for all the databases, selected databases, or even a tables within…
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…
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 or transaction consistent backups of the Microsoft centric applications like ADDS ( Active Directory), MSSQL and MS Exchange are possible with the use of Microsoft’s…