[mysql] replication of database structure changes

2004-05-04 Thread Jim 
Hi List,

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.

Thanks again.

Jim N.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [mysql] replication of database structure changes

2004-05-04 Thread Dan Nelson 
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
[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]