Hi Sergei!
Based on what you said, I think these "internal means" to ensure the
synchronization are 'exactly' what I need :)
Do you suggest me anything to learn about it?
As Sanja has adviced me, many of the concepts and routines from my project
could be reused from NDB...
About DDE, I have a first spec in a doc. But I'm afraid to post it on the
list because of its size (aprox. 400KB).
May I send it directly to you?
Regards
Fabricio
-----Mensagem original-----
De: Sergei Golubchik [mailto:serg@stripped]
Enviada em: segunda-feira, 14 de novembro de 2005 14:47
Para: Fabricio Mota
Cc: internals@stripped
Assunto: Re: Structural Transactions
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
