PDA

View Full Version : Database Servers



mactheripper
01-27-2003, 09:52 PM
If you use your OS X machine with Apache, PHP, Perl, and/or MySQL to do real web serving for fun or profit, I wanna hear from you.

I run a Yosemite G4/400 with 640MB RAM and a Fujitsu 20GB IDE drive, Apache, PHP4, and MySQL.

I have dyndns.org dynamic domain forwarding, which lets me run this server at home behind a Linksys switch/router with a firewall, off a DHCP cable connection, and have a consistent URL despite my ISP's changing my IP address occasionally.

I am still learning the intricacies of UNIX administration, groups, and throwing files around.

My only conundrum right now has to do with port numbers. I can't get ftp to work for anyone outside my LAN in to my server. I think this is b/c passive FTP allocates ports in the high 40000 numbers after receiving a request for a connection on 20 or 21. Anyone know anything about this???

billbo
01-27-2003, 11:01 PM
ripper, found this @ DynDNS (http://support.dyndns.org/guides/nat.php). It seems mostly directed towards NAT-based solutions, mainly meaning that you have to set "Port Forwarding"-rules. I don't know if your router will allow this, but that's all I scraped up.

Sorry I couldn't be any more help. My main strengths lie in recording audio on a Mac, not setting up servers. Thanks to this site and many Linux ones, I am starting to learn a little bit about networking in general, but not as much as I probably should.

Good Luck!

------------------
Bill

"I made a conscience decision in a semi-conscious state"

Jazzbo
01-27-2003, 11:37 PM
One assumes you've opened server:20,21 to/from any-host:any-port outside.

----
I wonder if you need to allow

outside:20,21 -> server:40000-65535

in your firewall router. This, of course, leaves one open for anyone outside to set a from port of 20 or 21 and pass traffic your way on any port on the server above 39999, assuming there was anything they could do that way.

I'm not thrilled with this one.

----
Can an outsider connect and get through login, but not transfer files? If that's the case, which fails: GET? PUT? DIR? all of those?

----
Are you running your ftpd with its -r flag set? That would force it to use data-ports in the high range instead of port 20, which you allow through your router. Unset -r and see if that does the trick. (I really like this one if it's the problem!)


Jazzbo

mactheripper
01-28-2003, 12:06 AM
Jazz, bill: thanks for the quick responses. Unfortunately, the problem is gnarly-er than I explained. (I was and am still hoping to dredge up some New Talent sysadmins to widen my geek knowledge pool...)

My Linksys switch/router uses NAT. I run a client on the Yose that check the public IP address every so often and updates dyndns.org servers when it changes. (Interestingly, it doesn't change that much. Like, once a month.)

I use Port Forwarding to run the server. I forward ports 20-23, 80, 8080, 3306, and 6700-6701 to the server box. As I understand it, 20 and 21 are FTP, 23 is telnet, 80 (and 8080 on mine, since my ISP blocks port 80 requests through its hardware... bastards!) are HTTP, 3306 is MySQL, and 6700-6701 are something else. I may have the latter two sets of ports mixed up, but you get the point.

Note: I also run email clients on the 9500, and, get this...
AOL Instant Messenger on both machines. I have no idea how this works right, unless it uses some kind of unique machine ID cookie sent with the message. IM won't allow the same username to connect simultaneously on two machines, so it kicks me off the 9500 when I log in on the Yose, but messages flow through the router to both machines (and my roommate's PC, also on the Linksys) unimpeded.

I did try forwarding a large range of ports in the 40000+ range to the server, and subsequently got ftp to work to the server via command-line ftp client from my buddy's OS 10 machine in Terminal. Transmit (ftp client) never did connect, though. He uploaded files and directories successfully, and he noticed that it kept assigning him unique port numbers above 40,000 for each transfer. We deduced that ftpd takes connections on 20/21, and then opens high-range ports to do the passive transfer, freeing it to use 20/1 for new connections. Is this correct?

The kicker was, when I opened up those ports, I thrashed email and IM on my 9500 and roommate's machines. So they must use high-range ports sometimes, too!!! I guess I really need to start using more in-depth admin utilities... where should I start?

ps. Jazz: I want to try your suggestion. How do I play with the ftpd settings? I've never manually started ftpd.

Jazzbo
01-28-2003, 12:53 AM
I believe that all of the chat-ish protocols use UDP and specific port. Since you're NATting, from the Internet side it's all the same IP-port combination, which is why two sessions from hosts the inside of your firewall bounce each other off -- looks like the same host-port pair from outside.

What should happen is that ftp data port connections move up into the dynamic range to stay out of the way of the listener (20/21). I just checked my inetd.conf file (it governs *most* TCP and UDP service listeners on most Unix hosts) and found that the default is without -r, so that's not your problem. (cat /etc/inetd.conf in Terminal to inspect it.)

Also, if you told the NATting router to pass all ports above 39999 to your OSX machine, none of the dynamic ports spun up on any other LAN host would be reachable from the outside, which would certainly unplug any other host from a lot of Internet communications. High-number ports are set up on demand for lots and lots of data exchanges.

You might try having the outside client run the connection in active mode instead of passive. Either ftp -A yourhost.domain or issue the passive command during the ftp dialogue, watching for it to be reported as "passive: off". This should result in the client machine providing the dynamic port for your ftpd to connect to and pass data.

I just don't know enough about running ftp servers behind NATting routers to get you much farther right away. I have a feeling things won't work at all if the outside client is also behind a firewall.

You might see if you can find anything on Linksys's web pages (or elsewhere) describing how to set up an ftp server NATted behind one of their routers.

Jazzbo

[This message has been edited by Jazzbo (edited 28 January 2003).]

Jazzbo
01-28-2003, 01:15 AM
Some discussions of note...

I thought this one at landfield (http://www.landfield.com/wu-ftpd/mail-archive/wuftpd-questions/2002/Sep/0047.html) while quite applicable, didn't seem to generate an answer.

This one at dslreports (http://www.dslreports.com/forum/remark,1381832%3Broot=equip,16%3Bmode=flat) does a nice job of explaining active vs. passive mode. One of its links suggests that Linksys hasn't implemented enough FTP server handling to do the job at all.

Note that if you add the internal IP address of your OSX to the Linksys as a "DMZ" machine, I believe that opens all ports not explicitly closed to be passed to it. Tighten that puppy down!

Jazzbo

mactheripper
01-28-2003, 10:16 PM
Yeah, I'm definitely not using DMZ. That's for newbies who are confused by port forwarding and trying to run QuakeIII Server, or hackers who are explicitly trying to work on a given box.

Jazzbo
01-28-2003, 11:26 PM
"That's for newbies who are confused by port forwarding" or for Internet service architects running a hardened proxy-server. In a past life I fronted a multi-national with such a Unix box, though I certainly didn't go it alone!

While they're tricky to set up correctly and require stringency a la Gregoire, DMZ hosts can be tremendously effective at both communications and defense.

Jazzbo

TZ
01-27-2004, 08:49 AM
A list of applications that offer a friendlier, graphic interface for MySQL database work:

MySQLMan (http://www.gossamer-threads.com/scripts/mysqlman/)
Eskuel
CocoaMySQL (http://cocoamysql.sourceforge.net/)
YourSQL (http://www.mludi.net/YourSQL/)
phpMyAdmin (http://www.phpmyadmin.net/)
Navicat (http://www.navicat.com/mac_overview.php3)
FMPro Migrator (http://www.dotcomsolutionsinc.net/products/fmpro_migrator/)
Digital Image MySQL (http://www.yvs.eu.com/otherproducts.html)
MySQL Magic (http://www.lachoseinteractive.net/en/products/mysqlmagic/)
MacSQL (http://www.rtlabs.com/macsql/)

[See also Apple MySQL note ]
http://docs.info.apple.com/article.html?artnum=106383

TZ
02-03-2004, 05:15 AM
Part II: XServe G5 Panther ComputerWorld (http://www.computerworld.com/softwaretopics/os/macos/story/0,10801,89682,00.html)

<BLOCKQUOTE class="ip-ubbcode-quote"><font size="-1">quote:</font><HR> Focusing solely on the hardware, the new Xserve just wows me. It has one or two 2-GHz G5 processors, uses 400-MHz ECC RAM and has a dedicated front-side bus running at 1 GHz (the dual-processor model has two independent front-side buses, one for each processor). Add to that the ability to support up to 8GB of RAM, and you have the makings of the fastest Mac ever conceived. But Apple didn't stop there. Each of the three drive modules contains dedicated 150MB/sec. controllers, and the Xserve supports 100- and 133-MHz PCI-X cards. Rounding out its impressive technology pedigree are two onboard Gigabit Ethernet ports, each with its own dedicated controller.

What does all that power mean? A machine that is up to 60% faster than the original Xserve, which was a powerhouse in its own right. Compared with similar server platforms, the Xserve G5 offers more sheer computational power for straight high-end computing tasks. &lt;&gt;

&lt;snip&gt;

But sheer power isn't what impresses me most. That accolade goes to its ease of configuration, monitoring and maintenance. A stock Xserve out of the box is impressive, but it ships with only a single 80GB drive. Adding drives to the Xserve is impressively easy. Simply pop out one of the three hot plug drive modules, put a new drive in it (up to 250GB at present), pop the module back in, and you're ready to go. No powering down the server, no messy opening it up, just pop out and pop back in, with no downtime whatsoever.

More... <HR></BLOCKQUOTE>

TZ
03-24-2004, 11:57 AM
Apple posted KB of what 3rd party hardware is supported on XRAID.

http://docs.info.apple.com/article.html?artnum=107911

TZ
03-29-2004, 03:05 AM
Linux kernel 2.6 for SMP was able to show 89% boost in file system performance and a huge boost in MySQL, which is used to run a lot of BBSs on the net.

<BLOCKQUOTE class="ip-ubbcode-quote"><font size="-1">quote:</font><HR> Linux Kernel Comparison: 2.6.4 vs. 2.4.25 - Conclusion
Published on 2004-03-29 01:00:00 By: Jim_

With the major improvements that we've seen in Samba over the last couple of years, testing Linux file server performance certainly seems like a good idea. Countless Unix and Linux administrators roll out Linux boxes running Samba to handle file serving needs. It's an inexpensive way to accomplish a fundamental IT need, networked storage.

Keeping all this in mind, I decided to play around with dbench for the first time. It's a pretty slick little benchmark that generates load patterns similar to Netbench, a commercial benchmark. What really makes it easy to use is the fact that you don't need a lab full of client machines to stress your server. How does kernel 2.6 measure up when it comes to file server performance?

Woah (/Keanu Reeves). This one shocked me enough to run this test over and over again in an attempt to find a mistake on my part that could explain this huge gap in performance. 2.6 completely obliterates 2.4 in this benchmark by approximately 89%! That's truly remarkable. I don't think I really have to comment any further do I? You folks know what kernel to choose if your server is going to be acting as a file server. Just look at that graph...

Conclusion

Initially I had much grander plans for this article. I was going to run the benchmarks not only on the high-end dual Xeon box, but also on a slightly older and considerably slower machine (Celeron 633 w/ 256MB memory) as well. Unfortunately I encountered some difficulty with the older hardware and was unable to bring you those results.

While this topic has been covered by many others in the past, I felt it prudent to take a look at the differences in kernel performance for those of us with multiple processor machines under our control. At 2CPU.com, we try to take care of the SMPers out there, and performing comparisons such as this are certainly solid steps in that direction.

As far as our results go, I can't say that I was really surprised. Whenever you're dealing with a new kernel series you expect performance with its predecessor to be quite close in certain applications and vastly superior in others. It would be an invalid expectation to assume performance gains in every situation as a lot of the time performance is clearly dependent on how the application is written. I think this is clearly the case with our picCOLOR results.

The considerable gains shown in MySQL read and write performance certainly have my head spinning as we do have busy forums which rely on MySQL's affection. If you just looked at those numbers, you'd probably think I'd be crazy not to make the jump to kernel 2.6 on our web server. However, our content management system does generate our articles as static HTML, so I have to keep that performance in mind. 2.4 bested 2.6 in this area, so this definitely complicates my decision making process.
http://www.2cpu.com/articles/98_5.html <HR></BLOCKQUOTE>

unclemac
03-31-2004, 10:59 AM
First stuff first:

G5 Xserve in the house!

Yahoo!!! http://forums.macgurus.com/images/phat.gif

Hi jacob,

Funny you ask. This SP G5 Xserve is going to be exactly what you are thinking about - FM Server 5.5v4 for (at peak) about 100 users, about 30 Files, most smallish but a couple large. Large as in approaching the 2 GB file size limit in FM Server currently.

Current FM server is not CPU intensive. Baically, it is a file locking device, and a backup scheduler, with a few other goodies like caching in the mix. Almost all the work happens on the client side, within the FM Pro application. So no problem with a SP G5, or even a SP G4. Our current box for this is a DP 1G G4 and as viewed through Top, CPU is about 80% idle. We only buy the better boxes for maximum I/O performance. FM has a good white paper about optimizing FM Server/Best Practices, and they recommond you spend your $$ on fast I/O - like current SCSI or FC - not on CPU or memory.

The next version, FileMaker Server 7 will be CPU intensive, as most work will happen on the server, more like a traditional SQL DB. Supposed to be wicked fast provided the hardware is up to snuff. FM Pro 7 is out already, but Server 7 will not be out till middle/end of summer, maybe later.

So if you plan to migrate up to Server 7 soon, go fastest DP; if not, decent SP is plenty. We figure it may be up to a year before we get live files on Server 7, so we will buy the DP 3G G5 (G6?)Xserve available then. http://forums.macgurus.com/infopop/emoticons/icon_wink.gif

TZ
05-07-2004, 06:07 AM
dbSuite Administration Tool for MySQL (http://dbsuite.de/dbsuiteAdminTool.html) is an integrated environment for administering local and remote MySQL database servers. It includes monitoring and administration of system settings, monitoring of server performance, management of users and access privileges, database access and navigation, creation and editing of tables, SQL queries and commands, and other features. dbSuite Administration Tool for MySQL is free for private use (donations requested) for Mac OS X and Windows. A $59 commercial license is also available.

unclemac
05-24-2004, 09:20 AM
With almost unlimited data hosting capacity, new server software is easier
to use, improves performance of shared database, and more secure.


Santa Clara, Ca., May 24, 2004

FileMaker has announced the immediateavailability of
FileMaker Server 7 (http://store.filemaker.com/r1.html),
the new server software for hosting FileMaker Pro 7 database files.

"Whether you're a 2-person small business or a large corporate workgroup,
FileMaker Server 7 allows you to easily share, manage and access database
information with others while dramatically increasing productivity," says
Ryan Rosenberg, vice president, Marketing and Services, FileMaker.

FileMaker Server 7 now offers numerous breakthroughs in data sharing and
administration, as well as advanced security features, including the
following new features:

FileMaker databases run faster

New within FileMaker Server 7 is the ability to perform searches and
calculations on the server instead of the client database providing data
speed gains; get greater performance from hard disk storage systems and
multi-CPU servers; while taking advantage of large amounts of RAM using
sophisticated caching.

Host virtually unlimited amounts of data

Each of the 125 database files that can be hosted on FileMaker Server 7 can
store up to 8 terabytes of information - 4,000 times the old limit. And,
because each FileMaker database file can now contain multiple data tables,
a single FileMaker Server can host thousands of data tables. For added
scalability, users can add FileMaker Servers to their network as their
business needs grow.

Easy database administration from anywhere

The new FileMaker Server 7 Administration Tool (SAT) allows users to
accomplish the following tasks, either locally at the Server station or
remotely over a network: Perform maintenance on live databases, including
live backups while the file is in use; Automate unattended, scheduled
backup; Audit remote administration through a new Event Log entry that
identifies Administrators and their activities; Ensure that all clients have
the most current plug-ins using the Auto Update feature; Record plug-in
downloads in the Event log; and change server settings without restarting
the server.

Better data protection with new security features

FileMaker Server 7 provides three new key security functions: account
authentication management for reducing the overhead of managing user
accounts and passwords, using industry standards provided by Active
Directory (Windows) and Open Directory (Mac OS); Database visibility control
for filtering the display of hosted database names based on the users'
privileges to protect sensitive information; and data encryption to enhance
the security of FileMaker information that is transferred between hosted
databases and desktop clients via Secure Socket Layer (SSL) encryption.

Pricing and availability

FileMaker Server 7, priced at $999/$499 upgrade (U.S., Suggested List
Price), is shipping to FileMaker volume license customers starting today.
The company plans to begin shipping retail units to all other customers and
distribution partners June 2. Customers can place pre-orders now for
FileMaker Server 7 by phone (1-800-325-2747) or online with select resellers
at http://store.filemaker.com/r1.html. Licensed users of FileMaker Server
5.5, 5.0 or FileMaker Pro Server 3.0, 2.1 may upgrade to FileMaker Server 7
at just US$499, a 50% savings off the regular price. This offer is valid
from May 24, 2004, to September 17, 2004, in the U.S. and Canada. After that
date, only licensed users of FileMaker Server 5.5 will be eligible for the
US $499 upgrade price.

unclemac
05-24-2004, 09:20 AM
With almost unlimited data hosting capacity, new server software is easier
to use, improves performance of shared database, and more secure.


Santa Clara, Ca., May 24, 2004

FileMaker has announced the immediateavailability of
FileMaker Server 7 (http://store.filemaker.com/r1.html),
the new server software for hosting FileMaker Pro 7 database files.

"Whether you're a 2-person small business or a large corporate workgroup,
FileMaker Server 7 allows you to easily share, manage and access database
information with others while dramatically increasing productivity," says
Ryan Rosenberg, vice president, Marketing and Services, FileMaker.

FileMaker Server 7 now offers numerous breakthroughs in data sharing and
administration, as well as advanced security features, including the
following new features:

FileMaker databases run faster

New within FileMaker Server 7 is the ability to perform searches and
calculations on the server instead of the client database providing data
speed gains; get greater performance from hard disk storage systems and
multi-CPU servers; while taking advantage of large amounts of RAM using
sophisticated caching.

Host virtually unlimited amounts of data

Each of the 125 database files that can be hosted on FileMaker Server 7 can
store up to 8 terabytes of information - 4,000 times the old limit. And,
because each FileMaker database file can now contain multiple data tables,
a single FileMaker Server can host thousands of data tables. For added
scalability, users can add FileMaker Servers to their network as their
business needs grow.

Easy database administration from anywhere

The new FileMaker Server 7 Administration Tool (SAT) allows users to
accomplish the following tasks, either locally at the Server station or
remotely over a network: Perform maintenance on live databases, including
live backups while the file is in use; Automate unattended, scheduled
backup; Audit remote administration through a new Event Log entry that
identifies Administrators and their activities; Ensure that all clients have
the most current plug-ins using the Auto Update feature; Record plug-in
downloads in the Event log; and change server settings without restarting
the server.

Better data protection with new security features

FileMaker Server 7 provides three new key security functions: account
authentication management for reducing the overhead of managing user
accounts and passwords, using industry standards provided by Active
Directory (Windows) and Open Directory (Mac OS); Database visibility control
for filtering the display of hosted database names based on the users'
privileges to protect sensitive information; and data encryption to enhance
the security of FileMaker information that is transferred between hosted
databases and desktop clients via Secure Socket Layer (SSL) encryption.

Pricing and availability

FileMaker Server 7, priced at $999/$499 upgrade (U.S., Suggested List
Price), is shipping to FileMaker volume license customers starting today.
The company plans to begin shipping retail units to all other customers and
distribution partners June 2. Customers can place pre-orders now for
FileMaker Server 7 by phone (1-800-325-2747) or online with select resellers
at http://store.filemaker.com/r1.html. Licensed users of FileMaker Server
5.5, 5.0 or FileMaker Pro Server 3.0, 2.1 may upgrade to FileMaker Server 7
at just US$499, a 50% savings off the regular price. This offer is valid
from May 24, 2004, to September 17, 2004, in the U.S. and Canada. After that
date, only licensed users of FileMaker Server 5.5 will be eligible for the
US $499 upgrade price.

TZ
05-26-2004, 08:05 AM
From ComputerWorld:
The visible SAN from Apple
Tom Yager, InfoWorld
26/05/2004 09:43:22

* First, Xsan http://www.apple.com/xsan/ is really a SAN file system, which makes SANs useful and accessible beyond their core capabilities.

* And second, Xsan is precisely the right way to turn inexpensive disk arrays (like Xserve RAID) into shared, consolidated network storage.

* Here's the elevator pitch: Xsan does the SAN thing, consolidating and virtualizing storage.

* But Xsan presents that storage in its most readily usable form, as disks that are partitioned into OS X HFS+ (HFS second-generation) volumes.

* Each of Xsan's virtual volumes permits simultaneous read/write use by multiple servers.

* Xsan puts SAN file systems within the reach of midsize businesses and high-demand workgroups or server clusters.

* The initial buy-in is manageable at around $35,000 for the Xserves, Xserve RAID, Xsan software, FC (Fibre Channel) network adapters, and the fiber switch needed to get a 3TB Xsan running.

* After that, you can join Xserve, Xserve G5, Power Mac G4, and Power Mac G5 systems to the Xsan for a flat $999 per machine plus the cost of the FC adapter.

* You can add Xserve RAID storage to your heart's content as long as you have open ports on your fiber switches.

* There is no cost associated with publishing traditional OS X, Unix, or Windows shared folders from Xsan servers.

* What gives me pause is Apple's professional services network. Xsan is, by far, the most complex technology that Apple has produced.

* Only a percentage of Apple dealers and consultants will have the skill to configure, expand, and support Xsan.

* Although Xsan should be a solution that opens SANs to those who can't afford them, it's going to be a do-it-yourself exercise until dealers get up to speed.

* There's a yellow flag here. But I got Xsan in 90 minutes over the phone with almost no understanding of SAN file systems.

If you can give up "plug, play, and don't touch" in favor of five or six figures' worth of reduced buy-in and upgrade costs, rolling up your sleeves might seem less inconvenient.

ComputerWorld: Apple Xsan (http://www.computerworld.com.au/pp.php?id=1892171864&fp=16&fpid=0)

TZ
06-01-2004, 10:06 AM
This is a really good, well-done review of the latest XServe and XRAID from Apple and would help anyone contemplating either for their data center or other environment. I think its also nice to see yet another review coming from ComputerWorld, too.
Apple's G5 Serve/XRAID (http://www.computerworld.com/softwaretopics/os/macos/story/0,10801,93433,00.html?nas=MAC-93433)

TZ
06-04-2004, 01:25 PM
No SSH Connection Connecting To Server

Peter Trist
I have noticed a similar problem to Chris on my home-office LAN. Connecting in either direction between my iBook and iMac since updating to 10.3.4 gives me the same notification.

Somewhat frustrating. I have been unable to find any ref to this new 'feature' on Apple's site after doing numerous searches over the last few days since updating. I originally applied the 10.3.4 standard update but have since downloaded and applied the 10.3.4 update over that to make sure I got the minor bits not included in the base update that are in the combo version.

Can't remember exactly what the diffs were at this time, but memory says one or two were security fix related.


Rene Borgella Jr.
Chris Leuty reports that he can no longer make a secure connections via "SSH after upgrading to 10.3.4. The error message reads: "Can't make a secure connection to .... The server... does not support secure connections via SSH. To connect with reduced security click Continue."

<>This is exactly what we've seen on all our machines upgraded to 10.3.4 Seems this is a bug to me.

Daniel Figucio
Only Mac OS X Server can be connected to via AFP over SSH - AND you have to enable it at the server end. You cannot connect to a Mac OS X Client with AFP over SSH. What used to happen was that the attempted connection would fail and it would connect without using SSH without letting you know. Now it lets you know... So in reality, its a feature improvement, as it plugs a security issue.

-----------------

sounds like Apple wants you to buy OS X Server, rather than using the Client version, for server operations?
</>

TZ
06-05-2004, 08:52 AM
Executives at Oracle and Apple are taking to the highway in a series of international road shows to introduce Oracle Database 10g on Mac OS X Server, which is Apple's Unix-based server operating system.


"The power of the new Xserve G5 and the flexibility of Oracle Database 10g running on Apple's Unix-based Mac OS X Server will deliver our joint customers a very compelling, cost-effective, scalable and reliable database solution," Milani said at the time.
http://www.eweek.com/article2/0,,1606918,00.asp

Oracle9i already runs on OS X:
http://otn.oracle.com/software/products/oracle9i/index.html
http://oracle.com

TZ
06-15-2004, 10:07 AM
Anyone know what the 272MB Apple OS X Server Admin Tools 10.3.4 is about?


Mac OS X Server 10.3.4 Admin Tools: Information and Download

The Server Administration Software contains administration software and tools that you can install on a computer other than your server.

These tools require Mac OS X version 10.3 or later.

The following tools will be installed into Applications/Server folder with the exception of QuickTime Broadcaster: Server Admin, Workgroup Manager, Server Monitor, Network Image Utility, Server Assistant, QTSS Publisherand QuickTime Broadcaster.
http://docs.info.apple.com/article.html?artnum=120280
Administration Tools for Mac OS X Server
Server Administration Software

The ServerAdministrationSoftware.pkg contains administration software and tools that you can install on a computer other than your server.

These tools require Mac OS X version 10.3 or later. The following tools will be installed into Applications/Server folder with the exception of QuickTime Broadcaster.


* Server Admin ó For configuring service settings, monitoring server activity, viewing log information, and checking the state of each service

* Workgroup Manager ó For managing share points, users, groups, computer lists, and Mac OS X managed client environments

* Server Monitor ó For monitoring the hardware status of Xserve servers

* Network Image Utility ó For creating, modifying, and managing NetBoot and Network Install disk images

* Server Assistant ó For remote installations and initial configuration of Mac OS X Server

* QuickTime Broadcaster ó To use in conjunction with QuickTime Streaming Server to broadcast live audio and video streams

* QTSS Publisher - The QTSSPublisher.pkg contains the QTSS Publisher application for installation on client computers. QTSS Publisher can be used to upload media to Mac OS X Server, prepare media for streaming, and to setup and manage video and audio playlists for publishing with QuickTime Streaming Server.

* Macintosh Manager - The Macintosh Manager folder contains installation software and documentation for use with Macintosh Manager. Macintosh Manager is Appleís desktop management solution for for managing workgroups, preferences, and user environments on Mac OS 9.

* Documentation - The Documentation folder contains electronic documentation in PDF format for getting started with Mac OS X Server, setting it up, and configuring it.

Updated documentation for Mac OS X Server can be found at this Apple website:
ē www.apple.com/server/documentation/

Utilities - The Utilities folder contains copies of the PackageMaker and Property List Editor applications for use in creating installation packages and editing XML configuration (.plist) files.

© 2003 Apple Computer, Inc.
User comment on VT:
After installing this "new" set of tools on my desktop machine, I could not access the Sharing button in Workgroup Manager. I checked the version number and found it was 2.0, but the version of Workgroup Manager on my Xserve (where I did not install the "new" tools) was 2.0.1. I copied WM from the Xserve to my desktop machine and now it works fine. This package also installed an older version of Server Monitor. Watch out! http://www.versiontracker.com/dyn/moreinfo/macosx/17727 I saw this on VT but nowhere else. :confused:

TZ
06-19-2004, 01:58 AM
Apple impresses with new Xserve hardware

Xserve with G5 CPUs, 3.5TB RAID gives you more for less
Affordable 64-bit computing


Want back-end power at a desktop price? AMD’s Opteron and Apple’s G5 deliver.

For dynamic workloads, IT has traditionally turned to 64-bit Unix servers with fast I/O and lots of expandability. Yet those servers’ enormous cost, trailing compute performance, and never-ending maintenance needs fueled the migration to Xeon in the first place. The ideal solution would be big-iron-like throughput and capacity without the sacrifice of Xeon-like compute performance and affordability -- something between cheap 32-bit PC servers and 64-bit IBM Power, Intel Itanium, or Sun Sparc machines. If low cost could be complemented by backward compatibility and smaller form factors, so much the better.

That sweet spot has been filled. Two emerging 64-bit platforms, one built on AMD’s Opteron and the other on IBM’s PowerPC 970FX, have stepped into the breach. Needless to say, we couldn’t wait to unpack two of the first systems based on these chips and see what 64-bit computing on a Xeon budget felt like. Our first test systems were a dual-Opteron reference server from AMD built on an MSI motherboard and a dual-processor Xserve G5 from Apple.

InfoWorld (http://www.infoworld.com/article/04/06/18/25FE64bits_1.html) Check out the full 3-page review.

TZ
06-26-2004, 11:21 AM
- New Certifications for Xserve RAID - Lionel - 18:59:25

Xserve RAID continues to progressively come into it's own. After receiving certification for the following:

Windows 2003 Server
RedHat Linux Server
Yellow Dog Linux Server

It is now certified for:

NetWare® 5.1
NetWare® 6
NetWare® 6.5
Novell Cluster Services™ 1.01
Novell Cluster Services™ 1.6
Novell Cluster Services™ 1.7

This nicely expands it's target customer base.
[translation by Astomatous]


xGrid on Unix - Lionel - 18:56:43
Source : http://www.heise.de

Daniel Cote of the Ontario Cancer Instiutite, part of the university of Toronto (http://unu.novajo.ca) has succeeded in installing xGrid, Apple's computational clustering technology, on several versions of Unix (RedHat, Debian, Darwin, Solaris).

unclemac
06-28-2004, 03:23 PM
Check these new and improved features.... my favorites:



- Software Update Server. Reduce network costs by controlling the distribution of Apple software updates with your own Apple software update proxy/cache server.

- Mobile Home Directories. Centrally manage mobile user's home directories with Tiger Server. When they reconnect to the network, mobile home directories automatically synchronize to the server.

- Xgrid 1.0. Easily build your own computational cluster with Xgrid 1.0, now fully integrated with Tiger Server. Xgrid 1.0 uses Kerberos and Open Directory for authentication and includes a new SDK for developers.

- Site-to-Site VPN. Extend your private network using IP tunneling with IPSec encryption. Compatible with DSL and cable broadband services.

- Open Directory 3. Tiger Server includes significant updates to Directory Services, Network Authentication and Service Discovery.

- Managed Network Browsing. Control how the Network is organized in the Finder and how your users view it. Administer virtual network views within the Workgroup Manager. Data is stored in Open Directory.

- NT Migration Tool. Easily migrate Windows networks from Windows Primary Domain Controller to Open Directory running Mac OS X Server.

- Gateway Setup Assistant. Small businesses and home offices can easily set up an Internet Gateway, Firewall and VPN with the new Gateway Setup Assistant, which walks you through the process.

- Certificate Management. Easily create and manage SSL certificates and assign them to services. Certificate creation tools built into Server Admin make it easy to create SSL/TLS Certificate Signing Requests or custom, self-signed digital certificates.

- High Availability Failover. Eliminate service downtime with automatic pairing of AFP, CIFS and NFS network file servers. Tiger Server supports 2-node active/passive file service clustering and provides complete setup and management of –cluster pair” with Server Admin.

- Ethernet Link Aggregation. Ensure faster and more reliable network performance by combining multiple network interfaces to make them behave as a single interface with the the same Ethernet address, the same IP address and the same host name. Designed to work with IEEE 802.3ad Ethernet switches.

See it all here. (http://www.apple.com/server/macosx/tiger/) This is shaping up very nicely. A couple dreamy features in there that used to only be available to real system admins.

TZ
08-30-2004, 10:54 AM
Aug 30, 2004

Xserve with hardware RAID card

Alan Claver - I received my Xserve dual 2 GHz today with hardware RAID card (after a long wait for availability) and 3 250GB serial ATA drives.

A few observations follow..

1. RAID was NOT configured. The drives were mounted as separate drive devices. However, OS X Server was installed on the first drive. Of course, I had to reinstall OS X as creating a new array required formatting of the drives.

2. RAID setup had to be done via a command-line prompt. This was a big surprise. It's not hard for an experienced administrator but not obvious for regular folks to setup. I would hope they get around to creating a GUI-based setup utility for the non-technical administrator.

3. Documentation is online (not included with server) and it's a bit sparse.

4. The setup utility is named Megaraid so I assume that the RAID card is an LSI Logic MegaRAID SATA 150-4 derivative.

5. It's very quiet. I was worried about the noise but it's reasonable under normal loads. It does throw off a good deal of heat - the temperature in my office climbed noticeably.

unclemac
09-13-2004, 10:21 AM
What's new in this version:

Includes changes for initializing and running your Xserve G5. It provides enhanced reliability during reboot sequences as well as support for the Xserve G5 PCI Hardware RAID Card. This firmware update is required for Xserve G5 customers who wish to install the Xserve G5 PCI Hardware RAID Card kit and is strongly recommended for all Xserve G5 systems with earlier firmware versions.


Interesting....

Will report back if I see anything different - we don't have the PCI RAID card in either of our G5 Xserves.

unclemac
10-07-2004, 03:03 PM
Yet another positive Xserve review. (http://www.informationweek.com/story/showArticle.jhtml?articleID=48800573&pgno=1)

And, as TZ mentioned elsewhere, SoftRAID 3.1 is finally out. Bootable mirrors are just what the doctor ordered for 24/7 uptime....

TZ
01-10-2005, 03:06 AM
In both data throughput and number of HTTP requests/second, the results showed Web server performance increased by 73.27 percent when upgrading the amount of RAM from 512MB to 2GB and increased over ninefold when upgrading from 512MB to 4GB.

When upgrading the amount of RAM from 2GB to 4GB, the Web server data throughput and number of HTTP requests/second increased by a factor of five. Web Server Performance and Memory Upgrade (http://www.crucial.com/library/server_memory_benchmark_tests.asp?CPE=NLC-908TD9773551&cid=1%2D2F9DFO)

TZ
01-15-2005, 08:21 AM
No degradation on Xserve/Xraid even when you are using 90% storage available. If you have to have 1TB of storage, you don't want to have to buy 2TB and waste half because it can't maintain the 200MB minimum needed for video editing.

But for both the Xserve RAID and Xserve G5, it's the improvements under the hood that stand out.
G5 Xserve/XRAID (http://www.infoworld.com/Apple_Xserve_RAID/product_46690.html)

Apple Xsan Fibre Channel (http://weblog.infoworld.com/techwatch/archives/000978.html)


When factoring in the OS cost, Xserve remains a smart server choice for budget-conscious operations that don't need an all-Microsoft ecosystem. If Xserve G5 falls short anywhere, it's on features that may be unnecessary outside the most demanding environments.

Apple impresses with new Xserve hardware
Xserve with G5 CPUs, 3.5TB RAID gives you more for less
InfoWorld G5 Xserve (http://www.infoworld.com/Apple_Xserve_G5/product_45990.html)
Xserve G5 RAID (http://weblog.infoworld.com/techwatch/archives/000958.html)

Apple takes the bite out of SANs - Xsan lowers the obstacles to SAN implementation
http://www.infoworld.com/article/05/01/12/03PPhands_1.html


... the value of Xserve RAID when compared with similar 3U arrays is obvious to even the most stubborn big-iron loyalist. Apple's Xsan storage networking app, also due this fall, might actually bring some sanity to SAN implementations. With a $999 price tag and purported 100 percent interoperability with ADIC's StorNext file system, Xsan may be the budget balancer that SAN technology needs to take off in smaller enterprises.

Apple's Xserve product line performs well and compares favorably on price. Feature for feature, it holds its own against anything I've seen in a Xeon- or Opteron-based system.

there are things I can do with Apple's tightly integrated hardware and OS that I can't do with other platforms, such as use an external FireWire boot device if a system refuses to boot on its own.
http://www.infoworld.com/article/04/06/18/25TCxserve_1.html

TZ
01-15-2005, 08:33 AM
2004: Fibre Channel still rules the SAN (http://www.computerworld.com/hardwaretopics/hardware/story/0,10801,98682,00.html)
Enterprise SAN for Mac OS X Server, Part 2 (http://www.computerworld.com/hardwaretopics/hardware/story/0,10801,98151,00.html)
Panther server and Active Directory (http://www.computerworld.com/softwaretopics/software/story/0,10801,95925,00.html)

Nicolas
12-10-2005, 01:25 PM
Windows 2000/XP

MacWindows Tutorial (http://www.macwindows.com/tutorial.html)

MacWindows 10.3 Panther (http://www.macwindows.com/panther.html)

MacWindows 10.4 Tiger (http://www.macwindows.com/tiger.html)

Setting Up Macintosh & Windows File Sharing Part I (http://www.informit.com/articles/article.asp?p=397057&seqNum=2)

Setting Up Windows & Macintosh File Sharing Part II (http://www.informit.com/articles/article.asp?p=397057&seqNum=3)

Sharing files between a Windows XP PC and a Mac running OS 10.3.x (http://www.ifelix.co.uk/tech/3001.html)

Also you can turn Windows 2000 and XP into a Server for Mac Clients see Cyan Mac Server IP!!!



Windows 2000 and 2003 Server
have some serious speed issues if you are using Appletalk clients (old AFP or AFPover TCP). With third party software you can gain up to two to six times the performance of SfM (windows Services for Macintosh).



Other problems you can have using SfM or SMB:

Max. Filesize (2GB limit)
Macintosh files are not longer working if copied to another PC for backup (resource forks to lose).
No 10.4 aka Tiger support
No authentication support form Mac clients
Problems mounting shares




Solutions:

Grouplogic Extreme Z-IP
http://www.grouplogic.com/products/extreme/file/fileserver.cfm

Improve your file copy performance by 2 - 6 times that of Windows NT's built-in Services for Macintosh (SFM)
and 2 - 3 times that of Windows 2000's SFM


Sharity
http://www.obdev.at/products/sharity/

- Access files on Windows 95, 98, ME, NT, 2000, 2003, XP, Samba, AppleShare IP, FacetWin and other CIFS servers.
- Provides network browsing facility similar to Windows' "Network Neighborhood".
- Runs on almost any Unix operating system (including Mac OS X). Click here for a complete list
- Easy Installation.
- Faster than NFS servers for Windows.
- Shares are mounted in the file system: You can open files directly from the server.


Cyan Mac Server IP
http://www.cyansoftware.com/MacServerIP.htm

- new: AFP 3.1 support
- new: Support for file names longer than 31 characters and support of \/`*?< >| in file and folder names
- new: Full support for TIGER MacOSX 10.4
- new: Kerberos support for single sign on pass through authentication in Active Directory
- new: Unlimited login password and user name lengths
- new: Unicode support
- new: DHX password encryption support
- new: On a cluster failover volumes are immediately available
- new: Very fast file searching via our new MSIP framework
- new: High performance MacOSX file access on Windows servers
- new: Bonjour (Rendezvous) support
- new: reduced memory consumption when sharing millions of files
- new: Supporting full compatibility between MacOS Classic and MacOSX files unlike Mac SMB client
- new: No hidden files or resource forks to lose,as with SMB
- new: Improved stability of Windows based servers in Mac dominated environments
- new: Enhanced Gigabit network performance
- new: Unlimited file and volume sizing (no 2GB file size limitations)
- new: 5 x faster than SFM and voted the fastest IP based Mac sharing system on the Windows platform
- new: improved performance; optimized for Win 2000; special optimized version for NT Cluster / Win 2000 Datacenter/Advanced / Win 2003 Datacenter/Enterprise available; inexpensive Workstation version available for turning a NT Workstation & 2000/XP Professional PC into an inexpensive extremely fast print & file server for Macintosh clients (*1)



Also take a look here:

Common File Systems and OSX (http://www.macgurus.com/forums/showthread.php?t=20515)

Networking (http://www.macgurus.com/forums/showthread.php?t=19239)

Security News (http://www.macgurus.com/forums/showthread.php?t=12489)

revi
02-28-2006, 05:43 PM
Hello!

Back in 2000 or so, it seemed that there were two primary contenders for open-source database: MySQL and PostgreSQL. For some reason, PostgreSQL seemed to fall off the radar and MySQL got all the press.

Well, as I learned last summer while prepping for some "benchmark" tests, MySQL v.4 lacked many features common in other RDBMS (e.g., transaction handling, cursors, etc.). These were to be addressed in MySQL v.5.

Well, then Oracle bought InnoDB, the open-source house that was going to provide the transaction tools for MySQL! That story is still open, but interesting nonetheless.

So, I went to a presentation by the chap who developed:

http://www.chicagocrime.org/

Which utilizes a number of neat little programming tricks and implements the Google Map API. He also uses PostgreSQL extensively...both on this site and on some commercial sites he runs. Oh, and PostgreSQL supports all those functions that MySQL doesn't.

My interest in PostgreSQL was very much reinvigorated by this talk (over the last number of years I've mainly worked on Oracle 8i and SQL Server 2000).

If one were looking for an open-source database, I'd recommend checking out PostgreSQL (btw, the name PostgreSQL has a convoluted etymology: it began as the Ingres database [named after the French painter Ingres], became open-source and they decided to do a number on its name...maybe that's why MySQL got popular insofaras people couldn't figure out what the "gre" was that was "Post" and if it ever were "Pre"... ;-)

Best,

Iver

TZ
04-24-2006, 10:16 AM
IBM DeveloperWorks: Sharing a Server with XP and OS X (http://www-128.ibm.com/developerworks/aix/library/au-unixothers/?ca=dgr-lnxw07Unix4WinMAc)

Great little tutorial and "how to."

Apple Tiger and MySQL (http://developer.apple.com/business/macmarket/mysql.html)