Category Archives: MySQL

MySQL-related

Migrating Sqlite Databases to MySQL

Recently I had to migrate a relatively simple (no FKs or views) Grafana 4 database of about 20 tables and 80,000 rows from sqlite3 to mysql5.6. Below are some notes I made on the 3 methods I tried. First up … Continue reading

Posted in MySQL, Open Source, 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