There's more noise about Solaris competing with Linux over at slashdot. I can understand the argument that Sun should direct their efforts to Linux. You know, Peace, Love, Linux. But which business would throw away their crown jewel to compete in the delivery of a product that already has a leading vendor (by some distance over #2)? Can you imagine asking MySQL to get into the Oracle support business (imagining that Oracle open sources their products)? Or let's pressure Alfresco to jump into the (future :-) open sourced MS SharePoint project. Yes, I know, it's ludicrous to ask MySQL or... READ MORE
In addition to the binary downloads that we provide from our site, Linux RPM builds of the MySQL Proxy (both the latest stable version as well as SVN snapshot releases, named mysql-proxy-snapshot) are now available for download from the server:/database repository of the openSUSE build service. It provides packages for a number of Linux distributions, e.g. Fedora 5/6, SLES 9/10 SuSE/openSUSE 10.x. By the way, this repository also contains RPMs of the current 5.0.45 MySQL Community Server for the distributions mentioned above. Thanks a lot to Darix for the initial checkin of the proxy package!
Few days ago I worked on some customer’s server and there was a problem - their nfs server went down and we were forced to change some settings on their FC4 clients to prevent shares from dieing because of kernel bug. But when we’ve changed settings in /etc/fstab there was one more step before task was completed - we need to remount this share (I mean unmount/mount). But how to perform this operation if there are some processes in D (non-interruptible sleep) waiting for dead share and prevent it from unmounting? They wait because of hard option on the share and lack of intr option and any unmount request would produce a following results:
streaming01:~# umount /storages/2
umount: /storages/2: device is busy
umount: /storages/2: device is busy
So, here is a list of steps you need to do to be able to remount your share.
First of all, you need to send KILL(9) signal to all you processes …
[Read more]A
Here is my notes on setting up replication on MySQL. In a lot of cases, that is not good enough, because it replicates EVERYTHING from the master to slave(s), whereas you may just want one or two databases replicated.
At first I thought I could just add this to /etc/my.cnf on the
slave:
[mysqld]
replicate-do-db=MyDb
That didn’t work very well for statements like this, assuming you are in a database other than MyDb:
insert into MyDb.TableInMyDb values (SomeValue)
Fine, I thought, let me add this to slave’s my.cnf:
replicate-wild-do-table=MyDb.%
It’s not enough. For the Sql statement above, it still couldn’t catch and execute that statement.
After some searching and testing, I found what I was looking for. As far as I can tell, it works beautifully. All you need to do is to modify my.cnf on slave. Just add the databases to ignore in the list. Below is a …
[Read more]Some say Sun is as cool as OSCon (if not cooler) because, among most companies that support OSCon, only Sun can produce truly underground notes on OSCon.
David Van Couvering reviews Mike Olson's comments about his
keynote at OSCon and pontificates about whether the value of Open
Source could be limited to the collaboration it fosters. David
aptly notes that
Open source and an open community gives you the assurance that the technology you are depending on is not going to be discontinued or put into "maintenance mode," it won't be acquired by someone who you would rather not do business with, and it won't be used as leverage against you to extract money or modify your behavior.
By way of further review, David contrasts MySQL as an Open Source project to …
[Read more]
I just unpacked and started setting up the Kysoh Tux toy that I got
at OScon. The lucky folks with a press badge were given a free
one. I had to pay for mine.
The good:
Physically, it feels to be well and solidly made. It didn't feel
like they were being cheap with the fabrication. It weighs just
over half a kilogram.
Physical setup is straightforward. Unstrap the parts from the
box. Click in the US power module into the internationalized
power cord. Plug in the penguin unit, to charge it up. It can
operate both plugged in, and on internal batteries, which it
charges itself. Plug the fish unit into your computer with the
included USB cord. It uses a mini-usb plug.
The firmware running in the "Penguin" main unit, and the firmware
running in the "Fish" USB/wireless transmitter unit, and the
interface library and control software on the host are …
Note: Installing Oracle 11gR1 on Ubuntu 8.10 Intrepid Ibex is now published.
Note: I have now published “Installing Oracle 11g on Ubuntu Linux 7.10 (Gutsy Gibbon)”
Note: This page focuses on Ubuntu installs. Oracle has published a web page for successfully installing Linux on unsupported platforms that you may find helpful.
I come from a MySQL background, and I have been given the challenge of learning Oracle. I can’t just play around with our customers’ databases, but I remembered that Paul Vallée said that there is …
[Read more]A
A