I was wondering if it is possible to specify multiple values for datadir. We will likely have a database approcaching 16TB over the next 12 months. We use the default 4k block size which limits an EBS volume to 16TB. It would be useful if we could shard the data across multiple ebs volumes. We use innodb. I believe this could be achieved using sym links. Is there any others ways? Thanks.
Hello, this is possible with innodb_directories variable
1 Like
Thanks very much Ivan. I guess we need to upgrade to 8.0 first. We are still on 5.7. We are planning to do so though.
1 Like