Category Archives: Postgresql

Facebook Production Engineering Open House 2018

Posted on May 31, 2018 by James Briggs

I attended the Facebook Production Engineering Open House at their Menlo Park HQ. “Production Engineering is Facebook’s secret sauce – it draws on multiple disciplines (Software Engineering, Systems Administration, Distributed Systems and Networking) to plan, build and maintain the massive … Continue reading →

Posted in API Programming, Cloud, Linux, Microservices, Postgresql, Tech | Leave a comment

PostgreSQL and “PANIC: replication checkpoint has wrong magic” error

Posted on May 19, 2018 by James Briggs

PSA: I haven’t seen a solution to this issue online, so posting it here for search engines to index. PostgreSQL is an ACID-compliant database, but filesystem corruption can still prevent it from starting. In my case, a linux test instance … Continue reading →

Posted in Open Source, Postgresql, Tech | Leave a comment

Percona Live 2018 Conference

Posted on April 28, 2018 by James Briggs

I attended the Percona Live 2018 database conference in Santa Clara again. As always, the conference was very well-organized and had great talks. For 2018, Percona attempted to make it more affordable, with prices in the $600 range. Much appreciated! … Continue reading →

Posted in API Programming, Linux, MySQL, Open Source, Oracle, Postgresql, Tech | Leave a comment

Postgresql vs MySQL in the Enterprise

Posted on March 30, 2018 by James Briggs

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 →

Posted in MySQL, MySQL Cluster, Open Source, Postgresql, Tech | Leave a comment

Maintenance Banner mx_banner Available

Posted on February 4, 2018 by James Briggs

While watching Superbowl 52, I finished my github project Maintenance Banner, aka mx_banner.php. It lets an application administrator schedule maintenance event notifications for a web application in a database, and the web application can then automatically display those on the … Continue reading →

Posted in Linux, MySQL, Open Source, Postgresql, Tech | Leave a comment