Avatar of Yashy
YashyFlag for United Kingdom of Great Britain and Northern Ireland asked on

Question about master and read database servers

hi guys

I've got a database server in the cloud that is a master with Amazon. And a read server which replicates from the master.

Now I know that the read server is what will be the 'viewable' server on server pages for security reasons etc for the public to see.

One of the features of this website is that the general public make changes to their profiles and submit/save those changes (i.e. they write to the database). Like you would on a facebook page or a linkedin page when you make changes to your profile.

My question is, can this be possible if the server that is viewable to the public only a 'read' database server? Or does it have to be like a 'master' database for the public to be able to make changes/write to it?

Thank you
Yashy
Cloud ComputingMySQL ServerMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
Yashy

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
mankowitz

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Yashy

thanks for the help.

I'm unfamiliar with API's. What sort of API's? And is there any other way of doing this?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck