(Keith Larson) So keepalived has been around for quite a while now …. however it is still a mystery to many.
Tag: Open Source
Install MySQL 8 on Linux with lower_case_table_names = 1
(Jesper Krogh) MySQL stores several files on disk. Even in MySQL 8 where the data dictionary is stored in InnoDB tables, there are still all the tablespace files.
Putting the ‘Fun’ In Functional Indexes
(Dave Stokes) I gave a thirty minute talk at Drupalcon this week on the features in MySQL 8.0 that would be of interest to developers and for such a short talk (and I cut slides to allow for audience questions) I could only cover the highlights.
Database Development in an Open Source World
(David Leininger) Data development in a pure open source environment is possible. In larger enterprises and consulting firms, expect to interface with internal and external systems based on a mix of open source, homegrown code, and commercial technologies.
The –bind-address option now supports multiple addresses
(Dmitry Shulga) Before the implementation of WL#11652 in MySQL 8.0.13 , the MySQL server listened to incoming connection requests either on one or all configured network interfaces.
Mysqldump vs Mysqlpump vs Mydumper
(Aakash Muthuramalingam) It is very important for every DBA’s to backup their data frequently so that they can recover data if any problems occur such as Hardware failure, System crashes, Human mistakes.
Migrate from MariaDB to MySQL on CentOS
(Frederic Descamps) On this article, I will show you how to migrate your wordpress database from the MariaDB on CentOS to the real MySQL.
How to Perform Compatible Schema Changes in Percona XtraDB Cluster (Advanced Alternative)?
(Przemys³aw Malkowski) If you are using Galera replication, you know that schema changes may be a serious problem. With its current implementation, there is no way even a simple ALTER will be unobtrusive for live production traffic.
Adding a replicated MySQL database instance using a Group Replication server as the source
(Tony Darnell) One of the best features of MySQL is the ability to use MySQL‘s built-in database replication feature to automatically replicate data from one server (source/master) to another (slave/replica).
MySQL statement level tracing
(Mahmoud Hatem) We already have seen how to gather overall MySQL server diagnostics information and how to trace a specific thread activity.