kstromeiraos

Prompt with git branch and last command exit code (smiley)

Add this to the bottom of ~/.bash_profile file.

# Prompt
parse_git_branch() {
 git branch 2> /dev/null | sed -e '/^[^*]/d' -e 's/* \(.*\)/ (\1)/'

kstromeiraos

import google.cloud.storage
import random
from subprocess import call

projectId = 'YOUR_PROJECT_ID';
bucketName = 'sqldumpbucket-' + str(random.randint(100000, 999999));

exportDbInstance = 'YOUR_EXPORT_DB_INSTANCE';
exportDbServiceAccount = 'YOUR_EXPORT_DB_SERVICE_ACCOUNT';
exportDbName = 'YOUR_EXPORT_DB_NAME'

kstromeiraos

Edit userDirectory file on Wasabi container

docker exec -it wasabi-main bash -c 'vi $(echo "$WASABI_HOME")/conf/userDirectory.properties'

Clean and restart wasabi

cd wasabi && ./bin/wasabi.sh clean && docker restart wasabi-main

kstromeiraos

Upgrade from Redash v3 to v4

1. Change Docker image tag
2. Connect to redash server container: docker exec -it redash_server bash
3. sudo su redash
4. set -a; . /opt/redash.env; set +a
5. bin/run ./manage.py db upgrade

kstromeiraos

Dump/restore Cassandra and MySQL data for Wasabi

If you have an existing installation of Wasabi on Docker containers and you want to save existing data, follow these steps.

Dump/restore Cassandra data

docker exec -ti wasabi-cassandra bash
apt update && apt install -y git python-pip && pip install cassandra-driver && git clone https://github.com/gianlucaborello/cassandradump && cd cassandradump && python cassandradump.py --keyspace wasabi_experiments --export-file wasabi_cassandra_dump.cql
exit

kstromeiraos

Deploy Wasabi using a remote Cassandra cluster and RDS

What's Wasabi?

Wasabi is a real-time, 100% API driven, A/B Testing platform. The platform offers companies and individuals the opportunity to perform experiments on the web, mobile and desktop for back-end and front-end, products and marketing.

Do you want to know more? Meet Wasabi, an Open Source A/B Testing Platform

Architecture behind Wasabi

kstromeiraos

-- Create Read-Only Group
 
CREATE GROUP ro_group;
 
-- Create User
 
CREATE USER ro_user WITH password 'XXX';
 
-- Add User to Read-Only Group
 

kstromeiraos

-- MySQL dump 10.13  Distrib 5.6.41, for Linux (x86_64)
--
-- Host: localhost    Database: wasabi
-- ------------------------------------------------------
-- Server version	5.6.41

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

kstromeiraos

Keybase proof

I hereby claim:

• I am kstromeiraos on github.
• I am kstromeiraos (https://keybase.io/kstromeiraos) on keybase.
• I have a public key ASCTasJGEED-yZwVMjyVzSRymkrGlZH6gEWi51kW3DQZZAo

To claim this, I am signing this object:

kstromeiraos

#!/usr/bin/env python

'''
List EC2 running instances and their private IPs
'''

import boto3
import sys
from subprocess import call
import argparse