HDTV Posted May 9, 2014 Share Posted May 9, 2014 IPB 4 support postgreSQL ? Link to comment Share on other sites More sharing options...
Management Matt Posted May 9, 2014 Management Share Posted May 9, 2014 No. We're only supporting MySQL for IPS 4. Link to comment Share on other sites More sharing options...
Crothers Posted May 9, 2014 Share Posted May 9, 2014 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? Link to comment Share on other sites More sharing options...
bfarber Posted May 12, 2014 Share Posted May 12, 2014 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. Link to comment Share on other sites More sharing options...
Crothers Posted May 15, 2014 Share Posted May 15, 2014 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.