Magento News

 

Magento: Database Updater Module

I am currently working on a project that has one Magento code base, but will be deployed to multiple instances on different servers, all having their own database. Because we’ll have one set of code and multiple databases, what happens when we need to make a database change (system config change, adding a product attribute, etc.) to some or all of the websites? I can tell you that having to go into the admin of 20+ Magento installs to make the change in each isn’t an option.

A better option that we have come up with is to create a module that allows us to do the updates. If done well, it should allow us to have all the control we need when a database update is necessary.

Here are some of the ideas we are working on:

  • A system config option that allows us to specify a website identifier code used for this module.
  • Additional methods added to our resource file which allow us to specify if we want an update to apply to all websites, only to specified websites, or to all excluding specified websites.
  • A mysql4-update template file with lots of documentation and examples of how to add/update some of the most common changes to make updates easier.

I have no plans to release this module (I can’t imagine much of a need for it for the majority of Magento users), but I wanted to share our plans in case there’s someone out there in the same place as we found ourselves.


Magento: Database Updater Module

Possibly Related Posts:


 

Leave a Reply