Issue link: https://resources.awscloud.com/i/1496544
database engines often come with some upper limits on their size and the input/output operations per second (IOPS) they can support. Many organizations can fit within these limits. But if your database is truly enormous, and you have greater IOPS needs than what the provider can support, you might find your chosen managed database services to be infeasible. You should run a cloud native database or run your own instances in the cloud by renting the VMs and storage that you need. You need full control over your databases If it's important for you to have maximum control over your databases, you must manage your own databases in the cloud. If you need a specific database version that's not supported by the cloud vendor, or you need to use database features or options that aren't supported by the provider, you're back on your own. Role of the DBA in a Managed Database As mentioned at the start of this report, moving to the cloud will change your job, sometimes in subtle ways. Chapter 2 covers this in detail, but we'll just say here that after you relinquish hardware maintenance, system configuration, and other things a managed database takes care of, there is plenty of work left for you. Here are some tasks that the DBA often performs on a managed database: • Determining requirements, such as CPU power and memory. • Configuring database runs, including the automation of scaling, failure recovery, and taking snapshots of the database. • Choosing which regions and AZs to host the database instances. • Creating and manipulating databases and tables through the command line, console, or API offered by the vendor. • Authorizing user accounts, setting up groups, and controlling access to databases and parts of the databases. Some databases offer this access through identity and access management (IAM) and others use the traditional interfaces offered by the database in on-premises deployments. • Determining how to divide data into shards when you need to distribute it across multiple systems. • Setting database parameters that affect performance or resil‐ iency. Role of the DBA in a Managed Database | 9