(Giuseppe Maxia) Up to now, the way of updating dbdeployer was the same as installing it for the first time, i.e. looking at the releases page, downloading the binaries for your operating system, unpacking it and finally replacing the existing binaries.
Tag: Open Source
MySQL Convert Binlog Based Replication To GTID Replication Without Downtime
(Bhuvanesh R) This title may be suitable for the new age MySQL Users. Because in 5.7 onwards its already supported to enable GTID online.
Check Constraints Issues
(Dave Stokes) Earlier I wrote about check constraints when MySQL 8.0.16 was released. But this week I noticed two different folks having similar problems with them. And sadly it is ‘pilot error’.
Compiling MySQL in Visual Studio. On a remote linux box.
(Georgi Kodinov) One of the perks of working on MySQL is that the code can compile (and has been compiled) on pretty much all of the modern (and no so modern) C/C++ compilers and all the modern OSes.
MySQL Python Connector
(Michael McLaughlin) While building my student image on Fedora 30, I installed the MySQL PHP Connector (php-mysqlndrp) but neglected to install the Python Connector.
FromDual Recovery Manager (rman) with progress indicator
(Shinguz) Since version 2.1.0 the FromDual Recovery Manager (rman) for MariaDB and MySQL has also a progress indicator for the restore of logical backups made with mysqldump.
MySQL 8.0 Flow Control in Group Replication
(Sri Sakthivel) We are well aware that MySQL Group Replication is one of the faster evolving clustering Technology for MySQL. Flow Control plays a key factor in Group Replication performance and data integrity.
MariaDB and MySQL Character Set Conversion
(Shinguz) Recently we had a consulting engagement where we had to help the customer to migrate from latin1 Character Set to utf8mb4 Character Set.
MySQL on Fedora 30
(Michael McLaughlin) While updating my class image to Fedora 30, I noticed that it installed the Akonadi Server. The documentation on the Akonadi server lacked some straightforward documentation.
MySQL 8.0: if I should optimize only one query on my application, which one should it be ?
(Frederic Descamps) Answering this question is not easy. Like always, the best response is “it depends” !