1,215 karma · joined June 16, 2015
to others reading this -- simplified, but, docker uses containerd to build/run images. all docker images are valid containerd images. you can run images through containerd straight off the docker hub.
I've legitimately considered running some kind of simple SaaS and behind the scenes running a Nomad cluster and having the remote SaaS agent just be a Nomad client.
It has no compile time, the development cycle is crazy fast, the stdlib is good for the web, every problem is solved so they’re all googleable, it has a good package manager now, great frameworks, good testing stuff, there’s a lot of positives atm
I'm curious why CTEs don't seem to be getting used here?
SELECT
(
SELECT
(
t.data,
t.created_at
)::jsonb_x_timestamp
FROM
telemetries t
WHERE
server_id = 'a0dcc312-0623-af60-4dc0-238301cc9bf8'
AND data ? 'load_avg'
AND t.created_at >= series.target
AND t.created_at <= (series.target + INTERVAL '2592 seconds')
LIMIT 1
)
FROM
(
SELECT
target
FROM
GENERATE_SERIES(
'2020-09-01 00:00:00'::timestamp,
'2020-09-15 23:59:59'::timestamp,
INTERVAL '2592 seconds'
) target
) series
I'm curious on the performance of: WITH series AS SELECT
target
FROM
GENERATE_SERIES(
'2020-09-01 00:00:00'::timestamp,
'2020-09-15 23:59:59'::timestamp,
INTERVAL '2592 seconds'
) target
SELECT
(
t.data,
t.created_at
)::jsonb_x_timestamp
FROM
telemetries t
WHERE
server_id = 'a0dcc312-0623-af60-4dc0-238301cc9bf8'
AND data ? 'load_avg'
AND t.created_at >= series.target
AND t.created_at <= (series.target + INTERVAL '2592 seconds')
LIMIT 1
or even shuffling some of the other selects and chaining CTEs together. I'm even curious if you could somehow use a combination of CTEs to generate something more suitable for use with SYSTEM_ROWS (TIL!! will keep this in my pocket for the future!).CTEs are never a guarantee for performance improvements (they make things worse at times) but I see them getting ignored a lot when at times they are a huge boost.
Edit: wow the formatting is really bad, hopefully the code stuff doesn't kill it for mobile users
It "works," but... operator beware.
I'm also not exactly sure if you'll get full stats out of a replica.
That said, I'm moving to a central distributed Vault that is mostly going to exist as a PKI so I'll only really need to repeat this process once more! Going to be using the raft internal engine for this one, and spread it physically across the globe so performance is going to be pretty terrible by design, but it should be quite resilient!
Coming in twice an hour late and being ridiculed about it is ridiculous. This is professional life, not some strict grade school.
This straight path you speak of they have been filing paperwork for and fighting for, for 3 years now. I believe he is just in the path to permanently moving to China and revoking his US citizenship status.
Everything about this process sucks. :(
I've been in this situation. Getting a $1000 budget approval took months and was _tough_.
On that note, does anyone from Cinc know if this will have any impact on that project?
I’ve been speaking to a friend who works at one of these companies and they had no idea this was happening.
Make darn well sure you aren't using any unsupported operations.
In their favor, if I were to revisit them I could use it now; however in the past they didn't support templates and a few other things which turned out to be major blockers.
we've had a ton of instances fail at once because they had some kind of rack-level failure and a bunch of our EC2s ended up in the same rack. :(
This is never going to end as more things shift towards being core APIs that allow you to write code instead of configure things. It's not even configuration-as-code, it's just code managing configuration files.
edit: I think my comment comes across maybe kinda rude. My beef with Envoy is that the documentation is _extremely_ complex, and I've repeatedly asked 'How do I get started with xDS?' and been pointed to the spec, which I think took some time to read through and when I asked others about how to setup LDS/RDS/CDS/SDS was met with a like 'what are these things...? just use xDS,' which led me to a lot of frustration. This has been my experience each time trying to approach Envoy, and xDS.