How to alter tables in Laravel when records are in millions
As a developer, I have experienced changes in an app when it is in production and the records have grown up to millions. In this specific case if you want to alter a column using simple migrations that will not work because of the following reasons:
It is not so easy if your production servers are under heavy load and the database tables have 100 million rows. Because such a migration will run for some seconds or even minutes and the database table can be locked for this time period – a no-go on a zero-downtime environment.
This post is submitted by one of our members. You may submit a new post here.