Re: Embedded MySQL: Opinion Please
http://www.qnx.com/ Tey actually have a headline right now about BerkleyDB being ported. While I take nothing away from the Mysql/Linux combo as a stable OS. I would stay that a specifically designed RTOS for embeded devices might be better in this situation. Gregg - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 15, 2001 1:00 PM Subject: Embedded MySQL: Opinion Please Hi! I've been monitoring this list for a while now (re: lurking), I've seen only passing comments about embedding MySQL, so I thought I would come out and directly ask the MySQL community for your opinions, or better yet, actual facts - based on experience. I am evaluating MySQL / Linux for use in a line of deeply embedded, multi-node, real-time SCADA products. Where: deeply embedded = headless platform, no user interaction (not even via telnet), no administration interaction, required to operate for years without restart. multi-node = 1 to N processor boards, sharing a common bus (VME, CPCI), not SMP. And, * Database size: between 10K - 250K records - where once the records have been created, they are only updated, typically between several 100 to several 1,000 UPDATES / second. * No moving parts (no fan, no hard disk, no CD, no floppy, no noth'n). * Memory size is not an issue (can add more as required); CPU power is not an issue (re: Moore's Law) (The actual requirements are not as extreme as depicted here, but I want to push the envelope.) I am convinced that MySQL / Linux will work in such as environment. But, the real question(s) is: Can they (MySQL / Linux) work in such an environment, continuously, without error or failure, or requiring operator intervention, for years on end? For this environment, is the MySQL / Linux combo a good idea? Or, should I stick with Linux, but seek out an alternate DBMS? Or, should I drop Linux and go with Windows CE, or some other RTOS? Or, should I stop being a software developing and become a sheepherder? David Vance Senior Software Developer GE Harris Energy Control Systems Canada, Inc. 2728 Hopewell Place NE Calgary, Alberta,Canada T1Y 7J7 +1 (403) 214-4543 +1 (403) 287-7946 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Embedded MySQL: Opinion Please
Hi. On Thu, Feb 15, 2001 at 02:00:04PM -0500, [EMAIL PROTECTED] wrote: [...] Can they (MySQL / Linux) work in such an environment, continuously, without error or failure, or requiring operator intervention, for years on end? Well, I see no principle problem here. The servers I administer run about 200-400 days without interruption (then the counters get interrupted by hardware/software upgrades ;-) Exceptions are massive internet accesses (so called slashdot effect), but with enough memory and some reasonable limits set, one gets even this stuff stable (not responsive, but stable). What you have to have a look at is anything which is incremental, mainly log files and such stuff. Either disable or rotate those. What I would do is make a test install, then leave it alone for some time and then compare all file sizes and assure that the growing files will be no problem or handle them with cronjobs. For case of emergency (i.e. if some program crashes anyhow), there are several solutions for watchers available, which can restart them (although, as I said, I did not need that stuff until now on x86 boxes). For this environment, is the MySQL / Linux combo a good idea? The question is whether the support for your hardware is stable. If so, I would dare to say that I get the software part stable, too. Or, should I stick with Linux, but seek out an alternate DBMS? MySQL is rock solid if you avoid newly added features and have tested your queries once to be supported. I won't say anything about other DBMSes, because I use none intensively enough to justify a opinion on it. Or, should I drop Linux and go with Windows CE, or some other RTOS? Well, I am biased there, but I would really avoid Windows. ;-) Other RTOS are probably a good idea, as someone else already said. Or, should I stop being a software developing and become a sheepherder? No comment. ;-) Bye, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Embedded MySQL: Opinion Please
Benjamin Pflugmann wrote: Or, should I drop Linux and go with Windows CE, or some other RTOS? Well, I am biased there, but I would really avoid Windows. ;-) Other RTOS are probably a good idea, as someone else already said. Or, should I stop being a software developing and become a sheepherder? A RTOS? I would go for QNX, better yet: Neutrino (this is a really weird RTOS) No comment. ;-) Bye, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
