-
Hi, I'm James Briggs, an Internet computer programmer/DBA/SRE in Silicon Valley. I've been engineering for over 20 years for companies like eBay, Netflix, Yahoo!, Apple, Amazon and startups.
I use TuCows/Hover for registering domain names.
I am available for MySQL/Postgres DBA/SRE/Security work in Silicon Valley or remote. Click here to contact me.
I am a MariaDB/MySQL code contributor and Perl CPAN author. Check out my github. My most recent project is cassandra-top.
In my spare time I do Open Source programming and like flying airplanes, karate and studying Asian languages.
This blog talks about events, places and things in my life. San Jose, San Jose International Airport, CA
Last Updated on May 20 2019, 10:53 pm PDT
Weather by NOAA
Current Conditions: Partly Cloudy
Temp: 56°F
Wind: Variable at 3mph
Humidity: 75%
Dewpoint: 48.0°F
RackPing Graphs- Daily Performance for Monitor Check 1000001 May 20, 2019RackPing Performance Graph
- Daily Performance for Monitor Check 1000001 May 20, 2019
-
RackPing Performance Graph
Category Archives: MySQL Cluster
Postgresql vs MySQL in the Enterprise
There are few people who have used both MySQL and Postgresql in production at scale. Both are great Open Source databases, so I thought I’d add some comments based on my experience. Feature MySQL/InnoDB Postgresql Replication Many options, simple to … Continue reading
Table Partitions in MySQL and Postgresql
We’re lucky to have two great Open Source databases, MySQL and Postgresql. One of the killer features in both MySQL and Postgresql is table partitions – for example, most Silicon Valley adtech companies are powered by MySQL partitions. They let … Continue reading
PSA: Intel and AMD Security Bugs and the DBA
Being famous is not always a good thing … There’s at least 5 problems related to the on-going Meltdown and Spectre serious CPU security bugs (AWS announcement) that impact the Database Administrator (DBA): in shared environments, like AWS or VMs, … Continue reading
Internet Latency and Multi-Master Database Transactions
There’s 2 common misconceptions in engineering West Coast – East Coast data centers: that packets travel at the speed of light that database transactions must be 2-phase commit, and two masters cannot be located very far apart because of #1. … Continue reading
Perl, DBI and MySQL utf8mb4 Character Set Support
MySQL’s modern UTF-8 encoding is named utf8mb4 (4 bytes), not utf8 (3 bytes.) For new applications, especially web, you should start with utf8mb4. For existing applications, you need to decide if an upgrade is worthwhile, and test extensively before a … Continue reading
