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,…
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…
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…
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…
A LAMP (Linux, Apache, MySQL, PHP) stack is free, and open-source web stack. It is used for hosting web content in a Linux environment.Many consider this as the platform of choice for high performance web apps. In this article, i will illustrate the LAMP setup process. CentOS7 Upgrade centos to…
A LAMP (Linux, Apache, MySQL, PHP) stack is free, and open-source web stack. It is used for hosting web content in a Linux environment.Many consider this as the platform of choice for high performance web apps. In this article i will illustrate the LAMP setup process. Ubuntu 18.04 LTS Update…
This is only for test environment and lazy people. Every time we have to add MySQL username and password to log in. Using this way we can login without credentials. MySQL Username and Password After the below changes, you will be able to login without credentials. All the commands like…
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…
The Apache Hadoop software library is a framework that allows for the distributed processing of large data sets across clusters of computers using simple programming models. It is designed to scale up from single servers to thousands of machines, each offering local computation and storage. Rather than rely on hardware…
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…
