Hey Mike and Kier would love to hear your thoughts on these for ther larger end forums for forum search, high concurrency and scalability wise ? if any plans for off loading stuff to memcached ? if so how extensive ? myisam table locking, innodb alternative ? mysql partitioning ? mysql replication ? mysql forks such as percona, mariadb ? mod_rewrite equiavlent syntax and support for alternative web servers other than apache ? i.e. lighttpd, litespeed web server, nginx oh and I forgot sphinx support ? thanks
Mike mentioned in another thread that Sphinx is planned. Why would it not run on lighty or nginx? I'm sure it will. memcached is an interesting question! I hope it's supported!
It's mostly using InnoDB. It actually uses transactions for a lot of the writes. At the very least, it's helpful when I mess something up in development. There are a few MyISAM/memory tables where it makes sense. No replication support in its current state. There is a caching system in, though it hasn't been exercised much. There are various places that want to take advantage of it, but we need to deal with cache expiration/updating. Don't really need to worry about mod_rewrite too much - it basically just redirects everything and deals with it in code. Or you could not use it. The only difference is "index.php?" (or just "?" if we make a small change). The search is written in a pluggable way, but it only supports MySQL full-text at this point. Sphinx is planned as it's a must have for any reasonable large board.
thanks good to sphinx is planned. hoping it will play nice with litespeed web server and nginx web servers too
Any web server that plays well with PHP and MySQL will do just fine. I've read that APC is recommended btw. So caching is encouraged under the hood.
I wonder if, on Windows, using Wincache for PHP caching and APC as a datastore might speed things up, or slow things down. I'd like to test this.
I'm finding using Windows less of a hassle. For some reason, it's still faster than when I was using Linux, with a different config, in that this one server has Active Directory and Exchange 2010 installed on it, IIS instead of LiteSpeed.
Well, if configured, Wincache could be the op-code, and APC the datastore, however, with Wincache 1.1 released, I only have the need for Wincache, as it too has a datastore, which I'd like to see XenForo making use of.
I see. Well we are using memcached for the datastore anyway due to our multi server setup. And I do hope that this will be supported here as well
Ok, I pledge that if XenForo doesn't come with Wincache support, I will personally write in Wincache support, and yes, I bumped this thread, because there's no point making a new one. The API is extremely similar to APC, such that only a replacement of apc_store with wincache_ucache_set will work.
