Ask HN: What are good learning resources on concurrency patterns with databases?

I'm interested in learning more about coordination techniques in distributed systems using database technologies, in particular using MySQL (InnoDB). For example, it's not hard to find projects out there leveraging technologies such etcd, dynamodb or redis to build all sort of things: queues, locks... When you need to stick with MySQL or similar relational databases, what are good resources out there? Books, courses, docs, etc?

I want to build a service that could have many instances running. Each instance would promote itself to lead a particular task that needs to be performed. I think that's doable using InnoDB's transaction model but do you know of good examples out there that I could use as a reference?