I use MySQL for the actual data, Redis for sessions, caching, and as an ad hoc store for ephemeral data (read and write access to assets, as an example), and Elastic for search and analytics.
There ends up being some overlap in most cases, especially if something like elastic search is used to look up Postgres records. However, they're not perfectly duplicate rows, usually different pieces of data referring to the same user/post/or other record.
I have more or less the same data in Elastic as what's in MySQL (sans the HTML, stop words and such), and a similar scheme for the caching in Redis, so that's a fair bit of overlap.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
I use MySQL for the actual data, Redis for sessions, caching, and as an ad hoc store for ephemeral data (read and write access to assets, as an example), and Elastic for search and analytics.
Do you duplicate data for different types of database?
There ends up being some overlap in most cases, especially if something like elastic search is used to look up Postgres records. However, they're not perfectly duplicate rows, usually different pieces of data referring to the same user/post/or other record.
I have more or less the same data in Elastic as what's in MySQL (sans the HTML, stop words and such), and a similar scheme for the caching in Redis, so that's a fair bit of overlap.