(Michael McLaughlin) While updating my class image to Fedora 27, I noticed that it installed the Akonadi Server. The documentation on the Akonadi server lacked some straightforward documentation.
Tag: Open Source
MySQL 8.0: InnoDB Introduces LOB Index For Faster Updates
(Annamalai Gurusami) To support the new feature Partial Update of JSON documents, InnoDB changed the way it stored the large objects (LOBs) in MySQL 8.0. This is because InnoDB does not have a separate JSON data type and stores JSON documents as large objects.
Installing MySQL 8.0 on Ubuntu 16.04 LTS in Five Minutes
(Peter Zaitsev) Do you want to install MySQL 8.0 on Ubuntu 16.04 LTS? In this quick tutorial, I show you exactly how to do it in five minutes or less.
Backing up users and privileges in MySQL
(Abdel-Mawla Gharieb) There are two simple ways to backup only the users and privileges in MySQL:
MySQL master discovery methods, part 5: Service discovery & Proxy
(Shlomi Noach) This is the fifth in a series of posts reviewing methods for MySQL master discovery: the means by which an application connects to the master of a replication tree. Moreover, the means by which, upon master failover, it identifies and connects to the newly promoted master.
The witching hour: How illegal datetimes get stored into MySQL in US timezones
(John Scott) Most companies make a mistake at the very beginning. They set their system time zone to Eastern, Central, Mountain, or Pacific time. Then, they install their database on it. They use all manner of timestamp and date types and insert terabytes of data.
Compiling ProxySQL 2.0.0
(René Cannaò) ProxySQL 2.0 is nearing (GA) and a lot of folks in the MySQL world are eager to check out many of the new features such as GTID consistent reads, frontend SSL and Galera native support.
My MySQL Database is Corrupted… What Do I Do Now?
(Bart Oles) How do MySQL tables get corrupted? There are many ways to spoil data files. Often, corruption is due to defects in the underlying platform, which MySQL relies on to store and retrieve data – disk subsystem, controllers, communication channels, drivers, firmware or other hardware faults.
MySQL master discovery methods, part 4: Proxy heuristics
(Shlomi Noach) This is the fourth in a series of posts reviewing methods for MySQL master discovery: the means by which an application connects to the master of a replication tree. Moreover, the means by which, upon master failover, it identifies and connects to the newly promoted master.
When ‘log sequence number X is in the future’ is a non-issue
(John Scott) While seeding a bunch of new slaves for an infrastructure (and after I had successfully seeded and started replication on several, and I can verify that the database is consistent), one of my fellow DBAs checks the mysql error log and says “INNODB CORRUPTION!!”.