constants.py

# constants
'''
constants
'''
VIP = "vip"
RADONDB_POSTGRES = "radondb-postgres"
POSTGRES_OPERATOR = "postgres-operator"
AUTOFAILOVER = "autofailover"
POSTGRESQL = "postgresql"
READWRITEINSTANCE = "readwriteinstance"
READONLYINSTANCE = "readonlyinstance"
MACHINES = "machines"
ACTION = "action"
ACTION_START = "start"
ACTION_STOP = "stop"
IMAGE = "image"
PODSPEC = "podspec"
SPEC = "spec"
CONTAINERS = "containers"
CONTAINER_NAME = "name"
POSTGRESQL_CONTAINER = "postgresql"
PRIME_SERVICE_PORT_NAME = "prime"
HBAS = "hbas"
CONFIGS = "configs"
REPLICAS = "replicas"
VOLUMECLAIMTEMPLATES = "volumeClaimTemplates"
AUTOCTL_NODE = "autoctl_node"
PGAUTOFAILOVER_REPLICATOR = "pgautofailover_replicator"
STREAMING = "streaming"
STREAMING_ASYNC = "async"
STREAMING_SYNC = "sync"
DELETE_PVC = "deletepvc"
POSTGRESQL_PVC_NAME = "data"
SUCCESS = "exec_success"
FAILED = "exec_failed"
SERVICES = "services"
SELECTOR = "selector"
SERVICE_AUTOFAILOVER = "autofailover"
SERVICE_PRIMARY = "primary"
SERVICE_STANDBY = "standby"
SERVICE_READONLY = "readonly"
SERVICE_STANDBY_READONLY = "standby-readonly"
USERS = "users"
ADMIN_USER = "admin"
NORMAL_USER = "normal"
USER_PASSWORD = "password"
USER_NAME = "name"
RESTORE = "restore"
RESTORE_FROMSSH = "fromssh"
RESTORE_FROMSSH_PATH = "path"
RESTORE_FROMSSH_ADDRESS = "address"
RESTORE_FROMSSH_LOCAL = "local"

# api
API_GROUP = "postgres.radondb.io"
API_VERSION_V1 = "v1"
RESOURCE_POSTGRESQL = "postgresqls"
RESOURCE_KIND_POSTGRESQL = "PostgreSQL"

# status.CLUSTER_CREATE_CLUSTER
CLUSTER_CREATE_CLUSTER = "cluster_create"
CLUSTER_CREATE_BEGIN = "begin"
CLUSTER_CREATE_ADD_FAILOVER = "addition failover"
CLUSTER_CREATE_ADD_READWRITE = "addition readwrite"
CLUSTER_CREATE_ADD_READONLY = "addition readonly"
CLUSTER_CREATE_FINISH = "finish"

# base label
BASE_LABEL_PART_OF = "part-of"
BASE_LABEL_MANAGED_BY = "managed-by"
BASE_LABEL_NAME = "app-name"
BASE_LABEL_NAMESPACE = "app-namespace"

# label node
LABEL_NODE = "node-name"
LABEL_NODE_AUTOFAILOVER = "autofailover"
LABEL_NODE_POSTGRESQL = "postgresql"
LABEL_NODE_USER_SERVICES = "user-services"
LABEL_NODE_STATEFULSET_SERVICES = "statefulset-services"

# label sub node
LABEL_SUBNODE = "subnode-name"
LABEL_SUBNODE_READWRITE = "readwrite"
LABEL_SUBNODE_AUTOFAILOVER = "autofailover"
LABEL_SUBNODE_READONLY = "readonly"

# labe role
LABEL_ROLE = "role"
LABEL_ROLE_PRIMARY = "primary"
LABEL_ROLE_STANDBY = "standby"

# other label
LABEL_STATEFULSET_NAME = "statefulset"

# other
MACHINE_MODE = "machine"
K8S_MODE = "k8s"

# docker-compose
DOCKER_COMPOSE_FILE = "docker-compose.yaml"
DOCKER_COMPOSE_FILE_DATA = '''
version: '3.1'
services:
  %s:
    container_name: %s
    image: ${image}
    network_mode: host
    restart: always
    volumes:
      - ${pgdata}:/var/lib/postgresql/data
      - /dev/shm:/dev/shm
    env_file:
      - ./pgenv
    command:
      - auto_failover
'''

# .env
DOCKER_COMPOSE_ENV = ".env"
DOCKER_COMPOSE_ENV_DATA = '''
image={0}
host_name={1}
pgdata={2}
'''

# env_file
DOCKER_COMPOSE_ENVFILE = "pgenv"

# docker-compose data dirctory
DOCKER_COMPOSE_DIR = "docker_compose"
PGDATA_DIR = "pgdata"
ASSIST_DIR = "/var/lib/postgresql/data/assist"
DATA_DIR = "/var/lib/postgresql/data"
PG_DATABASE_DIR = "/var/lib/postgresql/data/pg_data"
INIT_FINISH = "init_finish"

PG_CONFIG_PREFIX = "PG_CONFIG_"
PG_HBA_PREFIX = "PG_HBA_"

# net
# main_vip
# read_vip
# port
# real_main_servers
# real_read_servers
LVS_BODY = '''
global_defs {{
    router_id postgres
}}

vrrp_instance VI_1 {{
    state BACKUP
    nopreempt
    interface {net}
    virtual_router_id 100
    priority 100

    advert_int 2
    authentication {{
        auth_type PASS
        auth_pass pass
    }}
    virtual_ipaddress {{
        {main_vip}
        {read_vip}
    }}
}}

virtual_server {main_vip} {port} {{
    delay_loop 10
    lb_algo lc
    lb_kind DR
    nat_mask 255.255.255.0
    protocol TCP

    {real_main_servers}
}}
virtual_server {read_vip} {port} {{
    delay_loop 10
    lb_algo lc
    lb_kind DR
    nat_mask 255.255.255.0
    protocol TCP

    {real_read_servers}
}}
'''

# ip
# port
LVS_REAL_MAIN_SERVER = '''
real_server {ip} {port} {{
    weight 1
    MISC_CHECK {{
        misc_path "/usr/local/bin/pgtools --isprimary {ip}"
        misc_timeout 60
    }}
}}
'''

# ip
# port
LVS_REAL_READ_SERVER = '''
real_server {ip} {port} {{
    weight 1
    MISC_CHECK {{
        misc_path "/usr/local/bin/pgtools --isstandby {ip}"
        misc_timeout 60
    }}
}}
'''

# main_vip
# read_vip
LVS_SET_NET = '''
/sbin/ifconfig lo down;
/sbin/ifconfig lo up;
echo 1 > /proc/sys/net/ipv4/conf/lo/arp_ignore;
echo 2 > /proc/sys/net/ipv4/conf/lo/arp_announce;
echo 1 > /proc/sys/net/ipv4/conf/all/arp_ignore;
echo 2 > /proc/sys/net/ipv4/conf/all/arp_announce;
/sbin/ifconfig lo:0 {main_vip} broadcast {main_vip} netmask 255.255.255.255 up;
/sbin/route add -host {main_vip} dev lo:0;
/sbin/ifconfig lo:1 {read_vip} broadcast {read_vip} netmask 255.255.255.255 up;
/sbin/route add -host {read_vip} dev lo:1;
'''