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
ASKER CERTIFIED SOLUTION
Avatar of mankowitz
mankowitz
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Yashy
Yashy
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

thanks for the help.

I'm unfamiliar with API's. What sort of API's? And is there any other way of doing this?
Microsoft SQL Server 2008
Microsoft SQL Server 2008

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.

50K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo