Move postgresql database to separate machine
In current setup , we're running multiple web services like Matrix,diaspora,poddery on a single machine. Due to limited resources of the machine , we had a frequent downtime of services . To solve this problem, its better have the separate machine for postgresql database on the Same openstack instance. Let me know what others think .
ShamilSun 17 Dec 2017 4:22AM
👍 And we should do it quickly too.
Pirate PraveenSun 17 Dec 2017 4:30AM
@isaagar make a plan, list out the steps, then schedule a down time. We should announce it to our users. We can review the steps.
I SagarSun 17 Dec 2017 10:08AM
@praveenarimbrathod @noteness Yes, amar already provided one machine with 40 GB disk space.
I SagarSun 17 Dec 2017 10:36AM
New machine has public IP which I'll share and add the others ssh keys
Following are the steps for setup.
1. Find the configuration of all web services dependent on the postgresql where we need to change it according to our new setup. (Adding it in the wiki will be helpful before starting the setup)
2. Encrypt the 40 GB disk of the new machine.
3. Setup the postgrsql on new machine (replica ? new version 9.6?).
4. Shutdown all services and Sync the database to the new machine. (~12G and will be faster locally)
5. Make changes in the configuration of services and start the services.
I SagarMon 18 Dec 2017 1:15PM
@praveenarimbrathod @noteness @devraj Lets finalize the steps.
Raju DevidasMon 18 Dec 2017 3:02PM
what should we tell in the public announcement?
Pirate PraveenWed 27 Dec 2017 2:15PM
I think we can try to save some resources by shutting down services that are not used much like xmpp bridge, and possibly prosody and chat.diasp.in
Can we shutdown xmpp bridge?
opt-in by Pirate Praveen Closed Thu 28 Dec 2017 1:34PM
we are hitting the limits and I think this could be easily
Results
| Results | Option | Voters | |||
|---|---|---|---|---|---|
| Yes | 3 |  | |||
| No | 0 | ||||
| Undecided | 31 |               |
Pirate Praveen
Wed 27 Dec 2017 2:19PM
yes, it is run for just one channel (#piratesin:diasp.in)
Pirate Praveen ·Sat 16 Dec 2017 11:58AM
looks good to me. Just make sure we have proper working backups before starting the migration.