RDS is getting used for keeping the application data for multiple microservices. Amazon managed postgres RDS with multiple AZs for High availability. The integration with applications is quote easier with RDS as it provides a cluster endpoint to be used with services
Pros
Performance across multiple azs
Query Monitoring with performance insights
Maintaince is reduced as automatically done by amazon
Cons
RDS upgrade using blue green deployment can be made a bit easier. Prerequisites can be made more clearer
Likelihood to Recommend
RDS is very well suited for relational data and having a large amount of data and wanted to run sql queries. RDS does provide good monitoring in case of long running queries or queries having locks
Many teams, including mine, use Amazon RDS as an operational data store for applications. Amazon RDS is a great service that provides seamless setup, read replicas, intuitive scale-in and scale-out options, built-in monitoring, and much more.
Pros
Easy and simple setup.
Excellent support for cross region replication.
Enhanced security and access controls.
Multiple instance types based on the need.
Relatively less expensive.
Cons
It could do well to provide tools to update or create database table schemas easily.
Native support to postgres database could benefit.
Likelihood to Recommend
If your application needs a relational data store and uses other AWS services, AWS RDS is a no-brainer. It offers all the traditional database features, makes it a snap to set up, creates cross-region replication, has advanced security, built-in monitoring, and much more at a very good price. You can also set up streaming to a data lake using various other AWS services on your RDS.
VU
Verified User
Manager in Information Technology (10,001+ employees)
We started using RDS as an alternative to our BE system since, at the beginning, the team did not have experience or knowledge about BE frameworks, but it was necessary to maintain a relationship between the data of the projects being executed and the RDS services of Amazon were of great help, since it is an out of the box solution. As well as it also served as a starting point to understand how our BE system should be structured later.
Pros
Easy to implement
Lots of documentation and tutorials available, from Amazon and third parties
Low cost
Cons
The official documentation needs to be sharped.
Tools to move data from one server to another
Likelihood to Recommend
For people or companies that are starting out and do not have the necessary concepts to implement a database into their Backend system, or that they don't have their on cluster or a backend engineer that can configure it, RDS can fulfill a percentage of this functionality. Also if later is needed the data can be migrated to a database that lives inside the company cluster.
In healthcare, managing patient records and sensitive data securely is crucial. RDS offers encrypted storage, ensuring data security and compliance with regulations like HIPAA (Health Insurance Portability and Accountability Act). This encryption extends to data in transit and at rest. With RDS, you can set up multi-AZ (Availability Zone) deployments for high availability. This is vital in healthcare, where database downtime can directly impact patient care. In case of disasters, RDS facilitates quick recovery, minimizing data loss.
Pros
Automated Backups and Snapshots
Easy Scalability
Read Replicas for Improved Performance
Cons
Limited Control Over Underlying Infrastructure
Cost Management
Complexity in Monitoring and Logging
Likelihood to Recommend
Electronic Health Records (EHR) Management: RDS is ideal for managing EHR systems due to its high availability, security features, and scalability. It ensures that patient records are always accessible, secure, and can handle increasing loads as more data is added. For telemedicine platforms that require reliable, scalable databases to manage patient appointments, medical histories, and consultation notes, RDS can provide the necessary backend support. Scenarios Where Amazon RDS Might Be Less Appropriate:Highly Customized Database Configurations If your healthcare application requires very specific, fine-tuned database configurations or uses specialized database features not fully supported by RDS a self-managed database might be a better fit. If your healthcare application requires real-time processing of data (e.g., real-time monitoring of patient vitals), you might need a more specialized solution like Amazon Kinesis or a similar real-time data processing service.
VU
Verified User
Project Manager in Professional Services (10,001+ employees)
RDS simplifies database management tasks like provisioning, patching, backup, recovery etc. This reduces the administrative burden and allows teams to focus on application development rather than database maintenance. Since this is a managed service it provides in built high availability and scalability. Also we can secure our data by encrypting them at both transit and rest. One more useful use case is, we can selectively encrypt sensitive data to give extra protection
Pros
Read replicas and global availability of database which enhances user experience
Integrate well with other aws services lile IAM, KMS etc
Performance insight help us to get an aggregate view of db activities which is necessary for troubleshooting
Cons
Introduce more supportive engine
Can introduce more granular control over back ups to save cost
Likelihood to Recommend
E commerse platforms can take advantage of RDS very well as they have to maintain lot if structured data. I would say if the data is non relational and also if company requires real time analysis and all it is better to use other solutions
We utilize Amazon Relational Database Service to host MySQL RDBS to store the data related to custom apps for our dev environment. It's super easy & fast to set up the database instances in a few clicks from the AWS management console. A lot of times, the developers in our team aren't that expert when it comes to managing the database administration, & hence for this very reason, Amazon Relational Database Service is our preferred DB service as it simplifies time-consuming admin tasks.
Pros
Monitoring of metrics performance via AWS CloudWatch.
Read replicas to maintain data integrity & High availability.
Minimal need of maintaining the Database.
Serverless DB.
Cons
Somewhat costly.
Migrating from RDS to other DB service is complex.
Horizontal scaling can be improved.
Likelihood to Recommend
It will suit & fit in almost all the user cases where there is a need for RDBMS. Given its seamless & minimal effort to set it up & run along with a wide variety of DB engines to choose from, it is a robust DB Service.
RDS performs frequent backups of your database, and you may configure retention rules to control how long backups are kept. RDS makes it simple to extend our database instance vertically by switching instance types or horizontally by adding read replicas. AWS takes care of the underlying infrastructure, including hardware provisioning, database setup, patching, and backups of our business.
Pros
Regular backups of database.
Database is available even if there is hardware and network issues.
We can control access to your RDS instances through security groups and network access control lists
Cons
RDS price may be complicated, with various aspects such as instance type, storage, I/O operations, and data transmission influencing costs
RDS may lag in supporting the most recent versions of database engines.
Likelihood to Recommend
RDS is a great option for hosting the database backbone of online applications such as content management systems, e-commerce sites, and social media platforms. Amazon Aurora, a highly performant and scalable database engine, is supported by Amazon RDS. RDS is primarily intended for use with relational databases. Consider Amazon DynamoDB or other NoSQL database services if your application requires a NoSQL database with flexible schemas.
We at Publicis Sapient has been delivering software solutions to many of our clients regularly. There is often the need to persistent data storage and we recommend to use Amazon RDS because it is easy to set up, the dev team don't have to dig deep in understanding about how to connect the Amazon RDS to the backend or how to invoke a request. The Amazon RDS has low learning curve which means the new dev team can work on it from day 1 without good deeper in terms of learning.
Pros
We used to store persistent data of clients
Sales and user data is stored and the manipulation is done at the backend side using CRUD operations.
Cons
The improvement in terms of blockchain native could be introduced
The Amazon RDS should have it's standalone client so that we don't need to download the specific software in our system when we want to use it from our desktop.
Likelihood to Recommend
Amazon Relational Database Service is well suited when you want a rapid development as the learning curve is minimal for this and the new development team can start building from day 1.
The capabilities in terms of storing blockchain native data could be introduced, currently we can use it for fast paced data but the retrieval and flexibility of storage is not as good as other blockchain leger storages.
Amazon Relational Database Service (RDS) is a nosql relational database offered by Amazon itself.it will help organizations to manage and maintain large chunk of data. user can use its PAAS services and they have to manage only database part and rest backend infrastructure managed by Amazon itself. we can use Amazon storage S3 service to store data Aswell.
Pros
PAAS easily anyone can spin one
scalable as per your request
robust and easy to manage
99 % uptime
Cons
more features which help connect user
different API integration
seamless connection with onprem and other DB agent
Likelihood to Recommend
In our project we use Amazon Relational Database Service (RDS) along with other dB like sql and mssql.its easily connected with other onprem dB and create dataflow seamlessly.also we use Amazon Relational Database Service (RDS) to run our external data serve purpose.its easy scalable features help to scale as per business requirements. easly can connect with different endpoint.
RDS is pivotal to our data strategy, powering hundreds of databases within our infrastructure. Its reliability and scalability ensure optimal performance and data integrity. Rigorous security measures, including backups and monitoring, maintain database stability. RDS flexibility accommodates evolving business needs while optimizing performance and cost-efficiency.
Pros
Automated Backups
High Availability
Database Snapshots
Security and Compliance
Scalability
Cons
Limited Control
Cost Transparency
Lack of Support for Certain Database Engines
Improved Data Migration Tools
Switch to Encrypted RDS from Unencrypted RDS
Likelihood to Recommend
Amazon RDS is an ideal choice when you need rapid database deployment for your project due to its user-friendly configuration and robust automation support, including Terraform and CloudFormation. Being a managed service, AWS assumes responsibility for its management, ensuring reliability. However, it may not be the best fit if you require extensive control over your databases.