what's up folks, I am always looking for how to improve my infrastructure and these days I have been thinking about the feasibility of creating an lxc container or a vm in my proxmox just to install a db like mariadb and all the other services in another lxc's that will need a db for example wordpress, odoo, speedtest tracker, n8n etc. will point to that lxc or vm with the db of mariadb (or another)...
would it be good?, would it be bad? Would it be a good practice? Would it provide any bad performance? or would it be a benefit?
what do you think?
what's up folks, I am always looking for how to improve my infrastructure and these days I have been thinking about the feasibility of creating an lxc container or a vm in my proxmox just to install a db like mariadb and all the other services in another lxc's that will need a db for example wordpress, odoo, speedtest tracker, n8n etc. will point to that lxc or vm with the db of mariadb (or another)...
would it be good?, would it be bad? Would it be a good practice? Would it provide any bad performance? or would it be a benefit?
what do you think?
ok... I couldn't install docker with postgres so I did it with sql and that's it I hope I don't miss out in the future because I will have to look for someone to help me install it thanks friends
Please, I'm struggling with the docker-compose with postgres to get my n8n up and running... so just copy the docker-compose from the doc and made changes for my needs, could you tell me if im doin it rigth? or should I change something?
i want all data in: /docker/n8n/ so
root@13-n8n-RL23-WG /docker/n8n# nano .env
POSTGRES_USER=user-root
POSTGRES_PASSWORD=password-root
POSTGRES_DB=n8n
POSTGRES_NON_ROOT_USER=user-nonroot
POSTGRES_NON_ROOT_PASSWORD=password-nonroot
root@13-n8n-RL23-WG /docker/n8n# nano docker-compose.yml
version: '3.8'
volumes:
db_storage:
n8n_storage:
services:
postgres:
image: postgres:11
restart: always
environment:
- POSTGRES_USER
- POSTGRES_PASSWORD
- POSTGRES_DB
- POSTGRES_NON_ROOT_USER
- POSTGRES_NON_ROOT_PASSWORD
volumes:
- /docker/n8n/postgresql/data:/var/lib/postgresql/data
- ./init-data.sh:/docker-entrypoint-initdb.d/init-data.sh
healthcheck:
test: ['CMD-SHELL', 'pg_isready -h localhost -U ${POSTGRES_USER} -d ${POSTGRES_DB}']
interval: 5s
timeout: 5s
retries: 10
n8n:
image: docker.n8n.io/n8nio/n8n
restart: always
environment:
- DB_TYPE=postgresdb
- DB_POSTGRESDB_HOST=postgres
- DB_POSTGRESDB_PORT=5432
- DB_POSTGRESDB_DATABASE=${POSTGRES_DB}
- DB_POSTGRESDB_USER=${POSTGRES_NON_ROOT_USER}
- DB_POSTGRESDB_PASSWORD=${POSTGRES_NON_ROOT_PASSWORD}
- WEBHOOK_URL=https://subdomain.wtf.org/
- EXECUTIONS_PROCESS=main
- GENERIC_TIMEZONE=America/La_Paz
- TZ=America/La_Paz
ports:
- 5678:5678
links:
- postgres
volumes:
- /docker/n8n:/home/node/.n8n
depends_on:
postgres:
condition: service_healthy
thanks I will go for postgres database because of what I have been advised and additionally because I have been told that soon n8n will remove mysql/mariadb support.
I will create a lxc conteiner in my proxmox just for him so my question would be... which one would be more secure that it will not have problems in the future? for example that it is slower or easier to be damaged or lose information or that it lacks some feature, do you know what I mean? but ok i wil go with a database thanks!
I will create a lxc conteiner in my proxmox just for him so my question would be... which one would be more secure that it will not have problems in the future? for example that it is slower or easier to be damaged or lose information or that it lacks some feature, do you know what I mean?
hi folks i am starting to use n8n and i want to do some automations in my kommo crm and other things, but i have seen that there are several ways to install n8n in a self hosted way, so my question is for those who have n8n as self hosted services,
which would be the best way to install it?
\- docker without database? \- docker with database and which database would be better postgress or mysql? thanks
hi pals!
These days I am bothered by a question to improve the performance of my proxmox server. I hope you can advise me:
My Proxmos 8 24/7 is on an old dell optiplex 7010 4 x Intel(R) Core(TM) i3-3225 CPU @ 3.30GHz, 32gb RAM and it doesn't give me problems normally it is at 20% CPU usage, 60% ram usage, 5% swap, and 12% disk usage and I have the following CT's and VM's configuration:
4 VMs (VM1 linux lite 5gb RAM) (VM2 win10 5gb RAM) (VM3 xpenology 4gb RAM) (VM4 OpenWrt 1gb RAM) all in production
7 LXC CT (CT1 512mg RAM, 1 docker service in production 1WP) (CT2 1gb RAM, 3 docker services in production POLR, CALIBER WEB, MATOMO) (CT3 2gb RAM, 8 docker services in production EXCALIDRAW, UPTIME-KUMA, CODE- SERVER, IPERF3, GUACAMOLE, HEIMDALL, LIBRESPEED, MEMOS) (CT4 2.5gb RAM 6 docker services in production 4WP, LITTLE-LINK, CALIBRE-WEB) (CT5 250mg RAM, 3 docker services in production 3VAULTWARDEN) (CT6 512mb RAM 2 services docker in production SPEEDTEST-TRACKER, OPEN-SPEED-TEST) (CT7 3gb RAM nextcloud in production)
My question is which of the following configurations could be best to increase the performance of my server? 1- create an LXC CT for each docker service, for example, 1LXC CT with RAM optimized for 1 each of my 5 WORDPRESS's docker with the databases, 1LXC CT with RAM optimized for 1 guacamole's docker , 1LXC CT with RAM optimized for matomo and so on for each service, or.
2- the same as I was doing until now, 1 LXC CT with optimized RAM and several docker services, or
3- 1 VM with good RAM and all the docker services inside?
I am also thinking about the fact that each LXC CT makes requests to the kernel, but also about the good use of cpu, ram and kernel resources. Just in case I have a CGNAT so all my services go to the internet using cloudflare for CND domains and security, an external vps with wireguard and nginx.
thanks!
I got my proxmox in production and I've installed before whatschtower and just broke me down 4 containers with bad updates so I stoped from using whatschtower...
I would like any services that just notify me about any new docker image update whitout making any updating
Yeah that's why I didn't try any virtualizacion just backup that's why I just would like to share those hdd to my Synology
Im upgrading to 6gb that's the max and just for fun I've install proxmox PBS and it's working good hehe I just would like to share those disk to my Synology... 😊
hi pals!
I just got a desktop pc... is an old pentium Dual CPU E2200 2.20GHz with 4gb of ram and some time ago I wanted to make a backup system so...
I installed the last version of proxmox backup server and I put 6 old hdd of 1tb each, i take 1 hdd for backups of my VM's and CT's and i wanted to know if there is a way to pass/mount or share the remaining disks (5) to my synology VM that is hosted in my Proxmox VE and give use to those old disks and use them as storage volumes to save some movies?
hi folks I have several self hosted services and wordpress pages that I publish on the internet the problem is that I have no public ip so I have always used a linode vps with wireguard as vpn and then a reverse proxi as ngnx to address the ports of my services and websites...
The problem I have always seen is that no matter what I do the connections are always slow... and I think it is because the use of the same ngnx and wireguard; because they are several steps and could creates a high latency...
now I would like to use a zerotrust services as "cloudflare" or "twingate" and I would like someone who has gone through the same thing tell me if it is worth making that change... I believe that using a zerotrust would'nt have to use the wireguard, and maibe the nginx to address my services but i could avoid that latency and even having more security... please tell me your opinions and if someone already knows cloudflare's zerotrust or twingate please tell me your opinion of both 😉.