Category Archives: Open Source

Open Source-related

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

RedisConf 2018

I attended RedisConf 2018 on Thursday at Pier 27 (The James R. Herman Cruise Terminal) in SF. Just like 2017, the talks were extremely high-quality and imaginative – I wished I could see all of the tracks. The Herman Center … Continue reading

Posted in API Programming, Cloud, Java, Linux, Microservices, MySQL, Open Source, 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