I am using InnoDB.

When remove increase actions occur on the particular table, I have to ensure changes with other tables. At this time, I'm coping with that through code. I am wondering if there's an advantage in my experience carrying this out within the DB level.

Any ideas? Benefits and drawbacks to think about? Gotchas to consider?

I believe you might want to find out about using using MySQL Triggers. Additional links:

Restrictions overview

MySQL Triggers FAQ

The advantage of doing that in the database level is the fact that individuals needs is going to be enforced for each user and each application. (Including you, when you are sleep-deprived and pressurized.)