SQL Converter
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 ?
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…
The Elasticsearch ELK Stack
( 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
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,…
What is NoSQL ?
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…
[MySQL]: optimizer Index strategy
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…
[MySQL]: Innodb plugin 1.0.4 fine tune for performance
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](https://dbversity.com/wp-content/uploads/2014/11/mysql_cluster_acchitecture-150x150.png)
[MySQL]: Cluster Architecture
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…
[MySQL]: When does InnoDB compress and decompress pages?
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…
[MongoDB]: How to get nested document thru mongoimport
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…