[Info-vax] MariaDB (Re: OT: what is old is new again?)

[Kerry Main]

> -----Original Message-----
> From: Info-vax [mailto:info-vax-bounces at rbnsn.com] On Behalf
> Of Arne Vajhøj via Info-vax
> Sent: 24-Nov-16 7:56 PM
> To: info-vax at rbnsn.com
> Cc: Arne Vajhøj <arne at vajhoej.dk>
> Subject: Re: [Info-vax] MariaDB (Re: OT: what is old is new
> again?)
> 
> On 11/24/2016 3:08 PM, Kerry Main wrote:
> >Ok, perhaps someone can
> > correct me here, but I believe there is some limited shared
> nothing
> >MariaDB cluster offerings on Linux only.
> 
> Sharding is common but that requires nothing from the database.
> MariaDB and MySQL could do sharding on VMS out of the box (if
> there are any VMS customers left with enough VMS systems to
> make it relevant).
> 
> MySQL Cluster is really a transparent & automated version of
the
> same sharding concept.
> 
> Galera Cluster is a third party addon that provides
active-active
> clustering using a replication model to both MySQL and MariaDB.
> 
> That is what I am aware of.
> 
> Arne
> 

A good whitepaper posted in 2015 that looks at the pros and cons
of shared-nothing (Linux, Windows, UNIX, NonStop) databases vs.
shared-disk (OpenVMS, Linux/GFS, z/OS) can be found here:
http://bit.ly/2dScx9k

Original will likely wrap:
http://www.scaledb.com/wp-content/uploads/2015/11/Shared-Nohing-v
s-Shared-Disk-WP_SDvSN.pdf 

extract "Comparing shared-nothing and shared-disk in benchmarks
is analogous to comparing a dragster and a Porsche. The dragster,
like the hand-tuned shared-nothing database, will beat the
Porsche in a straight quarter mile race. However, the Porsche,
like a shared-disk database, will easily beat the dragster on
regular roads. If your selected benchmark is a quarter mile
straightaway that tests all out speed, like Sysbench, a
shared-nothing database will win. However, shared-disk will
perform better in real world environments."

Extract from conclusion "The comparison between shared-disk and
shared-nothing is analogous to comparing automotive
transmissions. Under certain conditions and, in the hands of an
expert, the manual transmission provides a modest performance
improvement. But under the vast majority of real world
conditions, the automatic transmission provides a better overall
experience. Similarly, shared-nothing can be tuned to provide
superior performance, assuming you can minimize the function- and
data-shipping. Unfortunately, this is rarely a valid assumption.
Shared-disk, much like an automatic transmission, is easier to
set-up and it adjusts over time to accommodate changing usage
patterns."

Regards,

Kerry Main
Kerry dot main at starkgaming dot com