Take Out The Papers And The Trash

How to clean and clear large tables in MySQL

From time to time our data team gets requests for advice on how to perform cleanup operations against large database tables. Typically, these originate in a ticket requesting information about how the disk is being used or why a specific table is performing poorly.

Somewhat less often, we are asked us to explain why a cleanup attempt has failed or why it has caused downtime for an application. Managing these types of operations with minimal or no downtime can be a challenge given the way a database like MySQL performs these tasks.

The most common form of table cleanup operation we are asked about is for the sessions table. Even though these are not really recommended practice(https://guides.rubyonrails.org/action_controller_overview.html#session) they are still quite common to see. Depending on your application workload and use cases these tables can grow very quickly in size; often including older records that are never going to be used again. Even though the data payload in each row is relatively small, it's not uncommon to find sessions tables that are 10 or 20 GB in size—often larger than the rest of the database combined.

The "Standard" Solution

While there is no automatic session cleanup built into a rails app it happens to be really easy to write a rake task that handles this cleanup for you. In fact, it's so easy that it's often overlooked until the table has reached the size where it is difficult to manage .

Read More

PaaS Providers Must Evolve or Die

Technology changes almost as frequently as the latest fashion trend. What’s in vogue today will be out of favor tomorrow; some technologies will fade away while others morph into something new. One of the technologies currently going through a transformation is Platform-as-a-Service (PaaS). Changes in business requirements, government regulations, and developer strategies are placing new demands on PaaS providers, and a new type of PaaS infrastructure is starting to emerge to meet the changing requirements.

Read More

Ruby on Rails vs PHP

There’s more than one way to build a web application. No matter what type of application you are trying to create, your programmers have their preferred approach and their preferred code languages to accomplish the task. In the world of web applications, most program developers have to decide between Ruby on Rails versus PHP.

Read More

What to Look for When Considering Application Hosting

Cloud computing has made hosting business-critical applications easier and less expensive. Application hosting makes deploying the resources you need easier and faster—without the overhead of additional hardware, software, and personnel. Once you decide to host your business applications, the question becomes, what criteria do you need to consider when looking for an application hosting provider?

Read More

5 Commercial Use Cases Continue to Prove the Value of Ruby on Rails


Ruby on Rails continues to gain popularity as an effective platform for developing web and cloud applications. Today, there are at least 865,472 business websites running on Ruby on Rails, and the number is growing. Ruby on Rails continues to gain momentum partly because it is open source, which means the developer community continues to improve the platform, and also because Ruby on Rails was created to promote “programmer happiness,” which means programmers are more productive and more efficient developing in Ruby on Rails than on other platforms such as .NET and Java.

Read More

Do we still need RVM Gemsets?

RVM or Ruby Version Manager allows you to install and manage Ruby environments. Similar tools are Rbenv and chruby. I previously wrote about installing these on a Mac here.

Read More

Top 5 reasons Not to miss Rails Conf

Every year, there is a gathering of developers, looking toward the future of a framework that nearly 15 years ago brought Ruby to the web. That gathering is Rails Conf, and the 2018 edition is in Pittsburgh, Pennsylvania!

Read More

Rails Encrypted Credentials Use AES 128-bit Key

Rails 5.2 introduces Credentials which replaces Secrets and Encrypted Secrets from previous Rails versions. I have previously written about Credentials for those of you wanting to know more.

Read More

Using Rails and Vue JS, Part 1

Vue (pronounced as view) calls itself the progressive JavaScript framework. It is designed to be incrementally adoptable. You can use Vue to build user interfaces on a few pages or a few areas of an existing Rails view. You don't have to throw away existing Rails code.

Read More

[Press Release] Engine Yard Publishes Guide to PaaS

Ruby on Rails Experts’ New E-Book Explores How This Technology Is Evolving

Austin, TX—March 9, 2018—Engine Yard, the leading provider of support services for Ruby on Rails applications, today announced it is publishing a guide detailing how PaaS is changing amid today’s application development landscape. The e-book, PaaS Is Dead: The Digital Evolution of a “Dying” Platform, is available for free download at www.engineyard.com/paas-is-dead. 

Read More

Subscribe Here!