[Maria-discuss] mysqldump Spider tables
Hi list, I am using Spider Storage Engine for multiple purpose. I often create spider tables as a drop-in replacement for Federated(x) tables. But one main difference I notice using spider SE vs Federated is that mysqldump dumps the whole data of remote spider tables whereas it only dumps the table schema of federated tables. I expected these two close storage engines to behave similarly... Is this an expected behaviour of Spider SE (and/or mysqldump)? Is there a workaround to make mysqldump dump only schema of Spider tables, just like it would do with a federated table? Of course, I can use the --no-data option but it's a bit annoying when you have a mix of innodb tables and spider tables in the same database. Thanks, -- Nicolas
Hello Nicolas, Stephane has opened a task for this: https://mariadb.atlassian.net/browse/MDEV-8183 It's being reviewed and may be added in future releases. Thanks for your feature request. Regards, Guillaume 2015-05-18 16:35 GMT+02:00 Nicolas Payart <launchpad@htmledit.com>:
Hi list,
I am using Spider Storage Engine for multiple purpose. I often create spider tables as a drop-in replacement for Federated(x) tables.
But one main difference I notice using spider SE vs Federated is that mysqldump dumps the whole data of remote spider tables whereas it only dumps the table schema of federated tables.
I expected these two close storage engines to behave similarly...
Is this an expected behaviour of Spider SE (and/or mysqldump)? Is there a workaround to make mysqldump dump only schema of Spider tables, just like it would do with a federated table?
Of course, I can use the --no-data option but it's a bit annoying when you have a mix of innodb tables and spider tables in the same database.
Thanks, -- Nicolas
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
I have read Stephane's PR and his proposal to add an option to mysqldump (--no-data-med) taking into account Spider tables. This is exactly what I need! Thank you, Nicolas
Le 20 mai 2015 à 19:13, Guillaume Lefranc <guillaume@adishatz.net> a écrit :
Hello Nicolas,
Stephane has opened a task for this: https://mariadb.atlassian.net/browse/MDEV-8183 <https://mariadb.atlassian.net/browse/MDEV-8183>
It's being reviewed and may be added in future releases.
Thanks for your feature request.
Regards, Guillaume
2015-05-18 16:35 GMT+02:00 Nicolas Payart <launchpad@htmledit.com <mailto:launchpad@htmledit.com>>: Hi list,
I am using Spider Storage Engine for multiple purpose. I often create spider tables as a drop-in replacement for Federated(x) tables.
But one main difference I notice using spider SE vs Federated is that mysqldump dumps the whole data of remote spider tables whereas it only dumps the table schema of federated tables.
I expected these two close storage engines to behave similarly...
Is this an expected behaviour of Spider SE (and/or mysqldump)? Is there a workaround to make mysqldump dump only schema of Spider tables, just like it would do with a federated table?
Of course, I can use the --no-data option but it's a bit annoying when you have a mix of innodb tables and spider tables in the same database.
Thanks, -- Nicolas
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss <https://launchpad.net/~maria-discuss> Post to : maria-discuss@lists.launchpad.net <mailto:maria-discuss@lists.launchpad.net> Unsubscribe : https://launchpad.net/~maria-discuss <https://launchpad.net/~maria-discuss> More help : https://help.launchpad.net/ListHelp <https://help.launchpad.net/ListHelp>
participants (2)
-
Guillaume Lefranc -
Nicolas Payart