Category Archives: MySQL

MySQL-related

Migrating SQLite Databases to MySQL

Posted on October 20, 2019 by James Briggs

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

Posted on April 28, 2018 by James Briggs

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

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