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

Install Scylla on Ubuntu 16.04

Scylla Is Next Generation NoSQL. Power your mission-critical applications with the best traits of Apache Cassandra at 10x the performance and low tail-latency at all times. Add Repo Add the Scylla APT repository to your system. $ sudo wget -O /etc/apt/sources.list.d/scylla.list http://repositories.scylladb.com/scylla/repo/63074dd55d7ebbd35bedc10c3d4ad5af/ubuntu/scylladb-1.7-xenial.list Install Use the below command to install Scylla.…

Continue reading

Puppet Hiera Configuration

Hiera is Puppet’s built-in key/value data lookup system. By default, it uses simple YAML or JSON files, although you can extend it to work with almost any data source. Hiera is the most flexible way to get configuration data into Puppet. Hiera is immensely powerful, and with great power comes great responsibility.…

Continue reading

Setup Puppet Server 5 on Ubuntu 16.04

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 throughout…

Continue reading