Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to manage mysql databases created in Azure?

Tags:

mysql

azure

Azure websites let us configure our site using a new MySQL Database instead of SQL Azure. But after creation it's never visible in admin panel. I beleive that it's because is hosted in a third party server, but I have no idea how to reach it, any tip?

like image 910
Moisés Briseño Estrello Avatar asked Aug 30 '12 04:08

Moisés Briseño Estrello


People also ask

Is Azure SQL Database fully managed?

Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.

What are the options for managed SQL databases on Azure?

Which SQL cloud database deployment options are available? Azure SQL Database is available as a single database with its own set of resources managed via a logical server, and as a pooled database in an elastic pool, with a shared set of resources managed through a logical server.


2 Answers

For managing it from an external tool check out my response here.

Though the database is hosted by a third party (ClearDB), you should see it listed as a "linked resource" on the dashboard for your Web Site in the Windows Azure portal. When you delete the Web Site, it asks if you also want to delete the linked resource.

If you choose not to or you unlink the MySQL resource explicitly, it's still there and you'll see it a list of existing resources when you subsequently do an explicit link. (I haven't found a way to see a list of the unlinked MySQL databases, but will update this response when I hear).

So I'd say to delete the MySQL database you can

  1. Delete the entire Web Site and, when prompted, select the MySQL database to be deleted too

  2. Unlink the MySQL database from the Web Site you want to keep; create a new temp Web Site, and add the existing MySQL database as a Linked Resource to it. Then delete the new, temp Web Site along with the linked database. Not elegant, but seems to work in my testing.

like image 162
Jim O'Neil Avatar answered Sep 28 '22 10:09

Jim O'Neil


Currently you can't manage the MySQL Server.

As for being third party - yes, the service (MySQL-as-a-Service) is provided by a third party byt lives in Azure! It is not on other servers, it is on the Azure servers. Most probably (just my guess) worker roles. But as the feature is still preview, the management is missing.

The third party vendor is ClearDB. They provide MySQL as a service on top of Windows Azure. so no worries, your data is in the same Data Center (of course if you chose same) as your web site. But you can't directly manage it, unless you install something like PhpMyAdmin on your website.

like image 34
astaykov Avatar answered Sep 28 '22 09:09

astaykov