![]() Going from first to last, users face the most lock-in to the least lock-in with each of these choices. "This is some standard database technology just with some GUI and interface on top of it and some automatic backups and stuff like that," Zaitsev said. Whether the users might want to manage their deploy in a VM or adopt a serverless system managed by a vendor will depend on how much work they want to do, how much control and flexibility they want to have and how much they can tolerate being locked into a particular vendor.Īdded into the mix, the cloud vendors offer proprietary databases for specific workloads, for Amazon offers DynamoDB, a fully managed proprietary value-key database, while Google offers BigQuery, a fully managed, serverless data warehouse. ![]() To navigate these choices, developers and database administrators need to understand the strengths and weaknesses of each approach.Īs the author of the MySQL performance bible and founder and former CEO of opensource database consultancy Percona, Peter Zaitsev has witnessed the rise of the various ways of deploying database in the cloud and cautions about making choices lightly. Similar options are available for other popular database systems, including MySQL, MongoDB and MariaDB. Meanwhile, some vendors have created serverless systems with PostgreSQL-compatible front ends, such as CockroachDB and Yugabyte.Īnd that's just PostgreSQL. For example, as well as hosting standard versions of PostgreSQL as in RDS, the major three cloud providers, including Azure and Google, also provide PostgreSQL-compatiable enhanced database services such Aurora and AlloyDB. In parallel to PostgreSQL's rise in popularity comes a bewildering array of ways to deploy the database system in the cloud or exploit PostgreSQL-compatible database services. I've seen people seduced by the cloud provider, and they fire their DBAs and everybody who knows about databases, but then they figure out when they need schema design, and query optimization – well, Amazon's not going to help them Since then, the relational system authored by Turing Award winner Michael Stonebraker in the 1980s has gone on to become the most popular database among professional developers, used by nearly half of them, according to Stack Overflow's 2023 Developer Survey. ![]() Feature It has been a decade since Amazon RDS launched support for PostgreSQL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |