MongoDB 2.6 MongoDB 2.6 has Key features include aggregation enhancements, text-search integration, query-engine improvements, a new write-operation protocol, and security enhancements. MMS 1.4, which includes On-Prem Backup in addition to Monitoring, is now also available. See MMS 1.4 documentation and the…
Relational databases are being pushed beyond their limits because of the way we build and run applications today, coupled with growth in data sources and user loads. To address these challenges, many companies, such as MTV and Cisco have migrated…
Introduction: MongoDB (from “humongous”) is a cross-platform document-oriented database. Classified as a NoSQL database, MongoDB eschews the traditional table-based relational database structure in favor of JSON-like documents with dynamic schemas (MongoDB calls the format BSON), making the integration of data…
[root@dbversitydotcom bin]# cat /etc/mongod.conf # MongoDB Configuration File # General Settings fork = true quiet = true smallfiles = true # Logging verbose = true logappend = true logpath = /opt/mongodb/mongod.log # Security auth = true #setParameter = supportCompatibilityFormPrivilegeDocuments=0 #setParameter…
Amazon Aurora is a MySQL-compatible, relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. Amazon Aurora provides up to five times better performance than MySQL at a…
MariaDB is a drop-in replacement for MySQL. MariaDB strives to be the logical choice for database professionals looking for a robust, scalable, and reliable SQL server. To accomplish this, the MariaDB Foundation work closely and cooperatively with the larger community…
If you need to do an aggregation in MongoDB on a DateTime property and you want to aggregate only by Date part, you can use a simple trick and use a filter to compose the date part before the grouping….
MongoDB supports partitioning data using either a user-defined shard key index (composed of one or more fields present in all documents) or based on a hashed index on a single field (which also much be present in all documents). A…
Writing Complex MongoDB Queries Using QueryBuilder MongoDB provides a lot of query selectors for filtering documents from a collection. Writing complex queries for MongoDB in Java can be tricky sometimes. Consider below data present in student_marks collection rs1:PRIMARY> db.dbversit.insert({“_id” :…
How do we review and set resource limits : Here’s the command to see unlits is below [root@dbversitydotcom oracle]# ulimit -a core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks,…