FFmpeg Video Processing Program
I do not do much crazy editing on my videos on YouTube. However, FFmpeg can also do much sophisticated editing and it is free with countless filters and options. Only your imagination and creativity is the limit here. Only downside I can think of that it only comes with command line interface. It means you […]
Schwinn Shuffle Adult Scooter
This style of a kick scooter is called as Amish kick scooter. Since I have 26 inch Swytch Bike conversion kit. I am wondering how it will perform as a eScooter. Thinking, it will be safer than those eScooter zipping around without any warnings nor safety. I am still debating myself to go with 26 […]
Building Auto Scaling System with LB & ASG on AWS
This blog lists the sequences of AWS services you have to setup for a scalable system. It is not required to setup in this sequence, but I found it is one of straight forward and the easiest way. AWS Certificate Manger Create SSL certificate for your system URL and import it. You can reimport for […]
[Laravel] Starting Laravel Project with existing DB/Schema
DB Settings After creating Laravel project with Composer, you need to modify two files to set DB environment. /config/database.php defines connections with environmental variables sourced from .env file. ‘mysql1’ connection has setting for connecting to ‘mysql1’ schema. ‘mysql2’ connection has setting for connecting to ‘mysql2’ schema. Now, your Laravel project is ready to connect to […]
[Bike] Buffalo Bicycle
While I was looking for a reasonable single speed 26 inch walk-through bicycle, I came across with Buffalo Bicycle. It is made by WORLD BICYCLE RELIEF. They are empowering individuals to access education, healthcare and economic opportunities through life-changing bicycles. In a word, they are designing, building and donating a durable easy-maintenance bicycle to developing […]
[Docker] Setting up website with WordPress Docker on SSL
I used three images in my docker compose yaml file, They are mysql, wordpress and certbot. 1. certbot from Let’s Encrypt certbot is image from Let’s Encrypt and it is free. The docker compose syntax looks as below. When containers are running. certbot container runs only once to generate your certificates. They can be found […]
[Ubuntu] How to build LAMP server 3 of 3 – MySQL
MySQL can be installed as simple as below. mysqld.conf sql_mode can be changed with query as well Root account setting After this, it will be easier to add other users and grant privileges with GUI of MySQL Workbench.
[Ubuntu] How to build LAMP server 2 of 3 – Apache
Apache configuration files for HTTP(Port 80) and HTTPS(Port 443) can be found as below. SSL Secured site can be configured by enabling ssl module and you will need to get SSL certificate in advance. Self-Signed SSL did not work for me. You can get free SSL certificates from Let’s Encrypt. No Browsing and .htaccess It […]
[Ubuntu] How to build LAMP server 1 of 3 – Server
LAMP server used to be installed as default. For 18.04 and 20.04, LAMP server can be installed as below. For 22.04, Apache and MySQL server gets installed for LAMP server as below. Update It is often recommended to run sudo apt-get update and sudo apt-get upgrade before installing packages. You can run sudo unattended-upgrade for […]
[AWS] RDS Instance changes in the cluster with no (much less?) Downtime.
(Source: https://stackoverflow.com/questions/54708210/how-to-change-aws-rds-instance-type-without-downtime) Instead of changing the instance type of the current instance, Add a new instance first. Then, you can delete the old instance in the cluster. There is no way to add the writer instance, So. In order to change the type of a writer instance. This way you will have nearly no downtime. […]