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

Idle connections are not closed

I deploy Keycloak server app (based on WildFly 10.0.0.Final) to Pivotal Cloud Foundry and use ClearDB service as relational database. ClearDB has a restriction, that it closes all connections, that are idle for 90 seconds. To not run into the…
Kir Merzlikin
  • 101
  • 1
  • 5
2
votes
2 answers

Heroku rake db:structure:load with cleardb can't find 'mysql'

I am trying to install an instance of Sharetribe on a heroku dyno. I am at the point where I am trying to create the database. I first tried rake db:migrate and it worked for most of the migrations but failed on one of them. I was advised to use…
user3096803
2
votes
0 answers

Function .JSON_OBJECT does not exist

I have 2 tables and I try to get statuses from table status and add to each status info about an author from a user table. I created the same database on my laptop and everything works fine. But I've got an error when published the database on…
rel1x
  • 2,351
  • 4
  • 34
  • 62
2
votes
1 answer

Encoding issue in CloudFoundry

I uploaded my web application to CloudFoundry, but my native language was broken as below. enter image description here I have checked that the DB has broken data. DB uses ClearDB MySQL Database, which CloudFoundry provides as a service. I ran the…
khhan
  • 21
  • 4
2
votes
1 answer

clearDB - Mysql - how to set grant priviledges

I'm creating an event to my CLEARDB mysql database, using heroku server. and I'm using mysql Workbench. I executed the code SET GLOBAL event_scheduler = ON; and it gives me error of Access denied; you need (at least one of) the SUPER privilege(s)…
Rabb-bit
  • 805
  • 12
  • 24
2
votes
1 answer

Can Heroku's cleardb ignite be used for production?

I understand that there are limitations with regards number of connections etc. but it doesn't have a tick next to "Production Ready" What does this mean? I cannot use it for production?
zooter
  • 2,128
  • 1
  • 13
  • 23
2
votes
1 answer

How to obtain service credentials for a service instance created on IBM Bluemix without binding the instance to an application on Bluemix?

I have created a ClearDB MySQL instance on IBM Bluemix. Can I see the credentials (hostname, username, password etc) without binding the instance to an application running on Bluemix ? Thank you, Sandhya
Sandhya Kapoor
  • 170
  • 9
2
votes
1 answer

passing variable to another page for sql query

I am trying to pass a variable from a page to another page so that i can display more information on the other page by getting the idea. I am not really sure what is going wrong and because I use bluemix it doesn`t display an error it just gives me…
user3356007
  • 393
  • 1
  • 6
  • 20
2
votes
1 answer

Azure ClearDB: Access denied for user 'xxxx' to database 'xxxx'

So I recently set up a database through Microsoft Azure using clearDB's MySQL db. I connected to it through java with the given server, name and user credentials given to me, and everything worked fine, for eight hours... suddenly out of nowhere…
morticii
  • 21
  • 1
2
votes
3 answers

Bluemix ClearDB MySQL capacity limitation

The MySQL ClearDB service in Bluemix catalogue is offered with one single plan with a very limited capacity (5MB and 4 connections) and for free. Do you have a recommendation for an application that requires a mysql db with a higher…
edevregille
  • 209
  • 2
  • 12
2
votes
0 answers

Can't interact with ClearDB hosted on Heroku

So I'm setting a connection like this: Then I made a dump…
Tachi
  • 2,042
  • 3
  • 27
  • 44
2
votes
1 answer

connection issues with cleardb from cloudfoundry (on pivotal)

we constantly face issues with the connections to MySQL hosted by ClearDB. We have a dedicated plan which offers more then 300+ connections for our application. I know the CBR on ClearDB site automatically closes an inactive connection after…
domi
  • 2,167
  • 1
  • 28
  • 45
2
votes
0 answers

Passing dynamic arguments into heroku scheduler

I'm trying to update my database by calling a cisco's cmx api. But since I'm using free version of cleardb, there is an hourly limit of 3600 insertions. Therefore I need to create a task with dynamic variables. I have the following…
CanCeylan
  • 2,890
  • 8
  • 41
  • 51
2
votes
1 answer

query error when access clearDB database using php on Heroku

I can access clearDB database well by using Mysql Workbench. But when I query database by using php on Heroku, it always fail. This is my code: $url=parse_url(getenv("CLEARDB_DATABASE_URL")); $dbhost = $url["host"]; $dbuser = $url["user"]; $dbpass…
user2865769
  • 23
  • 4
2
votes
0 answers

Azure mySQL Database disappeared

I'm using a mySQL DB by ClearDB in Azure. Now I've reached the limit and get appropriate warning mails by ClearDB. Now I want to increase the plan, but in Azure the mySQL database is missing. I can't find an entry anywhere. The ClearDB support says…
Benjamin Abt
  • 1,730
  • 18
  • 33
1 2 3
…
16 17