If you’d like a service to load / start on bootup or during a system restart then CentOS has a very easy way to achieve this. A utility called chkconfig, you can use it from the terminal as follows
Add named and mysqld services to chkconfig
chkconfig --add named chkconfig --add mysqld
Start named and mysqld at startup as follows
chkconfig named on chkconfig mysqld on
Remove named and mysqld from startup as follows
chkconfig named off chkconfig mysqld off
Check which services are associated with chkconfig and whether they are set to start at bootup or not
chkconfig --list