amazon web services – AWS Beanstalk Auto-scaling Scaling Triggers with UnhealthyHost count and status check

I have configured my scale triggers to look for an unhealthy host count, but it doesn't seem to be working.
my configuration settings

Now to test this: I am doing SSH on one of my instances and stopping the HTTPD service. Then when I navigate to the health overview, I will immediately see that the server on which SSHd is now in serious condition.

severe === unhealthy?

I guess at this point, after 1 minute has passed (according to my rules) a new server would be created, but that is not happening.

If I understand my rules correctly, there is now 1 unhealthy server (above the upper threshold), so we increment 1. And then, once the number of unhealthy servers is 0 (below the lower threshold), delete 1 server.

But yes, I waited about 5 minutes and no new EC2 servers were provisioned.

I also have some settings for status checking:

enter the image description here

Does this conflict with my autoscaling rules in any way? I thought the health check file should return a 200 response to be considered healthy and if HTTPD is stopped they would not return that response.

So what does it matter?

Anyone tried the nofrillscloud.com reseller plan (based on Amazon AWS)

Hi there
Does anyone have experience with nofrillscloud.com. They have promising reseller plans that are fully hosted on Amazon AWS.
To be fra … | Read the rest of https://www.webhostingtalk.com/showthread.php?t=1803469&goto=newpost

MYSQL query works fine on AWS RDS instances with 1 vCPU but crashes if run on instances with 2 vCPU or more

I have this below SQL query below executed on a Lambda function. Lambda function was connected to AWS RDS with MySQL 5.7.22.

When this query is run on a db.t2.small or db.t2.micro instance type, the query works fine and the results are returned within seconds. This instance type has 1 vCPU

However, when we raise the instance type to db.t3.small or db.t3.medium, which has 2 vCPUs, the query hangs until the lambda timeout (about 10 minutes). Even after the lambda function timeout, the CPU DB remains at 50% consumption for the longest time until I decided to restart RDS.

This is counterintuitive, as I think having more vCPUs should improve performance. I suppose it could be linked to multi-threading somehow, but can't find any info. I hope to get help / suggestions here.

Here is the SQL query in question

INSERT INTO
   CP58 (
   SELECT
      s.BRN, IFNULL(IFNULL((
      SELECT
         rtmp.DLR_CODE 
      FROM
         STABLE stmp, CP58_REPORT rtmp 
      WHERE
         stmp.DLR_CODE = rtmp.DLR_CODE 
         AND s.BRN = rtmp.BRN 
         AND stmp.HQ_FLAG = 'HQ' 
         AND stmp.STATUS = 'Active' 
      GROUP BY
         stmp.COMP_REGNO, rtmp.DLR_CODE 
      ORDER BY
         stmp.COMP_REGNO, SUM(rtmp.TOTAL) DESC LIMIT 1), 
         (
            SELECT
               rtmp.DLR_CODE 
            FROM
               STABLE stmp,
               CP58_REPORT rtmp 
            WHERE
               stmp.DLR_CODE = rtmp.DLR_CODE 
               AND s.BRN = rtmp.BRN 
               AND stmp.HQ_FLAG = 'HQ' 
            GROUP BY
               stmp.COMP_REGNO,
               rtmp.DLR_CODE 
            ORDER BY
               stmp.COMP_REGNO,
               SUM(rtmp.TOTAL) DESC LIMIT 1
         )
), 'NOHQDEALERCODE') as 'HQDEALERCODE', s.DEALERNAME, s.ADDRESS, IFNULL(MAX(x.CPTABLE_YEAR), MAX(y.EDTABLE_YEAR)) as 'YEAR', IFNULL(SUM(x.CPTABLE), 0) as 'CPTABLE_TOTAL', IFNULL(SUM(y.EDTABLE), 0) as 'EDTABLE_TOTAL', 
         (
            IFNULL(SUM(x.CPTABLE), 0) + IFNULL(SUM(y.EDTABLE), 0)
         )
         as 'TOTAL', '0' as 'PDF' 
      FROM
         (
            SELECT
               stmp.COMP_REGNO as 'BRN',
               stmp.DLR_CODE as 'DLR_CODE',
               stmp.DLR_NAME as 'DEALERNAME',
               CONCAT(stmp.ADDRESS, ' ', stmp.TOWN, ' ', stmp.POSTCODE, ' ', stmp.STATE) as 'ADDRESS' 
            from
               STABLE stmp 
            GROUP BY
               DLR_CODE
         )
         s 
         LEFT OUTER JOIN
            (
               SELECT
                  subqc.DESTDEALERCODE as 'DEALERCODE',
                  SUM(subqc.RM) as 'CPTABLE',
                  YEAR(subqc.DATETIME) as 'CPTABLE_YEAR' 
               FROM
                  CPTABLE subqc 
               GROUP BY
                  subqc.DESTDEALERCODE
            )
            x 
            on x.DEALERCODE = s.DLR_CODE 
         LEFT OUTER JOIN
            (
               SELECT
                  subsubqe.DEALERCODE as 'DEALERCODE',
                  SUM(subsubqe.AMOUNT) as 'EDTABLE',
                  YEAR(subsubqe.BANKACK_DATE) as 'EDTABLE_YEAR' 
               FROM
                  EDTABLE subsubqe 
               GROUP BY
                  subsubqe.DEALERCODE
            )
            y 
            on s.DLR_CODE = y.DEALERCODE 
      GROUP BY
         BRN 
      HAVING
         TOTAL > 0 
         AND HQDEALERCODE <> 'NOHQDEALERCODE')

