# SST failed to match "Data Directory"

**URL:** <https://forums.percona.com/t/sst-failed-to-match-data-directory/3304>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [February 27, 2014, 6:21am UTC](https://forums.percona.com/t/sst-failed-to-match-data-directory/3304 "2014-02-27T06:21:20Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Moontius](https://avatars.discourse-cdn.com/v4/letter/m/f05b48/32.png) [@Moontius](https://forums.percona.com/u/Moontius)\
**Post date:** [February 27, 2014, 6:21am UTC](https://forums.percona.com/t/sst-failed-to-match-data-directory/3304/1 "2014-02-27T06:21:20Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![madhusudan](https://avatars.discourse-cdn.com/v4/letter/m/76d3ee/32.png) [@madhusudan](https://forums.percona.com/u/madhusudan)\
**Post date:** [February 27, 2014, 7:45am UTC](https://forums.percona.com/t/sst-failed-to-match-data-directory/3304/2 "2014-02-27T07:45:31Z")

</div>

did u try this…?  
Change the default datadir path in the joining node’s my.cnf file!  
datadir = path to datadir

---

<div class="post-metadata">

**Author:** ![Moontius](https://avatars.discourse-cdn.com/v4/letter/m/f05b48/32.png) [@Moontius](https://forums.percona.com/u/Moontius)\
**Post date:** [February 27, 2014, 12:21pm UTC](https://forums.percona.com/t/sst-failed-to-match-data-directory/3304/3 "2014-02-27T12:21:03Z")

</div>

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…

---

<div class="post-metadata">

**Author:** ![Moontius](https://avatars.discourse-cdn.com/v4/letter/m/f05b48/32.png) [@Moontius](https://forums.percona.com/u/Moontius)\
**Post date:** [February 28, 2014, 2:16am UTC](https://forums.percona.com/t/sst-failed-to-match-data-directory/3304/4 "2014-02-28T02:16:21Z")

</div>

I’ve found below logs which could be related

```auto
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.

```

---

<div class="post-metadata">

**Author:** ![madhusudan](https://avatars.discourse-cdn.com/v4/letter/m/76d3ee/32.png) [@madhusudan](https://forums.percona.com/u/madhusudan)\
**Post date:** [February 28, 2014, 5:37am UTC](https://forums.percona.com/t/sst-failed-to-match-data-directory/3304/5 "2014-02-28T05:37:42Z")

</div>

Ok u r looking for multiple datadir’s … right.?. Now that is something mysql don’t appreciate, u can try with creating symlinks.