|
Today's tech notes...
I'm in the process of migrating the comments from MySQL to Postgres, which is a more robust database. Right now we're making two copies of each comment, one to each database, while I copy the old comments a month at a time. Occasionally things will get out of synch, but I'm hoping they'll be brought back to where they're supposed to be when the process is done.Once I've moved the comments, which is the largest table, I'll move the articles. When they've been moved, I'll shut down MySQL. If Postgres isn't robust enough to handle the load -- which it should be -- I can always use Oracle. I'll just have to rewrite major chunks of my code, rather than the minor chunks I'm dealing with now. Posted by: Fred 2007-06-06 |
| http://www.rantburg.com/poparticle.php?ID=190142 |