WinCoder Blog

Workaround for “You’ve reached your MYSQL quota” with WordPress WebSite Deploy on Microsoft Azure

Normally to create a new WordPress site on Azure you would Click => New => Compute => Website => From Gallery => WordPress. Except, this doesn’t work if you already have an existing WordPress site on Azure because the MYSql provider “ClearDB” limits you to one SQL instance. In the final step, you may encounter the following message:

Message

But… you can create a new one and attach it to your site by following these instructions:

1. Select your existing website from the left panel in the Azure Portal

Step1

2. Click “Dashboard”

Step2

3. Scroll down to “Linked Resources” and click the resource in blue

Step3

4. This brings you into your associated “ClearDB” account, click “Dashboard”

Step4

5. Click “Create a new Database”

Step5

6. Select the free “Mercury” instance

Step6

7. Choose the Primary region to deploy your database (you likely want this match the region you intend to deploy your Azure Website)

Step7

8. Click “Create my free Database”

Step8

9. Take note of the name of your newly created database

Step9

10. Back in Azure, create your new WordPress site from New => Compute => Website => From Gallery => WordPress and in step 3, select to “Use an existing MYSQL Database” and create a new WebScale Group in the same region as the Database that was created in step 7

Step10

All you have to do now is select your newly created database (name given in step 9) and you are good to go with using your new site against a new ClearDB database instance! Check the “ClearDB terms” box in the final step and notice the check mark is enabled and you can now deply your new WordPress site!

Final


Leave a Reply

Your email address will not be published.