When the query hangs I ran the EXPLAIN command and below is the output. It remains in this state unchanged, while consuming 50% CPU, until you restart the database server.

Explain the result of the query

AWS EC2 instance does not connect because ppk file permission changed with chmod 444

AWS EC2 instance does not connect through putty or winscp since ppk file permission has been changed (by mistake) using chmod 444 (-r--r--r--)

Is there a way to change the permission back to rwx for the owner?

postgresql: How to migrate tables with default values, constraints and sequences with AWS DMS for migration from postgres to postgres?

I recently did a migration from a postgresql RDS to Aurora postgresql. Tables were successfully migrated, but tables are missing their default values, constraints, and references. Nor did any sequence migrate.

Table in the source database:

                                        Table "public.addons_snack"
    Column     |           Type           | Collation | Nullable |                 Default
---------------+--------------------------+-----------+----------+------------------------------------------
 id            | integer                  |           | not null | nextval('addons_snack_id_seq'::regclass)
 name          | character varying(100)   |           | not null |
 snack_type    | character varying(2)     |           | not null |
 price         | integer                  |           | not null |
 created       | timestamp with time zone |           | not null |
 modified      | timestamp with time zone |           | not null |
 date          | date                     |           |          |
Indexes:
    "addons_snack_pkey" PRIMARY KEY, btree (id)
Check constraints:
    "addons_snack_price_check" CHECK (price >= 0)
Referenced by:
    TABLE "addons_snackreservation" CONSTRAINT "addons_snackreservation_snack_id_373507cf_fk_addons_snack_id" FOREIGN KEY (snack_id) REFERENCES addons_snack(id) DEFERRABLE INITIALLY DEFERRED

Tables in the target database

                         Table "public.addons_snack"
    Column     |            Type             | Collation | Nullable | Default
---------------+-----------------------------+-----------+----------+---------
 id            | integer                     |           | not null |
 name          | character varying(100)      |           | not null |
 snack_type    | character varying(2)        |           | not null |
 price         | integer                     |           | not null |
 created       | timestamp(6) with time zone |           | not null |
 modified      | timestamp(6) with time zone |           | not null |
 date          | date                        |           |          |
Indexes:
    "addons_snack_pkey" PRIMARY KEY, btree (id)

Did I do something wrong or DMS is not able to do it?

kubernetes – Traefik gets "Page 404 not found" on AWS

