The latest from the MySQL community

Today, I am going to tell very interesting use-case where we have used Blackhole engine as replication filter.
We have an Aurora Cluster(let's call it C1) where multiple db's are hosted and multiple applications are writing data into it. While in another project one application wanted to read the data from one of the db's hosted on aurora cluster C1 & this new project is hosted into another account.
Now the challenge is we don't want self hosted db which supports replication filters(replicate-do-db) and bring …

I came across a scenario where we were concerned about the size of a table, a 134G table, its a pretty huge table and growing fast. The nature of the table – its a table which contains logs , sort of a audit table. Some fundamental questions around this table’s use: 1) would it have a lot of reads ?  — Answer –  No 2) is it always insert only? — Answer – Yes 3) current strategy to restrict size ? — Answer – delete data from table. 4) does one need backup of the table, i.e. is it very important ?  — Answer – No Well based on the above, it would seem that logging is the theme. Schema of the table: CREATE TABLE `SystemLogs` (   `column1` varchar(255) DEFAULT NULL,   `column2` varchar(255) DEFAULT NULL,   `column3` varchar(255) DEFAULT NULL,   `column4` varchar(255) DEFAULT NULL,   `column5` text,   `column6` text,   `timestamp` datetime DEFAULT NULL,   `id` int(11) …