![Azure Database for MySQL](/img/default-banner.jpg)
- 60
- 43 417
Azure Database for MySQL
Приєднався 11 жов 2022
Azure Database for MySQL - Flexible Server is a fully managed open-source MySQL database-as-a-service offering on Azure that can handle mission-critical workloads with predictable performance and dynamic scalability. It's cost-effective and designed to provide more granular control and flexibility over database management functions and configuration settings. By leveraging the rich array of features available with the service, you can free up time to focus on rapid app development and accelerate time to market rather than investing precious time and resources to manage virtual machines and infrastructure.
Export backups on-demand in Azure Database for MySQL - Flexible Server (Public Preview)
With Public Preview of the on-demand backup and export feature, you can now easily export a physical backup of your MySQL flexible server to an Azure storage account (Azure blob storage) with just a few clicks on the Azure portal or with a single CLI command whenever you want. After exporting backups to blob storage, you can use them for multiple purposes, including:
- Data recovery, redundancy, and availability: In addition to the automated backups managed by the service, you can export backups on-demand and use them for data recovery. In case of data corruption, accidental deletion, or hardware failure, simply restore the server to its previous state using this copy of your data.
- Auditing: You can use exported physical backup files to restore on-premises MySQL servers to address the auditing, compliance, and archival requirements of an organization.
- Compliance: Regulated industries must be able to export any data hosted by a cloud provider.
- Avoid vendor lock in: Thake advantage of this solution to export data from MySQL flexible server or avoid vendor lock-in.
0:00 Introduction to On-demand backup and export feature
1:24 Demo
4:26 Resources
Resources:
Announcement blog: aka.ms/mysql-exportbackup-blog
Documentation: aka.ms/mysql-exportbackup
Recent updates and announcements playlist: aka.ms/azuremysqlupdates
Subscribe to our channel to learn more about Azure Database for MySQL: youtube.com/@UCOLRBAlkdNSRWNjpf_1P-oQ
Join the Azure Database for MySQL Contributors initiative and get recognized for your efforts! aka.ms/mysql-contributors
#AzureDatabaseforMySQL #mysql #flexibleserver #backup #export
- Data recovery, redundancy, and availability: In addition to the automated backups managed by the service, you can export backups on-demand and use them for data recovery. In case of data corruption, accidental deletion, or hardware failure, simply restore the server to its previous state using this copy of your data.
- Auditing: You can use exported physical backup files to restore on-premises MySQL servers to address the auditing, compliance, and archival requirements of an organization.
- Compliance: Regulated industries must be able to export any data hosted by a cloud provider.
- Avoid vendor lock in: Thake advantage of this solution to export data from MySQL flexible server or avoid vendor lock-in.
0:00 Introduction to On-demand backup and export feature
1:24 Demo
4:26 Resources
Resources:
Announcement blog: aka.ms/mysql-exportbackup-blog
Documentation: aka.ms/mysql-exportbackup
Recent updates and announcements playlist: aka.ms/azuremysqlupdates
Subscribe to our channel to learn more about Azure Database for MySQL: youtube.com/@UCOLRBAlkdNSRWNjpf_1P-oQ
Join the Azure Database for MySQL Contributors initiative and get recognized for your efforts! aka.ms/mysql-contributors
#AzureDatabaseforMySQL #mysql #flexibleserver #backup #export
Переглядів: 273
Відео
New advancements in Azure Database for MySQL - Flexible Server Business Critical service tier
Переглядів 1022 місяці тому
Following our commitment to deliver the best performance and availability for your mission critical workloads, we are bringing enhancements that will elevate your database experience on the Business Critical service tier for Azure Database for MySQL - Flexible Server. 1) Achieve a 2x increase in throughput using Accelerated Logs (General Availability): We're excited to announce the General Avai...
Microsoft Copilot in Azure - Unlock the benefits of Azure Database for MySQL with your AI companion!
Переглядів 3032 місяці тому
We’re excited to announce Microsoft Copilot in Azure extends capabilities to Azure Database for MySQL. Microsoft Copilot in Azure is an AI-powered tool that leverages Large Language Models (LLMs) and the Azure control plane to help you get answers to your general questions and receive high quality recommendations to real-time problems. With this new integration with Azure Database for MySQL, yo...
Load test emulation for MySQL - Flexible Server using mysqlslap
Переглядів 1483 місяці тому
Load test emulation for MySQL - Flexible Server using mysqlslap
Microsoft Defender for Cloud support for MySQL - Flexible Server - GA
Переглядів 543 місяці тому
Microsoft Defender for Cloud support for MySQL - Flexible Server - GA
Accelerated Logs (Public Preview) | Azure Database for MySQL
Переглядів 3728 місяців тому
We're excited to announce public preview of the accelerated logs feature for Azure Database for MySQL - Flexible Server! This functionality, available with the Business-Critical service tier at no additional cost, significantly enhances the performance of MySQL flexible servers, offering a dynamic solution that is designed for high throughput needs that also reduces latency and optimizes cost e...
Azure Database for MySQL Contributor initiative
Переглядів 1559 місяців тому
Azure Database for MySQL Contributor initiative
Private Link for Azure Database for MySQL - Flexible Server (General Availability)
Переглядів 1,5 тис.10 місяців тому
Private Link for Azure Database for MySQL - Flexible Server (General Availability)
MySQL extension for Azure Data Studio (General Availability)
Переглядів 39611 місяців тому
MySQL extension for Azure Data Studio (General Availability)
Autoscale IOPS for Azure Database for MySQL - Flexible Server (General Availability)
Переглядів 335Рік тому
Autoscale IOPS for Azure Database for MySQL - Flexible Server (General Availability)
Online migration for Azure Database for MySQL using Azure DMS (General Availability)
Переглядів 1,6 тис.Рік тому
Online migration for Azure Database for MySQL using Azure DMS (General Availability)
E08: Troubleshooting connectivity issues (P2) | Azure Database for MySQL - Troubleshooting Series
Переглядів 351Рік тому
E08: Troubleshooting connectivity issues (P2) | Azure Database for MySQL - Troubleshooting Series
Upgrade from MySQL 5.7 to 8.0 with minimal efforts (General Availability) | Azure Database for MySQL
Переглядів 6 тис.Рік тому
Upgrade from MySQL 5.7 to 8.0 with minimal efforts (General Availability) | Azure Database for MySQL
Cross-region read replicas in geo-paired regions (General Availability) | Azure Database for MySQL
Переглядів 315Рік тому
Cross-region read replicas in geo-paired regions (General Availability) | Azure Database for MySQL
E07: Checklist for troubleshooting performance | Azure Database for MySQL - Troubleshooting Series
Переглядів 712Рік тому
E07: Checklist for troubleshooting performance | Azure Database for MySQL - Troubleshooting Series
E06: Schema optimization | Azure Database for MySQL - Troubleshooting Series
Переглядів 251Рік тому
E06: Schema optimization | Azure Database for MySQL - Troubleshooting Series
E05: Troubleshooting query performance | Azure Database for MySQL - Troubleshooting Series
Переглядів 638Рік тому
E05: Troubleshooting query performance | Azure Database for MySQL - Troubleshooting Series
E04: Troubleshooting low memory issues | Azure Database for MySQL - Troubleshooting Series
Переглядів 473Рік тому
E04: Troubleshooting low memory issues | Azure Database for MySQL - Troubleshooting Series
Azure Database for MySQL connector for Power Apps (Public Preview)
Переглядів 1,3 тис.Рік тому
Azure Database for MySQL connector for Power Apps (Public Preview)
Connect to Azure Database for MySQL using Power BI directly from the Azure portal
Переглядів 2,2 тис.Рік тому
Connect to Azure Database for MySQL using Power BI directly from the Azure portal
Azure Database for MySQL connector for Power Automate & Logic Apps (Public Preview)
Переглядів 1,2 тис.Рік тому
Azure Database for MySQL connector for Power Automate & Logic Apps (Public Preview)
E03: Troubleshooting high CPU utilization | Azure Database for MySQL - Troubleshooting Series
Переглядів 900Рік тому
E03: Troubleshooting high CPU utilization | Azure Database for MySQL - Troubleshooting Series
E02: Troubleshooting connectivity issues | Azure Database for MySQL - Troubleshooting Series
Переглядів 765Рік тому
E02: Troubleshooting connectivity issues | Azure Database for MySQL - Troubleshooting Series
E01: Introduction to troubleshooting | Azure Database for MySQL - Troubleshooting Series
Переглядів 457Рік тому
E01: Introduction to troubleshooting | Azure Database for MySQL - Troubleshooting Series
S02 E04: Monitoring and optimising application performance | MySQL Developer Essentials
Переглядів 90Рік тому
S02 E04: Monitoring and optimising application performance | MySQL Developer Essentials
S02 E03: Planning for High Availability and Disaster Recovery | MySQL Developer Essentials
Переглядів 45Рік тому
S02 E03: Planning for High Availability and Disaster Recovery | MySQL Developer Essentials
S02 E02: Securing your data with Azure Database for MySQL | MySQL Developer Essentials
Переглядів 52Рік тому
S02 E02: Securing your data with Azure Database for MySQL | MySQL Developer Essentials
S02 E01: Building web applications and microservices for MySQL in Azure | MySQL Developer Essentials
Переглядів 93Рік тому
S02 E01: Building web applications and microservices for MySQL in Azure | MySQL Developer Essentials
S01 E01: What is Azure Database for MySQL Flexible Server? | MySQL Developer Essentials
Переглядів 194Рік тому
S01 E01: What is Azure Database for MySQL Flexible Server? | MySQL Developer Essentials
S01 E02: Application patterns and use cases for Azure DB for MySQL | MySQL Developer Essentials
Переглядів 163Рік тому
S01 E02: Application patterns and use cases for Azure DB for MySQL | MySQL Developer Essentials
I want an AI webinar AI Edition
where do we check the paid IO in my azure mysql flexible server
Hi @cloudway908, you can follow the steps mentioned here to monitor the IOPS utilised: learn.microsoft.com/azure/mysql/flexible-server/concepts-storage-iops#monitor-storage-performance
hi thank you for this video. Is it possible for the exported files to populate a new MySQL - Flexible Server (migration), for servers that have not been enabled with Geo redundancy?
The ability to use exported backups to spin up a new flexible server is not supported in public preview, but the functionality will become available after the feature goes GA. In the interim, please consider using “on-demand backup” (learn.microsoft.com/azure/mysql/flexible-server/how-to-trigger-on-demand-backup) to restore to a new instance of Azure Database for MySQL - Flexible Server.
Doesn't work. I just keep on getting this error in cloud shell: ERROR 9125 (HY000): An error occurred while validating the access token. Please acquire a new token and retry.
Thank you RAVI for driving us with the usual Connectivity issues with Vnet integrated servers
Thanks Ravi, for the insightful session!
helped me, thanks
Very good session Deepak
Good session by Deepak sir.🎉🎉
Nice one Deepak 💯 #Desengu #Orcas
As usual with Microsoft, it has no support and difficult to install software. It's plug and pray, but not working for Chinese characters. I use xlsx to export from 5.7 and import in 8.0, that worked.
We're truly sorry to hear about the challenges you've faced. At Microsoft, we're constantly striving to improve our products and services, and your feedback is invaluable in this process. Regarding the issue with upgrading Azure MySQL from version 5.7 to 8.0, it's designed to be a seamless process that doesn't require software installation. We're concerned to learn about the difficulties you've encountered, especially with Chinese characters. To better understand and resolve the specific issues you're facing, could you please share more details with us via email at <AskAzureDBforMySQL@service.microsoft.com>? Your insights will be directly forwarded to our technical team for a deeper analysis.
I am trying to create but getting an error sub target resource is not listing and the subnet also cannot able to select.Subnet should not be delegated ah?
👀 "PromoSM"
Great information
Good Session team. RK very informative talk!
can we run cron jobs in Azure Mysql
Good
Need a video tutorial for demonstrating azure mysql connectivity over point to site vpn using private endpoint
Can we use private endpoint connection with dns for this?
Hi Team. Any plan to Azure SQL DB to give support to Power BI services refresh?
Thank you genius!
Nice! Thumbs up for DBeaver!
Wondering if the extension supports INCLUDE or SOURCE statement functionality. Otherwise thanks a lot for the work on the extension. I use it a lot.
chatgpt 3.5 isn't updated with the extension step, thank you
Do we need premium license for this
Hi @yudhveersingh655 - Yes. You'll need to purchase Power Apps Premium license to use the connectors. For more details, see powerapps.microsoft.com/pricing/ .
So much thanks for the intro
💖 *Promo SM*
I thought i dont need to put credit card info on registration process?
No credit card is required to subscribe to our channel.
Can you please create similar video for azure cli based migration.. Need to know about properties file
What is accelerated logs?
It's a feature in development that will improve the performance of servers based on the Business Critical SKU.
Can I follow this video for PostgreSQL single server to flexible server or are the steps any different?
Hi Ashutosh, for migrating from Azure Database for PostgreSQL - Single Server to Flexible Server, I'd recommend you to refer to this document instead: learn.microsoft.com/azure/postgresql/migrate/concepts-single-to-flexible
Do we need to create target flexible server if yes how?
Thank you for the detailed video but my requirement is to set the read replica in another region than paired region for example my primary on south Central US and want to place read replica on East US region but I am not able to find the East US region while configuring DR read replica, another point , after I promoted read replica then how can I add back to read replica ? and fail back to the primary? appreciate your response. Thank you.
Hi Sreenivasa, 1) Universal Cross Region Read Replica, i.e., the ability to provision a read replica in another non-paired region is currently in Private Preview, and will be generally available by end of August. If you wish to enrol in Private Preview and test the feature out immediately, please write to AskAzureDBforMySQL@service.microsoft.com. 2) Once you promote a read replica to primary, replication is stopped and the replica becomes a standalone server. If you wish to revert back to primary region, you can create a new replica in primary region and promote it back to primary. However, if you wish to use the same primary server as before, you may need to use Data-in replication (learn.microsoft.com/azure/mysql/flexible-server/concepts-data-in-replication) to synchronize data from the replica (which is now a standalone server) to the primary server, and then cut-over to the primary server.
what is the best way to migrate Azure MySQL flexible from one subscription/region to another subscription/region? Any documentation on this?
Hi @chunhingyap, Moving from one subscription to other, but in the same tenant: Click 'move' next to subscription in overview page. - learn.microsoft.com/en-us/azure/azure-resource-manager/management/move-resources-overview Moving from one region to other: This is possible using geo-backup restore (Currently you can only do so to a paired region. Support for restoring to any region, i.e. universal restore feature is coming soon!). You can also use paired region read replica to achieve the same with minimal downtime. - learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-move-regions . Moving from one subscription to another or across regions, but to a different tenant: You can use Azure DMS to migrate. - learn.microsoft.com/en-us/azure/dms/
@@AzureDBMySQL unfortunately, it is different tenant.
Good work It was helpful
Timely video! I am using powershell method and received my token. I wanted to know how would I use that token to sign in. the Output token is in my C drive, temp folder
Nop, is not there. Is no part of extensions list. I'm using Azure Data Studio last version (no updates available) on MacOs Monterey
not there
Hi Ahmed. Can you provide any additional context? Thanks in advance!
The MySQL extension only appears if you are using the Azure Data Studio insiders build (the link is in the description).