Tagged Questions

2
votes
0answers
71 views

multiple rails engines talking to one mySQL server for horizontally scaling application servers

I've seen pictures like this where multiple rails engines write to a single mySQL server. 1) Is this possible? Or does Rails want each application server to write to one database server? 2) If ...
2
votes
0answers
451 views

Rails doesn't recreate mysql views in the test database, even when config.active_record.schema_format = :sql

We have some mysql Views in our development and test databases that were created via an execute(sql) statement in a migration. Rails' default schema.rb creates these views as tables. When ...
2
votes
0answers
406 views

Mysql server has gone away in rails when the database is in a faraway data center

We have two data centers located across the globe. if we run the rails app in one datacenter and point to the database located in the other data center. The app throws MySQL server has gone away ...
1
vote
0answers
36 views

Rails 3 activerecord query where clause with timezone

I have a problem with my rails application (rails 3.2.x, MySQL 5.x). Sample case to produce: set time_zone='Hanoi' in application.rb model Post new post created at 2013-06-28 01:00:00 (date of ...
1
vote
0answers
361 views

Use MariaDB instead of MySQL in my Rails project

How can I use MariaDB instead of MySQL in my Rails project? When I try to install mysql2 gem it returns error,because mysqlclient was not found. Here some solution, but I didn't found any ...
1
vote
0answers
65 views

Is there a way to export partial data from MySQL to SQlite using rails/ruby?

I know that yaml_db gem can export the whole MySQL database into SQlite, but I have too many things and I only need some tables. Is there an easy way to define which tables and which records to ...
1
vote
0answers
74 views

How to design bill table with dynamic bill details

I have different module such as painting, chasis_repair, over_oiling sections Each module have seperate bill table for example painting_bills, chasis_repair_bills, over_oiling_bills Now I have to ...
1
vote
0answers
59 views

how to store the session value in table in ruby on rails

i have an application in which books are sold. the customer add it to his cart and a session is created for that. now i want to add the items in cart to the order table so that admin can see what ...
1
vote
0answers
117 views

ActiveRecord with MySQL-Adapter: really slow INSERTs

A Rails 2 application has been upgraded to Rails 3.2.11. Everything runs just fine, except for one thing: In production mode on two different servers with brand new hardware, MySQL INSERTs from ...
1
vote
0answers
100 views

Can't connect to MySQL for single dyno on restart occasionally

Every once in a while, when we either restart the app or a dyno gets cycled/restarted automatically, a dyno restarts but comes back up with Can't connect to MySQL server on (url) (110) error. In then ...
1
vote
0answers
120 views

An ActiveRecord has its `id` == nil after saving

It is really awkward that the id of an ActiveRecord is still nil after save. My command in console is as follows: irb(main):003:0> c = Comment.new => #<Comment id: nil, commentable_id: nil, ...
1
vote
0answers
79 views

Alphabetical ordering of database columns in a large rails application

When working on a large and complex rails app I find it difficult to locate and work with specific columns in the database admin tools as the columns (there are well over 100 of them on some models) ...
1
vote
0answers
121 views

Rails/MySQL: lazy symbol binding failed?

I am a .NET developer by day and an aspiring Rails developer at night. I am trying to use Rails and MySQL as my DB. I have successfully installed both. However, I am running into a really strange ...
1
vote
0answers
117 views

Performance of Rails transaction rollback vs. manual cleanup in Production DB

I am aware that a rollback is not the same thing as a manual cleanup and is, in most cases, the preferred approach. That said, what is the performance difference between a large database rollback ...
1
vote
0answers
75 views

Error with mysql2 gem loading Rails env on OSX: “Symbol not found: _rb_prohibit_interrupt”

I'm on OSX 10.7.5 I'm setting up an existing Rails 3 app I've got the 64-bit dmg package of MySQL (v5.5.28) installed I've installed the mysql2 gem (v0.3.11) as part of the app bundle Whenever i ...

1 2 3 4 5 … 33
15 30 50 per page