From: Dan Nelson
Date: May 4 2004 3:54pm
Subject: Re: [mysql] replication of database structure changes
List-Archive: http://lists.mysql.com/mysql/164820
Message-Id: <20040504155448.GC2705@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (May 04), Jim said:
> Do changes in database structure replicate to the slaves from the
> master?  Is there a document somewhere in the manual (I have not
> found one) that explains what gets replicated and what does not? 
> Specifically, does an ALTER TABLE get replicated?  There is some
> mention that replication is for data and not for structure, but a
> formal explanation of what exactly that means is hard to find.

All commands that modify data, including CREATE|DROP TABLE|DATABASE,
replicated.

-- 
	Dan Nelson
	dnelson@stripped