(Walter Garcia) ProxySQL 1.4.2 introduced native clustering, allowing several ProxySQL instances to communicate with and share configuration updates with each other. In this blog post, I’ll review this new feature and how we can start working with 3 nodes.
Tag: Open Source
MySQL 8.0 Data Dictionary
We are all familiar with “.frm” files since the earliest days of MySQL, The community has been continuously requesting for replacement of file-system based metadata for several good reasons, So with MySQL 8.0 “.frm” files are gone for ever,
Impact of sharding on query performance in MySQL Cluster
(Mikael Ronström) A new week of blogs about our development in MySQL Cluster 7.6. After working a long time on a set of new developments, there is a lot of things to describe.
Analyze MySQL & MariaDB Error Log Messages using Monyog
(Shree Nair) The MySQL error log is an essential part of database server performance monitoring. Whenever something goes wrong or performance degrades, the Error Logs are usually the first place we look to start troubleshooting.
INPLACE upgrade from MySQL 5.7 to MySQL 8.0
(Nisha Gopalakrishnan) MySQL 8.0 General Availability was announced in April and it comes with a host of new features. The overview about the new features and improvements made in MySQL 8.0 can be found in the following blog.
How to drop a column in mysql table
(Marcelo Altmann) In this 101 article, I will show how to drop/remove a column from a table in MySQL.
Using –login-path with MySQL Cluster Manager
(Thomas Nielsen) Recent versions of MySQL has an added security feature, the –login-path option. This feature puts your username and password in an encrypted file, and you refer clients to this file instead of typing plain text passwords on the console, or putting them in scripts.
MariaDB 10.3 supports database sequences
(Vlad Mihalcea) Traditionally, both MySQL and MariaDB relied on AUTO_INCREMENT columns to generate an IDENTITY Primary Key.
MySQL InnoDB Cluster – Compatibility Matrix
(Frederic Descamps) Recently during my several talks and trips to meet the MySQL Community and MySQL InnoDB Cluster, I realized that some important message was missing. I got a lot of questions about which version of Router or Shell people should use.
MySQL NDB Cluster 7.6: Fast Import with ndb_import
(Jesper Krogh) A common problem when you need to set up a new database instance is to import the initial data. This can particularly be an issue, if you are converting an existing database so there is a large amount of data to import.