Long time no write a new post, I’ve been busy with new projects. In one of them a new callenge appeared…. The infraestructure consisted in two VPS hosted in different datacenters without private comunication, and with the necesity to configure a secure replication for Mysql and MongoDB. The best solution that came to my head […]
Greeting to all readers, the first thing is to apologize for not write time ago but I have been studying the LPIC-2 Certification ;-). In this article I’ll explain how mount a Mysql Multi-Master replication, this system consist in two databases running in separate servers, the production machine, with read/write access, and the read-only CDR […]
Hi, after install and & Configure Mysql Cluster is the moment to run a benchmark and see how respond Mysql Server. To implement this task I’ll use the dbt2 tool, in the 0.40 version and the dbttools to generate the reports. I use the dbt2 and not the dbt5 because it doesn’t support mysql testing.
After install the Mysql Cluster we only have one pending thing, mount a CDR server in read-only mode that will replicate the information from the primary database. And This is one possible application:
In previous posts I explained how enable Mysql Server for support SSL connections, now I’ll explain how configure a Tomcat application for using Mysql encrypt connections.
In this post I’ll explain how encrypt mysql connections using SSL certificates between mysql client and server (not applications). By default mysql are not used encryption, to activate it you only need to compile with SSL option.
Ok, after explain how install and configurate drbd and vmware stonith, it’s the moment to start a new project mount a MySQL cluster. The Concept The concept of an active/passive fail-over Cluster is the following: Two servers (nodes). They communicate over a cluster software (Heartbeat, Corosync, OpenAIS) They are running on DRBD failover storage system. MySQL is only running in MASTER […]
Ok, in previous entries I explained how install and configure DRBD and Stonith for Vmware. Now I explain how integrate all of them in CRM to control this resources with one tool. The CRM (a.k.a Pacemaker) is a Cluster Resource Manager which implements the cluster configuration provided by the user in CIB (Cluster Information Base). […]
In this new post I’ll splain how install and configure Vmware Stonith for a new Linux Cluster. For all the people that don’t know what’s Stonith, this is the explanation by Wikipedia: STONITH (“Shoot The Other Node In The Head” or “Shoot The Offending Node In The Head”), sometimes called STOMITH (“Shoot The Other Member/Machine In The Head”), […]
Hi, in this post I’ll splain how configure a DRBD infraestructure, but first, What’s DRBD: DRBD® refers to block devices designed as a building block to form high availability (HA) clusters. This is done by mirroring a whole block device via an assigned network. DRBD can be understood as network based raid-1.