MongoDB: Understanding Oplog
The following table clearly explains what each Oplog field denotes. Field Name Alias Details Operations Values ts TimeSpace Holds the “Time of the operation” & “incremental id”. For all bulk (insert/remove/update) operations “Time of the operation” remains same and…
MemSQL’s Kerberos setup with SSL
As of MemSQL 5.0, MemSQL includes an authentication plugin that enables a MemSQL Server to use PAM (Pluggable Authentication Modules) to authenticate users. PAM enables a system to use a standard interface to access various kinds of authentication…
[MariaDB]: Enforcing SSL for all connections
If we’ve configured required ssl configuration in the my.cnf and enabled ssl globally with required variables (have_ssl, have_open_ssl). Though we create users without REQUIRE SSL privilege, they will use SSL connection. [ root @ dbversity : /var/lib/mysql ] grep ‘ssl’…
RHEL’s MariaDB : how to do I add service script in Linux’s startup.
[ root @ my-host-name : ~ ] ps -ef | grep mysql root 2158 1 0 02:36 ? 00:00:00 /bin/sh /opt/rh/rh-mariadb101/root/usr/bin/mysqld_safe –datadir=/var/opt/rh/rh-mariadb101/lib/mysql –socket=/var/lib/mysql/mysql.sock –pid-file=/var/run/rh-mariadb101-mariadb/mariadb.pid –basedir=/opt/rh/rh-mariadb101/root/usr –user=mysql mysql 2332 2158 0 02:36 ? 00:00:00 /opt/rh/rh-mariadb101/root/usr/libexec/mysqld –basedir=/opt/rh/rh-mariadb101/root/usr –datadir=/var/opt/rh/rh-mariadb101/lib/mysql –plugin-dir=/opt/rh/rh-mariadb101/root/usr/lib64/mysql/plugin/ –user=mysql –log-error=/var/opt/rh/rh-mariadb101/log/mariadb/mariadb.log –pid-file=/var/run/rh-mariadb101-mariadb/mariadb.pid…
Neo4j Installation
Go to http://neo4j.com/download/ and download the Community edition. This should download Neo4j 2.3 Based on your download type, follow the appropriate instructions. Linux/Mac/Windows zip Untar/unzip the download Run command: bin/neo4j start for Linux/Mac or just bin/neo4j for Windows Go to http://localhost:7474/ and verify that the Neo4j Browser loads Shut it down with a bin/neo4j stop for Linux/Mac or Ctrl C for Windows Windows Installer 1. Install neo4j and launch it 2. Click on Browse and select a database location (create a new folder, say c:\tutorial) 3. Click start 4. Go to http://localhost:7474/ and verify that the Neo4j Browser loads Install docs are located at http://neo4j.com/docs/stable/serverinstallation.html
Intro to Neo4j webinar
Webinar | Thursday, July 21st Intro to Neo4j Webinar Thursday, July 21st 9:00 PDT | 12:00 EDT Register Now In this introduction to Neo4j and Graph Databases, we discuss the primary use cases for Graph Databases and explore the properties…
How MongoDB’s Plan Cache works !
When queries will get cached in MongoDB ? To answer this, not all queries automatically place a query plan in the cache. The query optimizer only caches the plans for those query shapes that can have more than one “viable/feasible…
Webinar | MongoDB vs. Couchbase Server – Architecture & Code
Have you been curious about the difference in architecture between MongoDB and Couchbase Server? Then this is the perfect time to learn more. Join my live webinar on Thursday, 21 July at 10:00 a.m. BST where I’ll discuss: The most…
MariaDB User Management
CREATE [OR REPLACE] USER [IF NOT EXISTS] user_specification [,user_specification] … [ REQUIRE {NONE | tls_option [[AND] tls_option] …} ] [ WITH resource_option [resource_option] … ] ; user_specification: username [authentication_option] authentication_option: IDENTIFIED BY ‘authentication_string’ | IDENTIFIED BY PASSWORD ‘hash_string’…