Category Archives: Oracle

Oracle Database-related

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

Table Partitions in MySQL and Postgresql

We’re lucky to have two great Open Source databases, MySQL and Postgresql. One of the killer features in both MySQL and Postgresql is table partitions – for example, most Silicon Valley adtech companies are powered by MySQL partitions. They let … Continue reading

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

How to Autoscale AWS RDS Read Slaves

I don’t see a lot of links on autoscaling AWS RDS read slaves. Is the reason: AWS RDS users are simply content with relying on features as they arrive? users could just be upsizing RDS masters or moving to Aurora, … Continue reading

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

Internet Latency and Multi-Master Database Transactions

There’s 2 common misconceptions in engineering West Coast – East Coast data centers: that packets travel at the speed of light that database transactions must be 2-phase commit, and two masters cannot be located very far apart because of #1. … Continue reading

Posted in Business, Cassandra, Linux, MySQL, MySQL Cluster, Open Source, Oracle, Tech | Leave a comment

Perl, DBI and MySQL utf8mb4 Character Set Support

MySQL’s modern UTF-8 encoding is named utf8mb4 (4 bytes), not utf8 (3 bytes.) For new applications, especially web, you should start with utf8mb4. For existing applications, you need to decide if an upgrade is worthwhile, and test extensively before a … Continue reading

Posted in Linux, MySQL, MySQL Cluster, Open Source, Oracle, Perl, Tech | Leave a comment