Run through the following steps to setup this project on your local environment. These instructions assume you're using the standard Classy Llama devenv.
Use the following to connect to stage.
Step 1: Upgrade Packages | |
# yum update | |
# yum groupinstall "Development Tools" | |
Step 2: Installing Recommended Packages | |
# yum install gcc-c++ patch readline readline-devel zlib zlib-devel | |
# yum install libyaml-devel libffi-devel openssl-devel make | |
# yum install bzip2 autoconf automake libtool bison iconv-devel | |
Step 3: Install RVM ( Ruby Version Manager ) |
# https://goaccess.io/ | |
yum install -y glib2 glib2-devel glibc make geoip geoip-devel ncurses-devel | |
cd ~/ | |
wget http://tar.goaccess.io/goaccess-1.1.1.tar.gz | |
tar -xzvf goaccess-1.1.1.tar.gz | |
cd goaccess-1.1.1/ | |
./configure --enable-geoip --enable-utf8 | |
make | |
make install |
[Install] | |
WantedBy=multi-user.target | |
[Unit] | |
Description=Google Cloud Compute Engine SQL Proxy | |
Requires=networking.service | |
After=networking.service | |
[Service] | |
Type=simple |
#file proxysql.cfg | |
# This config file is parsed using libconfig , and its grammar is described in: | |
# http://www.hyperrealm.com/libconfig/libconfig_manual.html#Configuration-File-Grammar | |
# Grammar is also copied at the end of this file | |
datadir="/var/lib/proxysql" |
FROM debian:jessie | |
ENV BUILD_PKG "automake bzip2 cmake make g++ gcc git-core libssl-dev patch binutils" | |
RUN apt-get update && apt-get install -y \ | |
libssl1.0.0 openssl ssl-cert $BUILD_PKG \ | |
vim mysql-client && \ | |
cd /usr/local/src && \ | |
git clone -b 2018-04-01 --depth 1 --single-branch https://github.com/google/re2.git && \ | |
git clone -b v2.0.0 --depth 1 --single-branch https://github.com/sysown/proxysql.git && \ |
#file proxysql.cfg | |
# This config file is parsed using libconfig , and its grammar is described in: | |
# http://www.hyperrealm.com/libconfig/libconfig_manual.html#Configuration-File-Grammar | |
# Grammar is also copied at the end of this file | |
datadir="/var/lib/proxysql" | |
admin_variables= | |
{ |
FROM debian:jessie | |
ENV BUILD_PKG "automake bzip2 cmake make g++ gcc git-core libssl-dev patch binutils" | |
RUN apt-get update && apt-get install -y \ | |
libssl1.0.0 openssl ssl-cert $BUILD_PKG \ | |
vim mysql-client && \ | |
cd /usr/local/src && \ | |
git clone -b 2018-04-01 --depth 1 --single-branch https://github.com/google/re2.git && \ | |
git clone -b v1.4.8 --depth 1 --single-branch https://github.com/sysown/proxysql.git && \ |
# List the composer home directory | |
# Typically /Users/<user>/.composer or /home/<user>/.composer or C:\Users\<user>\AppData\Roaming\Composer | |
echo $COMPOSER_HOME | |
# List files in the composer home | |
ls -la $COMPOSER_HOME | |
# View auth.json in composer home used when no local ./auth.json exists in the directory executed from | |
cat $COMPOSER_HOME/auth.json |
Run through the following steps to setup this project on your local environment. These instructions assume you're using the standard Classy Llama devenv.
Use the following to connect to stage.
# Consider filtering the varnishlog output | |
# https://feryn.eu/blog/varnishlog-measure-varnish-cache-performance/ | |
varnishlog -i "RespHeader,Req*" -X "RespHeader:(x|X)-" -I "timestamp:Resp" -x reqprotocol,reqacct -g request | |
# Capture the log output from varnishlog and look for BereqHeader | |
# -n name is how you can specify a specific named instance of varnish | |
# remove -n if you just want to access the default instance | |
varnishlog -n stage |