Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 7

Displaying posts with tag: uh... (reset)

Oh dear MySQL slave, where did you put those rows?
+0 Vote Up -0Vote Down

I need help from my fellow mysql users.  I know some of the people who read this are alot better then me with mysql so hopefully you can help

So today we decided that we are going to migrate one of our master database servers to new hardware.  Since we got the hardware this morning and we wanted to move on to it asap, we decided that we will take our slave down, copy data from it, and bring it up on future master server.  At that point, we will let it run as slave to the current master server until its time for us to take it down.  Reason we did that instead of mysqldump/import was to avoid the lag mysqldump creates on our server.

After we did all this and put up the new master server, we started to notice odd issues.  After looking around and comparing old db with new, we found out that

  [Read more...]
MySQL database backup file compression: gzip vs bzip2
+0 Vote Up -0Vote Down
In one of my previous posts: MySQL backups, I talked about using a script for automating backups. I show that we can use gzip to compress backup file to compress and save. Since then, our backup file has been growing meg or two a day which is causing our backup files to get [...]
Linux time - Daylight saving time (DST)
+0 Vote Up -0Vote Down

Its that time of the year again when time changes and we have to make sure our servers are using the right zone with right time. Out of many servers I admin, I found 3 servers which had wrong time displaying. All of them had one thing in common, Fedora Core 4. So I fixed it by doing the folowing.

mv /etc/localtime /etc/localtime.old

ln -s /usr/share/zoneinfo/PST8PDT /etc/localtime

Oven which can do things for you if you send it email or call it!
+0 Vote Up -0Vote Down

I was browsing the web today and stumbled upon this. This oven line is great! but come to think of it, how many people can afford to buy this $7k+ gadget (see this MSN coverage). Even if they could buy it, how many will actually would call their oven or email their oven and tell it to cook? I do have to say its a great concept and honestly if I was a millionaire who could afford to buy cool gadgets, I wouldn’t mind getting one of these. Heck, if I owned a house here in LA, it would be something I would consider putting in my kitchen. It would be interesting to see what happens in next few years when gadgets like these might become normal appliances you

  [Read more...]
Windows Vista Ultimate installation (update 1)
+0 Vote Up -0Vote Down

While looking through my new Vista, I found out that my cpu is 64bit capable! I was like.. OMFG hell yeah! I whipped out the 64bit Vista DVD and nuked all my hard work of setting up software without even giving it a second thought… About 20 mins later, I was back in my new found love, except this time I dove right into installing software. One by one, I get basic stuff installed in following order:

  • daemon tools (went out and got the upgraded vista version) no problems
  • Microsoft Office 2007 ultimate, uh.. thank god no problems there
  • McAfee VirusScan, ofcourse problems.. knew that from 32 bit version but what the hell.. was worth a try
  • Trillian - another no problem
  • VMWare Server………………………………………….PROBLEMS! Sigh.. they don’t support
  •   [Read more...]
    Google mini blues - 406 ownage!
    +0 Vote Up -0Vote Down

    We used to use Google mini to index our site to serve search results to our users. It worked great for a while until sometime back it just stopped indexing. It would get a fatal error and stop index after couple urls. It was also not so kind about sending me an email to let me know that it has stopped indexing. It was still serving pages which were indexed prior to this so we didn?t realize it wasn?t indexing new content.

    And than one day we logged in to the admin console to see whats going on with it and found out it wasn?t indexing. I checked the logs and found out that it was stopping due too too many 4xx errors. After looking at logs on our web server I found out that it was stopping because Apache was giving back 406 response code which is described at as:

    The resource identified by the request is only capable of generating response entities

      [Read more...]
    Can I get your name?
    +0 Vote Up -0Vote Down

    So I go to my favorite coffee place, Starbucks, pretty much every day. I always get the same thing which recent has been: tall vanilla latte, %, no foam. And they always ask me for my name which I always respond by saying: Sunny. Most of the time, not all, they get my name wrong. I don’t understand why is it so hard for people to write down Sunny. I am ok even if they just write Sonny, which is the most common misspelling of my name, but Starbucks staff always find creative ways of spelling “Sunny”.

    I have seen following names.. and I am not kidding or making up any of them. All the people who go with me to Starbucks know this! Here is the list I have so far: Sunny, Sonny, Suni, Sunee, Suuniee, Suney, Suny and the one I have in front of me which made me blog this, Sunni.

    So if any Starbucks staff reading this, could you explain to me how come you guys are

      [Read more...]
    Showing entries 1 to 7

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.