MemSQL on Debian – small notes

For installation requires at least 4 CPUs and 16 GB of RAM and for a good reason. If you have for example 10 GB of mysql data and you want to feed it into MemSQL you will need at least 15 GB of RAM just for these data. config files – in subdirectories of the...

MEMSQL – small notes

Small notes: MemSQL is compatible with MySQL client. You can connect to MemSQL from any DB GUI or programming language which already can connect to MySQL. MemSQL does NOT have stored procedures, foreign keys, integrity constrains MemSQL HAS window functions and...

MemSQL – commands cheat sheet

MemSQL SQL reference Every command can end with “;” (columns all in one row) or “\G” (every column on separate row). CREATE TABLE: SHARD KEY – sets column(s) for partitioning KILL: kill [ connection | query ] thread_id KILLALL: killall...

Elasticsearch – make your own docker image

I have read several articles on internet about how to make your own docker image and after several tests I can say that only way which worked for me was to use official elasticsearch image and modify it. But do not try to change resulting CMD. So I created something...