Add a new column to the database table in production which is already having 100 million of data

Question

Accepted Answer

Use a tool like Rails migration to add a new column to the database table in production with 100 million data.

Create a new Rails migration file to add the new column to the database table.
Test the migration locally to ensure it works as expected.
Deploy the migration to the production environment during a maintenance window to avoid downtime.
Consider using tools like ActiveRecord's `change_column` method to efficiently add the new column to a large dataset.