An aquarium pump including a first unit comprising a magnet in an encasement disposed against the outside panel of an aquarium or other tank, and a second, submersible unit comprising a magnet in an encasement and a motor, an impeller, and buoyant material contained within a chamber disposed against the inside panel of an aquarium or other tank and opposing the first unit. The magnet included on the second, submersible unit includes a plurality of recesses into which are inserted synthetically coated ball bearings that are allowed rotate freely, with a portion of the ball bearings extending outside the magnet thus allowing the ball bearings to make contact with the aquarium or tank wall and allowing the second, submersible unit to be maneuvered into place without the necessity of violating the aquatic environment. The buoyant material allows the second, submersible unit to remain fixed in place solely utilizing magnetic attraction.An aquarium pump comprises an outer member a side of which is disposed adjacent an exterior surface of a sidewall of an aquarium and a submersible inner member defining at least one slot for facilitating intake of water by the inner member and/or including an outflow port for facilitating outflow of the water from the inner member through the port by an impeller and into the aquarium. A side of the inner member is disposed adjacent an interior surface of the sidewall and opposing the outer member such that the sidewall is interposed between the members. The members are magnetically attracted and, in turn, movably retained in a fixed position relative to one another, the pump is “centrifugal,” and a motor and the impeller and slot and/or outflow port provide adequate power and intake and outflow of the water to create a variable current of the water in the aquarium.