Jeremy Cole wrote:
Is it possible to run MySQL with InnoDB enabled on a readonly
filesystem. We only intend to run some select query's on this server.
I guess I can ask the obvious question. Why are you trying to use
InnoDB, if your data/filesystem is read only? Why not use MyISAM
instead?
We allready have a large InnoDB database. And every hour we flush all
data from the mysql slave to disk, set a lock on the tables, make a
snapshot (takes about 1 second) of the data and unlock the tables again.
So we have a read-only snapshot on which we can work, and request data
from.
We just want to start a standalone mysql server with the data on the
snapshot to make some mysqldumps for archiving.
Regards,
Ralph
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
