Database and SQL Migration Tools : ========================= This site really worked for me and it can convert a bunch of different DDL commands from Oracle, MySql, MS-SQL Server, Sybase and others. http://www.sqlines.com/online SQLines provides database migration tools: Database Schema (DDL) Conversion…
What is NewSQL : NewSQL is a category of SQL database products that address the performance and scalability issues posed by traditional online transaction processing (OLTP) relational database management systems (RDBMS). Such systems aim to achieve the scalability of NoSQL…
( 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…