NodeCommunity
Backup data transfer to new database error solution
TecAdmin
(Resolved) Unknown collation: utf8mb4_0900_ai_ci – TecAdmin
The collation utf8mb4_0900_ai_ci is a character set collation for MySQL databases, introduced in MySQL 8.0.1. It is based on the Unicode Collation Algorithm (UCA) 9.0.0, and the character set is utf8mb4, which supports a wide range of Unicode characters.…
install #docker-machine
base=https://github.com/docker/machine/releases/download/v0.16.0 \
&& curl -L $base/docker-machine-$(uname -s)-$(uname -m) >/tmp/docker-machine \
&& sudo mv /tmp/docker-machine /usr/local/bin/docker-machine \
&& chmod +x /usr/local/bin/docker-machineNodeCommunity pinned «#install nginx and get ssl certificate sudo apt-get update sudo apt install nginx //check nginx status sudo systemctl status nginx sudo fuser -k 80/tcp sudo systemctl restart nginx cd /etc/nginx/sites-available //create file with domain name(sudo nano #name)…»
#mysq_docker
#strapi_docker
#strapi_docker
version: "3.7"
services:
admin:
build:
context: .
dockerfile: ./Dockerfile
image: biznesrivoj-strapi:latest
restart: always
ports:
- "1337:1337"
depends_on:
- mysql
volumes:
- .:/srv/app
- ./public:/usr/src/app/public
- data:/usr/src/app/db
env_file: .env
environment:
DATABASE_CLIENT: mysql
DATABASE_HOST: mysql
DATABASE_PORT: 3306
DATABASE_NAME: biznesrivoj
DATABASE_USERNAME: strapi
DATABASE_PASSWORD: strapi
DATABASE_SSL: 'false'
mysql:
image: mysql:5.7
restart: always
environment:
MYSQL_DATABASE: 'biznesrivoj'
# So you don't have to use root, but you can if you like
MYSQL_USER: 'strapi'
# You can use whatever password you like
MYSQL_PASSWORD: 'strapi'
# Password for root access
MYSQL_ROOT_PASSWORD: 'strapi'
ports:
# <Port exposed> : < MySQL Port running inside container>
- '3306:3306'
expose:
# Opens port 3306 on the container
- '3306'
# Where our data will be persisted
volumes:
- my-db:/var/lib/mysql
volumes:
data:
my-db:
#docker_registry
https://www.digitalocean.com/community/tutorials/how-to-set-up-a-private-docker-registry-on-ubuntu-20-04
https://www.digitalocean.com/community/tutorials/how-to-set-up-a-private-docker-registry-on-ubuntu-20-04
Digitalocean
How To Set Up a Private Docker Registry on Ubuntu | DigitalOcean
Learn how to set up a private Docker registry on Ubuntu. Configure authentication, TLS, and persistent storage for secure image hosting.
Udemy_Node_js,_Express,_MongoDB_&_More_The_Complete_Bootcamp_2021.torrent
261.8 KB
Jonasschmedtman Udemy Course
#course
#course
NodeCommunity
https://chartio.com/learn/databases/how-does-indexing-work/ #indexing #database
Advantages
* Speed up SELECT query
* Helps to make a row unique or without duplicates(primary,unique)
* If index is set to fill-text index, then we can search against large string values. for example to find a word from a sentence etc.
Disadvantages* Indexes take additional disk space.
* indexes slow down INSERT,UPDATE and DELETE, but will speed up UPDATE if the WHERE condition has an indexed field. INSERT, UPDATE and DELETE becomes slower because on each operation the indexes must also be updated.