IPB 4 support postgreSQL ?

[HDTV]

IPB 4 support postgreSQL ?

[Matt]

No. We're only supporting MySQL for IPS 4.

[Crothers]

Matt,

Does IPS4 support query type routing? IE: MySQL master server(s) for writes and MySQL slave(s) for reads?

This feature is highly important, as of now, a high concurrency site/forum/database is best managed with inteligent partitioning or replication to manage disk load and concurrent connections.

Should we expect this feature?

[bfarber]

The way the database driver is architected would make this far easier to implement in 4. We have actually done this sort of separation in 3.x in the past, but found it a little finnicky. For instance, say your update gets pushed to the master but doesn't replicate to a slave for 1 second, but your selects are hitting that slave. During the process of posting a new topic for instance, select queries are being run to help rebuild cached statistics, and this sort of data gets out of sync when there are delays. Little things like this would need to be accounted for.

Anyways, I tend to doubt we will offer out of the box MySQL read/write separation, however I can't say for sure just yet - and I can say that if we don't, it would be possible to do it yourself by overriding our database driver class.

[Crothers]

As good an answer as any I suppose. I look forward to extending these classes in 4 :)

The way the database driver is architected would make this far easier to implement in 4. We have actually done this sort of separation in 3.x in the past, but found it a little finnicky. For instance, say your update gets pushed to the master but doesn't replicate to a slave for 1 second, but your selects are hitting that slave. During the process of posting a new topic for instance, select queries are being run to help rebuild cached statistics, and this sort of data gets out of sync when there are delays. Little things like this would need to be accounted for.

Anyways, I tend to doubt we will offer out of the box MySQL read/write separation, however I can't say for sure just yet - and I can say that if we don't, it would be possible to do it yourself by overriding our database driver class.