Author:
erics, June 24th, 2019
In this blog post we will define what a split-brain scenario means in a MySQL database cluster, and then explore how a Tungsten MySQL database cluster reacts to a split-brain situation.
Categories: Failsafe, Mastering Tungsten Clustering, Multimaster, Split-Brain, Tungsten Connector Tags: HA, High Availability, mysql, Tungsten
| 
Comments Off on What on Earth is a Split-Brain Scenario in a MySQL Database Cluster?
Author:
erics, June 18th, 2019
This blog is about configuring Tungsten for PCI compliance.
Categories: Architecture, Compliance, Connector, IP Address, Mastering Tungsten Clustering, PCI, Tungsten Connector Tags: HA, High Availability, mysql, Tungsten
| Comments Off on Configuring the Tungsten Connector for PCI Compliance
Author:
erics, June 17th, 2019
Latency-sensitive applications running in Java sometimes experience unacceptable delays under heavy I/O load. This blog discusses why this problem occurs and what to do about it for applications running Tungsten Clustering for MySQL.
Categories: Cluster, Heavy I/O Load, I/O, Java GC, JVM, Manager, Mastering Tungsten Clustering Tags: Clustering, Java, mysql, Speed, Tungsten
| Comments Off on Why is My Java Application Freezing Under Heavy I/O Load?
Author:
erics, June 14th, 2019
Overview The Skinny In this blog post we will discuss how to use the Tungsten Connector keep-alive feature to ensure long-running MySQL & MariaDB/Percona Server client sessions stay connected in a Tungsten Cluster. Agenda What’s Here? Briefly explore how the Tungsten Connector works Describe the Connector keep-alives – what are they and why do we […]
Categories: Architecture, Bridge, Bridge mode, Connection, Connector, Intelligent, Keep-Alive, Load Balancing, Long, Long-Running, Mastering Tungsten Clustering, Multisite, SmartScale, Tungsten Connector Tags: HA, High Availability, Jobs, Keepalive, mysql, proxy, Session, TCP, Tungsten
| Comments Off on Using Keep-Alives To Ensure Long-Running MySQL & MariaDB Sessions Stay Connected
Author:
erics, June 12th, 2019
The Problem Tried to install the latest version of cpan and got stuck. Tracked it down to the dependency module Mac::SystemDirectory which was failing to build:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
cpan[1]> install Mac::SystemDirectory Reading '/var/root/.cpan/Metadata' Database was generated on Sun, 09 Jun 2019 07:17:02 GMT Running install for module 'Mac::SystemDirectory' Running make for E/ET/ETHER/Mac-SystemDirectory-0.10.tar.gz Checksum for /var/root/.cpan/sources/authors/id/E/ET/ETHER/Mac-SystemDirectory-0.10.tar.gz ok Scanning cache /var/root/.cpan/build for sizes ............................................................................DONE CPAN.pm: Building E/ET/ETHER/Mac-SystemDirectory-0.10.tar.gz HASCOMPILEREZFt/TESTUSSI.c:2:10: fatal error: 'EXTERN.h' file not found #include "EXTERN.h" ^~~~~~~~~~ 1 error generated. Couldn't execute cc -g -pipe -fno-common -DPERL_DARWIN -fno-strict-aliasing -fstack-protector -Os "-I/System/Library/Perl/5.18/darwin-thread-multi-2level/CORE" -c HASCOMPILEREZFt/TESTUSSI.c -o HASCOMPILEREZFt/TESTUSSI.o: Inappropriate ioctl for device at Makefile.PL line 14. Requires a compiler Warning: No success on command[/usr/bin/perl Makefile.PL INC=-I/Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/System/Library/Perl/5.18/darwin-thread-multi-2level/CORE] ETHER/Mac-SystemDirectory-0.10.tar.gz /usr/bin/perl Makefile.PL INC=-I/Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/System/Library/Perl/5.18/darwin-thread-multi-2level/CORE -- NOT OK Running make test Make had some problems, won't test Running make install Make had some problems, won't install Failed during this command: ETHER/Mac-SystemDirectory-0.10.tar.gz : writemakefile NO '/usr/bin/perl Makefile.PL INC=-I/Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/System/Library/Perl/5.18/darwin-thread-multi-2level/CORE' returned status 6400 |
The Solution Use the MacOS installer command to deploy the needed files:
|
|
sudo installer -pkg /Library/Developer/CommandLineTools/Packages/macOS_SDK_headers_for_macOS_10.14.pkg -target / installer: Package name is macOS_SDK_headers_for_macOS_10.14 installer: Installing at base path / installer: The install was successful. |
The, rerunning the cpan install works:
|
|
cpan[1]> install Mac::SystemDirectory ... Running make install Files found in blib/arch: installing files in blib/lib into architecture dependent library tree Installing /Library/Perl/5.18/darwin-thread-multi-2level/auto/Mac/SystemDirectory/SystemDirectory.bs Installing /Library/Perl/5.18/darwin-thread-multi-2level/auto/Mac/SystemDirectory/SystemDirectory.bundle Installing /Library/Perl/5.18/darwin-thread-multi-2level/Mac/SystemDirectory.pm Installing /usr/local/share/man/man3/Mac::SystemDirectory.3pm Appending installation info to /Library/Perl/Updates/5.18.2/darwin-thread-multi-2level/perllocal.pod ETHER/Mac-SystemDirectory-0.10.tar.gz /usr/bin/make install -- OK |
Categories: How-To's, Technology Tags: 10.14, CPAN, Error, extern.h, Fatal, Fatal Error, File not found, Header, headers, howto, Install, installer, Libraries, Library, MacOS, Mojave, not found, Package, perl, pkg, System, tips, update, upgrade, XCode
| No comments
Author:
erics, June 12th, 2019
The Problem Tried to load a Tab-delimited text file into MuSQL 5.6.43 and got the following error: mysql> LOAD DATA INFILE ‘sample.txt’ INTO TABLE test_table; ERROR 1290 (HY000): The MySQL server is running with the –secure-file-priv option so it cannot execute this statement Solution One mysql> SHOW VARIABLES LIKE “secure_file_priv”; Copy the file into the […]
Categories: How-To's, Technology Tags: Data, Error, File, howto, INFILE, Load, LOAD DATA, LOAD DATA INFILE, LOAD DATA LOCAL INFILE, local, mysql, Priv, Privilege, Secure, secure_file_priv, secure-file-priv, Show, SHOW VARIABLES, tips, VARIABLES
| No comments
Author:
erics, June 6th, 2019
Sonos was running just fine oon my MacOS Mojave iMac, then I had to force-quit it due to a system freeze. The Sonos app REFUSED to start, no matter what I tried, including uninstall/reinstall, full scrub of all files located, uninstaller software, reboots, cache cleaning and reboot with Onyx – NOTHING worked, and i was […]
Categories: How-To's, Technology Tags: Accessibility, MacOS, Mojave, Sonos
| No comments
Author:
erics, June 5th, 2019
Overview Continuent has traditionally had a relaxed policy about Linux platform support for customers using our products. While it is possible to install and run Continuent Tungsten products (i.e. Cluster/Replicator/etc.) inside Docker containers, there are many reasons why this is not a good idea. Background As background, every database node in a Tungsten Cluster runs […]
Categories: Docker, News, Policies, Policy, Support Tags: release
| Comments Off on The Continuent Docker Support Policy Explained
Author:
erics, June 3rd, 2019
To display the filenames included in each commit, just add the –name-only argument to git log:
Categories: How-To's, Technology Tags: Display, File, file names, git, git log, howto, Log, names, Show, tips
| No comments
Author:
erics, May 31st, 2019
Quickref: How to Remove a file from the staging area
|
|
git rm --cached {fileName(s)} |
The Story Recently, I accidentally added some files to git’s pre-commit phase, i.e.:
|
|
shell> git status On branch master Your branch is up-to-date with 'origin/master'. Changes to be committed: (use "git reset HEAD <file>..." to unstage) new file: good1.xml new file: good2.xml new file: bad1.xml new file: bad2.xml modified: good3.xml modified: bad3.xml |
For example, here is how to handle the above situation:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
shell> git rm --cached bad1.xml bad2.xml bad3.xml shell> git status On branch master Your branch is up-to-date with 'origin/master'. Changes to be committed: (use "git reset HEAD <file>..." to unstage) new file: good1.xml new file: good2.xml modified: good3.xml Untracked files: (use "git add <file>..." to include in what will be committed) bad1.xml bad2.xml bad3.xml |
To better understand, here are the phases/states/stages that git uses: Untracked – when a file is first created, git […]
Categories: How-To's, Technology Tags: Cache, commit, committed, git, howto, modified, Remove, staged, staging, tips, untracked
| No comments
