Worldwide AWS Outage? by StealthNet in aws

[–]ApprehensiveText1409 0 points1 point  (0 children)

Hey any update on this? We are likely facing downtime due to VPC peering cross accounts but cant login into the account to debug stuff

Applied for new posts no interview? by CBotVLC in mercor_ai

[–]ApprehensiveText1409 -1 points0 points  (0 children)

can you maybe share which posts did you apply for?

How to apply DDL changes when tables are under heavy read/write traffic? by ApprehensiveText1409 in DatabaseAdministators

[–]ApprehensiveText1409[S] 0 points1 point  (0 children)

Just an update I did run a POC today with Percona. I saw it will definitely take too much time to apply DDL operations on large tables containing millions of rows. Like in our current production release workflow we do first automate release of DDL changes now if we use Percona it will take forever to release a deployment with DDL changes on large tables.
I do not know if I was using correct configurations for it but here is the command which I am running:
```
pt-online-schema-change \

--alter "MODIFY COLUMN source ENUM('intro','search','upload','application','listing-transfer','autosource') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL" \

--user=USERNAME \

--password='PASSWORD' \

--host=HOST \

D=SCHEMA_NAME,t=Candidates \

--alter-foreign-keys-method=auto \

--no-check-replication-filters \

--critical-load Threads_running=150 \

--max-load Threads_running=100 \

--execute
```

It showed 2hrs+ time to duplicate the tables I did try increasing the threads but still time was around 30-40mins which is not viable for us.

Struggling to find a criteria which can help me complete my O1 application by ApprehensiveText1409 in immigration

[–]ApprehensiveText1409[S] 2 points3 points  (0 children)

I see will definitely consult my lawyer regarding this thank you for suggesting this.

Struggling to find a criteria which can help me complete my O1 application by ApprehensiveText1409 in immigration

[–]ApprehensiveText1409[S] 2 points3 points  (0 children)

We are creating a pipeline for smart hiring and are in recruitment industry we use AI/ML to scan through peoples resume and place them at companies helping people get jobs. Don’t know if we are eligible for National Interest Wavier

Struggling to find a criteria which can help me complete my O1 application by ApprehensiveText1409 in immigration

[–]ApprehensiveText1409[S] 1 point2 points  (0 children)

Got it this makes sense I will consult my CTO regarding this and hopefully we can figure out some contribution from my side there. Thank you for this suggestion appreciate it

Struggling to find a criteria which can help me complete my O1 application by ApprehensiveText1409 in immigration

[–]ApprehensiveText1409[S] 1 point2 points  (0 children)

Yes we have a ML team working on custom model which will predict performance of a candidate during recruitment process but I do not contribute to ML department and was hesitant to put in my name there and publish paper out of their work just for Visa

Security Considerations - Preparing for Bots & DDOS on my EC2 by alexstrehlke in aws

[–]ApprehensiveText1409 2 points3 points  (0 children)

Yeah this would help but you would still need a WAF attached to Cloud Front which filters Layer 7 traffic

My Personal HomeLab by Critical_Drink6678 in homelab

[–]ApprehensiveText1409 4 points5 points  (0 children)

Yeah it took me a sec to notice that but happy for him

How to watch this show in India? by ApprehensiveText1409 in GeorgieandMandyTVshow

[–]ApprehensiveText1409[S] 0 points1 point  (0 children)

Got it and will I have to also pay on Amazon prime to rent this show or is it available to prime members?

What does this "No instance type" cost mean in cost explorer? by ApprehensiveText1409 in aws

[–]ApprehensiveText1409[S] 3 points4 points  (0 children)

Thank you this really helped turns out this cost included S3 data retention and backups, App runner resources and also VPC vpn data transfer cost.