MySQL QA

MySQL QA In the 5.1 release MySQL Cluster will support replication to another MySQL installation. The replication is handled using Row Bases Replication instead of Statement Based Replication. I have been testing it for about a year now and it has gotten really hard for me to break at this point, but I am still trying. So what is so cool about Cluster Replication? Good question! One answer: Cluster Replication really gives a company five 9's (99.999%) in up time. You can have a Master Cluster in the main site supporting the business and have another Slave Cluster in a total different site that can be used as a backup for times there are issues with main site. In addition, the Slave Cluster can also be used for reporting or data mining to take that traffic off of the main Cluster. How hard is it to setup? Another great question. Answer: Easy So to set it up, you would create two set of Clusters configured the way that you wanted them. You configure the Master MySQLD to create a bin ...

MySQL QA Now that we have Disk Data for MySQL Cluster you can have the best of both worlds. You can use memory tables for those needing quick access and updates and Disk Data Files for those that will be too large to keep in memory all the time. One issue with this first release is not having the ability to spread the data and undo files accross the disk sub system using the config.ini file. This can be a important issue for performance. You really don't want to have everything on one disk. Here I list a work around for moving undo and/or data files off to different drives to help in disk performance that I used during performance testing. 1) Bring up the cluster to include all data nodes 2) Each data node will create its own File System ((e.g. ndb_#_fs) where # == the DN ID)). 3) Under the data node FS create the symbolic links pointing to the other drives: Examples Single Data Node: [ndb_2_fs]$ ls D1 D10 D11 D2 D8 D9 LCP [ndb_2_fs]$ ln -s /data0/log1/ dn_logs [ndb_2_fs]$ ln...

MySQL QA Testing 5.1 MySQL CLuster is moving along. We now have more automated test cases, have been using TPC-B and DBT2 in testing, conducted load and HA testing. The great news is that many issues are now found early before the customer base has to deal with them. This relase will be packed full of great stuff for Cluster including the first release of Disk Data and Replication for MySQL Cluster. The MySQL User Conf is just a few weeks away where much of this will be shown. Hope to see you there.