Not the answer you need?
Register and ask your own question!

SST failed to match "Data Directory"

MoontiusMoontius EntrantInactive User Role Beginner
Hi Everyone,

Assuming I create a table such as below on Server A on stand alone mode:

CREATE TABLE external (x int unsigned not null primary key) DATA DIRECTORY = '/mnt/external1/data';

The new server that joins the cluster (Server A) does not apply the location of table into "/mnt/external1/data"

The table "x" must be save be saved in "/mnt/external1/data" but instead it is saving in default "datadir" path ("/var/lib/mysql") .

How to overcome this?

Regards

Comments

  • madhusudanmadhusudan Contributor Current User Role Beginner
    did u try this..?
    Change the default datadir path in the joining node's my.cnf file!
    datadir = path to datadir
  • MoontiusMoontius Entrant Inactive User Role Beginner
    My datadir on all servers are the same,
    I only want to relocate small tables that are frequently accessed to SSD hard drive or RAMFS location for fast read/write...
  • MoontiusMoontius Entrant Inactive User Role Beginner
    I've found below logs which could be related

    2014-02-28 15:40:43 18680 [ERROR] InnoDB: A tablespace for database_sample/external has been found in multiple places;
    2014-02-28 15:40:43 18680 [ERROR] InnoDB: Default location; ./database_sample/external.ibd, LSN=0, Space ID=1681, Flags=0
    2014-02-28 15:40:43 18680 [ERROR] InnoDB: Remote location; /data/mysql/database_sample/external.ibd, LSN=0, Space ID=1681, Flags=0
    2014-02-28 15:40:43 18680 [ERROR] InnoDB: Will not open the tablespace for 'database_sample/external'
    2014-02-28 15:40:43 18680 [ERROR] InnoDB: Tablespace open failed for '"database_sample"."external"', ignored.
    
  • madhusudanmadhusudan Contributor Current User Role Beginner
    Ok u r looking for multiple datadir's .. right.?. Now that is something mysql don't appreciate, u can try with creating symlinks.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.