Title: flecky's Replies | WordPress.org --- # flecky [ ](https://wordpress.org/support/users/flecky/) * [Profile](https://wordpress.org/support/users/flecky/) * [Topics Started](https://wordpress.org/support/users/flecky/topics/) * [Replies Created](https://wordpress.org/support/users/flecky/replies/) * [Reviews Written](https://wordpress.org/support/users/flecky/reviews/) * [Topics Replied To](https://wordpress.org/support/users/flecky/replied-to/) * [Engagements](https://wordpress.org/support/users/flecky/engagements/) * [Favorites](https://wordpress.org/support/users/flecky/favorites/) Search replies: ## Forum Replies Created Viewing 7 replies - 1 through 7 (of 7 total) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[All in One SEO – AI SEO Plugin to Boost SEO Rankings & Traffic (Schema, Local SEO, Sitemap & SEO Insights)] wp_aioseo_cache – Errors – db](https://wordpress.org/support/topic/wp_aioseo_cache-errors-db/) * Thread Starter [flecky](https://wordpress.org/support/users/flecky/) * (@flecky) * [9 months ago](https://wordpress.org/support/topic/wp_aioseo_cache-errors-db/#post-18785501) * 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. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Redis Object Cache] recommended settings](https://wordpress.org/support/topic/recommended-settings-9/) * Thread Starter [flecky](https://wordpress.org/support/users/flecky/) * (@flecky) * [3 years, 8 months ago](https://wordpress.org/support/topic/recommended-settings-9/#post-16395029) * thank you * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Redis Object Cache] recommended settings](https://wordpress.org/support/topic/recommended-settings-9/) * Thread Starter [flecky](https://wordpress.org/support/users/flecky/) * (@flecky) * [3 years, 8 months ago](https://wordpress.org/support/topic/recommended-settings-9/#post-16393438) * 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. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Redis Object Cache] recommended settings](https://wordpress.org/support/topic/recommended-settings-9/) * Thread Starter [flecky](https://wordpress.org/support/users/flecky/) * (@flecky) * [3 years, 8 months ago](https://wordpress.org/support/topic/recommended-settings-9/#post-16383860) * hello till, yes everything is exactly same. i just use nginx proxy to redirect the user to a different backend server. mysql is galera. so it will be 100% same as well. * i was thining about haproxy on each node and then redis master – slave. so writes go to the current master and reads on the local machine. * not sure if cluster / sharding is overkill. what do you suggest? - This reply was modified 3 years, 8 months ago by [flecky](https://wordpress.org/support/users/flecky/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Complianz GDPR/CCPA Cookie Consent Banner] Undefined array key “enable_dependency”](https://wordpress.org/support/topic/undefined-array-key-enable_dependency/) * Thread Starter [flecky](https://wordpress.org/support/users/flecky/) * (@flecky) * [4 years, 8 months ago](https://wordpress.org/support/topic/undefined-array-key-enable_dependency/#post-15296987) * 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 * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Complianz GDPR/CCPA Cookie Consent Banner] Undefined array key “enable_dependency”](https://wordpress.org/support/topic/undefined-array-key-enable_dependency/) * Thread Starter [flecky](https://wordpress.org/support/users/flecky/) * (@flecky) * [4 years, 8 months ago](https://wordpress.org/support/topic/undefined-array-key-enable_dependency/#post-15296968) * hey rogier, seems like the mistake was on my side. i had a whitespace in integrations field. (third party scripts). after i´ve removed it, the error was gone. haha * sorry to bother you. * thx for patching something related. :=) * Forum: [Reviews](https://wordpress.org/support/forum/reviews/) In reply to: [[.html for all url] Thank you!!!](https://wordpress.org/support/topic/thank-you-1464/) * Thread Starter [flecky](https://wordpress.org/support/users/flecky/) * (@flecky) * [8 years, 11 months ago](https://wordpress.org/support/topic/thank-you-1464/#post-9644437) * 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! Viewing 7 replies - 1 through 7 (of 7 total)