Skip to content

Instantly share code, notes, and snippets.

View luanvuhlu's full-sized avatar

luan vu luanvuhlu

32 followers · 2 following
View GitHub Profile
@luanvuhlu
luanvuhlu / liquibase.sh
Last active August 25, 2021 05:31
liquibase generateChangeLog https://docs.liquibase.com/commands/community/generatechangelog.html
docker run -v <folder-to-save-sql>:/liquibase/changelog liquibase/liquibase \
--driver=<jdbc-driver> --url=<jdbc-url> \
--changeLogFile=“/liquibase/changelog/changelog.oracle.sql” \
--diffTypes=“catalog,tables,functions,views,columns,indexes,foreignkeys,primarykeys,
uniqueconstraints,data,storedprocedure,triggers,sequences” \
--username=<user> \
--password=<pass> \
generateChangeLog
@luanvuhlu
luanvuhlu / pom.xml
Created August 20, 2021 14:30
aws-secretsmanager-jdbc
<dependency>
<groupId>com.amazonaws.secretsmanager</groupId>
<artifactId>aws-secretsmanager-jdbc</artifactId>
<version>1.0.5</version>
</dependency>
@luanvuhlu
luanvuhlu / application.yml
Last active August 20, 2021 15:18
spring:
datasource:
url: jdbc-secretsmanager:mysql://database-host:3306/rdsdb
username: rdsrotation
driver-class-name: com.amazonaws.secretsmanager.sql.AWSSecretsManagerMySQLDriver
@luanvuhlu
luanvuhlu / oracle docker.sh
Last active September 6, 2021 04:02
docker pull store/oracle/database-enterprise:12.2.0.1-slim
docker volume create OracleData
docker run -d -v OracleData:/ORCL -p 1521:1521 --name oracle store/oracle/database-enterprise:12.2.0.1
# Wait a few minutes
docker exec -it oracle bash -c "source /home/oracle/.bashrc; sqlplus /nolog"
connect sys as sysdba;
# Password ORCLCDB
alter session set "_ORACLE_SCRIPT"=true;
create user luan identified by "80dl20h";
@luanvuhlu
luanvuhlu / sonarqube-docker-compose.yml
Created May 19, 2021 10:51 — forked from Warchant/sonarqube-docker-compose.yml
docker-compose file to setup production-ready sonarqube
version: "3"
services:
sonarqube:
image: sonarqube
expose:
- 9000
ports:
- "127.0.0.1:9000:9000"
networks:
@luanvuhlu
luanvuhlu / Install protobuf 3 on Ubuntu
Created January 6, 2021 07:52 — forked from lnquy/Install protobuf 3 on Ubuntu
# Make sure you grab the latest version
curl -OL https://github.com/google/protobuf/releases/download/v3.4.0/protoc-3.4.0-linux-x86_64.zip
# Unzip
unzip protoc-3.4.0-linux-x86_64.zip -d protoc3
# Move protoc to /usr/local/bin/
sudo mv protoc3/bin/* /usr/local/bin/
# Move protoc3/include to /usr/local/include/
@luanvuhlu
luanvuhlu / install_mysql_client.sh
Created December 4, 2020 06:26 — forked from sshymko/install_mysql_client.sh
Install MySQL 5.7 client on Amazon Linux 2
#!/bin/sh
sudo yum install -y https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
sudo yum install -y mysql-community-client
@luanvuhlu
luanvuhlu / User-Data.txt
Created June 14, 2020 15:54
Tự động run khi launch một EC2 instance mới https://aws.amazon.com/premiumsupport/knowledge-center/execute-user-data-ec2/
Content-Type: multipart/mixed; boundary="//"
MIME-Version: 1.0
--//
Content-Type: text/cloud-config; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment; filename="cloud-config.txt"
#cloud-config
@luanvuhlu
luanvuhlu / User-Data.txt
Created June 14, 2020 15:54
Tự động run khi launch một EC2 instance mới
Content-Type: multipart/mixed; boundary="//"
MIME-Version: 1.0
--//
Content-Type: text/cloud-config; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment; filename="cloud-config.txt"
#cloud-config
@luanvuhlu
luanvuhlu / elb_logs_create.sql
Created November 29, 2019 09:40
Load AWS ELB logs to MySQL
CREATE TABLE `elb_logs` (
`type` varchar(10) DEFAULT NULL,
`timestamp` varchar(30) DEFAULT NULL,
`elb` varchar(50) DEFAULT NULL,
`client:port` varchar(30) DEFAULT NULL,
`target:port` varchar(30) DEFAULT NULL,
`request_processing_time` varchar(10) DEFAULT NULL,
`target_processing_time` varchar(10) DEFAULT NULL,
`response_processing_time` varchar(10) DEFAULT NULL,
`elb_status_code` varchar(5) DEFAULT NULL,