Re: Structural Transactions

[Sergei Golubchik]

Hi!

On Nov 10, Fabricio Mota wrote:
> Hi all,
> 
> In my project - as it talks about Distributed Systems and Reliability
> - one of its requirements is a feature to ensure consensus in
> strutuctural modifications (ex.: alter table, create table, etc)
> between machines.
> 
> So, I need a way to perform structure alterations with possibility to
> undo (such as rollback) and to confirm them (such as commit). So I
> ask: is there anything already implemented in MySQL Server (such as
> MySQL Cluster code)?  Because I don't wanna reinvent the wheel... :)

No, unfortunately not. MySQL automatically wraps every DDL in a
transaction, doing commit before and after create/alter table.

NDB Cluster uses internal means to ensure that table structure is in
sync on the nodes.

(if you'd tell more about DDE I'd be able to give a better answer,
perhaps)
 
Regards,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <serg@stripped>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Senior Software Developer
/_/  /_/\_, /___/\___\_\___/  Kerpen, Germany
       <___/  www.mysql.com