New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Comments
I've had success using certbot with a deploy hook that does the copying, in case you need another option.
That might be better (or acme.sh) and move to NGINX (or just use caddy and manually specify the SSL).
All good ideas, i'll play with it this week.
Francisco
Been using
nginxandpython3-certbot-nginxfor a long while now. As already mentioned, certbot's deploy hook option would be the most convenient to just point to a script.I believe certbot uses systemd timers.
certbot certonly --nginx --agree-tos -m <tls-email> -d example.comThe
--nginxautomates the challenges (frompython3-certbot-nginx).@Francisco
You need to enable bulk downloads in each region.
Automatic backups often fail in each region.
Automatic backup files appear as 0 KB in each region.
Instead of downloading backups individually, provide a bulk backup download feature in the panel.
Backups fail to generate because mysqldump fails to connect because of the invalid ssl certs on sql.
If hou read back you can see us talking about it and possible fixes
Francisco
@Francisco
I see.
Why don't you add a bulk backup download feature?
Instead of downloading them one by one?
@Francisco
Beta was 100, now it’s 15
So I see you kicked the cert manually on NL node I guess and I can see small database backups - 300kB, cool.
The huge ass database of 60 69.78 GB still shows Failed, on scheduled or manual runs (-:
This situation is the same failure in other nodes as well.Backups show 0 kb.
70gb of database is a lot to download and backup in one go? If it was me, I’d say you were lucky to be able to download it at all. If it was me, I’d be like “hell no”
>
We see an avg ~10x compression ratio on SQL dumps so it'd probably be ~10G in total.
Francisco
Ahh ok - still, isn’t backing up a 70gb database going to put strain on the host?
Anyway - it’s not me 😜
I’ve just double checked and the space is now limited 15gb instead of the 100 initially
do you have pgsql now? and if so do you have test IP to NL?
whats your availibility % so far? i need something stable i can buy and forget
whats your availibility % so far? i need something stable i can buy and forget
Haven't worked on PSQL. I don't know it enough to comfortably work on it yet. I need to sit down and learn how permissions are handled in PSQL.
Francisco
Did you get your 100GB back? With support? Francisco manual reaction? Some secret code?
I am at the moment at ~82/15GB (haven't visited for few weeks, was working, was 100GB after you were limited to 15GB - I remember checking it) and logged in today to see that I am 15 GB. I am at 550% of limit yet I can still write to MySQL so that is some kind of very soft limit :-D
Something went down today for ~25 minutes on NL/LU DA so I went to investigate.
First support agent said I am drunk and I never had 100GB and proceed to ignore question if MySQL was offline for 25 minutes or this is something else related.
I don't really want to waste time of 1st line support agents that don't know secret hush-hush specific things and if this needs direct @Francisco input gonna bother him
@JabJab - nope, never got resolved.
Scheduled Backup Showing FAILED on all of my database hosted on SG-CRANEBASE Offload SQL.
Thanks.
Welp, looks like it's a time to move on then. I knew this deal was too good to be true, however I am pretty sure I explicitly asked about that here.
(-:
@Francisco
uk-mariadb01It's been like this for months. I don't know when they'll address it. No one is following up.
Nice service. Hope to find some stock soon.
@Francisco
I found that my offload database cannot be accessed by my other VPS, even though I've allowed the IP address for that VPS in the panel.
Can you check this?
Need this problem solved A.S.A.P.
already submit ticket #CRANE-20375 but need it A.S.A.P.
@abangnoob SG? they sleep right now (time in ticket), probably wait in 6-12h
yes, SG server had a major problems
@Francisco @NameCrane
I'm also having similar issues in SG - CRANE-20438
SG server periodically becomes unreachable.
It should be fine. The issue this morning was related to ZFS running out of space because of all the snapshots its keeping (we use zfs-auto-snapshot). We put this in place so that we didn't have another run in where a client deletes their own data then blames us for it.
When it did one of the rotations this morning it burned up 100 - 200G extra.
All backups are currently stored on the local box, and those backups were getting snapshotted too (so, backups of backups of backups...). The plan is to move it all to our S3 deployment. I already finished up the code, its been running on the NY node for a bit now.
I'll push it to the rest today/tomorrow.
Francisco