Stack Overflow
Stack Overflow

Questions tagged [cleardb]

ClearDB is a reliable, fault tolerant database-as-a-service for MySQL. It is also a heroku addon for mysql databases

ClearDB is a heroku addon for managing databases.

More info here: https://devcenter.heroku.com/articles/cleardb

247 questions
0
votes
1 answer

Is it possible to publish local db online with azure?

I've very recently started doing ASP.NET web development, and i have a student azure subscription, and i want to know if its possible to publish a project online with azure (which i am already doing) but so that it would also publish the local…
Velo
  • 25
  • 7
0
votes
2 answers

Azure ClearDB - Not taking database name

I'm creating a new ClearDB database in the Azure portal, the portal creates the database but using what appears to be an auto-generated name using the convention 'acsm_somehexchars'. The database I'm trying to create is in a resource group which is…
Simon Houlton
  • 182
  • 1
  • 10
0
votes
1 answer

Advantages of using Bluemix's SQL Database service vs ClearDB MySQL on Bluemix App

I have a bluemix app that is currently setup with the ClearDB MySQL 3rd party bluemix service through PHP. The service works well, however I noticed that there is a limit of 5mb of space for the free version (you can upgrade from there). I recently…
Leopold Joy
  • 4,524
  • 4
  • 28
  • 37
0
votes
1 answer

No schema for Azure ClearDb MySql Database

I have created a managed MySql database in Azure which uses ClearDb as a database provider. I appear to have a database if I go to Azure and click through to the ClearDb dashboard. However when I connect in MySql Workbench using the username and…
Rob Sedgwick
  • 4,342
  • 6
  • 50
  • 87
0
votes
1 answer

Recommendations for running Magento on Azure websites with ClearDB Database

I've set up a shop in Magento using Azure web apps but it's running very slow at the moment. I've scaled to the standard pricing tier and turned on autoscale but it's still very slow. Could it be the database that is the problem? I only have the…
mos
  • 11
  • 3
0
votes
1 answer

How to load a schema into Node-MySQL ClearDB Azure?

I've got a schema that I want to load into attached to my Azure/Node server: USE mydatabase; CREATE TABLE users( id BIGINT NOT NULL AUTO_INCREMENT, first_name VARCHAR(40), last_name VARCHAR(40) created_at DATETIME DEFAULT…
mLuby
  • 673
  • 7
  • 15
0
votes
1 answer

How to reduce sql query network time

I have a simple join query that returns ~5.7k records. the results says: /* Affected rows: 0 Found rows: 5,780 Warnings: 0 Duration for 1 query: 0.015 sec. (+ 5.438 sec. network) */ How can I reduce the "network" time i.e. 5.438 secs EDIT: I got…
Angad Dubey
  • 5,067
  • 7
  • 30
  • 51
0
votes
1 answer

how to do bulk update with from two different tables in two different databases in Azure MySQL DB?

I have two databases db1 and db2 in mySQL Azure instance. I want to bulk update a column in tbl2 from tbl1. I want to do bulk update statement with a select statement based on a matching column value in both tables tbl1 and tbl2 but not the primary…
Mostafa
  • 3,296
  • 2
  • 26
  • 43
0
votes
1 answer

MySQL connection gone

I am using clearDB database for my windows azure based php application. I am getting intermittent error on mysql connections. Currently we have nearly 2000 online customers. And we have 30 connections from database. How can I scale the website and…
RNK
  • 5,582
  • 11
  • 65
  • 133
0
votes
3 answers

Php web application can't process clearDB mysql service on bluemix

I'm trying to deploy a php web application on bluemix. So I have bound a clearDB mysql service to my application. The vcap_service variable are provided to me. but when I use those variable to perform simple sql query, the application page does…
Sahil S.
  • 59
  • 7
0
votes
1 answer

The same MySQL query takes 200 ms or gives timeout or more than 10 sec

We need to call one of our PHP web service periodically (once every 5 secs) This web service has more than one select statements and no writes in it. It normally and mostly takes 200 ms to execute this PHP web service. But sometimes it is timed out…
Nermin Ozkiranartli
  • 59
  • 3
0
votes
1 answer

Mysql: Integrity constraint violation

I am using cleardb for mysql database in php. And Situation is something like this: I am adding record in beneficiary table. and after adding that I am fetching last_inserted _id. And using this id to add payment method in beneficiary_payment_info.…
RNK
  • 5,582
  • 11
  • 65
  • 133
0
votes
1 answer

heroku node js cleardb mysql fail : ER_ACCESS_DENIED_ERROR: Access denied for user

Today I'm pushing my app on heroku, I create the database with cleardb, configure it by using a software (navicat premium) for create tables. I start my program, which works really well on local side, and when I try to access to my database I get…
taspai
  • 120
  • 1
  • 3
  • 13
0
votes
1 answer

upload mysql DB from my localhost to Heroku Clear DB

I create an app in heroku with the ClearDB add-on and PHP as language. Following the Heroku-ClearDB documentation guidelines I try to upload and existing localhost-DB created in MySQL with PHPMyAdmin -> I execute in the console: heroku addons:add…
user6527926
  • 55
  • 1
  • 3
  • 8
0
votes
0 answers

Python twisted with mysql : sending the request to the server one by one, but response is getting delayed

We have been using Twisted Python TCP socket server with the mysql db for more that 6 months now.We are facing the issue that our chat module is lagging when 4-5 clients are connecting to the server and tried to use the app for chatting. and…
Trupti Sawant
  • 1
  • 1
1 2 3
…
16 17