Azure Database for MariaDB
An Azure managed MariaDB database service for app development and deployment.
48 questions
2 answers
Get csv file in mail
I am Creating csv file after that this file I am adding in the share point document library by using (create file ) by giving .csv extension after that I am taking that item content by using (get file content ). now I am adding this get item content…
asked 2022-06-22T06:46:27.22+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 7.000000000000001%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Rajat
1
Reputation point
commented 2022-07-04T14:33:41.72+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 0%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZY%3C/text%3E%3C/svg%3E)
Zehui Yao_MSFT
5,831
Reputation points
1 answer
Where I can activate query_store_capture_mode in MariaDB 10.3?
In the documentation I found: Enable Query Store using the Azure portal Sign in to the Azure portal and select your Azure Database for MariaDB server. Select Server Parameters in the Settings section of the menu. Search for the…
asked 2022-05-26T12:44:53.227+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 10%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETG%3C/text%3E%3C/svg%3E)
Tecnico1 Giletta
1
Reputation point
commented 2022-06-01T21:17:49.86+00:00
GeethaThatipatri-MSFT
27,337
Reputation points Microsoft Employee
0 answers
MariaDB Hybrid Synchronization Top 3 Scenarios
What are top 3 scenarios for MariaDB hybrid synchronization? Thanks
asked 2022-05-26T19:31:40.017+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 91%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMQ%3C/text%3E%3C/svg%3E)
Morris Qibou
1
Reputation point
commented 2022-05-30T08:52:02.363+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Anurag Sharma
17,571
Reputation points
1 answer
setup ms universal printing
Hello, I need printers to be accessible globally without using any hardware. Setting up MS universal printing was really confusing. I created an account in microsoft azure and can login in azure portal, but admin.microsoft.com doesn't let me login. Can…
asked 2022-05-17T17:39:09.507+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
commented 2022-05-23T15:34:52.777+00:00
GeethaThatipatri-MSFT
27,337
Reputation points Microsoft Employee
2 answers
Use of CONNECT ENGINE
Hello, I want to use the "connect engine" from an external machine to an azure database. The problem is with the connexion URL as the Microsoft "user" to connect to the Azure PAAS already contains an "@" which is (in…
asked 2022-04-14T08:39:52.663+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 96%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
JPP
1
Reputation point
commented 2022-04-19T23:38:36.383+00:00
Oury Ba-MSFT
16,081
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How can you create indexes on replica database only
I want to create a replica of Azure MariaDB but with the ability to create indexes on it to improve search performance. How can I do that?
asked 2022-04-06T07:14:18.697+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 70%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHF%3C/text%3E%3C/svg%3E)
Hussain Fakhruddin
21
Reputation points
accepted 2022-04-13T10:09:57.777+00:00
Hussain Fakhruddin
21
Reputation points
3 answers
Types of Databases in azure
I need a comparison matrix of all the essential attributes, which can be differentiating to choose a database, MariaDB, Postgres, MySQL and SQL Server, since in the documentation each one is different and there is no resource that evaluates in different…
asked 2022-03-15T22:40:31.487+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 39%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Rodrigo Ramos Hernandez
1
Reputation point
commented 2022-03-17T18:13:29.147+00:00
Oury Ba-MSFT
16,081
Reputation points Microsoft Employee
2 answers
Error connecing with Database under WSL 2
I am using latest Windows 11 build and installed WSL 2 (Debian) for development purpose. To try out a project, I need to install and configure MariaDB under my WSL Debian system. I have installed MariaDB 10.6.5 fine with no errors, but during initial…
asked 2022-01-07T17:45:16.173+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 2%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Abhi D
1
Reputation point
commented 2022-01-26T18:15:35.857+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Saurabh Sharma
23,676
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
mysql on version 5.7 but hecking the server status states Server version is 5.6.42.0
We have a setup for azure mysql on version 5.7 according to the azure portal, however checking the server status states Server version is 5.6.42.0 MySQL Community Server (GPL). See attached.
asked 2020-05-14T02:08:30.073+00:00
Rohan Jones
291
Reputation points
commented 2021-12-01T16:33:31.897+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 35%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVG%3C/text%3E%3C/svg%3E)
Venu Gopal
1
Reputation point
1 answer
Opening ports to Azure for MariaDb
Hi All, More of an AWS guy here, so having a little trouble w. the Azure configs. I'm trying to set up NXLog Manager to connect to an Azure for MariaDb PaaS product. NXL, however, requires communication to the DB over 20000, 34200-34300 as well as…
asked 2021-11-16T05:27:43.46+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 54%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Me
1
Reputation point
commented 2021-11-30T19:37:12.18+00:00
GeethaThatipatri-MSFT
27,337
Reputation points Microsoft Employee
1 answer
Set charset and collation EF Core 3 code first
Using ASP.Net core and Identity 3.1, I have a web app and using Pomelo package to connect to mysql/MariaDB as my databsae. I can alter my tables and columns after database is created to change my collation and charset but looking for a way to set my…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 50%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
0 answers
Azure Policy to validate if TLS field is not selected
I am trying to implement a Deny Policy for "Azure Database for MySQL" -> "Connection Security" in Azure Portal which validates that once the "Enforce SSL Connection" is set to "Enabled" (handled in a separate…
asked 2021-09-28T15:25:12.833+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 46%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Aadil Karolia
1
Reputation point
commented 2021-09-30T08:24:56.513+00:00
Anurag Sharma
17,571
Reputation points
1 answer
Import data from serveur MariaDB to Azure MariaDB
Hi, I'm trying to import a database backed up with mysqldump from a server to Azure Mariadb. I use MySQL Workbench with the administrator account with the Server> Data Import menu. There is the message: ERROR 1046 (3D000) at line 22: No database…
asked 2021-04-22T16:51:09.637+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 24%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
AMI
1
Reputation point
commented 2021-04-27T22:41:05.847+00:00
Oury Ba-MSFT
16,081
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Connection via ODBC to MariaDB
Hello, I have some problem with my connection to my MariaDB via Virtual Machine Azure (ODBC and Heidi). I have already sucessefuly connect from diverses computers (not VM) to this DB, but when I try in VM Azure this doesn't works. What I have already…
asked 2021-03-01T19:22:15.78+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 1%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Luis Martins
116
Reputation points
commented 2021-03-05T23:13:42.61+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 93%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Navtej Singh Saini
4,216
Reputation points Microsoft Employee
1 answer
Manually trace Query Performance that spike our CPU usage in Azure Database MariaDB 10.3
Query Performance Insight is not applied to Azure Database MariaDB 10.3. I there any other option that we can manually trace Query Performance that spike our CPU usage?
asked 2021-01-22T09:55:14.747+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 92%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mohd Khairi
1
Reputation point
commented 2021-02-04T17:15:29.197+00:00
Navtej Singh Saini
4,216
Reputation points Microsoft Employee
3 answers
Getting SSL keys+certs from deployed MariaDB instances to be used with MaxScale
Hi everybody, is there a way to get for each MariaDB deployed instance the relative SSL certificate+key couple? Looking at the MariaDB SSL documentation there's no mention of keys or certificates, but just the CA, which is specifically this…
asked 2021-01-18T17:48:16.307+00:00
Raoul Scarazzini
1
Reputation point
commented 2021-02-03T01:38:42.133+00:00
Navtej Singh Saini
4,216
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Any event or metric that indicates Azure Maria DB backup success?
Hi, Is there any way to know or any event that can be used to send out an email notification whenever Azure Database for Maria DB completes the backup? We are aware that Azure Database for MariaDB service takes full, differential, and transaction log…
asked 2020-10-20T15:30:28.497+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 20%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBG%3C/text%3E%3C/svg%3E)
Bhushan Gawale
306
Reputation points
accepted 2020-12-21T19:18:15.843+00:00
Bhushan Gawale
306
Reputation points
1 answer
One of the answers was accepted by the question author.
Replicate production Maria DB server to Maria DB Azure PaaS
Hello all, we have been working on a customer use case where Maria DB is installed on the Azure VM and contains several large databases that are live in production. Customer wants to get this migrated to Maria DB PaaS service of Azure with minimal…
asked 2020-06-15T13:02:27.017+00:00
Bhushan Gawale
306
Reputation points
accepted 2020-12-21T19:18:02.02+00:00
Bhushan Gawale
306
Reputation points
1 answer
MariaDB Azure won't start
Hi, i had a Problem with the MariaDB Instance from Microsoft Azure. We stop the instance every evening, because it is only an dev environment. Today in the morning i start all services again, also the MariaDB Service. After 4 hours the…
asked 2020-12-15T12:05:08.183+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 9%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Christian Röhl
1
Reputation point
commented 2020-12-15T16:53:05.05+00:00
Anurag Sharma
17,571
Reputation points
1 answer
DB import error
Hi, I created a MariaDB server and I am able to connect it using commandline. I created a database and few empty tables from mysql cli without any issues. I am unable to import a database dump in the server. I get below error, root@Serdf2 [~]# mysql -h…
asked 2020-08-21T12:26:41.07+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 26%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Ajin Prasad
6
Reputation points
answered 2020-10-28T19:55:25.18+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 25%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Miroslav Adamec
1
Reputation point