( E – Elasticsearch, L – Logstash , K – Kibana ) Elasticsearch ( search, analyze in real-time. sweet.) —————– Elasticsearch is a flexible and powerful open source, distributed, real-time search and analytics engine. Architected from the ground up for…
Elasticsearch, the distributed restful search and analytics :- ———————————————————————— Elasticsearch is a flexible and powerful open source, distributed, real-time search and analytics engine. Architected from the ground up for use in distributed environments where reliability and scalability are must haves,…
Understanding NoSQL NoSQL refers to a database that is not based on SQL (Structured Query Language), which is the language most commonly associated with relational databases. Essentially, NoSQL data isn’t relational, NoSQL databases usually do not have schema, and they…
If the table has a multiple-column index, any leftmost prefix of the index can be used by the optimizer to find rows. For example, if you have a three-column index on (col1, col2, col3), you have indexed search capabilities on…
SERVER SETTINGS (my.cnf) ======================================================= #The MySQL server always must be started with the option ignore_builtin_innodb, as long as you want to use the InnoDB Plugin as a shared library. ignore_builtin_innodb #load the InnoDB Plugin and all Information Schema tables…
![[MySQL]: Cluster Architecture](http://dbversity.com/wp-content/uploads/2014/11/mysql_cluster_acchitecture-150x150.png)
Introduction: MySQL Cluster is a write-scalable, real-time, ACID-compliant transactional database, combining 99.999% availability with the low TCO of open source. Designed around a distributed, multi-master architecture with no single point of failure, MySQL Cluster scales horizontally on commodity hardware to…
I found below is an interesting discussion and wanted to share with you. There are two sections for rows in the page format for InnoDB compressed tables. The compressed section has one or more rows and must be decompressed to…
Imagine you’ve a flat CSV something like below, but you wanted to create a nested document something like dbversity collection below with mongoimport – how do we do ? Files,FileName,Extension,Size,SubFolders \\dbversity\\dbversity_files,dbversity_file00.db,db,1024,Subfolder1 \\dbversity\\dbversity_files,dbversity_file11.db,db,500,Subfolder2 \\dbversity\\dbversity_file1,dbversity_file22.db,db,250,Subfolder1 [root@dbversity ~]# mongo –port 27010 MongoDB shell…
Running Multiple MySQL Instances on One Machine In some cases, you might want to run multiple instances of MySQL on a single machine. You might want to test a new MySQL release while leaving an existing production setup undisturbed….
Backup and Recovery It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users deleting data…