Server Price Breakdown: DigitalOcean, Amazon AWS LightSail, Vultr, Linode, OVH, Hetzner, Scaleway/Online.net:
Permalink: git.io/vps
Provider | Type | RAM | Cores | Storage | Transfer | Network | Price |
---|
# Source: https://gist.github.com/b068c3eadbc4140aed14b49141790940 | |
###################### | |
# Create The Cluster # | |
###################### | |
az login | |
az provider register -n Microsoft.Network |
# Source: https://gist.github.com/d73fb6f4ff490f7e56963ca543481c09 | |
#################### | |
# Create a cluster # | |
#################### | |
# Follow the instructions from https://github.com/weaveworks/eksctl to intall eksctl if you do not have it already | |
export AWS_ACCESS_KEY_ID=[...] # Replace [...] with the AWS Access Key ID |
# Source: https://gist.github.com/88e810413e2519932b61d81217072daf | |
###################### | |
# Create The Cluster # | |
###################### | |
gcloud auth login | |
# Open https://console.cloud.google.com/cloud-resource-manager to create a new project if you don't have one already |
# Source: https://gist.github.com/69bfc361eefd0a64cd92fdc4840f7aed | |
###################### | |
# Creating A Cluster # | |
###################### | |
# NOTE: Docker Desktop and Minikube can be used only in some of the exercises | |
# Docker Desktop with Istio: https://gist.github.com/9a9752cf5355f1b8095bd34565b80aae (docker-istio.sh) | |
# Minikube with Istio: https://gist.github.com/a5870806ae6f21de271bf9214e523b53 (minikube-istio.sh) |
# Source: https://gist.github.com/d81f114a887065a375279635a66ccac2 | |
###################### | |
# Creating A Cluster # | |
###################### | |
# NOTE: A new and improved cluster creation Gists for GKE, EKS, and AKS | |
# Docker Desktop with Istio: https://gist.github.com/9a9752cf5355f1b8095bd34565b80aae (docker-istio.sh) | |
# Minikube with Istio: https://gist.github.com/a5870806ae6f21de271bf9214e523b53 (minikube-istio.sh) |
# as root | |
snap list | |
systemctl disable snapd.service | |
systemctl disable snapd.socket | |
systemctl disable snapd.seeded.service | |
snap remove lxd | |
snap remove core20 | |
snap remove snapd | |
snap list | |
apt autoremove --purge snapd |
#!/bin/bash | |
###################################################################################################### | |
### SCRIPT : sync_db.sh | |
### AUTHOR : CGIL <cgil@lausanne.ch> | |
### DATE : 2023-05-10 | |
### DESCRIPTION : this script allows to synchronize the database with a backup available in backup_url | |
### expects one parameter with the name of the database you want to synchronize | |
### the current dataabse is not renamed to old if the new one does not contain MIN_NUM_TABLES | |
###################################################################################################### | |
if [ $# -eq 0 ] |
cd /opt | |
mkdir curl_local | |
cd curl_local/ | |
wget https://curl.se/download/curl-8.0.1.tar.gz | |
tar xvfz curl-8.0.1.tar.gz | |
apt-get install libssl-dev autoconf libtool make build-essential libnghttp2-dev libssl-dev | |
cd curl-8.0.1/ | |
./buildconf | |
./configure --with-gnutls --with-openssl --with-kerberos --with-nghttp2 | |
make |
/* I got data like this in a table firstname | |
id firstname gender origin frequency | |
5220 janis (1) m latvian 0 | |
5221 janis (2) f english 0 | |
9841 shay (1) m irish, english 0 | |
9842 shay (2) m,f jewish 0 | |
10002 simone (1) f french 0 | |
10003 simone (2) m italian 0 | |
and I need to remove the (1) and group the information in gender, origin and frequency like this : |
Permalink: git.io/vps
Provider | Type | RAM | Cores | Storage | Transfer | Network | Price |
---|