• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Supported features, innodb, memcached, alternative web servers ?

p4guru

Well-known member
#1
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
#3
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
#4
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
#6
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?
 
F

Floris

Guest
#9
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
#10
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
#14
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.
 

Shamil

Well-known member
#16
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
#17
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
#18
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
#19
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)