Richard,
Andrew Hutchings wrote:
> Hello Richard,
>
> On Tue, 2009-10-27 at 12:44 -0400, Richard McCluskey wrote:
>> My question is this though: I have a DB with 2 stored procedures, and a
>> couple of functions. When I do a complete backup of my cluster, and a
>> full restore, are these functions and stored procedures included in the
>> cluster backup? It is not immediately obvious where they live in the
>> cluster-world, so I have no real way of testing for it.
>
> Stored procedures and functions are unique to the individual mysqld
> nodes so are not part of the NDB backup. You will need to use mysqldump
> (or similar) to back these up.
More specifically they are stored in the proc table of the mysql
database. Take a look, select * from mysql.proc.. there they are.
--
Tom Hanlon
>
> NDB backups only backup the data nodes, the data nodes have a copy of
> the table schemas inside them for the ndb tables (the metadata part of
> the restore) which is why these are restored from the backup.
>
> Kind Regards
