Category Archives: Postgresql

Facebook Production Engineering Open House 2018

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

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

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

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

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