On Tue, Jul 6, 2010 at 7:10 PM, mos <mos99@stripped> wrote:
> Why are you installing a client server database on an embedded
> system? There are better databases for this task. In the past I've been able
> to squeeze a Windows application and an SQL database so it could run
> directly off of a floppy disk (remember those?). But it wasn't client
> server. :) It seems to me you are trying to fit an elephant into a phone
> booth. Just don't expect it to sit up and dance.
> BTW, where are the MySQL temp files going to go? Like the ones used for
> sorting the table? Also are you going to have crash recovery in case the
> machine gets accidentally powered off and damages the database?
As I previously said, deciding which RBMS to use is not up to me. Actually I
myself suggested SQLite, but the system has already been designed and it's
not possible to change the plans.
Our case doesn't fit into your analogy (elephant and phone booth). The
system has a powerful processor, 2GB of RAM and broadcasts video over the
network. But the operating system resides on a flash memory. The client
program, used to receive the stream, connects to the MySQL server to do some
ACL and authentication stuff. There are some stored procedure in the DB
which does the job.
The purpose of using a flash memory and a read-only ramfs was to conqueror
the "accidentally powering off" part! It will update the flash memory when
we command it to do so.
Hope the scenario is clear now!
Did you really need this explanation to answer my question?
-- Nima Mohammadi