Now that we have created our Redis Cache lets connect to it. You can use the most common tool redis cli.exe https://redis.io/download or as I am going to do, use the Azure Portal to use the console directly, this isn’t probably the best way but it’s the easiest for this blog. 2 key points here:
Building Azure Redis Cache
Let’s go through a Redis build process. It will be fun.
Azure Redis Cache Intro
Redis Cache is a well know caching technology and you can run it in Azure as a fully managed service. A common requirement (the most basic one) is doing a workflow like:
Microsoft Defender for open-source relational DB
If you navigate to the overview section of your MySQL server you will see a notification area, here you will find security section. It’s basically an area to provide some hints / tips if things have not been configured such as if you have not enabled query store it may well suggest it. For this blog it is suggesting I consider a feature called Microsoft Defender.
MySQL server Query Store
The query store, sounds familiar? The idea of the black box sitting within the database server watching what is going on within the environment. This is available within MySQL, maybe not as feature rich as SQL Server but still useful.
You will find this option under the Query performance insight section of your MySQL server.
Azure DB for MySQL – Replication
No doubt there will be a need for you to split off your analytical queries from the main database for performance reasons.
Azure DB for MySQL – server parameters
If you have used MySQL before you will know about the system server variables, you know such commands as SHOW VARIABLES; You can access most of them via the Azure portal or connect to MySQL and issues the commands you come to know about.
Azure DB for MySQL – Storage v1 vs v2
When it comes to MySQL and storage you will normally have to decide on 3 options: basic, general purpose v1 or v2.
Basic does support up to 1TB and is low-cost option but has no IOPs guarantee, not really recommended for production systems. General purpose v2 should be the one used because it uses latest storage infrastructure which can support up to 16-TB and 20000 IOPs a shown below.
Connecting to Single Server MySQL
We have already created the server now it’s time to connect to it. What you will need – connection string details, correct networking setup and a tool like MySQL Workbench.
Creating Azure DB for MySQL – Single Server
Enough of the theory and text lets use the Azure Portal and create MySQL Single server. Navigate to the Azure Portal, find Azure Database for MySQL servers: