Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 17

Displaying posts with tag: FreeBSD (reset)

On operating system upgrades and a packager’s nightmare
+1 Vote Up -0Vote Down

A fairy tale

Once upon a time I did an operating system upgrade, a minor one that should do no harm, but just get me up to date by fixing any bugs in the version I had been using. It seemed like a good idea.

All seemed to be fine. I use a package provided by an external vendor and not the one produced by the operating system provider as this vendor provides a newer version of the package and I need that. The vendor has to make his package fit in the os environment his package is built for and normally does a pretty good job.

I use automation to build my systems and when I built a new one some issues appeared. Related to the new version of the OS the provider had enhanced one of his packages and the installation pulled in new dependencies. The install of the external package I use then broke as it conflicted with the new dependency

  [Read more...]
Moved to a new hosting provider
+0 Vote Up -0Vote Down

Again, I have moved to a new hosting provider after my free-tier with Amazon EC2 expired.  As usual I was looking for a good VPS provider with a decent price, providing good support and in particular a provider supporting FreeBSD, my favorite OS for server (for desktop I still prefer GNU/Linux.)

This time I have carefully reviewed many options and have finally settled with RootBSD, one of the reputed VPS hosting providers if you are choosing FreeBSD as your server OS.  One of the prime reasons for choosing FreeBSD is its performance, stability and the

  [Read more...]
[FreeBSD] unicorn.god
+0 Vote Up -0Vote Down

I had a very strange problem concerning my Ruby on Rails installation, using FreeBSD, nginx, Unicorn and God.

When starting god from the command line as root, everything worked. However, as soon as I placed the god command into /etc/rc.local or a even service file in /usr/local/etc/rc.d, god didn’t start the Unicorn server but showed exit code 127 for “bundle exec unicorn -E production -c config/unicorn.rb”.

So I added a log directive to the god configuration and looked at the log file. It said:

env: ruby1.9: No such file or directory

Then I changed the god configuration to include /usr/local/bin in the PATH and now everything works. Here my configuration file:

RAILS_ROOT = '/srv/www/my-project-prod/current'

God.watch do |w|
    w.name = 'my-project'
    w.interval = 30.seconds

    w.uid = 'my-project'
    w.gid =
  [Read more...]
MariaDB in FreeBSD ports tree
+3 Vote Up -0Vote Down

You can now find MariaDB 5.2 in your ports tree in FreeBSD. Check out ports/databases/mariadb. Its currently at MariaDB 5.2.4 and the package maintainer will continue updating it as new releases are made. Naturally the documentation in the Knowledgebase has been updated to reflect this.

tcpdump errors on FreeBSD for mk-query-digest
+0 Vote Up -0Vote Down

While I use this tcpdump command for MySQL query analysis with mk-query-digest, I found recently that it didn’t work on FreeBSD

$ tcpdump -i bge0 port 3306 -s 65535 -x -n -q -tttt -c 5
tcpdump: syntax error

It left me perplexed and reading the man page seemed to indicate my options were valid. I tried a few variances just to be sure without success.

$ tcpdump -i bge0 -c 5 port 3306 -x
tcpdump: syntax error
$ tcpdump -i bge0 -c 5 port 3306 -q
tcpdump: syntax error
$ tcpdump -i bge0 -c 5 port 3306 -tttt
tcpdump: syntax error

The solution was actually quite simple in the end, it had nothing to do with the commands, it had everything to do with the order of them. Placing port as the last option solved the problem.

$
  [Read more...]
PostgreSQL – Rock Solid in the face of forking MySQL
+3 Vote Up -13Vote Down

