MySQL/MariaDB vs MongoDB Privileges Comparision
privileges_comparision_mysql_or_mariadb_vs_mongodb
How to Transition from SQL to MongoDB
How to Transition from SQL to MongoDB It’s the ultimate question. Five years ago you would have looked at your company’s environment and you have said “we’re a SQL shop.” The same was true of MongoDB’s 3000+ customers before they…
MariaDB: What is buzzing ?!
MARIADB NEWSLETTER October 2016 Welcome to the MariaDB newsletter, which features our latest updates, news, events and more. There’s so much going on that we can’t possibly fit it all into one newsletter, so keep an eye on mariadb.com to learn…
MariaDB “JDBC/Connector J” Connection with SSL enabled.
[root@dbversity-com rh-mariadb101]# cat /etc/opt/rh/rh-mariadb101/my.cnf # This group is read both both by the client and the server # use it for options that affect everything [client-server] #################### <– Client-Server SSL Options–> ####################################### ssl ssl-cipher = AES128+EECDH:AES128+EDH ssl-ca = /etc/opt/rh/rh-mariadb101/pki/ca.pem ssl-cert…
MariaDB ODBC Driver (Connector/ODBC) testing
root@dbversity-com ]# ll -lhtr -rw-r–r– 1 698K Oct 4 06:42 mariadb-connector-odbc-2.0.12-ga-linux-x86_64.tar.gz [root@dbversity-com ]# [root@dbversity-com ]# [root@dbversity-com ]# [root@dbversity-com ]# tar -zxvf mariadb-connector-odbc-2.0.12-ga-linux-x86_64.tar.gz mariadb-connector-odbc-2.0.12-ga-linux-x86_64/lib64/libmaodbc.so mariadb-connector-odbc-2.0.12-ga-linux-x86_64/share/doc/mariadb_connector_odbc/COPYING mariadb-connector-odbc-2.0.12-ga-linux-x86_64/share/doc/mariadb_connector_odbc/README [root@dbversity-com ]# [root@dbversity-com ]# [root@dbversity-com ]# [root@dbversity-com ]# ll -lhrt -rw-r–r– 1 698K Oct 4…
Configuring MariaDB With PAM/Kerberos
Please note below directions assume the system is already setup to use AD for user logins. What is here will enable a MariaDB to leverage a system’s current setup. It will not deploy AD from scratch. As of MariaDB 5.0,…
[MongoDB]: For loop to generate documents with array, sub and nested documents
Find below sample for loop to generate a document with array, sub-document, nested-document use mydb db.studentscol.drop() for(var i = 1; i <= 1000 ; i++){var r= Math.random().toString(36).substring(7); db.studentscol.insert( { _id:i, name:r, address: { address_id:i, state:r,country:”India”,street:{name:r,colony:{ name:r,pin:r}}}, hobbies: [{h1:r},{h2:r},{h3:r},{h4:r}] });} //…
MongoDB DBA : Roles and Responsibilities
Roles & Responsibilities 01) Defragmentation 02) Schema Design – working with Application/Development team 03) Query fine tuning 04) Shell scripts for Monitoring like ‘slow queries’, replication lag, nodes fails, disk usage .. etc 05) Backup and restores (…
MongoDB: Working with JS ( For Loop)
MongoDB itself has provided some basic looping mechanism through which you can achieve iteration functionality. let’s discuss one by one. FOR LOOP:- For loop is a basic loop available in mongodb and its syntax is just same as we have…
MongoDB 3.2 CSharp Driver 2.2 Testing with SSL & Kerberos Enabled
using System; using MongoDB.Bson; using MongoDB.Driver; using MongoDB.Driver.Builders; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace ConsoleApplication1 { class Program { protected static IMongoClient _client; protected static IMongoDatabase _database; public static void Main(string[] args) { var credential = MongoCredential.CreateGssapiCredential(“user@DBVERSITY.COM”);…