The Ji Village News

Category: MySQL

  • Migrating from one RDBMS to another

    Here is some of my thoughts on migrating MySQL to Sql Server. It came out of an email discussion. I’d love to hear your thoughts on migrating to a different database platform, not just MySQL to Sql Server. I actually thought about writing a white paper or even a course on migrating from MySQL to…

  • Character set and collation for simplified Chinese — MySQL

    I am curious about character sets and collations, especially how they are used in databases. I got some time to play with them recently. I did some testing today on MySQL. I will do the same test on Sql Server, Oracle, and PostgreSql, time permitting. I am only dealing with simplified Chinese at this point.…

  • 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.…

  • MySQL and Daylight Savings Time change

    In a previous post I mentioned about patches needed to accomadate the new DST changes for Sql Server. (I know, this is one of Dannyman’s favorite subjects ;)) For MySQL, obviously you need to patch the host server first. Then you need to find out if MySQL needs separate work. Here is a note I…