flecky

if someone else is looking up for this..

this code fixed the entire bug in mysql. but its just a workaround.

[mysqld]
sql_mode = NO_ENGINE_SUBSTITUTION,ERROR_FOR_DIVISION_BY_ZERO

then restart mysql.

hello till,

i´m trying to route reads and writes. i´ve tried different settings.

define( ‘WP_REDIS_SERVERS’, [

    ‘tcp://10.0.55.1:6379?database=3&alias=server1’,    ‘tcp://10.0.55.2:6379?database=3&alias=server2’,
  ‘tcp://10.0.55.3:6379?database=3&alias=server3’,
] );

define( ‘WP_REDIS_CLIENT’, ‘phpredis’ );
define( ‘WP_REDIS_DATABASE’, 3 );

i also tried different settings with WP_REDIS_HOST, WP_REDIS_PORT, WP_REDIS_CLIENT (phpredis,predis etc) and also different ports for WP_REDIS_SERVERS with haproxy. i have haproxy writes on 6380 and reads on 6381. normal redis on 6379. but slave nodes arent forwarding. probably i´ve overseen some settings i guess. or is that only in premium version?

is it somehow possible to route writes to the master and and reads to the slave locally?

working szenarioo is when i used haproxy and route everything to the master node. whith haproxy i ideally need 2 ports. one read one write. is that somehow possible to set up with your plugin? i also have sentinel running if the master swiches.

define( ‘WP_REDIS_SENTINEL’, ‘redis-primary’ ); wasnt´t helping too.

thanks for your support.

maybe you can check those input-fields. i had like “unwanted whitespace”www.google.com … in that particular field.

anyway. nice plugin. i enjoy it

Would be great if u can add .html for buddypress and those userlinks etc.
and my custom forum links get overriden.

maybe its possible to fix this in further updates.
but anyway.. still nice work!