Using DB Alias in AAKE

[B Bharath Kumar Reddy]

Hello Team,

Has anyone succeeded using DB Aliases in AAKE installation? We are currently using the standard ae-db secret that generates the odbc and jdbc strings with hostname & db name. The documentation also states that one can modify the secret (though it won't be a permanent change) but I'm wondering on where we can define the alias details in the first place (tnsnames.ora)

Preparing the AE and Analytics Database for the Container Installation

Our idea is to use Alias so that we can reduce the overall downtime in case of any disaster recovery by simply importing the backup data onto a new DB and re-map the alias to new DB.

[Vimal Nallajerla V.V.N]

Hi Bharath, 

It might be possible using DNS CNAME record. If your primary goal is strictly reducing DR downtime, using a DNS CNAME record is often simpler to maintain than managing custom volume mounts and ConfigMaps in Kubernetes. Create a DNS record (e.g., aake-db-primary.yourcompany.com) and use that as the standard hostname in your ae-db secret.

During a DR Event, update the DNS CNAME record to point to your DR database's IP address. The AAKE pods might automatically connect to the new database upon their next retry.

Regards

Vimal

[Oana Botez]

Hi Bharath,

In v26 it's possible to set the ODBC and JDBC strings before the ae-db secret is generated, thus overwriting the strings that would otherwise be generated based on the other params.

For example:

kubectl create secret generic ae-db-oracle \
  --from-literal=host=external-oracle.location \
  --from-literal=vendor=oracle \
  --from-literal=port='1521' \
  --from-literal=user=username \
  --from-literal=db=ORCLCDB.localdomain \
  --from-literal=password=S3cret \
  --from-literal=data-tablespace-name=ae_data \
  --from-literal=index-tablespace-name=ae_index \
  --from-literal=additional-parameters=";SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=AL32UTF8,NLS_LENGTH_SEMANTICS=CHAR"
  --from-literal=overwrite-odbc="ODBCVAR=NNJNIORO,DSN=10.0.0.1:1521/DB.EXAMPLE.COM;UID=uc4;PWD=???;SP=NLS\_LANGUAGE=AMERICAN,NLS\_TERRITORY=AMERICA,CODESET=AL32UTF8"
  --from-literal=overwrite-jdbc="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS\_LIST=(ADDRESS=(PROTOCOL=TCP)(PORT=1521)(HOST=10.0.0.1))(ADDRESS=(PROTOCOL=TCP)(PORT=1521)(HOST=10.0.0.2)))(CONNECT\_DATA=(SERVICE\_NAME=DB.EXAMPLE.COM)))"

You can find more details in the documentation here https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/26.0.0/Automic%20Automation%20Guides/Content/Installation_Containers/containers_PreparingAEAnalyticsDB_ContainerInstallation.htm?Highlight=overwriteODBC

BR,
Oana