patternMinor
Cloud DB operator responsibilities / common tasks
Viewed 0 times
responsibilitiesoperatorcloudtaskscommon
Problem
When I feed a search engine with "DBA tasks responsibilities" lots of hits like "What does a DBA do all day?" and even official Oracle manual entries.
With modern automation a lot of those tasks don't exist anymore and as a DBaaS provider we sometimes even don't know our customers and his projects.
So what's the tasks of a Cloud DB operator?
With modern automation a lot of those tasks don't exist anymore and as a DBaaS provider we sometimes even don't know our customers and his projects.
So what's the tasks of a Cloud DB operator?
Solution
I always saw a DBA as someone who fits in between developers and operations when it comes to database management.
On the one hand, they often take care of backups, clustering, replication, actual binary installation, file system management, etc.
On the other, they also take care of relational DB schema, do performance or query optimization, and advise developers on the best way to lay out their application storage and configuration schemas.
In theory, the first job can be done by a system administrator. The second job can be done by a senior developer or architect.
In practice, it often makes sense to have someone who's well versed in all parts of running a database.
Provisioning the instance is only a small part of what they do. Having your instance hosted in the cloud doesn't remove the need to have someone manage your schema or optimize performance. A cloud RDS with default settings likely won't be aware that key_buffer_size value needs to be set to 16M or some of your application's features won't run.
On the one hand, they often take care of backups, clustering, replication, actual binary installation, file system management, etc.
On the other, they also take care of relational DB schema, do performance or query optimization, and advise developers on the best way to lay out their application storage and configuration schemas.
In theory, the first job can be done by a system administrator. The second job can be done by a senior developer or architect.
In practice, it often makes sense to have someone who's well versed in all parts of running a database.
Provisioning the instance is only a small part of what they do. Having your instance hosted in the cloud doesn't remove the need to have someone manage your schema or optimize performance. A cloud RDS with default settings likely won't be aware that key_buffer_size value needs to be set to 16M or some of your application's features won't run.
Context
StackExchange DevOps Q#1504, answer score: 6
Revisions (0)
No revisions yet.