-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Ralph,
On 6/2/19 16:32, Ralph Soika wrote: > The whole system is highly transactional as it runs on Java EE with > JPA and Session EJBs. And you write-through from your application -> RDBMS -> Lucene/Solr? How are you handling commits (both soft and hard) and re-opening the index? > So, as far as I understand, you recommend to leave the data in the > RDBMS? I certainly would, even if it's just to allow a rebuild of the index from a "trusted" source. > The problem with RDBMS is that you can not easily scale over many > nodes with a master less cluster. That sounds like it's a problem with your choice of RDBMS, and not of RDBMS's in general. > This was why I thought Solr can solve this problem easily. On the > other hand my Lucene index also did not scale over multiple nodes. If you want a clustered document-store[1], you might want to look at a storage system designed for that purpose such as CouchDB or MongoDB. Lucene/Solr is really best used as a distillation of data stored elsewhere and not as a backing-store itself. > Maybe Solr would be a solution to scale just the index? That's exactly what Solr is for. > Another solution I am working on is to store all my data in a HA > Cassandra cluster because I do not need the SQL-Core > functionallity. But in this case I only replace the RDBMS with > Cassandra and Lucene/Solr holds again only the index. This seems like another plausible solution. > So Solr can't improve my architecture, with the exception of the > fact that the search index could be distributed across multiple > nodes with Solr. Did I get that right? Yes. Hope that helps, - -chris [1] https://en.wikipedia.org/wiki/Document-oriented_database#Implementations -----BEGIN PGP SIGNATURE----- Comment: Using GnuPG with Thunderbird - https://www.enigmail.net/ iQIzBAEBCAAdFiEEMmKgYcQvxMe7tcJcHPApP6U8pFgFAlz1jYYACgkQHPApP6U8 pFjw6w/9GGv4Z4FIoypv8XQrtIf5heT8yH0On6pQaFI313mglmzerTrD4W9Jz3y7 VWQHeMw5Q5LBg56KKMGSKv/PEnNmiA+69YTMdXB+R5gJnwtW0ZEZU0jP1uhPO+af UO6ZpdbMnIuIyeZK8oeo99rL7nrb0CaPvzrVP7LoF+flX9gp5qt30841QPTVwNgZ ryC+mrlWTidRpFF/uKCctDOwDJgw6pKNf352F+n/Oc85maBTySgIla1ZEqz+B+G3 tdgdTiDT/ueZY0BNFubnWlpjVTP+rwQjOrq1cD/Z53zV6APs4v7RQ0JBqDeJcadj 5xohEmZh47lKiNqsrSpB+CZy5mebxEalB3ptB+O7zexwLoixzJB4wmqfbP/hcO69 ijp58mhdoYDZqqwNJXoRNQ6OfQ9KlTyxtQwQGNcKCDiOOzZkhPInaYFnDo4AARG7 bI4z4eMpDuAm0VKi+b1voASSDxvIcT1gUZVVEtQWR5O3lzWDYmpKLsdMXQi34TKG CXtpjgq5CR8x8kFhVQD8QijTG/zOsDf0pksF1AZx/6DQvN3JaFy3hy2dSW1Plbm6 n0WMDIkJ8w9IxofU+pFcu+tJuSRvKdcieK6dHSMHSrTvUAZc3VcCXWI4w25eODX2 985JoQF5tP6IizxBOv334VwizGu7GRyPmLLMSnQFuJXzjB52v2w= =cN5b -----END PGP SIGNATURE-----
