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
4
votes
0 answers

Sequelize, MySQL, and Quit inactivity on timeout for Heroku deploy

I am attempting to deploy a nodejs SPA to Heroku using Sequelize and a MySQL database through ClearDB. The app works locally, builds on Heroku successfully, and crashes when I request it from a browser with the following…
mscottnelson
  • 452
  • 4
  • 12
4
votes
0 answers

How to run mysqldump on a Heroku app

I want to make daily dumps of my production database that I can store in S3. I have created a bash script that works fine locally, but when run on Heroku's postinstall, I get the following error message: ./run-backup.sh: line 21: mysqldump: command…
JMurphyWeb
  • 382
  • 1
  • 11
4
votes
1 answer

How to use Mysql commands with ClearDB in Heroku?

I'm using ClearDB with Heroku. I managed to make the migrations that I needed but when I can't find the way to execute queries using the terminal as below: SELECT * from table . Thanks in advance.
Manu Mackwar
  • 61
  • 1
  • 6
4
votes
1 answer

How to fix "sequel::DatabaseDisconnectError - Mysql::Error: MySQL server has gone away" on Heroku

I have a simple Sinatra application hosted on Heroku and using Sequel to connect to a MySql database through the ClearDB addon. The application works fine, except when it sits idle for more than a minute. In that case, the first request I make…
Jonah
  • 15,806
  • 22
  • 87
  • 161
4
votes
2 answers

PHP to MySQL connection: wait until a connection is available, instead of throwing "max_user_connections exceeded" error?

MySQL has a feature that enforces a maximum number of connections, max_user_connections. When connecting from PHP (and other languages), in the event you exceed that number, my understanding is that your connection will fail with an error stating…
Josh
  • 7,232
  • 8
  • 48
  • 75
4
votes
0 answers

Getting communication link failure error in mysql on Heroku project

I am working on a Spring hibernate project which is on Heroku and uses ClearDB. When my page is idle for some time (hardly a minute) and then I send some request to the server I get the error as follows: HTTP ERROR 500 Problem accessing…
Kiran Dama
  • 41
  • 2
4
votes
2 answers

ClearDB auto-increment

I'm using ClearDB to host the MySQL database of my Ruby on Rails application. Today I observed that the id's of the tables, are jumping on steps of 10, starting on 1: 1, 11, 21, 31, 41.. I searched, and found this: "I'd guess that your…
Christiane Okamoto
  • 155
  • 2
  • 14
4
votes
2 answers

MySQL (ClearDB) does not work on Heroku

I have multiple (FREE) apps on Heroku, all of them using PHP and MySQL. However, on one of them I constantly have issues with ClearDB (MySQL). I get the following error SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket…
Teodor Talov
  • 1,933
  • 2
  • 25
  • 39
3
votes
1 answer

NodeJS Mysql pool.query() not releasing connections?

I am having trouble with pooling mysql connections with nodeJS. As I understand it, when creating a pool, I should be able to use pool.query() to: Get a connection Run my query Release the connection However, the issue I am running into is the…
PiddlyBapz
  • 33
  • 1
  • 4
3
votes
0 answers

Can´t reach MySQL from Heroku (Spring Boot App): Access denied for user (using password: YES)

I´m using MySQL ClearDB Heroku add-on. I´m using the credentials provided by ClearDB and I can succesfully connect to the database using MySQL Workbench and my Spring Boot Application running in Localhost. I deployed the same Spring code into…
DCatrileo
  • 31
  • 4
3
votes
1 answer

why does my node app works for a few moments on and crashes( heroku)?

i have deployed a nodejs app on heroku with ClearDb mysql, the app works for a few moments then crashes. i checked logs and got this errors 2019-09-20T19:03:41.536452+00:00 app[web.1]: events.js:174 2019-09-20T19:03:41.536474+00:00 app[web.1]:…
Saide Abdool
  • 33
  • 2
  • 6
3
votes
1 answer

NodeJS: Heroku ClearDB not closing connections

I deployed a NodeJS API on Heroku and tried to connect it to a MySQL DB, so I created a connectionPool for handling connections on a ClearDB ignite account (free), which allows a maximum of 10 connections. Every time I execute a query to the…
Marcelo
  • 351
  • 1
  • 5
  • 18
3
votes
1 answer

Heroku cleardb connection default addr for network unknown

I have created a free instance of Heroku cleardb instance for my app. I set the database URL as: heroku config:set DATABASE_URL='mysql://user:pass@us-cdbr-iron-east-03.cleardb.net/heroku_database?reconnect=true' I'm trying to connect using a Go…
abhink
  • 8,740
  • 1
  • 36
  • 48
3
votes
1 answer

Deploy a rails app using MySQL to Heroku using ClearDB addon

I have a Rails app called "enrollment_app" that initializes and populates all the tables in the database with a MySQL seed file. I built the app, added some migrations and pushed my app to Heroku. However, since Heroku uses Postgres, I need a way to…
Ben Pritchard
  • 508
  • 6
  • 11
3
votes
1 answer

How to create a MySQL schema when deploying with Heroku (Express Server)

Suppose I have the following server.js file: server.js var express = require('express'); var app = express(); var mysql = require('mysql'); var dbhelpers = require('./public/database_helpers.js') var bodyParser =…
theamateurdataanalyst
  • 2,794
  • 4
  • 38
  • 72
1
2
3
…
16 17