Announcement

Announcement Module
Collapse
No announcement yet.

SST failed to match "Data Directory"

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • SST failed to match "Data Directory"

    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
    Last edited by Moontius; 02-27-2014, 11:53 AM.

  • #2
    did u try this..?
    Change the default datadir path in the joining node's my.cnf file!
    datadir = path to datadir

    Comment


    • #3
      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...

      Comment


      • #4
        I've found below logs which could be related


        Code:
        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.

        Comment


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

          Comment

          Working...
          X