Drop the dependency on DBD:MySQL
To simplify the installation requirements of mylvmbackup, the dependency on DBD::MySQL should be removed. It's only required to issue the following commands "FLUSH TABLES WITH READ LOCK", "UNLOCK TABLES" and "SHOW MASTER/SLAVE STATUS". These could potentially also be issued by calling the regular "mysql" command line client and reading the output from there.
Blueprint information
- Status:
- Complete
- Approver:
- None
- Priority:
- Undefined
- Drafter:
- None
- Direction:
- Needs approval
- Assignee:
- None
- Definition:
- Obsolete
- Series goal:
- None
- Implementation:
-
Not started
- Milestone target:
- None
- Started by
- Completed by
- Lenz Grimmer
Related branches
Related bugs
Sprints
Whiteboard
Whomever posted this clearly doesn't understand how backups and locking work in MySQL. You cannot use the `mysql` command line to accomplish this task. Once the connection to mysql has terminated, all locks are released. So, once you issue the command `mysql -uroot -pmypass -e "FLUSH TABLES WITH READ LOCK"` the tables, are flushed and locked but immediately released because the command completed and returned you to shell.