We did this by using pt-online-schema-change 1. Since we are using RDS with Read Replica, and the tool require log_bin_trust_function_creators = 1, we did a failover to Read Replica, modifying parameter group of Master, reboot Master, then failback to Master and repeat this for Read Replica. If you have SUPER privilege of the DB, skip this step. 2. Prepare a…
I has been asked how to make Laravel run in Docker, and more importantly how to deploy it to a production server, since then I have been exploring for options and Laradocks seems to be a simplified way to go for. So before digging into Laradock, will be doing a vanilla dockerization to get the concept clear first. 1. Get…
It’s kind of pain to SSH into staging server and run git pull whenever there’s any code change in Master repo for testing in the staging server. It would save some time if whenever there’s a push to Master, Gitlab will automatically deploy the latest code to staging server for testers to test it out. It’s confusing as there’s private…
There are tons of tutorials sharing about how to host WordPress on the Cloud, this series of articles are to share our cloud methodology, and technology how Artisan deploy WordPress on the Alibaba Cloud. The process of deployment is always: 1. optimize current architecture, cache all you can, doing so will help you to save unnecessary scaling cost (why scale…
When we first tried to launch our first instance on Alibaba Cloud, intuitively we picked the default burstable type T5. Once launched, we are shocked, by the speed of running a simple apt-get update, how can it be so slow, it took 2 minutes for it to be completed. Kept exploring and found this instance type: The cost is slightly…
We were getting this letsencrypt renewal error on some Ubuntu 16.04 machines: OSError: Command /opt/eff.org/certbot/venv/bin/python2.7 – setuptools pkg_resources pip wheel failed with error code 1 Googling around, hit a few walls and finally found the solution, just need to run this in Ubuntu: export LC_ALL=”en_US.UTF-8″ export LC_CTYPE=”en_US.UTF-8″ Then continue on with the letsencrypt-auto script will do.
If you are getting ‘running out of space’ from your SSH console, but running a df -h shows that there are still plenty of free space left, then most likely inode is the one that run out. To confirm it, just run the command df -i from the result you should be able to a 100% in the mount point, for…
Freedom and flexibility are the main reasons people move to cloud, especially when there are tools like AWS RDBMS. They allow you to move to cloud and freed from your current on-premise vendor. With a BONUS! They also provide the tool that can help you to convert your database from one platform to another, FREEDOM!!! But without realizing it, we are merely…
As discussed in previous posts like public vs private cloud, you are getting vCPU for your public cloud servers, which is shared among other VMs in the same hypervisor. But how do you know if the hypervisor, the physical hardware CPU itself is being overpopulated? What you need to do is: SSH to your server Run the top command: type top…
What’s the difference between Public and Private The only main difference between the two is simple: Using public cloud: Sharing the physical hardware with other user Using private cloud: All the VM is sitting on your dedicated servers, sharing resource with no others but your own VM A wider definition of ‘Cloud’ itself could simply be – Offsite infrastructure /…