From freelancer to team of two : best way to share/sync db? I am a webdev. I have just hired a dev. Before that I was alone. Thus, I have to change a bit my organization.

I am looking for the best way to develop on the same database (MySQL). I am considering different options:


Get a small server in the office and set an access to this database (actually, this is what we are doing. Performance are poor)
Use a big platform like Amazon RDS or Google Cloud Platform
Use a small VPS like Linode or Digital Ocean
Keep a db on  each dev machine and use a kind of syncing/replication


What would be the best way for you?
Do not consider your database a development asset. Instead consider the code an asset. Make all changes to the database through code, have the code checked in into source control. Conflicting changes resolve as source merges. Rails migrations capture this philosophy pretty well. But it can be applied to any platform and any language, eg. Version control and your database.

This approach will solve not only your team work issues, but also deployment, QA, upgrade of live site(s), tracking history of database changes, explain the current database schema and so many more.