bobstrange

Use cli

Login

influx -username <username> -password <password>
SHOW DATABASES
use <dbname>

bobstrange

#!/bin/bash

TMPFILE=`mktemp /tmp/vipe.bashXXXXXXXX`

command="ls"

$(command) > ${TMPFILE}

confirm_changes_and_update() {
  while true; do

bobstrange

# Put this file to /etc/monit.d/mongo
check process mongod with pidfile /var/run/mongodb/mongod.pid
  group mongod
  start program = "/etc/init.d/mongod start"
  stop program =  "/etc/init.d/mongod stop"
  
  if failed host localhost port 27017 type TCP with timeout 15 seconds then restart
  if 5 restarts within 5 cycles then timeout

bobstrange

/var/log/mongodb/*.log {
   daily
   rotate 3
   copytruncate
   delaycompress
   compress
   dateext
   notifempty
   missingok
}

bobstrange

How to get directive's controller

Sample directive

class MyDirectiveController {
  constructor() {
    this.foo = "bar";
  }
  ...
}

bobstrange

# List mongo collections with count, size and storageSize. Output format is csv
# Usage: 
# mongo export_mongo_collection_size.js --eval "var dbName = 'something'"

const conn = new Mongo();
const database = conn.getDB(dbName);

const collectionNames = database.getCollectionNames();
const fields = [
  "count",

bobstrange

• Open keybindings
  • cmd+k cmd+s
• Install extensions
• shift+cmd+x

bobstrange

require 'sshkit'
require 'sshkit/dsl'
include SSHKit::DSL

require 'aws-sdk'

region      = 'us-west-2'
user        = 'ec2-user'
ssh_options = {
  keys:          ['~/.ssh/id_rsa'],

bobstrange

Show Database size

SELECT 
  table_schema,
  sum(data_length+index_length) / 1024 / 1024 AS 'Total size(MB)'
FROM
  information_schema.tables
GROUP BY
 table_schema

bobstrange

require 'net/https'
require 'uri'
require 'json'
require 'csv'

token = "*******"

def retrieve_stats(token)
  url = "*******"
  uri = URI.parse("https://api.agent-stats.com/groups/#{url}/now")