MediaWiki is the wiki used by Wikipedia. It's powerful, scalable software that's designed to be run on a large server farm for a web site that gets millions of hits per day.
Pages use MediaWiki's wikitext format, so users without knowledge of XHTML or CSS can edit them easily.
When a user submits an edit to a page, MediaWiki writes it to a database, but without deleting the previous versions of the page, thus allowing easy reverts in case of vandalism or spamming. MediaWiki can manage image and multimedia files, too, which are stored in the filesystem. For large wikis with lots of users, MediaWiki supports caching and can be easily coupled with Squid proxy server software.