Connect to Basic Mysql from AKS Nodejs Pod

Question

Connect to Basic Mysql from AKS Nodejs Pod

James Bissett 1

I have defined an external Service in AKS as below

apiVersion: v1
kind: Service
metadata:
  name: mysql
  namespace: mySpace
spec:
  type: ExternalName
  externalName: myDb.mysql.database.azure.com

then in my node app attempt to access by

mySqlConnection = mysql.createPool({
          host: mysql.mySpace.svc,
          port: 3306,
          user: myUser,
          password: myPass,
          database: myDB,
          waitForConnections: true,
          connectionLimit: 10,
          queueLimit: 0,
          multipleStatements: true
        });

but the connection does not seem to go through.
The pod and the Service are both in the same namespace.
I have also turned off ssl and allowed access from Azure Services in the portal ( This is only temporary for testing).
I have another Mysql running in the cluster, which I can connect to with no problems (i want to replace this instance with the MySql Paas)
I understand the connection options are limited in the basic deployments but I would rather not drive up my cots at the moment to upgrade to GP or Mem Opt at the moment.
Any help would be appreciated.
Thank you in advance.

Answer 1

Hello @James Bissett ,
In order for the AKS POD container to communicate to a PAAS SQL Service , it needs a VNET service endpoint followed by a vnet-rule which needs to be added .

I just tried below git hub document successfully , which talks about an AKS POD communication to MySQL PAAS Service.
https://github.com/yoshioterada/k8s-Azure-Container-Service-AKS--on-Azure/blob/master/Kubernetes-Workshop9.md

Able to login to the pod container and perform mysql operations.

Kindly let me know if you have additional questions.

Answer 2

James Bissett 1

VNET endpoints are not available in Basic, they require General Purpose or Memory Optimised plans.

shiva patpi 9,661 Reputation points Microsoft Employee

2020-12-03T21:08:58.53+00:00

I did try with Basic mysql and I was able to connect from container to mysqlDB.
Initially I was getting error ERROR 9000 (HY000): Client with IP address '40.76.160.39' is not allowed to connect to this MySQL server.
But after adding the client IP , I was able to query.
James Bissett 1 Reputation point

2020-12-04T00:52:37.07+00:00

When trying to add the subnet to the mysql instance,

az mysql server vnet-rule create \
-n k8sRule \
-g myResGroup \
-s myDB \
--subnet /subscriptions/{mysub|/resourceGroups/{myResGroup}/providers/Microsoft.Network/virtualNetworks/{myvnet}/subnets/{mysubvnet}

i get the following error

Deployment failed. Correlation ID: d0b49788-a3bb-402a-81e5-888092148298. This feature is not available for the selected edition 'Basic'
James Bissett 1 Reputation point

2020-12-04T01:03:59.373+00:00

In the github link you supplied in your answer, the mysql creation is actually creating a tier level "General Purpose" not "Basic:

"administratorLogin": "yoterada",
"earliestRestoreDate": "2018-06-29T12:21:50.183000+00:00",
"fullyQualifiedDomainName": "my-mysqlserver.mysql.database.azure.com",
"id": "/subscriptions/f77aafe8-****-****-****-d0c37687ef70/resourceGroups/MySQL-RG/providers/Microsoft.DBforMySQL/servers/my-mysqlserver",
"location": "japaneast",
"name": "my-mysqlserver",
"resourceGroup": "MySQL-RG",
"sku": {
"capacity": 2,
"family": "Gen4",
"name": "GP_Gen4_2",
"size": null,
"tier": "GeneralPurpose"
},
shiva patpi 9,661 Reputation points Microsoft Employee

2020-12-09T22:25:15.667+00:00

Hello @James Bissett ,
Apologies for late response. Yeah , you won't be able to add vnet-rule for the basic SKU. I was able to communicate from container pod to the Basic MySQL PAAS instance with out any additional vnet-rule.

Regards,
Shiva.
James Bissett 1 Reputation point

2020-12-10T07:06:37.333+00:00

I solved the problem by adding an entry in private DNS to allow resolution of the URL from the pod. Also worth noting that the userId does require the @dbname to qualify it it in the PaaS connection.

Connect to Basic Mysql from AKS Nodejs Pod

2 answers

Activity