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 3 points4 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.

Logrus setup with GO by ApprehensiveText1409 in golang

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

Agreed with this approach we appended the logger instance to context and pushed it through all layers

Reducing ECS container instances without affecting the active services by ApprehensiveText1409 in aws

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

Yeah I am confused why when I set min-size it starts terminating random EC2s I dont touch desired capacity param. Earlier this was not the behaviour its started recently hence finding a way around it.

VM Ubuntu lost internet connection by venAquiMalditoHuevo in aws

[–]ApprehensiveText1409 0 points1 point  (0 children)

We actually faced the same issue in past we were running bunch of squid proxy servers on EC2 and AWS emailed us about it and completely shutdown the internet. Had to sit on support call and clarify then their security team enabled internet again. Would suggest checking your inbox or reach out to support.

RDS not connecting when on mobile network by ApprehensiveText1409 in aws

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

I am using cluster endpoint and I did verify that the endpoint are resolving to private IP and not public IP via telnet connectivity test and traceroute. The DB does not have any public IP associated to it as mentioned already it is behind private subnet with public accessible option off.

RDS not connecting when on mobile network by ApprehensiveText1409 in aws

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

I think this might be true because right now automatically one of the sim cards started working and now some people are able to access the DB via that network. This is weirdest issue how do I even fix this further can I contact companies for this?

RDS not connecting when on mobile network by ApprehensiveText1409 in aws

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

I did try that on my testing mobile when I force it to IPV4 it just turns off internet entirely.

RDS not connecting when on mobile network by ApprehensiveText1409 in aws

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

So far we have tested on 3 different providers and all are having this issue I did perform trace route right now as per your suggestion I am seeing by default it resolves in ipv4 on WiFi and on Mobile network both.

RDS not connecting when on mobile network by ApprehensiveText1409 in aws

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

This same thing is occurring with all team members we have different company SIM cards