Hi all!
My company has a workflow right now where 2+ developers may be working on one Wordpress site at the same time. Due to the nature of our setup, we have remote developers as well so we cannot just run a server within the office that everyone can work off, unfortunately.
Currently, to handle this, we have a remote database server that we all connect to via an ssh tunnel that binds to address 127.0.0.0:5555 locally. We then configure our WP Config files to use that address as well as the proper db name, username, password for the remote server.
This does work and allows for a secure connection to the database server, however, the second we start to actually add content, plugins, pages, etc, our page load speeds locally seem to plummet. I’m talking sometimes 10 - 20 seconds for a page to load. These databases aren’t getting large by any means, the largest we are working with is probably 100mb or less.
I’m wondering if anyone has a similar workflow, and has any suggestions on how we could improve this on our end. Should we ditch the SSL tunnel and opt for a different method to allow all of our developers to connect?
Appreciate any help or tips!
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Great question @HelloCharlie
It reminds me of pre VM development, however working on a server in production, would not be something I would recommend,
I would say to your developers to setup a local instance of MySQL, you could go one step better and use docker to host and run Docker locally on each developers machines, using docker would make it very easy to keep versions the same as production.
https://www.digitalocean.com/community/tutorials/how-to-install-wordpress-with-docker-compose
Regards
Simon SnapShooter DigitalOcean Wordpress Backups SnapShooter
I would suggest your db issue is a config one. Can you post the contents of your my.cnf config file?
A
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.