Tag: Clustering

Clustering

Top PG Clustering HA Solutions for PostgreSQL

If your system relies on PostgreSQL databases and you are looking for clustering solutions for HA, we want to let you know in advance that it is a complex task, but not impossible to achieve. We are going to discussion some solutions, from which you will be able to choose taking into account your requirements …

Clustering

Percona XtraDB Cluster and SELinux: Getting It To Work

In this blog post, I’ll look at how to make Percona XtraDB Cluster and SELinux work when used together. Recently, I encountered an issue with Percona XtraDB Cluster startup. We tried to setup a three-node cluster using Percona XtraDB Cluster with a Vagrant CentOS box, but somehow node2 was not starting. I did not get enough …

Software

MySQL Cluster 7.6.4 is out

MySQL Cluster 7.6.4 DMR is out. This new version contains a number of goodies. 1) Local checkpoint algorithm have been rewritten The new checkpointing is designed to scale to at least 16 TBytes of DataMemory sizes Checkpoints will be much faster, this decreases recovery times significantly Table fragments that are not updated will not need …

Miscellaneous

Opportunities for CPU Efficiency When Data Clustering is not a Priority

Db2 for z/OS: Opportunities for CPU Efficiency When Data Clustering is not a Priority Not long ago, a veteran Db2 for z/OS DBA contacted me with an interesting question. He had, in the system he supported, a table with a clustering index, and he wanted to know how he could get Db2 to act, with …

Clustering, Security

How to Secure Your Open Source Databases with ClusterControl

  Security is one of the most important aspects of running a database. Whether you are a developer or a DBA, if you are managing the database, it is your responsibility to safeguard your data and protect it from any kind of unauthorized access. The unfortunate fact is that many organizations do not protect their …