I think the reason why most of your queries aren't being answered is because you're asking questions that most people don't have the answer to. On the automatic disconnect, anyone using Cassandra in prod doesn't really need to think about it because we're always running queries, perhaps millions a second. Queries are multiplexed over a single connection. Almost nobody ever actually runs into a case of leaving a socket open for hours without a query, so to find out if it actually happens, someone would have to look it up in the source.
Your questions about auditing are geared more towards if you're using a database that's built for multi user access. Cassandra was built to solve a very different problem. In most cases, you don't have hundreds of people connecting from a shell, leaving connections open, casually querying for BI reports. This isn't how *most* people use Cassandra, it wasn't really built for that. There's better support for users & roles nowadays but it's relatively new and that's about all you have right now. I realize you're new to the community, and it can be frustrating to not get answers to questions that seem completely basic and obvious, but you're asking about areas that *most* people on this list don't have knowledge about and zero motivation to learn, because it's not necessary to solve the problems we face. On Fri, Jan 29, 2016 at 6:19 AM oleg yusim <olegyu...@gmail.com> wrote: > Not a problem, Carlos, at least you tried :) I have overall a big problem > with my queries to Cassandra community. Most of them are not getting > answered. > > Oleg > > On Fri, Jan 29, 2016 at 8:03 AM, Carlos Alonso <i...@mrcalonso.com> wrote: > >> Oh, I thought you meant read/write timeout, not session timeout due to >> inactivity... >> >> Not sure there's such option. Sorry >> >> Carlos Alonso | Software Engineer | @calonso >> <https://twitter.com/calonso> >> >> On 29 January 2016 at 13:35, oleg yusim <olegyu...@gmail.com> wrote: >> >>> Carlos, >>> >>> I went through Java and Python drivers... didn't find anything like >>> that. Can you bring me example from your Ruby driver? Let me also make sure >>> we are on the same page - I'm talking about session timeout due to >>> inactivity, not read timeout or something like that. >>> >>> Thanks, >>> >>> Oleg >>> >>> On Fri, Jan 29, 2016 at 7:23 AM, Carlos Alonso <i...@mrcalonso.com> >>> wrote: >>> >>>> I personally don't use the Java but the Ruby driver, but I'm pretty >>>> sure you'll be able to find it in the docs: >>>> https://github.com/datastax/java-driver >>>> >>>> Carlos Alonso | Software Engineer | @calonso >>>> <https://twitter.com/calonso> >>>> >>>> On 29 January 2016 at 13:15, oleg yusim <olegyu...@gmail.com> wrote: >>>> >>>>> Hi Carlos, >>>>> >>>>> Thanks for your anwer. Can you, please, get me a bit me information? >>>>> What is the driver? JDBC? What is the name of configuration file? >>>>> >>>>> Thanks, >>>>> >>>>> Oleg >>>>> >>>>> On Fri, Jan 29, 2016 at 5:12 AM, Carlos Alonso <i...@mrcalonso.com> >>>>> wrote: >>>>> >>>>>> Hi Oleg. >>>>>> >>>>>> The drivers have builtin the timeout configurable functionality. >>>>>> >>>>>> Hope it helps. >>>>>> >>>>>> Carlos Alonso | Software Engineer | @calonso >>>>>> <https://twitter.com/calonso> >>>>>> >>>>>> On 28 January 2016 at 22:18, oleg yusim <olegyu...@gmail.com> wrote: >>>>>> >>>>>>> Greetings, >>>>>>> >>>>>>> Does Cassandra support session timeout? If so, where can I find this >>>>>>> configuration switch? If not, what kind of hook I can use to write my >>>>>>> out >>>>>>> code, terminating session in so many seconds of inactivity? >>>>>>> >>>>>>> Thanks, >>>>>>> >>>>>>> Oleg >>>>>>> >>>>>> >>>>>> >>>>> >>>> >>> >> >
