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
Questions tagged [cleardb]
247 questions
0
votes
1 answer
Migrating MySQL DB version 5.6 to 5.5 (Django) structure dump import fails
Locally I was working on Django project with MySQL version 5.6
I am trying to host a DB on Azure and unfortunately ClearDB support 5.5 and not yet 5.6.
I am migrating the data using the export/import functionality on MySQL Workbench.
I dump the…
Saher Ahwal
- 9,015
- 32
- 84
- 152
0
votes
1 answer
Bluemix ClearDB - Table doesn't exist after inactivity
I have several Cloud Foundry applications written in Spring and hosted on Bluemix that rely on ClearDB MySQL databases.
Everything works fine except that, after a period on inactivity, my services cannot connect properly to the database all with…
Luca
- 45
- 6
0
votes
0 answers
Azure Upgrading MySQL Database (ClearDB) Version from v5.5 to v5.7
I'm using Django to create an API with MySQL as the database. I'm using JSONField in my code and my local MySQL version is v5.7 so JSON field is supported. But Azure's MySQL version is v5.5 and JSON field is not supported.
Is there a way to upgrade…
Furkanzmc
- 104
- 3
- 13
0
votes
1 answer
IBM BlueMix: TomCat ROOT.xml adjustment for DB Connection
I am facing a configuration issue within IBM BlueMix. I have 2 items running, which are already connected:
TomCat
ClearDB
Within TomCat an application is deployed (LifeRay) which seem to over-utilize the provided connection pool of ClearDB (4…
Fabiansc
- 1
- 1
0
votes
2 answers
Error with ClearDB connection during migration to IBM Bluemix
I'm trying to use ClearDB service on my PHP App on Symfony 3 which is hosted on IBM Bluemix. I have
successfully linked cleardb service with app and got credentials all gathered from Bluemix dashboard.
However during application upload (cf push) an…
goldjunge
- 331
- 1
- 4
- 12
0
votes
0 answers
Deleted ClearDB database through bluemix
I just accidentally clicked on the delete button on the wrong database in bluemix. To be fair, on some views the database directly lines up with the instance, in others it doesn't.
So...
Who do I contact in order to get this recovered? I have sent…
mevans
- 196
- 2
- 9
0
votes
1 answer
Azure Testabo cleardb upgrade
I'm trying out the free trial of azure with an a wordpress installation and therefor created a cleardb mysql database. The database was created with the free version and has a very poor performance. However I don't know if I can use my free testrail…
Stefan
- 14,826
- 17
- 80
- 143
0
votes
1 answer
Bluemix using Node-RED bind to existing ClearDB MySQL service
I am using Node-RED on IBM Bluemix. I am trying to connect to MySQL hosted by ClearDB, but I cannot find a suitable node in the database category.
How can I bind to existing ClearDB service that I already have bound to another app?
0
votes
2 answers
Cannot connect to clearDB [heroku]
till last week, I cannot connect to cleardb. The configuration did not changed.
Usually, I connect to my db with this command:
mysql --host=eu-cdbr-west-01.cleardb.com --user=ba2*******61 --password=9*****f heroku_2*********f
This is the output I…
pierrelb
- 493
- 1
- 5
- 10
0
votes
1 answer
No connection could be made because the target machine actively refused it Laravel 5
i have a problem when trying to connect to a cleardb database it gives me this error.
No connection could be made because the target machine actively refused it
i check my connection information and it's correct because i test it in navicat and it…
Mohammad AL-Raoosh
- 721
- 1
- 12
- 32
0
votes
0 answers
Connecting cleardb to Heroku using php
// create connection
$conn = new mysqli($server, $username, $password, $db);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$conn->close();
I am trying to connect my php file with a cleardb database using the…
Kesh
- 75
- 1
- 1
- 7
0
votes
1 answer
Joomla/Wordpress Azure Hosted sites going down randomly and inconsistantly
I recently moved 2 websites over to Azure. One was wordpress and one was joomla. I have a monitoring website (24X7) that pings the website every 5 minutes to make sure they are still up. 2 days ago, both went down for about 3 minutes at around the…
Monz
- 139
- 1
- 13
0
votes
1 answer
ClearDB - does it take time to read the newest data?
I just used mySQL workbench to connect to my clearDB account which is connected to an azure web app. The problem is even thought I ran a query that drops/creates tables in the newly made schema that mirrors exactly the tables and data in my previous…
LatentDenis
- 2,839
- 12
- 48
- 99
0
votes
1 answer
PHP MYSQL query data between date and time fields HEROKU
i have to query data in certain range of date and time. I have a ClearDB database in heroku with 2 fields to save date and time, these fiels are varchar type, not DATE.
Data Structure here and don't look the field names, i have changed below in the…
0
votes
1 answer
1044 - Access denied for user 'root'@'%' to database 'test' cleardb
I have an issue that when i try to connect to a database in cleardb it gives me this error:
1044 - Access denied for user 'root'@'%' to database 'test'
when it connect via navicat and try to upload new test.sql file to update my database i get the…
Mohammad AL-Raoosh
- 721
- 1
- 12
- 32