default datetime in mysql

 ALTER TABLE <TABLE_NAME> 

CHANGE COLUMN <COLUMN_NAME> <COLUMN_NAME> DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP;

How to create an AKS cluster in Azure?

 

To create an Azure Kubernetes Service (AKS) cluster, you can use either the Azure portal, Azure CLI, or Azure PowerShell. Here are the steps for each method:

1. Azure Portal:
• Sign in to the Azure portal (https://portal.azure.com).
• Click on "Create a resource" in the left navigation pane.
• Search for "Azure Kubernetes Service" and select it from the search results.
• Click on "Create" to start the AKS cluster creation wizard.
• Provide the necessary information, such as subscription, resource group, cluster name, region, and Kubernetes version.
• Configure the desired node size, node count, and authentication method.
• Review the settings and click on "Review + Create" to validate the configuration.
• Finally, click on "Create" to create the AKS cluster. The deployment may take several minutes to complete.
2. Azure CLI:
• Open the Azure CLI (command-line interface) on your local machine or use the Azure Cloud Shell (https://shell.azure.com).
• Run the following command to create an AKS cluster:

az aks create --resource-group <resource-group-name> --name <cluster-name> --node-count <node-count> --node-vm-size <node-vm-size> --location <region>

Replace <resource-group-name> with the name of the resource group where the cluster should be created, <cluster-name> with the desired name for the cluster, <node-count> with the number of nodes in the cluster, <node-vm-size> with the VM size for the nodes, and <region> with the desired region for the cluster.

• Optionally, you can add more parameters to the command to configure advanced settings like networking, authentication, and monitoring.
2. Azure PowerShell:
• Open the Azure PowerShell module on your local machine or use the Azure Cloud Shell (https://shell.azure.com).
• Run the following command to create an AKS cluster:

New-AzAksCluster -ResourceGroupName <resource-group-name> -Name <cluster-name> -NodeCount <node-count> -NodeVmSize <node-vm-size> -Location <region>

Replace <resource-group-name> with the name of the resource group, <cluster-name> with the desired name for the cluster, <node-count> with the number of nodes in the cluster, <node-vm-size> with the VM size for the nodes, and <region> with the desired region.

• You can also provide additional parameters to the command to configure networking, authentication, and other advanced options.

After executing the appropriate command, the AKS cluster creation process will start, and it may take several minutes to complete. Once the cluster is created, you can access and manage it using the Azure portal, Azure CLI, Azure PowerShell, or the Kubernetes command-line tool (kubectl).

How to configure load balancer in Azure Kubernetes Service ?

 

To configure a load balancer in Azure Kubernetes Service (AKS), you can follow these steps:

1. Create an AKS cluster: Start by creating an AKS cluster using the Azure portal, Azure CLI, or Azure PowerShell. Make sure to specify the desired configuration, such as the number of nodes, node size, and networking options.
2. Deploy your application: Once the AKS cluster is created, deploy your application or services to the cluster. You can use Kubernetes manifests (YAML files) to define your application deployment, services, and any necessary ingress resources.
3. Create a Kubernetes service: To expose your application to the external world and load balance the traffic, you need to create a Kubernetes service. A service defines a stable network endpoint that receives traffic and distributes it to the appropriate pods.

Here's an example of a Kubernetes service manifest that exposes your application on a specific port:

apiVersion: v1

kind: Service

metadata:

  name: my-app-service

spec:

  type: LoadBalancer

  ports:

    - port: 80

      targetPort: 8080

  selector:

    app: my-app

In this example, the service is defined as type LoadBalancer, and it exposes port 80, which gets mapped to the target port 8080 on the pods labeled with app: my-app.

4. Apply the service manifest: Apply the service manifest using the kubectl apply command to create the service in the AKS cluster. The Kubernetes service controller will automatically provision an Azure Load Balancer and configure the necessary routing rules.

kubectl apply -f service.yaml

5. Verify the load balancer: Once the service is created, you can check the status and details of the load balancer using the Azure portal, Azure CLI, or Azure PowerShell. Look for the provisioned Load Balancer resource associated with your AKS cluster.
6. Access your application: After the load balancer is provisioned and configured, it will route the incoming traffic to the pods running your application. You can access your application using the public IP address or DNS name associated with the load balancer.

That's it! You have now configured a load balancer for your application in Azure Kubernetes Service. The load balancer will evenly distribute incoming traffic to the pods, ensuring high availability and scalability for your application.