search

vitessio / vitess

Vitess is a database clustering system for horizontal scaling of MySQL.
http://vitess.io
Apache License 2.0
18.4k stars 2.08k forks source link

vtctl ExecuteFetchAsDba should wrap DMLs in a transaction #3025

Open sougou opened 7 years ago

sougou commented 7 years ago

Without that ability, one cannot execute DMLs using that tool.

michael-berlin commented 7 years ago

As a workaround, you can use the vtclient binary: https://github.com/youtube/vitess/tree/master/go/cmd/vtclient

It will take to vtgate instead of vttablet and should be easier to use.

But there might be situations where you want to run a DML on a particular vttablet?