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
1
vote
1 answer

How to set max user connections in python environment?

Currently I am working on a bot using mysql connector , which is python library that allows you to communicate with mysql. I am running ClearDB on Heroku. Sometimes while I am running certain commands I run into the following error. Error Code:…
Pacified
  • 175
  • 9
1
vote
1 answer

MySQL's max_questions error is being thrown even for 1 query when the limit is 18000

I've been working on this problem for a few hours now and I'm close to jumping from the Heroku platform purely out of frustration. I have a simple web app running on Heroku which uses PHP and MySQL with Silex and AngularJS. The MySQL DB (running on…
Anoop Santhanam
  • 85
  • 1
  • 10
1
vote
0 answers

How jhipster apps create databases on heroku platform?

I am trying to deploy my app to heroku, the problem is that instead of creating the db with utf-8 as it is written in jdbc url: url: jdbc:mysql://localhost:3306/devizionuseUnicode=true&characterEncoding=utf8&useSSL=false It creates it with charset…
Voland Mortes
  • 95
  • 7
1
vote
1 answer

500 (Internal Server Error) on heroku using cleardb and php with an ajax request

I created a small application that goes to the amazon api and grabs the asin, and a few other things. This works perfectly fine on my localhost however, once putting it in heroku, it seems to stop working. I get this error: GET…
Edon Freiner
  • 338
  • 2
  • 17
1
vote
2 answers

how to deploy a php app with mysql to heroku?

I have a small php app that uses mySql for the database, I wish to deploy the app on heroku using the clearDB add on, But I am not sure how to do it, please help. I am presently using MAMP server locally which has MySQL installed.
Mayur Tolani
  • 1,458
  • 3
  • 17
  • 28
1
vote
1 answer

Can not save utf8 with Cleardb heroku

When I deploy in heroku, I use ClearDB, I can't insert japanese character, When I remote ClearDB with MySQL workbench, I can handle insert japanese. Problem can is code. I use playframework 2.5 Config in Procfile: web:…
Chung Do
  • 79
  • 9
1
vote
1 answer

Issue with setting tables remote ClearDB (heroku) database

I'm trying to migrate my app from a Cloud9 IDE to the Heroku platform. I'm able to serve up the page no problem but the page isn't loading any of the info that was supposedly migrated over. I'm not seeing any error messages, nor do I know how to…
cbroomhead
  • 29
  • 5
1
vote
2 answers

MYSQL - set default as NULL to all columns, where default is not set

I have about 12 databases, each with 50 tables and most of them with 30+ columns; the db was running in strict mode as OFF, but now we had to migrate the db to cleardb service which by default has strict mode as ON. all the tables that had "Not…
Brij Raj Singh - MSFT
  • 4,903
  • 7
  • 36
  • 55
1
vote
0 answers

Unable to provide a default value as NOW() for 'datetime' column while creating table in ClearDB on azure

I got an error while trying to set a datetime column a default value NOW() or CURRENT_TIMESTAMP: ALTER TABLE temp MODIFY COLUMN EntryDate EntryDate datetime DEFAULT NOW() Primarily, the same query worked perfectly on a local instance on MySQL but…
A Devale
  • 11
  • 2
1
vote
1 answer

Upload mysql dump on heroku

I need to upload my local .sql dump into my heroku machine. I'm using MySQL db and the plugin ClearDB. I have tried this command: mysql --host=us-cdbr-east.cleardb.com --user=MY_USER --password=MY_PASSWORD --reconnect heroku_xxxxxxxxxxxx <…
ste
  • 3,087
  • 5
  • 38
  • 73
1
vote
0 answers

SQLI tiemout issue specific to Azure/ClearDB node recycle

When Azure/ClearDB recycle the principal My SQL node we are getting problems in our PHP programs even though we've got: $timeout = 10; /* seconds for timeout */ $mysqli->options( MYSQLI_OPT_CONNECT_TIMEOUT, $timeout ); Is there some other parameter…
user2554122
  • 41
  • 3
1
vote
2 answers

How to set production environment variables on heroku?

I want to run an app using MySQL on heroku. I have already installed and configured cleardb for this purpose. All I have left to do is configure environment variables. However, I can't find a proper way to do this. in this article, Matt explains…
Alex Lomia
  • 6,705
  • 12
  • 53
  • 87
1
vote
1 answer

MySQL error 1366 appears when leaving non-null columns with default values as blank

I am new to CodeIgniter and PHP in general. I made a new table with certain non-null columns. The non null columns all have defaults set according to their data type, so a VARCHAR has an empty string, while numeric types have 0 as default. However,…
omrakhur
  • 1,362
  • 2
  • 24
  • 48
1
vote
1 answer

Change Schema Name in heroku ClearDB

I just provisioned the clearDB add on, and received a random schema name. Is it possible to change this name to something a little more manageable?
Shreyans Patel
  • 51
  • 1
  • 7
1
vote
1 answer

The performance of Drupal on Azure

I have the main page that loaded very long time (6-10 seconds) because it contains a form with captcha. The performance of the webapp + mysql (venus) is very bad... Drupal does not cache pages with a captcha, so recreate a page and does not load…
Ed.
  • 43
  • 8
1 2 3
…
16 17