Infrastructure at your Service

Tag

Cluster Archives - Blog dbi services

Franck Pachot

No{Join,GroupBy}SQL – Analytic Views for BI

By | Cloud, Oracle | No Comments

By Franck Pachot . Advocates of NoSQL can query their structures without having to read a data model first. And without writing long table join clauses. They store and query a hierarchical structure without the need to follow relationships, and without the need to join tables on a foreign key name, in order to get a caption or description from a lookup table. The structure, like an XML or JSON document, provides metadata to understand…

Read More
Franck Pachot

Oracle 12c – global partial index

By | Cloud, Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . We have an incredible number of possibilities with Oracle. Yes, an index can be global (indexing many partitions without having to be partitioned itself on the same key) and partial (skipping some of the table partitions where we don’t need indexing). In the previous post of this series of small examples on recent features I partitioned a table, with covid-19 cases per day and per country, partitioned on range of date…

Read More
Franck Pachot

Oracle 12c – reorg and split table with clustering

By | Cloud, Database Administration & Monitoring, Oracle | 2 Comments

By Franck Pachot . In this series of small examples on recent features, I have imported in a previous post, the statistics of covid-19 per day and per countries. This is typical of data that comes as a time-series ordered by date, because this is how it is generated day after day, but where you probably want to query from another dimension, like per countries. If you want to ingest data faster, you keep it…

Read More
Saïd Mendi

Deploying a MariaDB 10.4 Galera cluster with Clustercontrol

By | Database Administration & Monitoring | No Comments

What is ClusterControl ? Since years, I’m using and installing by customers a management and automation software called “ClusterControl” from Severalnines (www.severalnines.com). With it, you can easily deploy, manage, monitor and scale your open source database servers or clusters (MariaDB, Percona, Postgres, Galera) from one GUI (Clustercontrol User Interface) on premise or even in the cloud. Some weeks ago, Severalnines announced the version 1.7.4 with several new features. One of these was the support of…

Read More
Saïd Mendi

Galera Cluster 4 with MariaDB 10.4.8: part 2

By | Database Administration & Monitoring | No Comments

My previous blog was about the MariaDB Galera cluster new features (version 10.4). Now I will only focus on the streaming replication and give you an overview of all the tests I performed. How to enable streaming replication? Quite easy, there are only 2 parameters: wsrep_trx_fragment_unit and wsrep_trx_fragment_size Then you have to choose a replication unit between the followings: . bytes and the fragment size is in bytes . rows and the fragment size is…

Read More
Morgan Patou

Alfresco – Share Clustering fail with ‘Ignored XML validation warning’

By | Application integration & Middleware, Entreprise content management | No Comments

In a recent project on Alfresco, I had to setup a Clustering environment. It all went smoothly but I did face one single issue with the setup of the Clustering on the Alfresco Share layer. That’s something I never faced before and you will understand why below. Initially, to setup the Alfresco Share Clustering, I used the sample file packaged in the distribution zip (E.g.: alfresco-content-services-distribution-6.1.0.5.zip): <?xml version=’1.0′ encoding=’UTF-8′?> <beans xmlns=”http://www.springframework.org/schema/beans” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:hz=”http://www.hazelcast.com/schema/spring” xsi:schemaLocation=”http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd…

Read More
Morgan Patou

Alfresco Clustering – Solr6

By | Application integration & Middleware, Entreprise content management | No Comments

In previous blogs, I talked about some basis and presented some possible architectures for Alfresco, I talked about the Clustering setup for the Alfresco Repository, the Alfresco Share and for ActiveMQ. I also setup an Apache HTTPD as a Load Balancer. In this one, I will talk about the last layer that I wanted to present, which is Solr and more particularly Solr6 (Alfresco Search Services) Sharding. I planned on writing a blog related to…

Read More
Morgan Patou

Alfresco Clustering – Apache HTTPD as Load Balancer

By | Application integration & Middleware, Entreprise content management | No Comments

In previous blogs, I talked about some basis and presented some possible architectures for Alfresco, I talked about the Clustering setup for the Alfresco Repository, the Alfresco Share and for ActiveMQ. In this one, I will talk about the Front-end layer, but in a very particular setup because it will also act as a Load Balancer. For an Alfresco solution, you can choose the front-end that you prefer and it can just act as a…

Read More
Morgan Patou

Alfresco Clustering – ActiveMQ

By | Application integration & Middleware, Entreprise content management | No Comments

In previous blogs, I talked about some basis and presented some possible architectures for Alfresco, I talked about the Clustering setup for the Alfresco Repository and the Alfresco Share. In this one, I will work on the ActiveMQ layer. I recently posted something related to the setup of ActiveMQ and some initial configuration. I will therefore extend this topic in this blog with what needs to be done to have a simple Cluster for ActiveMQ….

Read More