How to setup and install Elasticsearch: From a single node to a cluster of nodes
Elasticsearch is a complex software incomparable to other mainstream database software, whether it's RDBMS or NoSQL. It functions primarily as your search engine and works as your document database to store valuable data for analytics....
10 Considerations for Architecting a Multi-Cloud Database
Thinking about architecting a multi-cloud database? It’s an increasingly common topology nowadays. The adoption rate of a multi-cloud approach has been growing fast for years. It’s a solid option for a disaster recovery plan (DRP)...
Best Practices for Scaling A Multi-Cloud Database Infrastructure
Scaling a multi-cloud database infrastructure can be a complex and challenging task, but it's essential for businesses that require high scalability, availability, and reliability. With multi-cloud becoming increasingly popular, organizations are leveraging the benefits of...
What’s new in SQL Server 2022
SQL Server 2022 is the latest database version released by Microsoft in November 2022. The release builds upon previous versions to add more choice for SQL Server users when it comes to development languages, data...
wtmp Log Rotation Settings for Sudo User in ClusterControl
Requires ClusterControl. Applies to all supported database clusters. Applies to all supported operating systems (RHEL/CentOS/Debian/Ubuntu). ClusterControl requires a super-privileged SSH user to provision database nodes. If you are running as non-root user, the corresponding user...
A Guide to MySQL User Management
Requires ClusterControl 1.2.11 or later. Applies to MySQL based clusters. In this example we will look at how you can use ClusterControl to create a user and assign privileges to the user. We will create...
Database Security – How to Fully SSL-Encrypt Your MySQL Galera Cluster
Data security is a hot topic for many companies these days. But for those who need to adhere to security standards like PCI DSS or HIPAA, security is not an option. We showed you sometime...
Integrating ClusterControl with FreeIPA and Windows Active Directory for Authentication
Integrating ClusterControl with a corporate LDAP directory is a common task for many IT organizations. In an earlier blog, we showed you how to integrate ClusterControl with OpenLDAP. In this post, we will show...
How-To and Performance Impacts of SSL-Encrypted Replication Traffic in Galera Cluster for MySQL
Deploying Galera Clusters across WAN environments might lead to concerns around data privacy and security - especially as more organisations are having to comply with national and international regulations. You would not want hackers eavesdropping...
How to Setup Centralized Authentication of ClusterControl Users with LDAP
ClusterControl 1.2.6 introduces integration with Active Directory and LDAP authentication. This allows users to log into ClusterControl by using their corporate credentials instead of a separate password. LDAP groups can be mapped onto ClusterControl user...
Heartbleed OpenSSL Bug: Impact on ClusterControl Users & Recommendations on How to Protect Your Systems
In the wake of recent concerns and debates raised around the Heartbleed bug, we wanted to update Severalnines ClusterControl users on any impact this bug might have on ClusterControl & associated databases and/or applications. Background...