ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Databases & messaging · #mariadb
A MariaDB schema must handle event logging across multiple regional time zones while ensuring data remains consistent during daylight savings transitions. The goal is to maintain a reliable audit trail that can be retrieved in the local time of the event origin. Two documented approaches exist: using TIMESTAMP columns, which automatically handle UTC conversi
I have a process that exports the data from an AWS RDS MariaDB using mysqldump which has been running succesfully in a docker-image on Concourse for years. Since two nights ago the process has started failing with the error: mysqldump: Couldn't execute 'FLUSH TABLES WITH READ LOCK': Access denied for user 'admin'@'%' (using password: YES) (1045) The official
Goal: achieve identical identifier case‑sensitivity behavior for tables between a typical Windows development server and a Linux production server so that application queries succeed in both environments. Constraint: the lower_case_table_names variable can only be set at server startup; changing it after InnoDB tablespaces have been initialized requires a lo
