Venu Anuganti Blog

Since few months, I was struggling to maintain my local system bookmarks between all my systems (3 desktops + 2 laptops); as each has its own version; and its hard to maintain them and also to keep them in sync. I found an interesting solution with Yahoo! online bookmarks; which offers easy and convenient way of managing the bookmarks online.

The factor which I really liked is; importing from your local browser and also exporting the online version to Internet Explorer or Firefox or XML compatible; so that you can reimport them back to any local browser. This is indeed a good solution to keep all bookmarks online. Not only it maintains; but when you are away from your regular systems; you can still access your bookmarks; just by logging into Yahoo! account; which anyway I do it because I access Yahoo! mail and My Yahoo! all the time.

Here is what I did to keep all my bookmarks in sync in all systems along with keeping a copy online: Exported all my bookmarks from my latop Internet Explorer browser to bookmarks.htm file Imported and exported for rest of the systems; so that all bookmarks on all systems are in sync. Opened Yahoo! online bookmarks and logged in. Click on tools -> Import bookmarks, will lead to Import bookmarks page Selected the bookmarks file and then imported under no category Now, I have all my bookmark links online. I did another export from online version to IE version of bookmarks file from tools -> export bookmarks and reimporting them on local system IE seemed to work fine.

Good to go. Even though the bookmarks failed to import directly from my browser; and filled a bug report on this to the team. This would help not to worry about export and import factors. Another interesting thing is; even if you don’t want to keep the local version of bookmarks in browser; you can stil install Yahoo! toolbar; which includes the online version of bookmaks manager within the tool itself; which is very convenient and handy and syncs with online version automatically when you add any bookmark to local toolbar.

As we all know, MySQL reads all its individual component configurations from the my.cnf file. The problem is if you have a custom build and installed the binaries with prefix; then that $prefix/etc is also added to the list of paths for searching the my.cnf

We at Yahoo! has the same scheme; where all MySQL installation goes to /home/y and yahoo setup of my.cnf file is installed to /home/y/etc/my.cnf and a symlink is added in /etc/my.cnf.

With the above setup, when you start the mysqld server, it actually reads both the files from /etc/my.cnf and /home/y/etc/my.cnf in the same order.

1
2
3

Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf /home/y/etc/my.cnf
The following groups are read: mysql_cluster mysqld server mysqld-5.1</blockquote>

That seems reasonable. The problem is; there are few config parameters which can repeat with different values like Replicate-Wild-Do-Table and Replicate-Wild-Ignore-Table. As MySQL reads both the files and the values are actually repeated as duplicates. For example; for the above parameters, when you run SHOW SLAVE STATUS you will get duplicate values:

1

Replicate_Wild_Do_Table: test.%,venu.%,test.%,venu.%

I still think this is a bug in MySQL. They should avoid the duplicate values for the same parameter even if they read it multiple times. One solution for this is explicitly passing –defaults-file=#, so that it limits to one particular file.

Recently am playing with a DLL project on Windows using visual studio 2005 on Windows Vista 32-bit (its sp1 with vista extentions installed, 8.0.50727.867). When I needed to insert a .def file to the project, it is prompting with an error; which I never seen….the error is not even an error…looks like internal error or kind of assert as in the screen shot below:

Something is wrong..now I need to find a way to add .def file so that I can export some functions as API.