Ever since Sun Microsystems agreed to acquire MySQL back in 2008 (http://www.mysql.com/news-and-events/sun-to-acquire-mysql.html), there has been a fair bit of uncertainty and chaos surrounding the world’s most popular Open Source database. With many big names in the MySQL community pulling in different directions and the recent Oracle / Sun acquisition, the choice of which Open Source database to use is now easier than ever –

  [Read more...]
Merry Christmas!
+0 Vote Up -0Vote Down

I spent the last month taking a break from Open Source, partly due to FreeBSD 7.1 failing to hit the FTP servers as scheduled (any excuse), but mostly due to Santa’s early delivery of Ableton Live. Not really Open Source I may add but extremely cool nonetheless and a much needed break from coding!.

I find that staring too much at code can hamper the creative process (hehe), and as you know Creativity and Innovation go hand in hand with Open Source Software!.

Speaking of which, while I have been busy playing with waveforms and elastic audio, the Open Source world has been all guns blazing with cool releases like MySQL 5.1 GA

  [Read more...]
Success with OpenSolaris + ZFS + MySQL in production!
+0 Vote Up -0Vote Down

Pimp My Drive by Richard and Barb

There’s remarkably little information online about using MySQL on ZFS, successfully or not, so I did what any enterprising geek would do: Built a box, threw some data on it, and tossed it into production to see if it would sink or swim.

I’m a Linux geek, have been since 1993 (Slackware!). All of SmugMug’s datacenters (and

  [Read more...]
Code Me In!
+0 Vote Up -0Vote Down


If you are security conscious and nowadays who isn’t?, you may have pondered over ways to make your external SSH connection safer.
Of course there’s always One-time Passwords and Public Keys, but if like me you watch the daily barrage of brute force attacks you may be thinking it’s only a matter of time…

That’s what I was thinking at about the same time an SMS arrived on my mobile….then it hit me….I take my mobile everywhere, if only my server could call me and ask if it is really me trying to log in.

My first instinct was to try and



  [Read more...]
MySQL RSS Feeds
+0 Vote Up -0Vote Down
Issue Five of MySQL Magazine just came out and it included the results from its Annual MySQL Usage Survey. Among a bunch of other cool information, it asked the question: “What is your favorite blog?” (Q26). The results were as follows: The first interesting thing that I noticed was that the #1 [...]
MySQL Snapshots on FreeBSD
+0 Vote Up -0Vote Down

I read a lot about MySQL (http://www.mysql.com) backups using LVM Snapshots on Linux, WAFL Snapshots on NetApp and more recently ZFS Snapshots. But did you know you can do the same under FreeBSD?

FreeBSD has had snapshot capability since around 2001 allowing administrators to take a frozen image of a

  [Read more...]
Trouble in OpenSource paradise
+0 Vote Up -0Vote Down

Whenever I decide to take a holiday I can usually guarantee that something cool will occur in the IT industry in my absence.

Now this holiday has been slightly different in many ways. I had to cancel my flight due to a sudden onset of Vertigo 1 day before I was supposed to fly. If like me you have never experienced Vertigo before, thank yourself lucky!. Having no sense of balance and intense room spin whenever you open your eyes is no fun at all, it took at least 2 days for me to stop being sick.

Having been able to actually use my laptop in the last couple of days I notice that the “cool thing” I usually miss on holiday turns out to be

  [Read more...]
Roundup.
+0 Vote Up -0Vote Down
  • alias skedit='open -a skEdit' is highly useful. Now I can do skedit foo.php and it opens it up. What joy with such simple things.
  • Great to see Mono go into Rawhide, meaning FC5 Test 2 will have it. Now I can’t hardly wait. On PPC, if we had Xen working (upstream), life would be the ultimate breeze.
  • I will not be making it to linux.conf.au 2006 in New Zealand. Despite all good attempts to get a flight leaving KL, I can’t. Well, affordably (hello coach class). Registrations however are still open. There’s a Red Hat/Fedora meetup, and Joshua Wulf would be a useful person to contact if you’re rocking up for it (email discussion still has dates
  • Is there a reason Fedora disabled updatedb running by default? Now users actually need to specify yes, in /etc/updatedb.conf. Why? Was this for laptop
  [Read more...]
FreeBSD 6 is lookin sexy!
+0 Vote Up -0Vote Down
Came across an article today linked to off the FreeBSD site that had some particular interest to me. I've had a lot of people tell me that Linux works better for database because of its supported filesystems. Well not for much longer!

"New performance improvements in FreeBSD 6 will take advantage of the new SMP architecture. It will also have the ability to scale to eight, 12, and 14 processors. The filesystem is now multithreaded, which, according to Long, will allow for much better performance of mail servers and database servers."

Which is awesome to hear, better SMP support and multithreaded file systems! FreeBSD community never ceases to amaze me. The article also talked about some neat features coming in the new version of OpenBSD which should make it an even better platform for BSD based router /



  [Read more...]
FreeBSD 6 is lookin sexy!
+0 Vote Up -0Vote Down
Came across an article today linked to off the FreeBSD site that had some particular interest to me. I've had a lot of people tell me that Linux works better for database because of its supported filesystems. Well not for much longer!

"New performance improvements in FreeBSD 6 will take advantage of the new SMP architecture. It will also have the ability to scale to eight, 12, and 14 processors. The filesystem is now multithreaded, which, according to Long, will allow for much better performance of mail servers and database servers."

Which is awesome to hear, better SMP support and multithreaded file systems! FreeBSD community never ceases to amaze me. The article also talked about some neat features coming in the new version of OpenBSD which should make it an even better platform for BSD based



  [Read more...]
Server Monitoring
+0 Vote Up -0Vote Down
So about a month ago we put in a new hosting infrastructure and me as the sole admin needed an easy way to monitor and keep an eye on all of my servers and the services and resources of each server.



So after some digging around I found that an application I use to use was now a new application Nagios. Now this application is great, took me about 2 days to set everything up as it is now, but once I found everything i needed it was great. Nagios uses SNMP Protocol to monitor almost anything on your server. It has a very OO configuration allowing you to reach some pretty complex setups. Mine didn't get too complex so i can't speak to all of that but



  [Read more...]
MySQ5 and the almighty ARCHIVE Engine
+0 Vote Up -0Vote Down
A while back I wanted to test the ARCHIVE Engine in MySQL 5 on FreeBSD, well I had to do some jinkying around with the Makefile to add the options i needed to turn on the ARCHIVE Engine. I haven't seen it committed to the port yet so here it is:

# diff Makefile Makefile.orig
68,71d67
150d145

After getting it compiled i ran a series of tests to see how it was working and to check the speed and how it compared to storing my data in a MyISAM table. Here is some of the stats...

mysql> SHOW TABLE STATUS LIKE 'campaign_16_long_myisam';
+-------------------------+--------+----------+
: Name : Engine : Rows :
+-------------------------+--------+----------+
: campaign_16_long_myisam : MyISAM : 28224724 :
+-------------------------+--------+----------+
1 row in set (0.00 sec)















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

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.