Since switching to RDS, this has become a thing of the past.
Because like many websites/apps, data is at the core of what we do. But when there were problems, there were huge problems. Most of the time (because these are not new technologies), there were no problems. But the machine and the software were our problem to handle. It was Oracle for a while, then we moved to mySQL. Also, tooling is restricted.Ī lot of great tools to dig into performance and query tracing won't work with the AWS caveats so you have to use the AWS RDS console and logs and it can be more tedious to really drill into application performance bottlenecks.Ĭommenti: Waaaay back in the day, we owned and managed huge machines on which we ran our database software. There are other caveats and restrictions for other DBMS products too.Īnother thing I don't like is when you change your instance size it takes a long time - but at least there's no downtime.
You can adjust a number of parameters in the RDS console but only those which AWS have explicitly added support for.
DBEAVER CONNECT TO AWS POSTGRESQL RDS UPGRADE
It's also dead easy to upgrade software versions - simply let AWS look after it.īeing a managed database service there are restrictions for instance, with SQL Server you don't have the sysadmin role and you can't set any trace flag you want. RDS makes it easy to spin up a new database, have multi-availability zone replicas, back it up, and do many other things.
it is a real boon to simply have a database-as-a-service that we spin up, connect to, and work with, letting AWS deal with all the management.ĪWS RDS allows us to deploy databases easily and efficiently with great resilience, scalability, and security - but without having to deal with managing a server. We definitely gain value and efficiency from not having to deal with the management of yet another server - and its operating system, patches, uptime, etc. Commenti: We use Amazon RDS to manage our key production/transactional databases for our customer-facing applications as well as our development environment, internal ERP, etc.
0 kommentar(er)
