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’…
[MongoDB]: Max Query buffer size
Most of you, if you run a query with more than 4096 characters, you’ll see error as below. SyntaxError: Unexpected token ILLEGAL I know lots of have below queries in mind ? 1) What is max size query…
Joins in MongoDB ($lookup)
Performs a left outer join to an unsharded collection in the same database to filter in documents from the “joined” collection for processing. Joins in MongoDB is introduced in MongoDB 3.2 with $lookup aggregate. Compared to SQL server it is…
MongoDB YCSB with Sar – Automated script
[ root @ DBVERSITY: /opt/ycsb/ycsb ] ll -lhtr total 6.9M -rw-r–r– 1 1000545644 2000048971 3.0K Jan 3 2014 workloada -rw-r–r– 1 1000545644 2000048971 209 Jan 3 2014 root.iml -rw-r–r– 1 1000545644 2000048971 952 Jan 3 2014 README -rw-r–r– 1…
Fresher Openings in Deloitte, Wipro – Hyd/B’lore/Pune
Wipro Fresher Openings at Pune *Need urgently 275 BE computers candidates with or without experience for wipro pune location.* *Pls inform anybody if u know.* *Salary 35 to 45 k take home. 2 years bond. Confirmation based on work…
MariaDB/MySQL Database Hardening
1) Start the server using –skip-show-database option. 2) All LOAD DATA LOCAL statements can be disabled from the server side by starting mysqld with the –local-infile=0 option. 3) Disable command history by setting MYSQL_HISTFILE to /dev/null or linking mysql_history to…
[MariaDB]: How to disable load data and enable skip_show_database
[ root @ dbversity : /etc/opt/rh/rh-mariadb101 ] sed “s/#skip-show-database/skip-show-database/g” my.cnf | grep skip skip-show-database [ root @ dbversity : /etc/opt/rh/rh-mariadb101 ] [ root @ dbversity : /etc/opt/rh/rh-mariadb101 ] sed -i “s/#skip-show-database/skip-show-database/g” my.cnf [ root @ dbversity : /etc/opt/rh/rh-mariadb101 ] […
how to disable mysql_history in MariaDB/MySQL
MariaDB/MySQL stores the commands typed in the mysql> prompt in the ~/.mysql_history file. [ root @ dbversity : ~ ] ll -lhtr .mysql_history -rw——- 1 root root 19K Jun 15 06:12 .mysql_history [ root @ dbversity : ~ ] …
Don’t miss the 2nd annual MongoDB Community Open House
Maybe people from Percona at this event will be able to tell us why they are more focused on MongoDB instead of MariaDB… View in browser Mark your calendar! We’re excited to announce the 2nd annual…