paul-rogers commented on issue #10782: URL: https://github.com/apache/druid/issues/10782#issuecomment-970639554
From experience on other Apache projects (Drill, Impala), ZK is not good at this sort of thing: ZK is not a distributed DB. It will struggle to hold very many queries. The SQL DB solution is good. In an HDFS or S3 environment, it may also be possible to store queries as files. Security is often another consideration with this kind of thing: should user A be able to see user B's queries? How are queries kept private or shared? Should user A have the ability to alter or replace a shared query? Or, only the admin can do that? If someone accidentally replaces a query with the wrong one, is there a way to get the old one back? Pretty soon, we are building a DB application and the MySQL idea looks pretty good. Suggestion: consider doing this as an extension point: if someone wants to implement it in ZK (because it fits their use case), go for it. Maybe another works with MySQL, etc. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
