-
MySQL replication notes 2:replicating only certain databases
Here is my notes on setting up replication on MySQL. In a lot of cases, that is not good enough, because it replicates EVERYTHING from the master to slave(s), whereas you may just want one or two databases replicated. At first I thought I could just add this to /etc/my.cnf on the slave: [mysqld] replicate-do-db=MyDb…
-
MySQL replication notes 1: replicating all databases
A couple of weeks ago, a friend asked about replication on MySQL 4.1.7. I’ve worked with replication in the past, just a quick and dirty job on MySQL 5, and soon forgot about it. This time, I wanted to do it on MySQL 4, and make sure I take good notes for my own benefit.…
-
Drop all indexes in Sql Server 2005
Here is a script I wrote to generate a script to drop all indexes that are not primary keys. This works for Sql Server 2005. The main thing it uses is sp_MSForEachTable, an undocumented stored procedure. Run the generated script, and you will be good to go. This is especially useful before a bulk load…
-
Oracle 10g Express Install Part 2
After my last failed Oracle 10g Express install due to insufficient memory, I purchased some memory from eBay, and started it over. This time, the first thing the installer noticed was that the swap file is not big enough. I fixed that by doing a total re-install of Fedora Core 2. Yeah, I know that…
-
Katmai installation notes
I downloaded and installed Katmai, code name for Sql Server 2008, a few weeks ago. My friend Scott Whigham has a great post on it. Here are some of my own observations: 1. The installation process is very similar to that of Sql Server 2005. Here is one screen shot of feature selections: 2. If…