Re: [plug] corrupted MySQL files

2007-02-10 Thread Roberto Verzola
On Sunday 11 February 2007 1:11 pm, Orlando Andico wrote: > The more sinister part of this is, the repair method sometimes loses rows. > :P But then you'll never know. But it happened to me before, with rather > ill results. Yes, I can imagine that can happen, if power is lost while files are ope

Re: [plug] corrupted MySQL files

2007-02-10 Thread Roberto Verzola
Ok, I get it. Yes, we had discussed an off-site "failover" system... It is now part of the design. Obet On Sunday 11 February 2007 10:39 am, Ariz Jacinto wrote: > i mean the report generation process and the scripts that you're going to > use to process those data should also be replicated on a

Re: [plug] corrupted MySQL files

2007-02-10 Thread Orlando Andico
The more sinister part of this is, the repair method sometimes loses rows. :P But then you'll never know. But it happened to me before, with rather ill results. On 2/10/07, Roberto Verzola <[EMAIL PROTECTED]> wrote: On Saturday 10 February 2007 7:23 pm, Orlando Andico wrote: > welcome to the c

Re: [plug] [OT] NetBSD 3.1 LiveCD r o c k s !

2007-02-10 Thread Norbert P. Copones
On Sun, February 11, 2007 3:06 am, Ariz Jacinto wrote: > sorry and no offense to our fellow BSD users (i'am forced to say this) > but based on your earlier post, it's quite obvious that you're still new > to the concept of Fake RAID drivers and the difference on the way it > is encapsulated into th

Re: [plug] VA flight system powered by TinyX / Linux

2007-02-10 Thread Cocoy Dayao
yup. cool nga daw yan, according to adam curry. he mentioned it when he was on twit a few weeks back. On 02 11, 07, at 10:44 AM, Ariz Jacinto wrote: http://www.engadget.com/2007/02/10/mega-hands-on-virgin-americas- airbus-a320-with-red-in-flight-e/ Specs: Linux-based with Tiny X VA develope

[plug] VA flight system powered by TinyX / Linux

2007-02-10 Thread Ariz Jacinto
http://www.engadget.com/2007/02/10/mega-hands-on-virgin-americas-airbus-a320-with-red-in-flight-e/ Specs: Linux-based with Tiny X VA developed Red in-flight interface 9-inch 1024 x 600 resolution integrated touchscreen Dual internal flash drives for redundant storage of embedded OS USB port that

Re: [plug] corrupted MySQL files

2007-02-10 Thread Ariz Jacinto
i mean the report generation process and the scripts that you're going to use to process those data should also be replicated on a remote office as a precautionary measure. "kumbaga", you have to make sure that your operations should be able to withstand the unimaginable, imho. :) On 2/10/07,

Re: [plug] corrupted MySQL files

2007-02-10 Thread Roberto Verzola
On Sunday 11 February 2007 2:23 am, Ariz Jacinto wrote: > you should enable the auto-repair feature on the mysql configuration > so that those damaged files will be repaired automatically. Thanks for the tips, Ariz. Currently, the MySQL setup uses the defaults. I would appreciate what other chang

Re: [plug] [OT] NetBSD 3.1 LiveCD r o c k s !

2007-02-10 Thread Ariz Jacinto
sorry and no offense to our fellow BSD users (i'am forced to say this) but based on your earlier post, it's quite obvious that you're still new to the concept of Fake RAID drivers and the difference on the way it is encapsulated into the BSD and Linux kernels. that's why i kept on asking you for t

Re: [plug] corrupted MySQL files

2007-02-10 Thread Ariz Jacinto
you should enable the auto-repair feature on the mysql configuration so that those damaged files will be repaired automatically. replicating the report is one thing while replicating the report generation process is another. TWG should also be conducting failover simulations by now since your loc

Re: [plug] corrupted MySQL files

2007-02-10 Thread Roberto Verzola
On Saturday 10 February 2007 7:23 pm, Orlando Andico wrote: > welcome to the craptacular world of MySQL :P > try an isamchk or myisamchk that usually can recover something from > the crap that MySQL leaves behind... Yes, I did use mysqlcheck -r and the files were craptacularly repaired... We're b

Re: [plug] corrupted MySQL files

2007-02-10 Thread Roberto Verzola
On Saturday 10 February 2007 11:05 pm, Roger Filomeno wrote: > Use DB replications then make a port forwading script to switch from > primary to slaves. I'd like to learn how to do this one... Maybe one of you MySQL hotshots can come to the next HALAL TWG meeting, next Saturday, 2pm, at the usual

Re: [plug] need advice

2007-02-10 Thread Roger Filomeno
In Vitro PLDT you can ask to let your admins stay there on site during the critical period, it think this is also possible with other data centers. Goodluck :) On 2/9/07, Roberto Verzola <[EMAIL PROTECTED]> wrote: On Friday 09 February 2007 7:52 am, Roger Filomeno wrote: > Have your server co-l

Re: [plug] corrupted MySQL files

2007-02-10 Thread Roger Filomeno
Use DB replications then make a port forwading script to switch from primary to slaves. On 2/10/07, Orlando Andico <[EMAIL PROTECTED]> wrote: welcome to the craptacular world of MySQL :P yes, power interruptions can do that. try an isamchk or myisamchk that usually can recover something from

Re: [plug] OT: how much salary intended for a Systems Linux Administrator

2007-02-10 Thread Roger Filomeno
Ofcourse they have to know also, not that you have to hide that fact. Youre right, its very hard to do and for sanity's sake it does eat up a lot of your social time so I wont probably do this anymore when i hit age 30's :) If youre young and talented i recommend giving it a try but watch your hea

Re: [plug] [OT] NetBSD 3.1 LiveCD r o c k s !

2007-02-10 Thread ralph bacolod
On Sat, Feb 10, 2007 at 11:32:56AM +0800, Dean Michael Berris wrote: > >On Wed, February 7, 2007 9:16 pm, Dean Michael Berris wrote: > If you actually care to check, Linux kernel development has been > better than ever. 2.6.20 is coming out soon, and packs more than any > other OS kernel can even

Re: [plug] OT: how much salary intended for a Systems Linux Administrator

2007-02-10 Thread Orlando Andico
holding down that many positions is quite hard. either those companies don't have high expectations, or they're not getting the services rendered that they're paying for. i've been in the situation where people were willing to pay me X amount, knowing full well that i had a full-time job and that

Re: [plug] [OT] NetBSD 3.1 LiveCD r o c k s !

2007-02-10 Thread JM Ibanez
"Norbert P. Copones" <[EMAIL PROTECTED]> writes: > On Sat, February 10, 2007 11:32 am, Dean Michael Berris wrote: >> If you want to argue, show me code and let's see which technical >> solution is better than the other. Then tell me again why BSD is >> better than Linux. > > what code? openbsd's c

Re: [plug] corrupted MySQL files

2007-02-10 Thread Orlando Andico
welcome to the craptacular world of MySQL :P yes, power interruptions can do that. try an isamchk or myisamchk that usually can recover something from the crap that MySQL leaves behind... On 2/10/07, Roberto Verzola <[EMAIL PROTECTED]> wrote: error: Can't open file: 'phones.MYI' (errno:

Re: [plug] [OT] NetBSD 3.1 LiveCD r o c k s !

2007-02-10 Thread Norbert P. Copones
On Sat, February 10, 2007 11:32 am, Dean Michael Berris wrote: > Wait, so you're saying even the developers consider FreeBSD 5 unstable > -- but why was it released and given a "stable version release" number > if that was the case? freebsd provides 3 trees for users to choose from. 1st is CURREN