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
13
votes
1 answer

How to drop database in heroku clearDB?

I see here how to drop Heroku Postgres DataBase. But how can I drop the database if I'm using the addon ClearDB?
Alaa M.
  • 4,961
  • 10
  • 54
  • 95
12
votes
2 answers

ClearDB MySQL Installation on Heroku Asking for Account Verification

I have deployed my current Laravel project on Heroku. My local database is MySQL. As Heroku does not support MySQL directly, I need to install ClearDB MySQL addon. When I run heroku addons:create cleardb:ignite in my Heroku CLI, it gives the…
Tauhid404
  • 121
  • 1
  • 4
12
votes
3 answers

How to enable DELETE, PUT for PHP app at IIS?

Although DELETE request works successfully locally, it does not work when I deploy my app to MS Azure. Here is what I get in console when try to delete a record: DELETE http://mywebsite.azurewebsites.net/api/subjects/1 405 (Method Not Allowed) My…
Samir Sabri
  • 937
  • 3
  • 11
  • 26
11
votes
1 answer

Handling Heroku/ClearDB auto Increment primary key strategy

With Heroku running ClearDB as the MySQL layer, primary keys are auto-incremented in multiples of 10. So, for example, the first insert could be 4 then 14, 24, 34 etc. I fully accept their reasoning for this, so that's not the issue. My question…
Doug
  • 1,850
  • 23
  • 50
10
votes
2 answers

How to remotely connect to ClearDB in an Azure Website?

I have created a free Azure Website with Wordpress on it. A ClearDB mysql database was automatically created. I want to remote connect to the DB using something like MySQL Workbench. I used the credentials from the "View connection strings" in the…
Yaron Levi
  • 12,535
  • 16
  • 69
  • 118
9
votes
3 answers

mySQL auto increment increasing by 10 (ClearDB & Node)

I have a simple table in ClearDB: CREATE TABLE `users` ( `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(100) DEFAULT NULL, `message` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=INNODB AUTO_INCREMENT=11 DEFAULT…
Chris Olson
  • 1,021
  • 4
  • 12
  • 19
8
votes
2 answers

How to update the version of the MySQL engine in ClearDB?

By default, heroku only works with the postgreSQL database. However, there is a ClearDB plugin that allows you to use a MySQL database. The problem is that this plugin uses the old version of the MySQL 5.5.62 engine. When connecting to the server…
Неуловимый Джо
  • 181
  • 1
  • 2
8
votes
1 answer

Auto increment by 1 in MySQL with clearDB

I am using Windows Azure with clearDB. Current database auto-increment value is 10. I want it as 1. I tried to run these commands in PHPMyAdmin with, 1) set global auto_increment_increment = 1; set global auto_increment_offset = 1; ERROR: #1227 -…
RNK
  • 5,582
  • 11
  • 65
  • 133
7
votes
2 answers

Understanding Heroku and ClearDB max_questions resource error

I'm getting this error consistently with my Rails site on Heroku using ClearDB mySQL. Mysql2::Error: User '123123' has exceeded the 'max_questions' resource (current value: 18000) Looking at the logs, the exceptions are returning for normal…
Saluto
  • 81
  • 1
  • 3
7
votes
1 answer

reconnect keyword argument on ClearDB default connection string causing errors with MySQLdb

I uploaded a Django app to Heroku and than provision the cleardb add-on using these 3 commands from Heroku documentation: heroku addons:create cleardb:ignite heroku config | grep CLEARDB_DATABASE_URL heroku config:set…
s_s
  • 709
  • 1
  • 7
  • 13
6
votes
1 answer

Diagnosing 2013 Lost connection to MySQL

I am using SQLAlchemy with two MySQL databases. One of these being my development database hosted locally on my machine and the other is a MySQL server provided by ClearDB on Heroku for production. I have a long running session open with the…
freebie
  • 2,161
  • 2
  • 19
  • 36
6
votes
2 answers

Heroku and ClearDB error

I have a Ruby on Rails application with a mysql database (using the gem mysql2). Since Heroku runs postgres I followed this step in order to make it work: $>heroku addons:create cleardb:ignite $>heroku config | grep CLEARDB_DATABASE_URL $>heroku…
ste
  • 3,087
  • 5
  • 38
  • 73
5
votes
0 answers

How can I use an Azure WordPress instance to geo-load balance with Traffic Manager and CDN

PROBLEM: I have a scalable instance of WordPress (not a VM but Microsoft Azure's preconfigured WordPress web application instance) setup on Azure using ClearDB for the MySQL database. I have Tested the Azure BLOB storage WordPress plugin and it…
TeleRiddler
  • 51
  • 2
5
votes
1 answer

MySQL: Access denied for user to database

I'm trying to create a database on my remote sql server - clearDB - on Heroku. I connected with this: mysql --host='<>' --user='<> --password My username and password are obtained from the result from running heroku…
user3918985
  • 4,278
  • 9
  • 42
  • 63
4
votes
2 answers

ClearDB on Heroku throws an error when running a migration to create a new table that has a `details` field of type `json`

I am running a Rails 5.2.2 and ruby 2.6.3 app on Heroku backed by ClearDB database. NOTE: Locally this all works fine my gem file has the mysql2 version as such: gem 'mysql2', '>= 0.4.4', '< 0.6.0' When I attempt to run a migration to create a new…
Elvyn Mejia
  • 307
  • 4
  • 18
1
2 3
…
16 17