From c163108c0c0c7b7a4f05da411e98ac0f503e31e0 Mon Sep 17 00:00:00 2001 From: "Suren A. Chilingaryan" Date: Fri, 23 Mar 2018 06:51:23 +0100 Subject: Fix critical bug in docker provisioner, improve mysql performance, provision system users/groups to enable NFS group mapping, various minor fixes --- docs/databases.txt | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'docs/databases.txt') diff --git a/docs/databases.txt b/docs/databases.txt index 7f8468e..aa58a2e 100644 --- a/docs/databases.txt +++ b/docs/databases.txt @@ -9,8 +9,16 @@ Galera INNODB 3.5 MB/s fast 3 x 200% - Should be perfect, but I am not sure about automatic recovery... Galera/Hostnet INNODB 4.6 MB/s fast 3 x 200% - MySQL Slaves INNODB 5-6 MB/s fast 2 x 250% - Available data is HA, but caching is not. We can easily turn the slave to master. + MySQL S.+Zlib INNODB + ZLib 2-4 MB/s normal 2 x 300% - At about 35% compression level. DRBD MyISAM (no logs) 4-6 exp. ? I expect it as an faster option, but does not fit the OpenShift concept that well. + +Optimized (Large buffers, transactions in ADEI, etc.) + Method Database Perf (Mst/Slv) Clnt/Cache MySQL Gluster HA + MySQL Slaves INNODB 12 / 14 MB/s fast 600-800% - + + + Gluster is a way too slow for anything. If node crashes, MyISAM tables may be left in corrupted state. The recovery will take ages to complete. The Gluster/Block is faster, but HA suffers. The volume is attached to the pod running on crashed node. It seems not detached automatically until -- cgit v1.2.1