# cluster how to read ibdata file

**URL:** <https://forums.percona.com/t/cluster-how-to-read-ibdata-file/2866>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [August 7, 2013, 4:29am UTC](https://forums.percona.com/t/cluster-how-to-read-ibdata-file/2866 "2013-08-07T04:29:55Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mssatheesh87](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mssatheesh87/32/944_2.png) [@mssatheesh87](https://forums.percona.com/u/mssatheesh87)\
**Post date:** [August 7, 2013, 4:29am UTC](https://forums.percona.com/t/cluster-how-to-read-ibdata-file/2866/1 "2013-08-07T04:29:55Z")

</div>

Hi,

Actually we have nearly above 600Gb of data but i have one doubt is .ibd and ibdata1 both are needed? because db contains 300Gb and ibdata contains 320 GB … And mysql taking much time to start…

---

<div class="post-metadata">

**Author:** ![percona.jayj](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/percona.jayj/32/927_2.png) [@percona.jayj](https://forums.percona.com/u/percona.jayj)\
**Post date:** [August 7, 2013, 6:52am UTC](https://forums.percona.com/t/cluster-how-to-read-ibdata-file/2866/2 "2013-08-07T06:52:59Z")

</div>

You can’t have one without the other in Innodb – the ibd files and the ibdata1 are inseparable and you must copy them all over.

If the ibdata1 is bloated with a bunch of empty space, there’s only one way to shrink it. The first answer here: [url][database - How to shrink/purge ibdata1 file in MySQL - Stack Overflow](http://stackoverflow.com/questions/3456159/how-to-shrink-purge-ibdata1-file-in-mysql%5B/url%5D)

---

<div class="post-metadata">

**Author:** ![mssatheesh87](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mssatheesh87/32/944_2.png) [@mssatheesh87](https://forums.percona.com/u/mssatheesh87)\
**Post date:** [August 9, 2013, 2:05am UTC](https://forums.percona.com/t/cluster-how-to-read-ibdata-file/2866/3 "2013-08-09T02:05:14Z")

</div>

Thanks For your reply… I will check with that link and let you know. And we have mysql 5.1.39 and innnodb version is 1.0 … what is the basic requirement for percona clusterand xtarbackup

---

<div class="post-metadata">

**Author:** ![mssatheesh87](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mssatheesh87/32/944_2.png) [@mssatheesh87](https://forums.percona.com/u/mssatheesh87)\
**Post date:** [August 14, 2013, 4:11am UTC](https://forums.percona.com/t/cluster-how-to-read-ibdata-file/2866/4 "2013-08-14T04:11:04Z")

</div>

Hi tried the link you gave it is working… But mysqldump took 8 hrs and mysql restore took 30 hrs… how to avoid this much time…

---

<div class="post-metadata">

**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\
**Post date:** [August 16, 2013, 8:53am UTC](https://forums.percona.com/t/cluster-how-to-read-ibdata-file/2866/5 "2013-08-16T08:53:43Z")

</div>

If you re-created your data by dumping/reloading to/from sql dump, you can use this new instance as binary data source for more nodes, no need to dump/load again.  
But in general for SQL dumps, you may try tools like mydumper/myloader to speed the process up.