Posted by Singer Wang on Nov 10, 2009
Debian Linux (the underlying foundation of Ubuntu) manages the startup/shutdown of MySQL quite differently from the ways I am used to. I am a long-time user of both the MySQL binary provided by Red Hat/SuSE (along with Fedora and clones like CentOS and Oracle Enterprise Linux) and the official binary from mysql.com. After the successful restore of a cold backup, I started mysqld using the Debian provided init script. The script said that mysqld failed to start up, but in reality it did start up. Similarly, stopping mysqld fails.
The output below demonstrates the outputs and the behavior seen on a Ubuntu 8.04 LTS Server: Read the rest of this entry . . .
Posted by Brad Hudson, SA Team Lead on Sep 4, 2009
Considering my recent update to Ubuntu 9.10, I decided to have another go at getting TOra up and running. This time I am tackling a 64-bit system rather than the 32-bit “Hardy Heron” I had done previously.
On my way, I found some odd issues that I will describe here. All in all, it was a good few hours of cobbling together the pieces I needed to proudly present to you . . .
Installing TOra with Oracle support on Ubuntu 9.04 (Jaunty Jackalope)
Conventions and Caveats
- I use
sudo for everything because logging in to root shells is just bad practice.
- I plug vi whenever possible, because vi is the greatest (and to annoy emacs people).
- I did this all in a KDE desktop, which means that some things I say may sound like I use KDE. Commands issued are in pre-formatted text without any prompt gunk in front of them, so cut and paste to your heart’s content.
- Output is also in pre-formatted text and I use it sparingly where relevant. Apt likes to output lots of text. I think it’s lonely.
- Some instructions are pasted from the original so you will not need to refer to my last howto to get this working. For an all-new jocular experience, no attempts at humour were recycled.
- When I say “dep”, I actually mean dependancy.
Read the rest of this entry . . .
Posted by Sheeri Cabral on Nov 19, 2008
“There are 10 types of people in the world — those who understand binary, and those who don’t.”
The term “binary” in MySQL has many different meanings. How many can you come up with? I have 6, but I am willing to believe there are more!
0) “Binary distribution” is the name for the package that contains a binary. Another use is “binary installation” but that’s pretty much the same usage pattern as “binary distribution”, so I won’t count “binary installation” as a separate usage.
1) “Server binary” or “client binary” is the actual program (mysqld, mysql).
2) “Binary format” is a compressed format. For example, DECIMAL is stored in a “binary format” — each group of nine digits is compressed into 4 bytes.
3) “Binary log” is the change log. You can argue that this is an extension of #3, because the binary log is a compressed log, but “binary log” is encountered ubiquitously in the MySQL world, and “binary format” is somewhat obscure knowledge.
4) “Binary CHARSET” – sets the collation to be case-insensitive. For instance, utf8_bin and latin1_bin are the binary collations for the utf8 and latin1 character sets, respectively.
5) “Binary string” – a byte string. This is also known as the BINARY data type. There is some kind of wit/pun in the fact that a number in binary is actually a “bit string”.
Any more I missed? There are over 1600 mentions of the word “binary” in the 5.0 manual!