I installed my Traefik with default files from: https://docs.traefik.io/routing/providers/kubernetes-crd/#configuration-examples

My entry route looks like this:

apiVersion: traefik.containo.us/v1alpha1
kind: IngressRoute
metadata:
  annotations:
  name: traefik-test-ingressroute
  namespace: default
spec:
  entryPoints:
  - traefik
  routes:
  - kind: Rule
    match: Host(`test.domain.com`) 
    services:
    - name: whoami
      port: 80

On the board, the ruler is seen correctly. Find all endpoints and sign it as "Success". But when I put the domain "test.domain.com" in my browser it is getting me 404. I am using this domain with AWS ip loadbalancer created by Traefik service in my / etc / hosts.

Traffik is coming to Traefik because in logs I am getting such log on every connection try:

172.20.59.64 - - (29/Mar/2020:22:19:47 +0000) "GET / HTTP/2.0" - - "-" "-" 190 "-" "-" 0ms
172.20.59.64 - - (29/Mar/2020:22:19:49 +0000) "GET / HTTP/2.0" - - "-" "-" 191 "-" "-" 0ms
172.20.59.64 - - (29/Mar/2020:22:19:49 +0000) "GET / HTTP/2.0" - - "-" "-" 192 "-" "-" 0ms
172.20.59.64 - - (29/Mar/2020:22:19:49 +0000) "GET / HTTP/2.0" - - "-" "-" 193 "-" "-" 0ms
172.20.59.64 - - (29/Mar/2020:22:19:49 +0000) "GET / HTTP/2.0" - - "-" "-" 194 "-" "-" 0ms
172.20.59.64 - - (29/Mar/2020:22:21:09 +0000) "GET / HTTP/2.0" - - "-" "-" 195 "-" "-" 0ms

Amazon web services: what's the difference between AWS site-to-site VPN and AWS client VPN?

I know that Site to Site you are using IPSec (layer 3), but client you are using TLS (application layer). It seems that both are really Site to Site vpns after reading articles / documents online.

I assume the protocol (IPSec vs. TLS) is its only difference, which has implications on when you would use which one. I assume both are equally good, and you should always use TLS at the application layer anyway, even on top of the client's VPN.

How do you decide which one to use and why?

amazon ec2 – Virutal Hosting using XAMPP on AWS EC2 INSTANCE

Trying to host 2 or more domains in a single instance of aws ec2.

my configuration is:

18.219.39.37 [my domain]

Listen 80


AllowOverride none
Require all granted

#Virtual hosts

Include etc / extra / httpd-vhosts.conf

#since XAMPP 1.4.3

AllowOverride AuthConfig Limit
Order allow, deny
Require all granted
Allow from all


ServerAdmin webmaster @ [public IPv4 IP]
DocumentRoot "/ opt / lampp / htdocs / rustikhaws / public_html /"
ServerName [IPv4 public IP]

This configuration gives me …

The requested URL was not found on this server. If you entered the URL manually, please check your spelling and try again.

If you think this is a server error, please contact the webmaster.

and i don't know what is missing in my setup.

Please help. Thank you!

amazon web services – General questions about setting up Vivotek Camera with AWS Kinesis Video Stream?

Thanks for contributing a response to Stack Overflow!

  • Please make sure answer the question. Please provide details and share your research!

But avoid

  • Ask for help, clarification or respond to other answers.
  • Make statements based on opinion; back them up with references or personal experience.

For more information, check out our tips on how to write great answers.

Nginx installed on Windows on EC2 (AWS)

Hi everyone,
I have installed a basic Windows server with Nginx on AWS.
I tried the installation and it's fine. (On the server, I typed "localhost" and the browser showed the Nginx welcome page).
I am having trouble connecting from another machine. I have tried ping + IP, ping + DNS, and did the same with HTTP (IP or DNS name).
The server is unreachable.
I have checked network security and it is fine.
HTTP TCP 80 0.0.0.0/0 –
HTTP TCP 80 :: / 0 –
RDP …

Nginx installed on Windows on EC2 (AWS)