To connect to Google Cloud SQL, run
|
1 |
gcloud sql connect DB_INSTANE_NAME |
Amazon S3 CORS
To enable CORS for Amazon S3 bucket, add
|
1 2 3 4 5 6 7 8 9 10 11 |
<?xml version="1.0" encoding="UTF-8"?> <CORSConfiguration xmlns="http://s3.amazonaws.com/doc/2006-03-01/"> <CORSRule> <AllowedOrigin>*</AllowedOrigin> <AllowedMethod>PUT</AllowedMethod> <AllowedMethod>POST</AllowedMethod> <AllowedMethod>DELETE</AllowedMethod> <MaxAgeSeconds>1800</MaxAgeSeconds> <AllowedHeader>*</AllowedHeader> </CORSRule> </CORSConfiguration> |
Google Cloud App Engine
To list instances in Google Cloud App Engine, run
|
1 |
gcloud app instances list |
To create an application
|
1 |
gcloud app create |
To deploy an application
|
1 |
gcloud app deploy |
Google Cloud SQL
To create a Google Cloud SQL database, run
|
1 |
gcloud sql instances create INSTANCE_NAME_HERE --activation-policy=ALWAYS --tier=db-n1-standard-1 |
INSTANCE_NAME_HERE = this can be anything, lowercase letters, 0-9, for identification purpose only.
db-n1-standard-1 => this is size of the server, you can change it as needed.
To create a Database, run
|
1 |
gcloud sql databases create DB_NAME_HERE --instance INSTANCE_NAME_HERE |
To create a User, run
|
1 |
gcloud sql users set-password root --host=% --instance INSTANCE_NAME_HERE --password=PASSWORD_HERE |
To list all google cloud SQL instances, run
|
1 |
gcloud sql instances list |
To list all databases in a Google Cloud SQL server, run
|
1 |
gcloud sql databases list --instance INSTANCE_NAME_HERE |
To connect to Google Cloud SQL database, run
|
1 |
gcloud sql connect INSTANCE_NAME_HERE |
This will open firewall rule and add your IP so you can connect to Google Cloud SQL server.
Set Permanant hostname on AWS EC2 CentOS 7 server
On AWS EC2 when you boot, hostname set something like ip-172-31-41-172.eu-central-1.compute.internal
To chaneg this, run
|
1 |
hostnamectl set-hostname --static HOSTNAME_HERE |
Example
|
1 |
hostnamectl set-hostname --static server1.serverok.in |
To disable change of hostname, run
|
1 |
echo "preserve_hostname: true" > /etc/cloud/cloud.cfg.d/99_hostname.cfg |
Now reboot your server with
|
1 |
reboot |
Resize Amazon EC2 Boot Disk
Once you resize disk in Amazon AWS console, it get auto resized on reboot. Some times this won’t happen, you have to manually resize the disk.
To resize disk, do the following.
1) Take a snapshot of the disk
2) Create a new server in same availability zone as current server. Lets call it tmpServer.
3) Shutdown tmpServer.
4) Shutdown the server that need disk resized. Lets call it mainServer. Make sure you have Elastic IP, if not shutting down changes IP of the server.
5) Detach the disk.
6) Attack the disk in tmpServer as /dev/xvdf
7) Start tmpServer.
Login to tempServer and do the following.
Resize Partition
Firt find the devices
|
1 |
parted -l |
In this cause /dev/xvdf is the disk that need to be resized. Current Size is approx 107 GB.
To see free disk space on this disk, run
|
1 |
parted /dev/xvdf print free |
There is 21.5GB free space on the disk.
To grow partition 1 to use up remaining disk space, run command
|
1 |
growpart /dev/xvdf 1 |
Verify free disk space after. Now you see there is not much free disk space left after partition 1.
Resize FileSystem
Resize file system depends on the type of file system you are using. For ext4, do the folllowing.
Check disk using e2fsck
|
1 |
e2fsck -f /dev/xvdf1 |
If any errors found, you will be asked to press “y” to fix the errors. After e2fsck run, you can reszie filesystem with command
|
1 |
resize2fs /dev/xvdf1 |
You have completed resizeing the disk. All you need to do now is
8) Shutdown tmpServer
9) Detact the disk from tmpServer (/dev/xvdf)
10) Attach the disk on original server mainServer as /dev/sda1.
11) start the mainServer.
VMWare ESXI add SSH key
To enable password less SSH login on VMWare ESXI server, add your SSH key to file
|
1 |
/etc/ssh/keys-root/authorized_keys |
VMWare esxcli
To list all running VM, run
|
1 |
esxcli vm process list |
To list all installed software
|
1 |
esxcli software vib list |
Example
|
1 2 3 |
[root@server:~] esxcli software vib list | grep esx-ui esx-ui 1.33.1-12086396 VMware VMwareCertified 2019-02-24 [root@server:~] |
Google Cloud open a port in firewall
To open port 80 globally for all VMs on google cloud project, run
|
1 |
gcloud compute firewall-rules create allow-port80-all --allow tcp:80 --source-ranges 0.0.0.0/0 --network default |