I want access to remote cassandra with one ip address. how can I change cassandra.yaml to block all ip address except ip that I want to connect?
Can I do by cassandra.yaml ?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
Isn't this exactly what a Firewall does for you?
Isn't it better to let this purpose-built software take the brunt of any "attack", rather than letting the attacker most of the way into your server and asking Cassandra to try to defend "herself" ... ?
As a certain, fictional engineer is famed for saying:
The Right Tool for the Right Job ...
While you cannot block or allow IP addresses with Cassandra, I recommend enabling authentication, authorization, and client-to-node SSL/TLS encryption. This way, anyone from another IP address (who tries to access your cluster), will not have the required valid credentials or TLS certificate; and will not be allowed to connect to your cluster.
You don't configure network access rules in the database itself. You need to do this at the network layer using hardware or software firewalls.
With firewalls, you can configure access control lists (ACLs) such that only certain devices/network segments (typically your app servers) have connectivity to the database. Cheers!