Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 18

Displaying posts with tag: Ruby On Rails (reset)

Speaking at RubyConf Philippines
+0 Vote Up -0Vote Down

I will be speaking about High Performance Rails with MySQL on RubyConfPH. If you use Ruby on Rails with MySQL and in Manila on March 28-29, you should register for the event!

Poll: What programming languages and platforms do you use?
+1 Vote Up -0Vote Down

What programming languages and platforms do you use for large-scale projects in your organization?

If something is missing from the list please leave a comment and share your story. Thanks!

Note: There is a poll embedded within this post, please visit the site to participate in this post's poll.

The post Poll: What programming languages and platforms do you use? appeared first on MySQL Performance Blog.

DbCharmer 1.7.0 Release: Rails 3.0 Support and Forced Slave Reads
+0 Vote Up -0Vote Down

This week, after 3 months in the works, we’ve finally released version 1.7.0 of DbCharmer ruby gem – Rails plugin that significantly extends ActiveRecord’s ability to work with multiple databases and/or database servers by adding features like multiple databases support, master/slave topologies support, sharding, etc.

New features in this release:

  • Rails 3.0 support. We’ve worked really hard to bring all the features we supported in Rails 2.X to the new version of Rails and now I’m proud that we’ve implemented them all and the implementation looks much cleaner and more universal (all kinds of relations in rails 3 work in exactly the same way and we do not need to implement connection switching for all kinds of weird corner-cases in ActiveRecord).
  • Forced
  [Read more...]
Adopting RAD in the Enterprise: The 14 Biggest Misconceptions
+0 Vote Up -0Vote Down

Rapid Application Development (RAD) is a way of developing computer software applications with less effort than the traditional means.

RAD tools focus on providing code generation and automated testing capabilities with the use of convention over configuration to provide a streamlined workflow to create applications.

Even with the most advanced and easiest to use RAD tools, there are times which the traditional enterprise and the business software development vendors which are having their own implementations and in-house built frameworks are continuously refusing to adopt them.

