Understanding the changes in the Root CA change for Azure Database for MySQL single server (SSL)

https://learn.microsoft.com/en-us/azure/mysql/single-server/concepts-certificate-rotation#create-a-combined-ca-certificate They changed supplier Download new cert from link and edit in your connection string Connect with HeidiSQL and check version That is if ssl in enforced in mysql for single server and version is selected, i.e 1.2 in Azure. Note This article applies to Azure Database for MySQL – Single Server ONLY. For Azure […]

Azure for MySql single server (with Zabbix)

Make ubuntu vm Make Azure for MySql single server Add 2 NSG to the vm Add firwale rules to the MySQL Install and configure Zabbix Connect to MySQL with HeidiSQL Connect Zabbix to MySQL Configure frontend Azure Database for MySQL documentation | Microsoft Docs Note port 3306 vs 3309 for client. If you install Zabbix […]

Zabbix agent

4 Windows agent installation from MSI (zabbix.com) After you have installed Zabbix on a VM and MySQL or PostGreSQL on a another VM it is time to start collecting data from the servers you want to monitor. Install Zabbix Agent on Windows (msi) | Server Monitoring Guide (bestmonitoringtools.com) Install agent msi On the host you […]

Zabbix 6 good practice 2022 + Azure install 2 VM’s (zabbix and mysql)

Note: Install Zabbix Server package without installing MySQL server : zabbix (reddit.com) software installation – What are the implications of –no-install-recommends (apt-get install)? – Ask Ubuntu Note check mysql installed It must be the last package Does MySQL get installed, is zabbix-server-mysql MySql: Getting Zabbix 6, there are 4 ways, 5 with Azure market. Microsoft […]

Zabbix on VM remote MySql (Na market)

Lets continue and install Zabbix on a VM and MySql on another: BasicsSubscriptionFree TrialResource groupzabbix-rgVirtual machine namevm-zabbixRegionWest USAvailability optionsNo infrastructure redundancy requiredImageUbuntu Server 18.04 LTS – Gen1SizeStandard DS1 v2 (1 vcpu, 3.5 GiB memory)Authentication typePasswordUsernameespentestPublic inbound portsSSHAzure SpotNoDisksOS disk typeStandard HDDUse managed disksYesUse ephemeral OS diskNoNetworkingVirtual network(new) zabbix-rg-vnetSubnet(new) default (10.0.0.0/24)Public IP(new) vm-zabbix-ipAccelerated networkingOffPlace this virtual […]