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

Pros and Cons of DevOps as a Service


It seems as though every component of business computing is being offered as a cloud-based service, including DevOps. The business advantages of using cloud services are obvious: You can rent computing resources rather than having to buy and manage them, and you can make changes faster since there is no on-site hardware to deal with. However, can you really outsource every aspect of business computing? Can DevOps as a Service really work? Does cloud collaboration between development and operations speed up projects, or does it mean companies lose control of business-critical applications?

Read More

How the Role of DevOps Will Change in 2018

Trendspotting is always challenging. No one can know for certain what the future holds, but it’s clear that change is a constant, especially when it comes to the evolving role of DevOps in supporting enterprise applications. As business needs evolve and companies seek out new ways to increase efficiency and harness the cloud, the role of DevOps will become even more important, and it will be more closely integrated into business operations.

Read More

What Is a Full Stack Developer Salary?

When you need customized enterprise solutions, do you tend to hire the expertise you need to develop the necessary applications or do you contract it out? When you consider that added overhead of hiring a full-stack developer salary, you may find it more cost-effective to rent the expertise you need rather than hire it.

Read More

DevOps Explained: A Day in the Life

If you have the letters “IT” in your job description, you have probably worked with programmers, web application developers, and DevOps experts, but have you ever wondered what it really takes to make a DevOps project successful? Here’s a brief primer on DevOps.

Read More

[Press Release] Engine Yard Publishes Guide to Hiring DevOps

Ruby on Rails Experts' New E-Book Details 5-Step Process for Finding the Best Talent

AUSTIN, Texas—Jan. 4, 2018—Engine Yard, the leading provider of support services for Ruby on Rails applications, today announced it is publishing a guide to help established Ruby developers and teams find and hire top DevOps talent. The e-book, The Complete Guide to Hiring a Ruby DevOps, is available for free download at https://www.engineyard.com/guide-to-hiring-a-ruby-devops.

Read More

Why DevOps? What Are the Benefits of DevOps?

Just five years ago, most enterprises operated their innovation efforts in silos. Development was in one corner, working on the next big thing; operations was in the other, making sure that none of the technology stopped working. Far too often, like Star Trek’s Dr. McCoy, people in these disparate roles exclaimed, “I’m a doctor, not a ...” They rarely engaged with each other—and things were left to fall through the cracks.

Read More

1st Stop. What is DevOps? - Podcast

Welcome to Engine Yard's Podcast Journey.

Read More

3 DevOps Skills Your Team Must Have

 

Expanding your DevOps team can sometimes feel like defeating a demogorgon—or demodogs for that matter (R.I.P., Dart)—without Eleven. You may have a paladin, a cleric, a bard, and a ranger. But without the mage, or at least a little truesight, it’s tough to know how to make the most of your resources and expand your capabilities. (Can you tell we’ve binged on Stranger Things 2?)

Read More

Subscribe Here!