Solved: How to update the host ip of DevPortal database - Page 2

Report Inappropriate Content · 09-17-2015 08:40 PM

Could anyone please answer to the question on DevPortal for Private Cloud?

As for updating the IP address of existing MySQL Database specified in the file;

/var/www/html/sites/default/settings.php

with the parameter 'host' of $databases array, can we take either or both of the following procedures?

Opt-1: service httpd stop -> update the setting.php -> service httpd start
Opt-2: drush vset maintenance_mode 1 -> update the setting.php -> drush vset maintenance_mode 0

Other than this do we also need to fllow the steps;

Go to {{site_url}}/update.php, where {{site_url}} is your site URL and follow instructions on screen.

You will need to be logged in as an administrator.

anilsr

Dear @Toshihiro Shibamoto ,

You don't need to start / stop http server or even put the site in maintenance mode. Settings are dynamically read during run time. So , I will suggest following approach.

Take a backup of settings.php file
Make changes & save the file.

I don't think you will see any downtime. It will be split second. The moment you save the file, developer portal will start serving from new database. That's it.

You will run update.php if any upgrades are available for modules / entire site. Since the codebase is same i don't think you need to run update.php.

PS: Above solution will work if a developer portal database exists in new ip address. Otherwise developer portal will break or will ask for re-installation. Make sure you have populated database in new ip address.

If your developer portal is up & running in production environement then i would suggest below approach to prevent data loss.

Put site in Maintenance Mode.
Take a backup of existing database.
Move the database to new ip location using the backup taken in above step.
Take the backup of settings.php
Change the settings in settings.php to point to new location.
Disable Maintenance Mode.

You can also stop your server , but it will result in 500 server not found error. Maintenance mode is good to go considering user experience.

Keep us posted if you see any issues.

Cheers,

Anil Sagar

View solution in original post