Drop ClearDB and develop a native Azure MySQL compatible database
Drop ClearDB and develop a native Azure MySQL compatible database with scalability options similar to Google and Amazon.
Changing status to “Completed” as our service is now available!
Mostafa Elzoghbi commented
I agree, ClearDB is a joke. they do not provide any performance monitoring or standard insights on what is happening on your database. also, managing tiers by connections is silly, because i care about the allocated computer power for my db server over connections. either to over a new offering or get rid of them. AWS wins MySQL business because of MySQL is considered a first class citizen on their PaaS. connect me and i can provide more details as well from my experience.
This is a huge problem. I run close to 20 Wordpress sites for a local county government. We were looking to move to Azure, even brought in trainers from MS via an enterprise agreement, but working with ClearDB proved to be impossible. We even had trouble setting up accounts, adding credit cards, etc. We couldn't use Project Nami either because of the plugin compatibility issue. As a result, we're not using Azure, and had invested a LOT of time and research into the migration. It's incredibly disappointing to say the least. I truly hope MS makes a native MySQL solution, but until then, we can't use Azure.
Nicholas Eden commented
These guys have been nothing but headaches. The dashboard provides no data. When you report problems, their canned response is "everything looks fine". We started doing a basic test every minute to connect and query. It frequently fails to connect.
MS needs a fully supported MySQL solution rather than a vendor that makes no effort to provide a solid product.
ClearDB Sucks commented
They are the Worst. MSFT please get rid of these clowns before they cost you more Azure business!!!
Sebastian de Mel commented
Current solutions and there problems:
1. In-app MySQL. The MySQL in app is not an alternative for production as mksunitha sais in the blog post comment:
"@James: This feature provides a free database to help get developers started with MySQL database if their app requires one for development purposes. It is not to be used as a production database tier where the other solutions you mention would be more beneficial."
The previous comment by @James describes good points why the in-app solution isn't really a good solution.
2. Solution: Project Nami. There is a constant problem with plugins not working properly on it. Some of the most commonly used ones that don't work without hacking are: Visual composer, Ninja forms, GravityForms, Revolution slider etc.
3. MariaDB Enterprise Cluster
Overkill for many uses and requires maintenace work hence not being PaaS. But, when you need scalable MySQL solution, this is a good option based on VM's.
Please make a proper Azure SQL/Azure DocumentDB etc. like solution for this. This is still one of the major reasons why running WordPress in Azure doesn't have much benefits compared to AWS. The point of PaaS is that you can avoid the VM/Container maintenance work and if the main argument is: Use a VM, well, might as well stay in AWS.
And note, if Project Nami was a good alternative (main problem: plugins) or WordPress had a good database abstraction layer, we wouldn't have this problem but we have and for now, WordPress is a big part of the web. According to W3Tech WordPress is used by 59,3% of all CMS users.
It is possible to install wordpress on azure vm on ubuntu using serverpilot.
Robert Folkers commented
Finally there seems to be a alternative for ClearDB:
Marcelo Amorim commented
Success! I just started with docker at azure and after understand the azure docker driver configuration, my solution with 2 different hosts all done. One host with nodejs app and another one with mysql database.
All services up with one line command $ docker-compose up
Thanks Docker Team.
Make sure your servers are secure
Charles Roddie commented
For wordpress you can use Project Nami and use Azure SQL instead of ClearDB MySQL. I found it very easy to set up.
kanish kumar commented
kanish kumar commented
You look at the online surveys, then just you will come to think about the quality agency that are getting given by the prepared escorts of Chandigarh and these agency will help you comprehend the contrast amongst escorts and whores.
Visit Now: http://www.chandigarh-escorts.in/
Clear DB doesnt even support subscriptions in my country but we are using US$ as well
On the weekend i upped an A0 Linux VM with MySQL only as a cloud appliance, what a world of difference in performance, almost instantly traffic in my sites was up so CLearDB is bad for business
MySql db is by no doubt developer basics miscrosoft need to leverage highly on this and we all take azure from a better step already
Ubuntu 16.04 LTS is now available, but Azure is out of touch with one that is nearly out of support it so old
my site page load times with ClearDB are so pathetic that my page rank times are affected
Mike Rouse commented
The VM options are now out-of-date. The Docker one, for instance, uses Ubuntu 15.10. It says "Updates and patches for Ubuntu 15.10 will be available until July 2016."
I need a hand with the following please:
I have created a Web App in Azure and a ClearDB database. I copied the connection string from the DB and paste it onto the Web App. Also created a NSG to allow http & https traffic and also port 3306. When I log in to the ClearDB portal, I still see the following: "No connections are currently established to this database".
I am not sure what I am missing. I'd really appreciate a hand with this.
I pulled 11 apps from Azure because of this issue. Moved them to siteground.com
#1 rated idea? No response?