Archive for August, 2008
Wednesday, August 20th, 2008
| MySql Cluster is a technology that provides a shared-nothing clustering capabilities for the MySql Database Management System. The shared-nothing architecture allows the system to work with very minimum software and hardware requirements.This is my first attempt to make the MySql Cluster running on my FreeBSD machines.Each host is an Intel-based desktop PC, running a generic FreeBSD 7.0 installed to disk in a standard configuration.Filesystems on all hosts are set up identically.The MySQL version I use in this setup is 5.0.45.As this is just my experiment to make it running, I am suggesting you to read the guides from MySQL page to everything in details. Bare in mind that you need to test and prepare your databases before using it in production mode.Okay, lets begin.
Step 1. Servers
I will use the following FreeBSD servers that are all in the same network (192.168.1.* in this example):Management (MGM) node 192.168.1.1
MySQL server (SQL) node 192.168.1.2
Data (NDBD) node “A” 192.168.1.3
Data (NDBD) node “B” 192.168.1.4
Step 2. Setting Up the Management Node
Using FreeBSD, installation using ports is pretty simple.
cd /usr/ports/databases/mysql50-server
Then,
shell>make –with-ndbcluster
shell>make install
After installation, we will be insterested in the file /usr/local/libecex/ndb_mgmd.
That is the ndb management executable.
Next, we must create the cluster configuration file, /usr/local/mysql/var/mysql-cluster/config.ini:
The path may differ in Linux or other distributions.
3. Setting Up the SQL Node
shell>/usr/local/etc/mysql-server start
4. Setting Up the Data Node
(in /etc/rc.conf make sure mysql_enable=”YES”)
>>/etc/my.cnf
shell>cd /usr/local/libexec/
shell>./ndbd
shell>ndb_mgm |
Posted in General | 1 Comment »
Sunday, August 10th, 2008
Samsung debuts Omnia, the all-in-one maxi-phone fully loaded with top-of-the line multimedia enhanced smartphone features:
OMNIA, meaning ‘everything’ in Latin and ‘wish’ in Arabic, goes beyond the current top-of-the-line features available in today’s mobile phones. The OMNIA will be available to the market from June 2008.
Read the rest »
Posted in Gadget | 1 Comment »
Saturday, August 9th, 2008
heise online said:
| Version 2.0 of the FreeBSD spin-off, DragonFly BSD, is available for immediate download. The eighth major release of the project contains a new filesystem along with better hardware support, bug fixes and new software.One of the highlights of the new version is the Hammer file system, which can handle snapshots and includes features like undo and rollback. Hammer also removes the need to run fsck after a crash.Developers have worked hard with improvements in the drivers for network and WiFi cards. There are also improvements to the Bluetooth stack, and the FreeBSD driver for the Omnikey CardMan 4040 smartcard reader is now integrated into DragonFly BSD.The system is available on an installable live CD that lets users first test compatibility with their hardware. DragonFly BSD can then be installed on a hard drive using either a command line installer or a still experimental browser-based installer. The project provides detailed installation instructions in the read-me file.
DragonFly BSD started in June 2003 when it split off from the FreeBSD project. Matthew Dillon of the FreeBSD team who started DragonFly, callied it the “logical continuation” of the 4.x FreeBSD series. As a spin-off of FreeBSD, DragonFly BSD is one of the free UNIX derivatives based on the free 4.4BSDLite2 release. Some of the best known representatives of these BSD systems are OpenBSD, FreeBSD, and NetBSD. (jk/c’t) |
Posted in FreeBSD, Unix | No Comments »
Sunday, August 3rd, 2008
FreeBSD new leadership:
| The FreeBSD Project is pleased to announce the conclusion of our fourth consecutive democratic election of project leadership. The FreeBSD Core Team constitutes the project’s “Board of Directors” and is responsible for vetting new src committers, arbitrating technical disagreements, weighing in on policy and administrative issues, and appointing sub-committees for handling specific duties (security officer, release engineers, port managers, webmasters, etc..).
The core team has been democratically elected every 2 years by active FreeBSD committers since 2000.Peter Wemm is rejoining the team after a 2 year hiatus, and Kris Kennaway is joining the team for the first time. The remaining 7 slots were filled with incumbents Wilko Bulte, Brooks Davis, Giorgos Keramidas, George V. Neville-Neil, Hiroki Sato, Murray Stokely, and Robert Watson.
The new core team would like to especially thank outgoing members Wes Peters and Warner Losh for their many years of service to FreeBSD, our electioneer Dr. Josef Karthauser for running another election for us, and our returning core secretary Philip Paeps.
Murray Stokely
On behalf of the (new) Core Team |
Posted in Computer, General | No Comments »
Saturday, August 2nd, 2008
MASTER_SITES controls where the port fetches its source from. By setting MASTER_SITE to the site of a known good source code tarball, you can control where the port downloads from. For example, if you use the command make MASTER_SITE=ftp://ftp2.freebsd.org/pub/FreeBSD/distfiles, then fetch will attempt to pull the distfile directly from that site.
If you want to pull the distfile directly from a FreeBSD repository, you can specify MASTER_SITE_FREEBSD=YES. The distfile probably exists there. Most FreeBSD mirrors are already heavily loaded, so please avoid this.
Probably the most useful option for maintainers of large FreeBSD networks is MASTER_SITE_OVERRIDE. The network administrator can build a central repository of important distfiles on a local server. The site listed in MASTER_SITE_OVERRIDE is checked for distfiles before any remote sites are contacted. This saves on exterior bandwidth and makes fetching distfiles more reliable.
For more details go here.
Posted in Unix, Tips | No Comments »
Saturday, August 2nd, 2008
This is what you have to do after your mysql binary installed on your FreeBSD or Linux machine.
| freebsd02# mysql_install_db –user=mysql
WARNING: The host ‘freebsd02.acskl.com’ could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MySQL version. The MySQL daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MySQL privileges !
Installing MySQL system tables…
OK
Filling help tables…
OKTo start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your systemPLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/local/bin/mysqladmin -u root password ‘new-password’
/usr/local/bin/mysqladmin -u root -h freebsd02.acskl.com password ‘new-password’
See the manual for more instructions.
You can start the MySQL daemon with:
cd /usr/local ; /usr/local/bin/mysqld_safe &You can test the MySQL daemon with mysql-test-run.pl
For FreeBSD, do not forget to add the following to your /etc/rc.conf :
mysql_enable=”YES”
cd mysql-test ; perl mysql-test-run.plPlease report any problems with the /usr/local/bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com |
Posted in Database, Unix, Tips | No Comments »
Friday, August 1st, 2008
If you are installing some package using FreeBSD port, it is going to download the package from the internet using fetch. If you machine is behind a proxy, you have to set the environment for HTTP_PROXY :
setenv HTTP_PROXY http://your_proxy_server:port
or add the line to your .cshrc
If the proxy need authentication, add HTTP_PROXY_AUTH :
setenv HTTP_PROXY_AUTH ‘basic:*:<username>:<password>’
then reboot your machine.
Posted in Unix, Tips | No Comments »
