The following was taken from Linux Magazine from an article written by Jeremy Zawodny. It talks about a litlte known feature of the MyISAM tables in MySQL which allows you to create raid tables. The snippet of the article is publised below.
RAID Tables The final variety of MyISAM tables isn’t widely known, but can be useful in some circumstances. RAID tables are simply MyISAM tables whose data (.MYD) files have been broken into multiple files. CREATE TABLE mytable … TYPE=MyISAM RAID_TYPE=STRIPED RAID_CHUNKS=4 RAID_CHUNKSIZE=8 Running that SQL command breaks the MyISAM table into 4 separate files (chunks) that are written to in a round-robin fashion in 8 KB stripes. Why do that? If you’re using a filesystem that places a limit on how large a file can be (2 GB or 4 GB), RAID tables work around that limitation. (However, file size limits are becoming more and more rare, as recent Linux kernels don’t have size limits anywhere near that low.) Performance is another reason for RAID tables. By putting each chunk on a separate physical disk, you can spread the I/O work out more evenly. In most MySQL installations, the main bottleneck is disk I/O, so this isn’t very far fetched. However, if you have the option of using hardware RAID or even software RAID at the OS level, you’re probably better off doing so.
Reference: LAMP Post, by Jeremy Zawodny
Posted by Keith Elder | Posted in Open Source, PHP, Programming | Posted on 07-06-2003
1
The LogiCreate Applicaton Server built with PHP was released as open source on June 5th, 2003. LogiCreate is a framework to build portals, CMS, CRM or custom web applications. It is extremely fast to start developing applications with, very little code for the developer to start writing and is extremely different from pretty much anything else out there right now. You can download the PDF presentation on the LogiCreate site as well as register on the site to download the system. We’ve been using it for several years now and will start offering hosting accounts pre-packaged with it soon.
Posted by Keith Elder | Posted in Man Toys, Programming | Posted on 24-10-2002
0
I picked up a new toy this weekend called the “HipTop” produced by Danger, Inc.. It is the coolest device I have ever owned in terms of a PDA, phone combo. The HipTop is an always on device, the first one of its kind. The bottom line is that I can surf a web page, check email and get instant messages through AIM anytime I want when I am away from the computer.
Posted by Keith Elder | Posted in PHP, Programming | Posted on 23-05-2002
0
I received a phone call from Community Connect, the creators of Black Planet and other online commmunity sites (very big sites with lots of users) yesterday asking me if I knew any PHP developers looking for a job. That is an understatement right? I cannot even go to the grocery store without someone asking me if I will get them a job or know of anyone hiring for PHP. Anyway, before I get into a “why you shouldn’t pickup a PHP book and read two online tutorials and go around thinking you are a PHP developer” session, check out these 2 jobs which are available in the New York Manhattan area. If you are out of work and want to relocate this is a GREAT opportunity.
These are a little late for April fools day, but none-the-less these are funny. We made these up whilst sitting around the office back in the summer. I thought I would put them out now, we’ve had them long enough. Hope you have a good laugh.
