diff options
| author | Suren A. Chilingaryan <csa@suren.me> | 2018-03-23 06:51:23 +0100 |
|---|---|---|
| committer | Suren A. Chilingaryan <csa@suren.me> | 2018-03-23 06:51:23 +0100 |
| commit | c163108c0c0c7b7a4f05da411e98ac0f503e31e0 (patch) | |
| tree | 4934d1b2e98b0e8a94816848e44496e009e6755f /docs/databases.txt | |
| parent | cba41110aa086553192ed5a309a6b8031812c221 (diff) | |
| download | ands-c163108c0c0c7b7a4f05da411e98ac0f503e31e0.tar.gz ands-c163108c0c0c7b7a4f05da411e98ac0f503e31e0.tar.bz2 ands-c163108c0c0c7b7a4f05da411e98ac0f503e31e0.tar.xz ands-c163108c0c0c7b7a4f05da411e98ac0f503e31e0.zip | |
Fix critical bug in docker provisioner, improve mysql performance, provision system users/groups to enable NFS group mapping, various minor fixes
Diffstat (limited to 'docs/databases.txt')
| -rw-r--r-- | docs/databases.txt | 8 |
1 files changed, 8 insertions, 0 deletions
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 |