I have a Mysql db that is loaded with about 500,000 records a night using LOAD DATA INFILE. This goes on for a month then a new table is created and so on. Then data is then just queryed nothing else.
To take some stress off of this server I was wondering if there is a way to have One Mysql server for loads and one to do querys?? I was thinking of turning on tcp/3306 and have a Load server use LOAD DATA LOCAL to load the data over tcp. So the current server would bascailly become my query server. Can you use LOAD DATA that way??? If not please direct me to the mysql tool that will do this, or a smarter way? thanks,rob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
