Microsoft Azure Web App Service

Three steps to create a FREE web app on Microsoft Azure using Azure CLI.

Create Resource Group - Name: myResourceGroup
Create App Service Plan - Name: lthwnodejs
Create Web app - Name: lthwnodejs

Create Resource Group


az group create --name myResourceGroup --location "South Central US"

Create FREE App Service Plan

MUST add --sku FREE


az appservice plan create --name lthwnodejs --resource-group myResourceGroup --sku FREE

Create Web App


az webapp create --name lthwnodejs --resource-group myResourceGroup --plan lthwnodejs

Yet another example creating a python webapp

PS F:\Projects\github\iflask> .\env\Scripts\activate
(env) PS F:\Projects\github\iflask> az webapp up --sku F1 -n iflask -l centralus
webapp iflask doesn't exist
Creating Resource group 'tuyendq_rg_Linux_centralus' ...
Resource group creation complete
Creating AppServicePlan 'tuyendq_asp_Linux_centralus_0' ...
Creating webapp 'iflask' ...
Configuring default logging for the app, if not already enabled
Creating zip with contents of dir F:\Projects\github\iflask ...
Getting scm site credentials for zip deployment
Starting zip deployment. This operation can take a while to complete ...
Deployment endpoint responded with status code 202
You can launch the app at http://iflask.azurewebsites.net
{
  "URL": "http://iflask.azurewebsites.net",
  "appserviceplan": "tuyendq_asp_Linux_centralus_0",
  "location": "centralus",
  "name": "iflask",
  "os": "Linux",
  "resourcegroup": "tuyendq_rg_Linux_centralus",
  "runtime_version": "python|3.7",
  "runtime_version_detected": "-",
  "sku": "FREE",
  "src_path": "F:\\Projects\\github\\iflask"
}
(env) PS F:\Projects\github\iflask> code .
(env) PS F:\Projects\github\iflask> az webapp up --sku F1 -n iflask -l centralus
Webapp iflask already exists. The command will deploy contents to the existing app.
Creating zip with contents of dir F:\Projects\github\iflask ...
Getting scm site credentials for zip deployment
Starting zip deployment. This operation can take a while to complete ...
Deployment endpoint responded with status code 202
You can launch the app at http://iflask.azurewebsites.net
{
  "URL": "http://iflask.azurewebsites.net",
  "appserviceplan": "tuyendq_asp_Linux_centralus_0",
  "location": "centralus",
  "name": "iflask",
  "os": "Linux",
  "resourcegroup": "tuyendq_rg_Linux_centralus",
  "runtime_version": "python|3.7",
  "runtime_version_detected": "-",
  "sku": "FREE",
  "src_path": "F:\\Projects\\github\\iflask"
}
(env) PS F:\Projects\github\iflask>

Free tier limit

PS F:\Projects\github\iflask> az webapp up --sku F1 -n iflask -l centralus
webapp iflask doesn't exist
Exceeded the limit of 1 free tier linux server farm per subscription.
PS F:\Projects\github\iflask>

MySQL: Notes

Ways to check MySQL version mysql --version mysql -V dpkg -l 'mysql-sever' mysql -u root -p How to check MySQL version: mysql --version Database folder On Microsoft Windows, by default, MySQL save databases in this folder: %ProgramData%\MySQL\MySQL Server 5.5\data Check databases' size SELECT table_schema AS "Database name", SUM(data_length + index_length) / 1024 / 1024 AS "Size (MB)" FROM information_schema.TABLES GROUP BY table_schema; Export database schema $ mysqldump -u root -p --no-data wordpress1001 > c:\backup\schema-wordpress1001.sql Enter password: **************** Create a dedicated user to backup databases Give credit to: http://www.fromdual.com/privileges-of-mysql-backup-user-for-mysqldump Create dedicated mysql user and grant privileges to run backup $ mysql -u root -p CREATE USER 'backupdb'@'localhost' IDENTIFIED BY 'passwordhere'; GRANT SELECT,SHOW VIEW,RELOAD,REPLICATION CLIENT...

luyện

Search This Blog