Useful tips for everyday
How do I backup my RDS MySQL database? Scheduling Amazon RDS MySQL Database Backup Using Backup Ninja Step 1: Complete the schedule details. Give a…
How can I convert an oracle dump file into SQL Server? “is there any possibility to use another way in converting oracle dump file?” Import…
Can you promote a read replica to master? Here’s another way to do it: Execute the operations on a designated Read Replica and wait for…
What is a standard ISO definition? Standards are the distilled wisdom of people with expertise in their subject matter and who know the needs of…
What is an example of a distributed database? Though there are many distributed databases to choose from, some examples of distributed databases include Apache Ignite,…
How to change InnoDB buffer pool size in MySQL? You need to restart your mysql server to have it’s effect in action. As of MySQL…
What is MongoDB WiredTiger? WiredTiger is a NoSQL, Open Source extensible platform for data management. The WiredTiger storage engine is the default storage engine starting…
What is uncommitted data? Uncommitted Data This problem occurs when one transaction updates a data item, but has not yet committed the data permanently to…
Is Autovacuum on by default? Refer to Section 23.1. 5 for more information. Controls whether the server should run the autovacuum launcher daemon. This is…
What is multivalued dependencies explain with example? Multivalued dependency occurs when there are more than one independent multivalued attributes in a table. For example: Consider…