Alexander sasha-id
sasha-id
/ gist:2df77ec7c3b27b965f3b7ac0a997ce36
Created
January 21, 2021 05:45
— forked from den-crane/gist:6eff375752a236a456e1b3dc2ca7db62
Clickhouse example AggregatingMergeTree, (max, min, avg ) State / Merge
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DROP TABLE IF EXISTS requests; | |
| CREATE TABLE requests ( | |
| request_date Date, | |
| request_time DateTime, | |
| response_time Int, | |
| request_uri String) | |
| ENGINE = MergeTree(request_date, (request_time, request_uri), 8192); | |
sasha-id
/ ssl_puma.sh
Last active
September 14, 2019 05:45
— forked from tadast/ssl_puma.sh
localhost SSL with puma
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # | |
| # Use just this: | |
| openssl req \ | |
| -newkey rsa:2048 \ | |
| -x509 \ | |
| -nodes \ | |
| -keyout server.key \ | |
| -new \ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| To install this init script, you should save mongodb to /etc/init.d/ and mongosharding.conf to /etc/ | |
| then run the following commands as root or with sudo: | |
| chmod 755 /etc/init.d/mongodb | |
| chown root:root /etc/init.d mongodb | |
| update-rc.d mongodb defaults | |
| This installation procedure was tested on UBUNTU 11.10 |