THis is not a maya issue please ask this on a python language board prefeerably one that relates to MySQLdb!
Generally you would just keep one directory for 64 bit libs and a second one for all 32 bit ones maybe a 3rd for pure python ones. Then just dont point the 64 bit to the 64 bit librtary path and 32 bit to 32 bit path. You can easily accomplish this by manipulating the maya env file under the version number pref directory.
PS: please dont change package names, this may have consequences as the packeges may point back to themselves and theese pointing mechanisms dont allways magically know that you changed the name of a package
PPS: if you want to do this dynamically in the python init then see into using the platform module or possibly sys.maxsize
