GC: increase memory to 256Mi and drop CPU limit to 500m

[goat-ssh]

Summary of changes

We continue to see occasional crash due to OOMs especially on clusters with frequent scheduled jobs. Also reduce CPU limit to 500m as we're too generous with 2 CPUs now.

Checklist

• [x] Link to issue this PR refers to: https://github.com/crate/cloud/issues/1886
• [x] Relevant changes are reflected in CHANGES.rst
• [ ] Added or changed code is covered by tests
• [ ] Documentation has been updated if necessary
• [x] Changed code does not contain any breaking changes (or this is a major version change)

[goat-ssh]

Script to patch:

#!/usr/bin/env bash
##set -ex

for namespace in $(kubectl get cratedb --all-namespaces -o jsonpath='{.items[*].metadata.namespace}'); do
  depl=$(kubectl -n "$namespace" get deployment --selector=app.kubernetes.io/component=grand-central -o jsonpath='{range .items[*]}{.metadata.name}{end}')
  echo "Processing Namespace: $namespace and GC: $depl"
  # patch the deployment to update resources
  kubectl -n "$namespace" patch deployment "$depl" -p'{"spec":{"template":{"spec":{"containers":[{"name":"grand-central-api","resources":{"requests":{"cpu":"64m","memory":"256Mi"},"limits":{"cpu":"500m","memory":"256Mi"}}}]}}}}'
done

[goat-ssh]

Progress:

dev:

• [x] aks1.eastus-dev
• [x] eks1.us-east-1
• [x] gke1.us-east1-dev

prod:

• [x] aks2.westeurope
• [x] aks1.eastus2
• [x] aks1.westeurope
• [x] eks1.eu-west-1
• [x] eks1.us-east-1
• [x] gke1-us-central1

[goat-ssh]

How to check current settings:

kubectl get deploy -l app.kubernetes.io/component=grand-central -o=jsonpath='{range .items[*]}{.metadata.name} REQ:{..containers..resources.requests} LIMIT:{..containers..resources.limits}{"\n"}{end}' -A