--- title: "MySQL Database for Secure Messages" slug: "mysql-database-for-secure-messages" description: "Set up an Azure MySQL Database for eSHARE Secure Messages, approve private access, connect it in Admin Console, and monitor database health." tags: ["Azure MySQL", "Secure Messages"] updated: 2026-10-21T16:39:24Z published: 2026-10-21T16:39:24Z canonical: "docs.eshare.com/mysql-database-for-secure-messages" stale: true --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.eshare.com/llms.txt > Use this file to discover all available pages before exploring further. # MySQL Database for Secure Messages This document describes how to set up an Azure MySQL Database to migrate and store your organization's Secure Messages content from the eSHARE hosted Database. The following steps will be reviewed: - [Requirements and Pricing](/collaborate/docs/mysql-database-for-secure-messages#requirements-and-pricing) - [Set Up the MySQL Server in Azure](/collaborate/docs/mysql-database-for-secure-messages#set-up-the-mysql-server-in-azure) - [Set Up the MySQL Database in Azure](/collaborate/docs/mysql-database-for-secure-messages#set-up-the-mysql-database-in-azure) - [Approve the Private Endpoint Connection](/collaborate/docs/mysql-database-for-secure-messages#approve-the-private-endpoint-connection) - [Connect the Database in the eSHARE Admin Console](/collaborate/docs/mysql-database-for-secure-messages#connect-the-database-in-the-eshare-admin-console) - [Monitor Database Health](/collaborate/docs/mysql-database-for-secure-messages#monitor-database-health) > **PREREQUISITES:** > > Access to the Microsoft Azure Portal with permission to create Azure Database for MySQL flexible server resources, and an eSHARE administrator role with access to the eSHARE Admin Console. ### **Requirements and Pricing** The recommended practice is to utilize Microsoft’s Azure SQL Database. It offers several deployment options while running as a hosted service and tiers that scale according to your needs. We recommend the [General Purpose](https://docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tiers-general-purpose-business-critical) tier for the needs of this feature, it offers the best price/performance ratio. Please see [https://azure.microsoft.com/en-us/pricing/details/mysql](https://azure.microsoft.com/en-us/pricing/details/mysql) for up-to-date pricing. ### **Set Up the MySQL Server in Azure** 1. Log in to the Microsoft Azure Portal (*For Commercial Customers:* [*https://portal.azure.com*](https://portal.azure.com) *| For Government Customers:* [*https://portal.azure.us*](https://portal.azure.us)). 2. Search for '**Azure Database for MySQL flexible servers**' and select the '**Azure Database for MySQL flexible servers**' option from the list of services. ![](https://cdn.us.document360.io/c516537f-0d2f-4bf8-930d-3385ca9a11d7/Images/Documentation/CleanShot 2025-11-09 at 14.50.35@2x(2).png?sv=2026-02-06&spr=https&st=2026-11-18T20%3A08%3A32Z&se=2026-11-18T21%3A08%3A32Z&sr=b&sp=r&sig=UmituP7aiYGarK4TxnEnvghnGmZPgZzBCiMyu5fHlWw%3D) 1. On the next screen, select the '**Create**' option in the top left, then choose '**Advanced Create**' under '**Flexible server**'. 2. Select your subscription model and define the resource group (Resource group could be named "*eShareSQLdatabase*" for indexing purposes and ease of reference). It is recommended to define a separate resource group to isolate our access from any other service you might be running. ![A screenshot of a computer Description automatically generated](https://cdn.us.document360.io/c516537f-0d2f-4bf8-930d-3385ca9a11d7/Images/Documentation/azuresql-database-for-secure-messages-image-w2tae3cv.png?sv=2026-02-06&spr=https&st=2026-11-18T20%3A08%3A32Z&se=2026-11-18T21%3A08%3A32Z&sr=b&sp=r&sig=reh1QmDfLq8INQcukqqmJG0OtTb%2FINE5GrIhFD1%2B5lA%3D) 1. Set a '**Server name**', the '**Region**' of the database (US East recommended for better performance / same region as eSHARE), and the MySQL version (any available version is okay). ![](https://cdn.us.document360.io/c516537f-0d2f-4bf8-930d-3385ca9a11d7/Images/Documentation/CleanShot 2025-11-09 at 15.18.49@2x.png?sv=2026-02-06&spr=https&st=2026-11-18T20%3A08%3A32Z&se=2026-11-18T21%3A08%3A32Z&sr=b&sp=r&sig=HCod7uF%2F7Yxhji8XhQh5BwD6fbS7o7biTHhC4BPSzpo%3D) 1. Determine the '**Workload type**', '**Compute + storage**', and '**Availability Zone**'. eSHARE recommends the configuration shown in the below image. If the MySQL Flexible server will be used for only the eSHARE secure conversations, there is no need to select a pricier configuration as eSHARE’s use of the MySQL Database is not resource intensive in terms of read/write. ![](https://cdn.us.document360.io/c516537f-0d2f-4bf8-930d-3385ca9a11d7/Images/Documentation/CleanShot 2025-11-09 at 15.25.39@2x.png?sv=2026-02-06&spr=https&st=2026-11-18T20%3A08%3A32Z&se=2026-11-18T21%3A08%3A32Z&sr=b&sp=r&sig=%2BtdoK92Fa7Z00eOxxTUzrTK%2BdHn9yT321GDKkRX%2BwTI%3D) 1. For '**Authentication Method**', ensure a local SQL Authentication user is created, and add a username and password that will be used to access the database. ![](https://cdn.us.document360.io/c516537f-0d2f-4bf8-930d-3385ca9a11d7/Images/Documentation/CleanShot 2025-11-09 at 15.41.59@2x.png?sv=2026-02-06&spr=https&st=2026-11-18T20%3A08%3A32Z&se=2026-11-18T21%3A08%3A32Z&sr=b&sp=r&sig=WjxjF6NL7eOzmlO78HJE24dA%2FtiU%2FZlY3w5C1O508jw%3D) 1. Confirm the creation of your MySQL Database Server and wait for the server to be deployed. 2. Once completed, access the resource to proceed with creating a new Database for the server. ![](https://cdn.us.document360.io/c516537f-0d2f-4bf8-930d-3385ca9a11d7/Images/Documentation/CleanShot 2025-11-09 at 16.07.16@2x.png?sv=2026-02-06&spr=https&st=2026-11-18T20%3A08%3A32Z&se=2026-11-18T21%3A08%3A32Z&sr=b&sp=r&sig=%2BvBJEqVAgNmCYPEFsB%2FYNdsR2vgBLGY5paErpG8IwxQ%3D) ### **Set Up the MySQL Database in Azure** 1. While in the newly deployed MySQL Server resource, navigate to '**Settings**' > '**Databases**'. 2. Select the '**+ Add**' button at the top of the page. 3. Enter a name for your database, leave the other options as their defaults, and select '**Save**'. ![](https://cdn.us.document360.io/c516537f-0d2f-4bf8-930d-3385ca9a11d7/Images/Documentation/image-1779979871528.png?sv=2026-02-06&spr=https&st=2026-11-18T20%3A08%3A32Z&se=2026-11-18T21%3A08%3A32Z&sr=b&sp=r&sig=m10By6rw9btYGVLPoVrsOjfT2Lk5INRWHdYCjT9tc8A%3D) 1. Once creation has completed, go to the '**Overview**' page, select '**JSON View**', and send the Resource ID to your eSHARE Customer Success Manager so they can initiate the Private Endpoint Connection. ![](https://cdn.us.document360.io/c516537f-0d2f-4bf8-930d-3385ca9a11d7/Images/Documentation/CleanShot 2025-11-09 at 16.04.13@2x.png?sv=2026-02-06&spr=https&st=2026-11-18T20%3A08%3A32Z&se=2026-11-18T21%3A08%3A32Z&sr=b&sp=r&sig=XPdKEnZt7iEh7%2FbviRA08kENJKE0%2FTgx1vssUfh4JAI%3D) ### **Approve the Private Endpoint Connection** 1. In the newly created database, navigate to the '**Security**' section and select '**Networking**'. 2. Select the '**Private Access**' tab, then under '**Private endpoint connections**' there will be a pending request. Review the request and approve it. ![Graphical user interface, text, application, email Description automatically generated](https://cdn.us.document360.io/c516537f-0d2f-4bf8-930d-3385ca9a11d7/Images/Documentation/image-1762721161880.png?sv=2026-02-06&spr=https&st=2026-11-18T20%3A08%3A32Z&se=2026-11-18T21%3A08%3A32Z&sr=b&sp=r&sig=YkaNyh7GTMZ5%2FktI1V1R%2FR2kufAQBBHK6rbjy%2B6SfCc%3D) ### **Connect the Database in the eSHARE Admin Console** 1. Navigate to '**Admin Console**' > '**Share Messages**'. You will be required to point eSHARE to the Database you created so it can start storing your Organization's Secure Messages. 2. Fill out the required fields with the information: 1. **Database Type:** MySQL 2. **Host:** Endpoint name of the MySQL Server 3. **Port:** 3306 4. **Database:** Name of the created Database 5. **User:** local admin account username 6. **Password:** local admin account password 7. **Enable Secure Transport:** Enable, paste the [public Azure MySQL SSL certificate](https://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-connect-tls-ssl#download-the-public-ssl-certificate) ![](https://cdn.us.document360.io/c516537f-0d2f-4bf8-930d-3385ca9a11d7/Images/Documentation/CleanShot 2025-11-09 at 14.37.37@2x.png?sv=2026-02-06&spr=https&st=2026-11-18T20%3A08%3A32Z&se=2026-11-18T21%3A08%3A32Z&sr=b&sp=r&sig=wKsv1heUILEkSe16VvLViZAUwiC3l4256JjgaAUbGkE%3D) > [!WARNING] > Note: > > After saving you may receive an error message, ensure you have entered all information about the database correctly and the network connection has been put into place. ![Εικόνα που περιέχει σχεδίαση Περιγραφή που δημιουργήθηκε αυτόματα](https://cdn.us.document360.io/c516537f-0d2f-4bf8-930d-3385ca9a11d7/Images/Documentation/azuresql-database-for-secure-messages-image-q693nh29.jpg?sv=2026-02-06&spr=https&st=2026-11-18T20%3A08%3A32Z&se=2026-11-18T21%3A08%3A32Z&sr=b&sp=r&sig=g8%2FBMrxI5dzaAm%2BPNvbkaZiliFG5x84uwrqqrNe%2FKcA%3D) All Done! Now eSHARE will utilize your own Database for all your organization’s secure messages. ### **Monitor Database Health** In our implementation the most important and common things to keep track of to make sure the Database remains healthy are CPU Percent, Memory Percent, Network In/Out and Network connections and finally Storage Metrics. You will find these in the '**Metrics**' tab under Monitoring in your AzureSQL Database. ![](https://cdn.us.document360.io/c516537f-0d2f-4bf8-930d-3385ca9a11d7/Images/Documentation/CleanShot 2025-11-09 at 16.08.22@2x.png?sv=2026-02-06&spr=https&st=2026-11-18T20%3A08%3A32Z&se=2026-11-18T21%3A08%3A32Z&sr=b&sp=r&sig=PvYW%2FNyraqyjpQtti6uoc327SuvxGVuw%2FDCTioxwFLo%3D) - **CPU Percent:** A high CPU percent is not a bad thing if you don’t consistently reach the limit. - **Memory Percent:** Ideally your entire Database should be stored in memory while leaving enough for other processes. Check frequently as your Database scales in size. - **Network In/Out and Connections:** Unless doing backups or transferring huge amounts of data, it should not be the bottleneck. - **Storage Metrics:** Make sure you always have free space for new data, temporary files, snapshot, or backups. You can create an alert when database, logs and temp is > 85% usage so you can scale accordingly.