Jobleads Releases Review (24.40 - 25.1)
Infrastructure Team
XSS prevention
Problem: Cobalt found forms vulnerabilities in admin area.
Solution: Validation and sanitization were applied.
Ontology optimization during indexing
Problem: xMP & xMP ES used all ontologies for indexing job. That was leading to a slowdown and big memory consumption.
Solution: We, together with Actonomy, applied additional parameters to use selective ontologies.
Effect: Faster job indexing.
Information about session refresh
Problem: We had no information when the user refreshed the token and stayed with us longer.
Solution: We introduced an additional log in refresh process.
Effect: BI can evaluate how long user stay with us.
Read-only connection in EMS
Problem: EMS executes a lot of SQL queries against important tables. It caused a general slowdown during the campaign sendout.
Solution: EMS uses the connection to the slave database where possible.
xMP ES rollout
Problem: We want to switch to the xMP ES country by country to be safe.
Solution: Currently 14 countries are fully switched.
xMP ES monitoring
Problem: We need metrics to be sure about xMP ES and Elastic usage.
Solution: Aditional dashboard introduced.
Debezium PoC
Problem: Because of performance and service independence, we will need database separation soon. Databases need to share some data.
Solution: We tested Debezium. It's data distribution tool.
Effect: We were able to replicate data to a dedicated schema using Kubernetes hosting. Soon, we will start the final implementation.
Manticore optimalization
Problem: From time to time Manticore had serious stability problems.
Solution: We evaluated master-master replication and decided to eliminate it because it consumed resources and had stability problems. It was an overengeniered solution for our case.
Effect: Faster response time, less resources and stability.
Other
xMP & xMP ES special characters escaping
Troubleshooting Marigold API communication issues and communication with their support