backup database

docker exec -t {DB_PG_CONTAINER} pg_dump -U {POSTGRES_USER} {POSTGRES_DB} > {dump_name} docker exec -t php_text_message-database pg_dump -U postgres php_text_message > php_text_message-dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql

restore database

docker exec -i {DB_PG_CONTAINER} psql -U {POSTGRES_USER} {POSTGRES_DB} < {dump_name} docker exec -i php_text_message-database psql -U postgres php_text_message < php_text_message-dump_25-06-2020_20_41_30.sql

start project

• yarn install: install lib
• docker-compose up: run project with docker
• docker-compose up php_text_message-backend php_text_message-database php_text_message-redis-queue php_text_message-rabbitmq: run backend
• docker-compose up php_text_message-es php_text_message-kb: run elastic search
• yarn run database:sync: sync orm schema to database
• ...others refer package.json
• dump db with ssh and docker ssh {USER}@{IP} "docker exec -t {CONTAINER_NAME} pg_dump -U postgres {DB_NAME}" > "{DB_NAME}_dump_date +%d-%m-%Y""%H%M_%S.sql"
• restore db with ssh ssh {USER}@{HOST} "docker exec -t {DB_CONTAINER} psql -U postgres {DB_NAME}" < {DUMP_FILE}
• restore db with psql psql -h {HOST} -p ${PORT} -d {DB_NAME} -U postgres -f '${file_dump}'

"max virtual memory areas vm.max_map_count [65530] is too low, increase to at least [262144]" : sysctl -w vm.max_map_count=262144

sysctl -w vm.max_map_count=262144 : max virtual memory areas vm.max_map_count [65530] is too low, increase to at least [262144]

• use gagara/kibana-oss-arm64 for kibana run on arm64
• arm64 and aarch64 is same thing
• docker volume bind and mount is same thing, but bind is simple setup with one field, mount using multiple option. In docker-compose only using mount

• GET /_cluster/health
  

• GET /_cat/nodes/?v
  

• GET /_cat/indices/?v
  

• DELETE /products
  

• PUT /products
  

• PUT /products
  {
    "settings": {
      "number_of_shards": 2,
      "number_of_replicas": 2
    }
  }
  

• POST /products/_doc 
  {
    "name": "Tea Maker",
    "price": 64,
    "in_stock": 10
  }
  

• GET /products/_doc/100
  

• PUT /products/_doc/100 
  {
    "name": "Beer Maker",
    "price": 64,
    "in_stock": 10
  }
  

• POST /products/_update/100 
  {
    "doc": {
      "in_stock": 9
    }
  }
  

• POST /products/_update/100 
  {
    "script": {
      "source": "ctx._source.in_stock = 11"
    }
  }
  

• POST /products/_update/100 
  {
    "script": {
      "source": "ctx._source.in_stock = params.quantity",
      "params": {
        "quantity": 0
      }
    }
  }
  

• POST /products/_update/100 
  {
    "script": {
      "source": """
        if(ctx._source.in_stock == 0) {
          ctx.op ='noop';
        }
        
        ctx._source.in_stock--;
      """,
      "params": {
        "quantity": 4
      }
    }
  }
  

• POST /products/_update/101
  {
    "script": {
      "source": "ctx._source.in_stock++"
    },
    "upsert": {
      "name": "Blender",
      "price": 399,
      "in_stock": 5
    }
  }
  

• DELETE /products/_doc/101
  

• if_primary_term : using today
• if_seq_no : using today
• if_version: traditional

• POST /products/_update/101?if_primary_term=1&if_seq_no=1 
  {
    "doc": {
      "in_stock": 9
    }
  }
  

• GET /products/_search
  

• GET /products/_search
  {
    "query": {
      "match_all": {}
    }
  }
  

• POST /products/_update_by_query
  {
    "script": {
      "source": "ctx._source.in_stock++"
    },
    "query": {
      "match_all": {}
    }
  }
  

• POST /products/_delete_by_query
  {
    "query": {
      "match_all": {}
    }
  }
  

• POST /_bulk
  { "index": { "_index": "products", "_id": 200 }}
  { "name": "Hai Nguyen", "price": 900}
  { "create": {"_index": "products", "_id": 201} }