DEV Community: Hady Rashwan

Google Cloud Run and MySql using Ruby On Rails

Hady Rashwan — Mon, 24 Aug 2020 12:42:05 +0000

We are going to deploy a rails app into Google Cloud Run and Cloud SQL. This will make the rails app serverless.

We will follow the following steps to deploy our app.

When running the app, it took over 20 seconds to respond for the first run. Many configurations can be adjected to improve performance. Please feel free to comment with suggestions.

Setup Google Cloud SQL for Mysql.

Find the service network API section using the search bar.
Enable the service network API.
Go to the Cloud SQL section.
Create a new database instance.
Choose Mysql.
Setup the database name and password.
Click on "show more configuration options". and enable private IP.

Click on create and wait until the process is done.
Write down the private IP.
Click on Connect with cloud shell.
Connect using gcloud by pressing enter in the terminal you should see a similar command shown in your shell.
Enter the root password that you choice earlier and press enter.
Should now be connected.
Create the database using the following command.
Check that the database exists.

Setup Cloud Run

Clone this repository https://github.com/hadyrashwan/ruby-on-rails-getting-started and enter the folder.
Generate the secret key using the following command. For demo purposes, we can use this one e2348e9aaf6da01aea29f03eef0a09a6d7c330ac2571043a126335ce62bc087f70931a54e6bf3bc8f6edff93e0fc502fb34c8af2cab31581b00507138088f230

It is recommended to excuate the following command to get your own secret key.

$ rake secret

Update the deploy.sh file with your project ID.
Install gcloud from gcloud download page.
Run the following command to deploy.

./deploy.sh

When asked to enable the cloud build API to enable it and
then you may be asked where to deploy it choose us central.

Write down the deployment URL.

Connect Cloud Run with Cloud Sql.

Open Serverless VPC page.
.
Click on Create Connector.
Setup the connector as follows and click Create.
Now go to the cloud run page.
Open your app.
Edit deploy.
Edit the connection section.
Update your environment variables. They should be as follow this table:

Key	Value
BLOG_DATABASE_HOST	Private IP
BLOG_DATABASE_PASSWORD	Password
SECRET_KEY_BASE	Secret key

It should look like this.

Finally, click Deploy.

Done

Your app should be ready now go to the deployment URL on your browser.
It may ask you to do a database migration do so.
In my test, the response took over 20 seconds coming from a cold start(first time hitting the app) and 254 ms afterwards.
I disabled the Webpack caching mechanism and used environment variables instead of the secret manger for the demo purposes.

Google Cloud docs links that helped me.

Setup Java and VS Code on Ubuntu

Hady Rashwan — Fri, 07 Aug 2020 12:47:30 +0000

Settings up your development environment for Java on Ubuntu is straight forward. We are going to install the Java SDK and VS code with the Java extension then create a simple Hello World app.

Find the available versions of Java JDK

First, we will search for the available packages to install. I'm looking for version 11, so my search will be.



$ sudo apt search openjdk-11

You will get similar to the following.



Sorting... Done
Full Text Search... Done
default-jdk/focal 2:1.11-72 amd64
  Standard Java or Java compatible Development Kit

openjdk-11-dbg/focal-security,focal-updates 11.0.8+10-0ubuntu1~20.04 amd64
  Java runtime based on OpenJDK (debugging symbols)

openjdk-11-demo/focal-security,focal-updates 11.0.8+10-0ubuntu1~20.04 amd64
  Java runtime based on OpenJDK (demos and examples)

openjdk-11-doc/focal-security,focal-security,focal-updates,focal-updates 11.0.8+10-0ubuntu1~20.04 all
  OpenJDK Development Kit (JDK) documentation

openjdk-11-jdk/focal-security,focal-updates 11.0.8+10-0ubuntu1~20.04 amd64
  OpenJDK Development Kit (JDK)

openjdk-11-jdk-headless/focal-security,focal-updates 11.0.8+10-0ubuntu1~20.04 amd64
  OpenJDK Development Kit (JDK) (headless)

openjdk-11-jre/focal-security,focal-updates,now 11.0.8+10-0ubuntu1~20.04 amd64 [installed,automatic]
  OpenJDK Java runtime, using Hotspot JIT

openjdk-11-jre-dcevm/focal 11.0.3+1-1 amd64
  Alternative VM for OpenJDK 11 with enhanced class redefinition

uwsgi-plugin-servlet-openjdk-11/focal 2.0.18-11ubuntu1 amd64
  JWSGI plugin for uWSGI (OpenJDK 11)

You can change the number 11 and look for other versions of Java.
As you can see openjdk-11-jdk is available. So let's install it.

Install Java JDK

Now we will install the Java JDK using one command.



$ sudo apt install openjdk-11-jdk

Verify that Java installation using the following.



$ sudo java -version

The output should be similar to.



openjdk version "11.0.1" 2020-04-14
OpenJDK Runtime Environment (build 11.0.1+7-Ubuntu-1ubuntu1)
OpenJDK 64-Bit Server VM (build 11.0.1+7-Ubuntu-1ubuntu1, mixed mode, sharing)

Install VS code

You can use the following command to do so.



sudo snap install --classic code

If snap is not available, you can use apt by following this post.

Install Java Extension Pack

Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.



ext install vscjava.vscode-java-pack

Run A Hello World App

1 - Open VS code.
2 - Create a file called Hello.java.
3 - Paste the following code. And save it.



public class Hello {

    public static void main(String[] args) {

        System.out.println("Hello World!");

    }


}

4- Open the Debug tab and click on Run and Debug.

5- The output in the terminal should be.

Credit

This post was based on the information from the linuxconfig post .