On Dec 18, 2008, at 12:36 PM, Francesco wrote:
What happen if master and slave have different default engines ?
IMHO it should be an error
It should not be an error.
That's a very common configuration.
For example, having a blackhole engine on the master, and regular
storage storage engines on the slaves is a common configuration, to
keep IO load lower on the master, and to avoid the temptation to read
from the master.
Other common configurations is to have a slave keep a table in the
archive engine, to do constant backup, while the other slaves keep
that table in inno or myisam
--
Mark Atwood <http://mark.atwood.name>
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
