[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