Most of the misconceptions on the RAD are based on FUD (Fear, Uncertainty

  [Read more...]
Ravelry Runs On – 2010
+0 Vote Up -0Vote Down

I guess that it’s time for the 3rd annual “Ravelry Runs On” roundup. The last two were in March 2008 and March 2009.

This year, our traffic increased by 50% to 5,000,000 page views and 15 million Rails requests per day. We made very few changes to our architecture in 2009 but we did add a new master database server after our working set of data outgrew our memory and IO capacity.

This summary is more detailed then the last two and I’ve broken it up into rough sections.

Physical Network

We own our own servers and colocate then in a datacenter here in Boston. The datacenter provides us with a cooled

  [Read more...]
SAP as a case study for open source engagement
+0 Vote Up -0Vote Down

There was some incredulity expressed yesterday when I suggested that SAP is a great case study on the way in which proprietary companies have engaged with open source.

To be clear, I was not suggesting that SAP is, or should be considered, an open source company, but based on our understanding of SAP’s changing strategy with regards to open source software it represents a good case study on how proprietary companies have learned that it is in their best interests to contribute to open source software projects.

Jay and I had the opportunity yesterday to speak to Claus von Riegen, SAP director of technology standards and open source, and Erwin Tenhumberg, SAP open source program manager. Our

  [Read more...]
Eleven Open Source Cloud Computing Projects to Watch
+0 Vote Up -0Vote Down

Last month cloud computing and systems management expert John Willis published his best of Cloud Computing for 2009 list he calls the Cloudies.  I am not an expert on the latest developments in cloud computing so it was nice to get a list of the best (in his expert opinion)

  [Read more...]
DB Charmer – ActiveRecord Connection Magic Plugin
+1 Vote Up -1Vote Down

Today I’m proud to announce the first public release of our ActiveRecord database connection magic plugin: DbCharmer.

DB Charmer – ActiveRecord Connection Magic Plugin

DbCharmer is a simple yet powerful plugin for ActiveRecord that does a few things:

  • Allows you to easily manage AR models’ connections (switch_connection_to method)
  • Allows you to switch AR models’ default connections to a separate servers/databases
  • Allows you to easily choose where your query should go (on_* methods family)
  • Allows you to automatically send read queries to your slaves while masters would handle all the updates.
  • Adds multiple databases migrations to ActiveRecord


    There are two options when

  •   [Read more...]
    Loops plugin for rails and merb released
    +0 Vote Up -0Vote Down

    loops is a small and lightweight framework for Ruby on Rails and Merb created to support simple background loops in your application which are usually used to do some background data processing on your servers (queue workers, batch tasks processors, etc).

    Originally loops plugin was created to make our (Scribd.com) own loops code more organized. We used to have tens of different modules with methods that were called with script/runner and then used with nohup and other not so convenient backgrounding techniques. When you have such a number of loops/workers to run in background it becomes a nightmare to manage them on a regular basis (restarts, code upgrades, status/health checking, etc).

    After a short time of writing our

      [Read more...]
    Bounces-handler Released
    +0 Vote Up -0Vote Down

    Today I’ve managed to finish initial version of our bounces-handler package we use for mailing-related stuff in Scribd.

    Bounces-handler package is a simple set of scripts to automatically process email bounces and ISP‘s feedback loops emails, maintain your mailing blacklists and a Rails plugin to use those blacklists in your RoR applications.

    This piece of software has been developed as a part of more global work on mailing quality improvement in Scribd.com, but it was one of the most critical steps after setting up reverse DNS records, DKIM and SPF.

    The package itself consists of two parts:

    • Perl scripts to process incoming email:
      • bounces processor — could be
      [Read more...]
    Web Developer / Graphic Designer Job Openings
    +0 Vote Up -0Vote Down
    Currently, there are several great opportunities with exciting companies available in the New York area. If you're a rock star Java/PHP/Ruby developer or a pixel-obsessed designer, contact me at your earliest convenience.

    Web Developer:

    Give Real is a well-funded startup in the midst of an exciting period of growth and success. Our technology uses a patent pending platform that combines the ubiquity of credit card transactions and the power of social networks to create a new gifting experience.

    Our primary platform is Rails, but there are programming challenges that range from SOAP APIs to Facebook application development. We are searching for full-time developers with expertise and broad experience in:

    * Ruby on Rails (we also use rSpec, Starling, Memcache)
    * MySQL
    * xHTML & CSS, and comfort with

      [Read more...]
    Sakila the MySQL Dolphin at CommunityOne and JavaOne
    Employee +0 Vote Up -0Vote Down

    Yes, I know. JavaOne is about Duke, the friendly mascot of Java technology. Created and maintained by James Gosling and all.

    But MySQL also introduces Sakila to the JavaOne attendees. Sakila is also friendly, and the mascot of MySQL technology. The dolphin was chosen by MySQL founders Michael “Monty” Widenius and David Axmark, as was its name Sakila (which came from a naming contest in the early days).

    Together with Giuseppe (in the picture above) and the rest of the MySQL Community Team, I will be handing out incarnations of Sakila (also seen above in the pic) at CommunityOne and JavaOne as follows:

    • Monday 5 May 2008 09:30-10:45: CommunityOne General Session: Ian Murdock, Sun Microsystems;
      [Read more...]
    Dog-pile Effect and How to Avoid it with Ruby on Rails memcache-client Patch
    +0 Vote Up -0Vote Down

    We were using memcache in our application for a long time and it helped a lot to reduce DB servers load on some huge queries. But there was a problem (sometimes called a “dog-pile effect”) - when some cached value was expired and we had a huge traffic, sometimes too many threads in our application were trying to calculate new value to cache it.

    For example, if you have some simple but really bad query like

    SELECT COUNT(*) FROM some_table WHERE some_flag = X

    which could be really slow on a huge tables, and your cache expires, then ALL your clients calling a page with this counter will end up waiting for this counter to be updated. Sometimes there could be tens or even hundreds of such a queries

      [Read more...]
    FastSessions Rails Plugin Released
    +0 Vote Up -0Vote Down

    How often do we think about our http sessions implementation? I mean, do you know, how your currently used sessions-related code will behave when sessions number in your database will grow up to millions (or, even, hundreds of millions) of records? This is one of the things we do not think about. But if you’ll think about it, you’ll notice, that 99% of your session-related operations are read-only and 99% of your sessions writes are not needed. Almost all your sessions table records have the same information: session_id and serialized empty session in the data field.

    Looking at this sessions-related situation we have created really simple (and, at the same time, really useful for large Rails projects) plugin, which replaces ActiveRecord-based session store and makes sessions much more effective. Below you can find some information about implementation details

      [Read more...]
    Sun acquires MySQL
    Employee +0 Vote Up -0Vote Down

    This morning, Sun Microsystems announced plans to acquire MySQL AB (http://www.mysql.com/news-and-events/press-release/release_2008_03.html).

    After all the industry speculation about MySQL being a “hot 2008 IPO”, this probably takes most of us by surprise — users, community members, customers, partners, and employees. And for all of these stakeholders, it may take some time to digest what this means. Depending on one’s relationship to MySQL, the immediate reaction upon hearing the news may be a mixture of various feelings, including excitement, pride, disbelief and satisfaction, but also anxiety.

    Being part of the group planning this announcement for the last

      [Read more...]
    Navigating categories within my blog
    Employee +0 Vote Up -0Vote Down

    With 130 entries in the “MySQL” category and no MySQL-related subcategories, my blog had become impossible to search and navigate easily.

    And thus I created a number of new categories for the MySQL entries within my blog. They’re listed in the left navigation bar, below the months, as well as below:

      [Read more...]
    Ruby on Rails 2.0 Released
    Employee +0 Vote Up -0Vote Down

    Ruby on Rails 2.0 was released last week, It’s done!, David Heinemeier Hansson notes.

    Ruby on Rails has come a long way since Lenz Grimmer’s interview with DHH in February 2006.

    Browsing DHH’s blog, I find snippets (bolding mine) like

    Piggy-backing off the new drive for resources are a number of simplifications for controller and view methods that deal with URLs.

    As you might have gathered, Action Pack in Rails 2.0 is all about getting closer with HTTP and all its glory.

    We?ve also made it much easier to

      [Read more...]
    Rails, Stored Procedures, Migrations, Mysql 5+ and … Trouble!
    +0 Vote Up -0Vote Down

    This is a tale about Ruby On Rails, custom stored procedures for MySql 5 (http://www.mysql.com/) and how Rails 1.2.3 is not only opinionated against stored procedures but also actually incompatible with creating and sometimes calling (mysql) stored procedures. The tales does not end with a truly happy ending but some “hacks” are mentioned that I have found useful.

    The rails framework developers, being of the opinion that complexity is best located in the code and not in the database, does not advocate using stored procedures as a abstraction layer between the database and the application. Instead dynamic sql generated from RoR code is used. For typical application databases, this approach works very well indeed.

    Examples where the traditional rails way

      [Read more...]
    Showing entries 1 to 18

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.