Summary ------- I need to set up a read-only DB on the cloud which will synchronize with the read/write DB on my laptop whenever possible (that is, whenever I connect my laptop to the Internet). Need some pointers on what sort of replication that I'm supposed to use and how to set it up. Details ------- Hello, I'm developing a database that will be used for business intelligence. That is, there are some CSV reports. Using them, I've created a data model and I'm parsing and loading the reports to the local DB that I've created. The business team needs to be able to read this data in order to use them in their analyses (such as using tools like PowerBI), so I need to put this data somewhere that's always reachable from the Internet. Thing is, the local DB on my laptop is always in development. That is, the tables keep changing, views keep changing, data keeps being changed, etc. Developing directly on the cloud DB is slow. Furthermore, I would need constant Internet access to develop on the cloud DB. Hence, I'm thinking that if there was a solution that will allow me to develop on my laptop and eventually (doesn't need to be instant) synchronizes my local DB with the cloud DB (both the data model and the data itself) automatically, whenever possible (whenever I connect my laptop to the Internet), I believe this would be the solution that I need. I've read the documentation but it's pretty complex. I got the impression that streaming replication would be what I need but it mentions something like the standby server connecting to the primary server. This would not be possible since the primary server is in a laptop, which is not reachable from the public Internet. I believe this could be worked around by using a VPN and connecting both my laptop and the cloud DB to the same VPN. For reference, I'm using AWS RDS if it makes any difference. Regards
