Stack Overflow
Stack Overflow

Questions tagged [xeround]

Xeround provides a cloud database service for applications based on the open source edition of the MySQL database.

28 questions
8
votes
4 answers

Should we use RDS or Xeround?

We use Amazon S3 and CDN. Our app runs on Heroku. We are thinking of using a DBaaS like RDS or Xeround. Because we are already using S3 and CDN from Amazon, should we use RDS? Since all technologies are running on the same host (Amazon), will there…
Christian Fazzini
  • 19,613
  • 21
  • 110
  • 215
5
votes
2 answers

Xeround vs ClearDB hosted MySQL pros and cons?

We are currently on RDS for hosted MySQL but are considering moving to one of the fault tolerant MySQL addons for heroku. The two main ones seem to be xeround and ClearDB, but I'm having a hard time determining the differences between them. We're…
Matt Hall
  • 2,569
  • 2
  • 23
  • 33
4
votes
1 answer

Records getting deleted from Mysql table automatically

I have created a cronjob in Python. The purpose is to insert data into a table from another one based on certain conditions. There is more than 65000 record to be inserted. I have executed the cronjob and has seen more than 25000 records inserted.…
SkariaArun
  • 219
  • 1
  • 13
3
votes
1 answer

How do I force Xeround to close all connections?

I was experimenting with SQLAlchemy on Xeround: >>> from sqlalchemy import create_engine >>> engine = create_engine("mysql://user:pass@instance0000.db.xeround.com.:1234/app000000") >>> engine.execute("SELECT USER()").scalar() >>> exit() I did that…
Kit
  • 30,365
  • 39
  • 105
  • 149
3
votes
1 answer

Same MySQL Query Returning Different Results on Same Server

I am running the following query. Sometimes it returns around 100 records, as expected, other times is returns only one record with NULL for all of the values of the joined fields. Also, explain returns a different result almost everytime. Here is…
Jonathan
  • 5,495
  • 4
  • 38
  • 53
3
votes
1 answer

Fast Left Joins

I recently switched from using a local MySQL instance to using a Xeround MySQL instance for my C# application. As such, I've noticed that queries run much more slowly. I'm currently running a left join to create a new table and am trying to shave a…
user1120540
  • 121
  • 1
  • 8
2
votes
3 answers

Error "Failed to establish a database connection" in Google Docs Spreadsheet

I am using xeround for a MySQL database and for the past year I've been connecting to it with Google Apps Script in a Google Docs Spreadsheet. Now all of a sudden it is not connecting. I've checked the username and password, and I've double checked…
user1706788
  • 21
  • 1
  • 3
2
votes
2 answers

How to Concatenate Strings in MySQL (xeround)

I'm in a Stored Procedure, and I need to concatenate 3 parameters PLUS a static string to create a unique ID for a table. So the SP has, let's say, p1, p2 and p3 as varchar parameters, and I want to insert a new row in a table with values p1, p2, p3…
Amarundo
  • 2,357
  • 15
  • 50
  • 68
2
votes
1 answer

Proxy setting for Connecting to Xeround Database

I am trying to connect to Xeround Database fro inside my office but i cant connection it says connection link error but when i try to connect to it from home it works fine.I am not able to debug this error can anyone help Here is my connection…
user1457686
  • 33
  • 1
  • 6
1
vote
1 answer

Heroku app with Xeround DB, how to configure?

I’m trying to setup a Heroku app but using a Xeround DB. The instructions I have found are a bit confusing: http://xeround.com/developers/heroku-cloud-database-mysql/ I'm trying to follow the second way, creating the db directly on Xeround. My…
Pod
  • 928
  • 1
  • 10
  • 30
1
vote
1 answer

Xeround Reliability

I recently scaled up my application which uses a C#/.NET front-end and PHP scripts as web-crawlers as a back-end. Both sides of my application interact with a Xeround MySQL database (I am currently using Xeround Basic, but am considering moving to…
user1120540
  • 121
  • 1
  • 8
1
vote
0 answers

Wordpress on Heroku and localhost with different databases: Can't log in to Heroku WP dashboard

As the (long) title suggest, I have a Wordpress blog that is running on localhost for development and Heroku for production. I modified the wp-config file so that when the site is on localhost, it pulls a local database and on Heroku it pulls a…
zstix
  • 23
  • 3
1
vote
2 answers

Using Ruby and XEROUND on Heroku

First I would like to know if anyone has successfully built a Ruby on Rails application on Heroku using the XEROUND Add-on? My PHP app works fine with the XEROUND Add-on (same database). My Ruby application however, errors on starting. We're sorry,…
Robert Forillo
  • 11
  • 1
1
vote
2 answers

how to limit ActiveRecord database connections across multiple processes

when using a DBaaS (database as a service) such as Xeround with a Rails app hosted on EC2 instances, how is it possible to limit the number of concurrent connections to the database (according to the DB service plan limits) ? is it necessary to do…
Gal Ben-Haim
  • 17,433
  • 22
  • 78
  • 131
1
vote
1 answer

How to use Django 1.4 with Xeround?

According to Xeround's Release Notes they don't support save points and I can't figure out how to turn off support for this in Django 1.4. Does anyone know how to accomplish this?
mrbillyocean
  • 1,341
  • 1
  • 14
  • 24
1
2