Newsletter sent on 18th July 2020
Good Week End from London, Europe.
As mentioned in the last issue, Federico-Razzoli.com UPDATEs format changed, and possibly it’s still changing. You will find some notes from me and more news, which are better categorised. This is the reason why FRU is now sent on weekends: you will have more time to read it.
For quick news, it’s better to subscribe my Telegram channel: open_source_databases.
Since the last issue, I wrote two articles about MariaDB features (not only from the recent 10.5 version):
10.5 went GA, and this time the community weren’t asked to vote for new features to include in 10.6. It’s a pity.
I will give two virtual talks at “Oxbridge” meetups:
- PHP & Databases: How MySQL can boost (or kill) your PHP application, 21st July, PHP Cambridge meetup
- JSON features in MySQL and MariaDB, 29th July, PHP Oxford meetup
Most relevant events I am aware about:
- MariaDB Server Fest Online Conference 16-17 Sep 2020
Articles from the web
Commentary of the week
MySQL 8.0.21 allows to disable InnoDB Redo Log. The documentation states that this feature is only intended to load data more quickly, and should not be used in production systems. I hope that the number of users who deliberately ignore (or don’t read at all) this recommendation is relatively small. In fact, a crash while the Redo Log is disabled will corrupt the whole dataset (but it should be possible to repair it). They also introduced a new permission for disabling the Redo Log, INNODB_REDO_LOG_ENABLE. To me this sounds like a suggestion that it makes sense to allow this operation to someone who is not root… which makes the whole thing even more weird.
Don’t misunderstand me, I’m not criticising, for example, PostgreSQL UNLOGGED tables. They make sense, and it even makes sense to make a table UNLOGGED and then LOGGED again. Accepting the risk to lose one table or a set of tables to get better performance may be perfectly reasonable.
- MySQL Query Performance Troubleshooting: Resource-Based Approach
- XtraDB Cluster troubleshooting a rejected node
- binlog2sql: Binlog to Raw SQL Conversion and Point In Time Recovery
- Understanding Memory-Barrier with MySQL EventMutex
- What are PostgreSQL templates?
- How one word in PostgreSQL unlocked a 9x performance improvement
- Noisia, Harmful workload generator for PostgreSQL
- The myth of NoSQL (vs. RDBMS) “joins dont scale”
- Why Performance Matters in Time-Series Data
- Review: The Design of the Postgres Storage System – Mark Callaghan wrote a brilliant review of the paper that described POSTGRES, the ancestor of PostgreSQL. Turns out to be more modern than I thought.
- Race Conditions/Concurrency Defects in Databases: A Catalogue
- Handling Real-Time Updates in ClickHouse
- Getting the Most out of Lightweight Transactions in Scylla
- How TiDB Reduced Multi-region Read Latency and Network Traffic by 50%
- How CockroachDB Wrote a Massive & Complex Go Application
- What’s New in RavenDB 5.0?
Misc technical contents
- Do robots usually have databases?
- Multi-threaded Bash scripting & process management at the command line
- Dynamic Tracing of C++ Class Member Functions with perf
IT & Database strategies
- TileDB Closes $15M Series A for Industry’s First Universal Data Engine
- Yes, it’s safe to move sensitive data to the cloud
- Data Prep Still Dominates Data Scientists’ Time, Survey Finds
- Open source contributions face friction over company IP
- Contribute Product Feedback for Percona Development!
- The unwavering optimism of Tim O’Reilly
- Suse acquires Kubernetes management platform Rancher Labs
- Bridging batch and stream processing for the Recruiter usage statistics dashboard
Fun & Curiosity
- Ashens History Of Computers – A fascinating YouTube channel, if you like retrocomputing
If you like my contents, my talks/webinars, my books and Federico-Razzoli.com UPDATEs, you may want to check my professional services. You may want to try a database health check or training, and then decide if you’d like to start a long term collaboration. If you can’t make this kind of decisions, please consider endorsing me with your manager.
You may also want to follow the open_source_databases Telegram channel. Links about the open source database world, every day.
Enjoy these UPDATEs!