Guide can be found at https://www.percona.com/doc/percona-xtradb-cluster/5.7/howtos/upgrade_guide.html. There is no need to re-invent the wheel. I am too lazy to do it. Issue 1: If you are running mysql_upgrade and face the following error: “mysql_upgrade: [ERROR] 1136: Column count doesn’t match value count at row 1”, just do as follows: Clone https://github.com/mysql/mysql-sys and go to this folder. Run…
This quick guide is to help you setup ReactJS Development environment with Babel and WebPack. The post is mostly copied from Source: https://www.codementor.io/reactjs/tutorial/beginner-guide-setup-reactjs-environment-npm-babel-6-webpack. I post it here for later personal reference. Let’s start from scratch Create a new folder ‘react-hello-world’ and initialize it with npm. [bash]mkdir react-hello-world cd react-hello-world npm init[/bash] Accept the default for all…
Quick note here the necessary steps to install and run Selenium with FireFox browser in CentOS. We will need to setup XWindows for Headless Selenium with FireFox webdriver. First, install Xvfb: [bash]yum -y install firefox Xvfb libXfont Xorg[/bash] Then, install X-desktop: [bash]yum -y groupinstall "X Window System" "Desktop" "Fonts" "General Purpose Desktop"[/bash] Next, launch a XWindows Virtual…
Today I will mention how to install Jenkins and necessary plugins/tools for doing Continuous Integration. This is just a very first step of using Jenkins for PHP Continuous Integration work. I choose to start with a Virtual Machine with Ubuntu 16 and use LAMP with PHP7 for the web stack. First, we will use Apache…
Just a quick introduction for OpenVPN installation since there is a good work from https://github.com/Nyr/openvpn-install that helps install in 1-click. I just add some extra notes when installing as well as connecting for future references. First, run the one-step installation command: [bash]wget https://git.io/vpn -O openvpn-install.sh && bash openvpn-install.sh[/bash] When installing, just remember to choose “1) Current system resolvers”…
Today I will brief necessary steps for installing OpenVPN server CentOS 7. This will include custom server name and also rules for csf firewall which is widely used. The OpenVPN server name in this tutorial will be myvpnserver, associated domain will be myvpnserver.myserver.com, and server IP address is XXX.YYY.ZZZ.UUU . We will user a self-signed certificate…
Do not want to mention what Chef is, or what Let’s Encrypt is. This is just a short step-by-step tutorial to guide you how to install Chef server Lets Encrypt for the server SSL. Setup Let’s Encrypt First, install let’s encrypt to generate a standalone certificate before installing chef server: [bash]git clone https://github.com/letsencrypt/letsencrypt cd letsencrypt…
When migrating gitlab to a new server, you might face much problems of in-compatible versions, different OS (so different latest gitlab version), etc. The best way is to upgrade the old server to the same latest gitlab version, then backup gitlab, and then transfer the backup to the new server, install same latest gitlab version…
UPDATE: It seems Amazon has banned ACD_CLI. I contacted Amazon to see what is their suggestion. So waiting for a feedback from them now. We are going to connect to Amazon Cloud Drive from Debian Command line to utilize the benefit of unlimited cloud storage. Even there are various tutorials out there, finding a really…
If you are running an EC2 instance behind an Amazon Elastic Load Balancer (ELB), you’ll find that the visitors’ IPs are hided behind the load balancer, so your application cannot get the clients’ real IPs. In fact, visitors’ original IPs are passed via a X-Forwarded-For information in the header (http://docs.aws.amazon.com/ElasticLoadBalancing/latest/DeveloperGuide/x-forwarded-headers.html), so we can easily get…