aamsur-mkt

redis-cli -h 9.9.9.9 -p 6379 -a authkey -n indexdb --scan --pattern *yourfpattern* | xargs redis-cli -h 9.9.9.9 -p 6379 -a authkey -n indexdb del

# first syntax will show list of keys
redis-cli -h 9.9.9.9 -p 6379 -a authkey -n indexdb --scan --pattern *yourfpattern*

aamsur-mkt

UPDATE db_rumah_sakit
SET icon = REPLACE (icon, 'https://from.url.com', 'http://to.url.com')
where icon like 'https://from.url.com%'

aamsur-mkt

CREATE USER 'user'@'%' IDENTIFIED BY 'yourfpassword';
GRANT SELECT ON *.* TO 'user'@'%';
FLUSH PRIVILEGES;

# ALL PRIVILEGES- as we saw previously, this would allow a MySQL user full access to a designated database (or if no database is selected, global access across the system)
# CREATE- allows them to create new tables or databases
# DROP- allows them to them to delete tables or databases
# DELETE- allows them to delete rows from tables
# INSERT- allows them to insert rows into tables
# SELECT- allows them to use the SELECT command to read through databases

aamsur-mkt

ALTER USER 'user'@'%' IDENTIFIED BY 'yourfpassword';
FLUSH PRIVILEGES;

aamsur-mkt

https://www.tecmint.com/setup-mysql-master-slave-replication-on-ubuntu/ 18.04
https://technologyrss.com/mysql-master-slave-replication/ 14.04

dont forget to dump master db to slave db first!

aamsur-mkt

create database new_f_database
with
owner=yourfuser;

aamsur-mkt

$ sudo nano /etc/hosts

# add yourfhostname after localhost
# example :
# 127.0.0.1 localhost yourfhostname
# then save

$ sudo hostnamectl set-hostname yourfhostname

# check the result with: 

aamsur-mkt

$ sudo apt-get update
$ sudo apt-get install docker.io
$ sudo curl -L https://github.com/docker/compose/releases/download/1.24.1/docker-compose-`uname -s`-`uname -m` -o /usr/local/bin/docker-compose
$ sudo chmod +x /usr/local/bin/docker-compose
$ docker-compose -v

aamsur-mkt

$ sudo apt-get update
$ sudo apt-get install docker.io
$ sudo curl -L https://github.com/docker/compose/releases/download/1.24.1/docker-compose-`uname -s`-`uname -m` -o /usr/local/bin/docker-compose
$ sudo chmod +x /usr/local/bin/docker-compose
$ docker-compose -v

$ sudo usermod -a -G docker $USER
$ sudo newgrp docker # add user to docker group without restart

$ sudo systemctl enable docker # Auto-start on boot

aamsur-mkt

good artikel, read here
https://medium.com/@rahulian/how-to-reduce-volume-of-an-aws-ec2-instance-d493ec891698

also the problems here
https://serverfault.com/questions/673048/how-to-reduce-aws-ebs-root-volume-size