Supported features, innodb, memcached, alternative web servers ?

p4guru

Well-known member
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
 

mlx

Well-known member
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!
 

Mike

XenForo developer
Staff member
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.
 

Kuma

Active member
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.
Will InnoDB be a requirement?
 

p4guru

Well-known member
thanks good to sphinx is planned.

hoping it will play nice with litespeed web server and nginx web servers too :)
 
F

Floris

Guest
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.
 

Shamil

Well-known member
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.
 

Shamil

Well-known member
silly people ;)
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.
 

mlx

Well-known member
Wincache AND APC?

Both are opcode cachers, aren't they? Why would you want to run both of them?
 

Shamil

Well-known member
Wincache AND APC?

Both are opcode cachers, aren't they? Why would you want to run both of them?
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.
 

mlx

Well-known member
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 ;)
 

Shamil

Well-known member
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.
 

Luke F

Well-known member
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.
When I was using Windows, APC was at least as fast.

(As Wincache)
 
Top