If you are planning to synchronise the data from one to another, that should
not be rocket science. However, if you want both database servers to update
the data, you're in for something rather heavy.
In the easy case, I would probably get the replication feature to output all
the database
Hello everyone
I have a question. In a MySQL 3.23 server running on Linux (RH 7.x), can I
symlink the data files and index files of MyISAM tables to different disks
for better performance? After RTFM, it seems that commands alter, repair and
optimize will migrate the files back to the same disk
Actually, you might want to play with sed or perl.
mysqldump -u root --no-create-info -q --all-databases | sed s/'INSERT INTO
acctlog'.*//
is a first draft, although perhaps not optimal in speed. It will remove all
acctlog inserts from all databases. You might want to play a bit with shell
I use XFS. Though my benchmarking is incomplete, it appears that it
outperforms ReiserFS and Ext3 on large files. This is probably due to the
fact that XFS was developed by SGI, whose systems work on large
Audio/Visual files.
Beware that you'll need to spend more time on your kernel once you
Hello, everyone
I have the following situation:
After enjoying problems related to deleting a large portion of a table,
subsequent slow selects and such, I decided to do an alternate route when
removing data from a table:
The table had transactions for one year, and the table really only needs
If you're looking to qoute strings in perl, your DBI handle has a function
called quote:
$quoted_string = $dbh-quote($unqouted string)
I believe you need to be connected to your database server in order to use
this, and I am not POSITIVE whether this works for all RDBMS servers.
Jeppe