(Alexander Rubin) TiDB is an open-source distributed database developed by PingCAP. This is a very interesting project as it is can be used as a MySQL drop-in replacement: it implements MySQL protocol, and basically emulates MySQL. PingCAP defines TiDB is as a “one-stop data warehouse for both OLTP
Tag: Open Source
MySQL InnoDB Cluster – Controlling data consistency and expel timeouts
(Miguel Araújo) This blog post follows the series that we have been composing to detail every single new feature added in the latest MySQL InnoDB Cluster release.
Your ORM and SELECT FOR UPDATE
(Baron Schwartz) If you use a programming language framework such as Django or Ruby on Rails, chances are you use an ORM to help you construct queries.
MySQL Partition pruning Explained
(Aakash Muthuramalingam) Partitioning is a process in which a single larger table is split into several smaller tables (physically) and still considered as a single table.It is generally a good idea for the tables whose size is in a few 100 GB’s.
MySQL 8.0.14: A Road to Parallel Query Execution is Wide Open!
(Alexander Rubin) For a very long time – since when multiple CPU cores were commonly available – I dreamed about MySQL having the ability to execute queries in parallel.
Group Replication – Consistency Levels
(Nuno Carvalho) The MySQL Group Replication (GR) feature is a multi-primary update anywhere or single-primary replication plugin for MySQL with built-in conflict detection and resolution, automatic distributed recovery, and group membership.
MySQL InnoDB Cluster – Changing cluster options ‘live’
(Miguel Araújo) As listed in the release announcement of the latest MySQL InnoDB Cluster release, 8.0.14 brings exciting new features! This blog post integrates a series detailing every single new feature added.
Training spaCy’s Parser for Conversational Applications
If you already have some experience with spaCy, you know that there are a lot of pre-trained statistical models that can be put in use immediately. These models are not trained however to work in certain areas. In other words, they may not be specific to your domain. This may push you to consider improving an existing model or creating...
How to manually decrypt an encrypted binary log file
(João Gramacho) The encrypted binary log file format introduced in MySQL version 8.0.14 was designed to allow a “manual” decryption of the file data when the value of the key that encrypted its file password is known.
New in MySQL 8.0.14 – CREATE UNDO TABLESPACE
(Kevin Lewis) The newest release of MySQL 8.0.14 includes the ability to control the number and location of UNDO tablespaces using SQL. Users can now manage UNDO tablespaces using SQL from the MySQL client.