SSL Replication

Percona Server generates SSL certificates by default. With SSL replication, we can encrypt the communication between master and slave server. Encrypted Replication On Master server add “REQUIRE SSL” to the replication user, as show below. GRANT REPLICATION SLAVE ON *.* to ‘repl_user’@’%’ IDENTIFIED BY ‘repl_pass’ REQUIRE SSL; CHANGE MASTER MASTER_SSL=1,…

Continue reading

MySQL SSL Connection

With an unencrypted connection between the MySQL client and the server, someone with access to the network could watch all your traffic and inspect the data being sent or received between client and server. MySQL supports encrypted connections between clients and the server. Percona server generates all the SSL certificates…

Continue reading

ScyllaDB Backup

Scylla is an open-source distributed NoSQL data store. It was designed to be compatible with Apache Cassandra while achieving significantly higher throughputs and lower latencies. Scylla is a fault tolerance system, even though it is recommended to regularly backup data to external storage. Backup is per node basis. Therefore take…

Continue reading

Setup Puppet Server 5 on CentOS 7

Puppet is a ruby based configuration management tool (IT automation software), licensed under Apache 2.0 designed to help system administrators, automate many repetitive task they regularly perform . It is open-source, flexible, customizable framework for managing the configuratons of computer system. It defines and enforce the state of your infrustructure…

Continue reading

ScyllaDB Monitoring

ScyllaDB Monitoring Stack can monitor all the Scylla infrastructure easily. Scylla team has beautifully explained, all the steps to setup monitoring. It’s very straight forward and any body can configure it using the below URLs. ScyllaDB URLs http://docs.scylladb.com/operating-scylla/monitoring/monitoring_stack/ http://docs.scylladb.com/operating-scylla/monitoring/monitor_without_docker/ Troubleshooting I’m just sharing up a scenario, where i faced some…

Continue reading

Setup Cassandra Cluster on CentOS 7

Apache Cassandra is a free and open-source distributed NoSQL database management system designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure. Cassandra offers robust support for clusters spanning multiple datacenters, with asynchronous masterless replication allowing low latency operations for…

Continue reading