Re: Using MySQL with its data files on a CD-R (recordable CD)
On Wed, 05 Mar 2008 00:13:56 -0500, Michael Hemer wrote: I have been researching to see if it's possible to have a MySQL database with it's data files on a cd-rom, but could use some help to determine if I have found out the full truth of what's possible. I would appreciate any additional info people have to offer. Would this be like an ldap server? -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Using MySQL with its data files on a CD-R (recordable CD)
I believe that this situation could work with ldap, but it is not what I had imagined. I was picturing a database for retail. The database could hold a list of products for sale and details relating to those products. -Michael Thufir [EMAIL PROTECTED] wrote On Wed, 05 Mar 2008 00:13:56 -0500, Michael Hemer wrote: I have been researching to see if it's possible to have a MySQL database with it's data files on a cd-rom, but could use some help to determine if I have found out the full truth of what's possible. I would appreciate any additional info people have to offer. Would this be like an ldap server? -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Using MySQL with its data files on a CD-R (recordable CD)
On Wed, Mar 5, 2008 at 12:13 AM, Michael Hemer [EMAIL PROTECTED] wrote:
Hi,
I have been researching to see if it's possible to have a MySQL database
with it's data files on a cd-rom, but could use some help to determine if I
have found out the full truth of what's possible. I would appreciate any
additional info people have to offer.
The simple answer is yes. Data is data, regardless of how and
where it's stored.
However, a more truthful answer uncovers some complexities,
including the speed at which the data can be transferred from the CD
(which will be slower than direct access from a hard drive), as well
as the version limitations. If the MySQL databases on the CD are, for
example, in MySQL 5.x format, but your end-user is still using MySQL
3.23, it's not going to work. Also, there will need to be some
configuration variables modified on each end-user system so that the
MySQL server knows where to locate the CD databases (and then the
server will need to be restarted, as well).
So to summarize, it can be done, but don't expect it to be a
point-click-send operation; there are going to be some bumps in the
road.
--
/Dan
Daniel P. Brown
Senior Unix Geek
? while(1) { $me = $mind--; sleep(86400); } ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Using MySQL with its data files on a CD-R (recordable CD)
Daniel Brown [EMAIL PROTECTED] wrote
On Wed, Mar 5, 2008 at 12:13 AM, Michael Hemer [EMAIL PROTECTED] wrote:
Hi,
I have been researching to see if it's possible to have a MySQL database
with it's data files on a cd-rom, but could use some help to determine if
I have found out the full truth of what's possible. I would appreciate
any additional info people have to offer.
The simple answer is yes. Data is data, regardless of how and
where it's stored.
Even though I tend to agree that data is data, the how and where does seem
to be important. So far my testing indicates that the approach used by the
storage engine does make a difference. So far it appears that InnoDB, CSV,
and Archive require write access to either the data files, or the directory
in which the data files reside. It's possible that I've overlooked
configuration options that would make it work, but I have tried many
different configurations with no success. So far, MyISAM is the only one
that I've had success with reading the data from a CD.
However, a more truthful answer uncovers some complexities,
including the speed at which the data can be transferred from the CD
(which will be slower than direct access from a hard drive), as well
as the version limitations. If the MySQL databases on the CD are, for
example, in MySQL 5.x format, but your end-user is still using MySQL
3.23, it's not going to work. Also, there will need to be some
configuration variables modified on each end-user system so that the
MySQL server knows where to locate the CD databases (and then the
server will need to be restarted, as well).
I definitely agree that data on CD will be slower to read than on a hard
drive. I also agree that details like the version used will need to be kept
the same from computer to computer. For my scenario though, I am more
concerned with being able to leave the data on the CD and not needing to
copy it to the local hard drive, than I am about performance and
standardization issues.
So to summarize, it can be done, but don't expect it to be a
point-click-send operation; there are going to be some bumps in the
road.
I have found that it can be done using MyISAM, but so far it appears to me
that it is not possible with InnoDB, CSV, or Archive. I will continue to
experiment with any configuration options that I can find that I haven't
already tried, but so far it's not looking feasible for every storage
engine. If you think of any configuration options that you know will make
this work with InnoDB, CSV, or Archive, please let me know.
Thanks,
Michael
--
/Dan
Daniel P. Brown
Senior Unix Geek
? while(1) { $me = $mind--; sleep(86400); } ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Using MySQL with its data files on a CD-R (recordable CD)
Hi, I have been researching to see if it's possible to have a MySQL database with it's data files on a cd-rom, but could use some help to determine if I have found out the full truth of what's possible. I would appreciate any additional info people have to offer. The situation I've been thinking about involves a MySQL database that is created and populated with data while the data files are in a directory on a regular hard drive. The database server is then shutdown, the data files are burned to a CD-R, and then the CD-R is distributed to another person. The person receiving the CD-R would have their installation of MySQL configured to access the data directly from the CD-R. The person receiving the CD-R would only have read access to the data, of course, unless they copy the data to their own hard drive, but since read access is what is wanted, this would not be a problem. An important factor is that the data is stored on a CD-R and the person receiving the data can use it directly from the CD-R without needing to copy it anywhere else. I have found that using MyISAM as the storage engine appears to work, but was wondering if other storage engines could be used as well. It appears from my attempts that InnoDB, Archive, and CSV cannot be used for the storage engines in this manner, but I thought that I may have overlooked something. Once again, any additional info people have to offer would definitely be appreciated. Thanks.
