Best Practice Using Galera Cluster

2017-08-17 Thread Garry Williams
We have just set up a Galera Cluster on three geographically diverse servers.

How should we modify Perl clients to take advantage of this?

The DBD::mysql manual page gives no indication that we can specify a
cluster (or multiple hosts) instead of a host.  I have concluded that
we need to modify client code to handle failures and retries on
different hosts.

Any suggestions otherwise?

-- 
Garry Williams


Announce: DBI 1.637

2017-08-17 Thread Tim Bunce
  file: $CPAN/authors/id/T/TI/TIMB/DBI-1.637.tar.gz
  size: 596423 bytes
   md5: fdcb1739c923300de7bc5250c1c75337
  sha1: 183ba1542a7499b508568c1765a4a1bcc4b4bbc9

=head2 Changes in DBI 1.637

Fix use of externally controlled format string (CWE-134) thanks to pali #44
This could cause a crash if, for example, a db error contained a %.
https://cwe.mitre.org/data/definitions/134.html
Fix extension detection for DBD::File related drivers
Fix tests for perl without dot in @INC RT#120443
Fix loss of error message on parent handle, thanks to charsbar #34
Fix disappearing $_ inside callbacks, thanks to robschaber #47

Allow objects to be used as passwords without throwing an error, thanks to 
demerphq #40
Allow $sth NAME_* attributes to be set from Perl code, re #45
Added support for DBD::XMLSimple thanks to nigelhorne #38

Documentation updates:
Improve examples using eval to be more correct, thanks to pali #39
Add cautionary note to prepare_cached docs re refs in %attr #46
Small POD changes (Getting Help -> Online) thanks to openstrike #33
Adds links to more module names and fix typo, thanks to oalders #43
Typo fix thanks to bor #37

=cut

Many thanks to those who contributed to this release.

Enjoy!

Tim.