By Todd Duell

W hat do you need to do to configure your server to optimize performance? User’s guides and manuals seldom answer that question. They tend to only offer minimum settings and only the most basic configuration information without regard for the impact that the settings will have on security and performance. This white paper will discuss everything you need to know about hardware selection, system specifications, installation, and configuration of FileMaker Server 9. This white paper will make some assumptions in the recommended configuration settings to balance cost, ease of administration, and security. For additional details on functions not covered in this white paper please read the FileMaker Server 9 Getting Started Guide and the technical brief: Upgrading to FileMaker 7: How to take advantage of the new server model and capabilities, which are available from FileMaker, Inc. Live Configuration Changes Almost all changes to the FileMaker Server 9 preferences can be made without requiring FileMaker Server 9 to restart.

The only notable exception is if you want to configure SSL encrypted connections to FileMaker Server 9. This requires a restart. Therefore, for companies whose FileMaker Server 9 software configurations are under change management control your policy or SOP for FileMaker Server 9 should clearly state that the only change that requires approval is changing the SSL encryption setting because it requires you to stop the services and restart the server. All other FileMaker Server 9 software configuration changes should be at the discretion of the system administrator. External Authentication FileMaker Pro 9 can authenticate users internally or with Active (Windows) or Open (Apple) Directory. The access privileges themselves are set in the FileMaker Pro database files (File>Manage>Accounts & Privileges. Figure 1), and if “External Server” authentication is selected in FileMaker Pro 9, FileMaker Server 9 security settings must be configured to work with your external server accounts. This means that FileMaker Server 9 cannot operate in a mixed authentication environment. Either you set up authentication through FileMaker Pro or through Active or Open Directory. This white paper will not cover the

Todd Duell is the Vice President & CIO of Formulations Pro, Inc and has been creating powerful commercial and custom solutions using FileMaker Pro since 1989. He holds an MBA in Technology Management, is a Certified FileMaker Pro 7 and 8 Developer, and has been a member of the FileMaker Business Alliance since 1998. Todd may be reached at

DO NOT backup the live files with third party software from vendors such as Retrospect Remote, Veritas or Network Appliance. The backup files will be damaged. Only backup the files created by FileMaker Server 9 from the backup folder. You should periodically check the backup files with a copy of FileMaker Pro 9 on your computer (not on the server) to make sure they are not damaged in the case of a needing to restore the data. Although FileMaker Server 9 can be configured to monitor the health of the file, that does may mean that the file has not lost data due to corruption. You should always periodically check the validity of the backup process. How frequently you check the backup files is dependent on how critical the files are to your business.

Figure 1 Account Settings — Select the authentication method in FileMaker Pro 7 files.

configuration of FileMaker Pro 9 solutions with Active or Open Directory. Live Backups FileMaker Server 9 starts copying the live files while users are still accessing them. At the end of the copy process the file is momentarily paused to synchronize the changes since the start of the copy. The files are physically paused for a very short time so the clients are not inconvenienced while the backup occurs. The copy reflects the state the files were in at the end of the backup process, not the state they were in when the backup started. If a user locks any records, FileMaker Server 9 makes another pass at those records until they are all backed up.

User Connectivity Limits • 125 Files • 250 Concurrent users FileMaker Server 9 can host 125 files. Since each file can have up to 1 million tables, that’s equivalent to 125,000,000 tables per server. When you build your FileMaker Pro file(s) this will be an important consideration in terms of how efficiently you use the 125 file limit. If you need ODBC, JDBC, IWP, or custom web publishing connectivity you will need to upgrade to FileMaker Server 9 Advanced. FileMaker Server 9 Advanced (web publishing) will not be covered in this white paper. Operating Systems • Mac OS X Server (10.4.9, Power-PC or Intel processor) • Mac OS X (10.4.9, Power-PC or Intel processor) • Windows 2000 Server (Service Pack 4) • Windows 2003 Server Standard Edition (Service Pack 2) • Windows XP Professional (Service Pack 2)

Page 2

• •

Java Runtime Environment 5 (6 recommended) Java Runtime Environment 6 for Windows Vista

FileMaker Server 9 runs as a background service (daemon) on both operating systems. Supported Clients • FileMaker Pro 7, 8, 8.5, and 9. • Firefox 2.0 • Internet Explorer 6.0 and 7.0 • Safari 1.2, 1.3, and 2.0 Networking •TCP/IP • Static IP address assigned to FileMaker Server 9 The performance of the client interaction with FileMaker Server 9 will be optimized if it is running on it’s own subnet. The only downfall is that users may have more difficulty locating the server through the Host button if they are not on the same subnet as the server. In this case they will have to know the IP address of the server to store the server address as a favorite host in FileMaker Pro 9. FileMaker Server 9 supports multi-homing. By installing more than one NIC card FileMaker Server 9 can listen and transmit data over more than one subnet. • Port 5003: FileMaker Data port • Port 16000: HTTP Admin Console • Port 16001: HTTPS Admin Console • Port 16004: Admin Console • Port 16006-16018: Web Publishing Engine • Port 50003: FileMaker Server Service/Daemon

• Port 50006: FileMaker Server Helper/Daemon If you need to administer FileMaker Server 9 using the Admin Console through a NAT firewall you will need to open and redirect the ports for 16000. If you need to connect to the FileMaker data through a NAT firewall using FileMaker Pro 9 open and redirect port 5003. If you are connecting to the server remotely over the Internet you should use a secure connection with a Virtual Private Network or enable the SSL encryption between FileMaker Server 9 and the FileMaker Pro 9 client. Server Hardware Selection As everyone knows, there is a big difference between the stated minimums and best practices. FileMaker Server 9 should be deployed on “server class” hardware. That means that you will spend between $4000 and $10,000 depending on your configuration. If you choose Windows as your operating system you will also have to purchase client applications licensing (CALS) for each user. Tack on approximately $300 per user for Windows-based servers. OS X Server comes with an unlimited client license. • 2 GB RAM Install as much RAM as you can afford. New chips, such as the Intel Dual-Core chip, can handle as much as 16 GB of RAM. With RAM being relatively inexpensive we recommend no less than 2 GB of RAM. How much RAM is enough? It depends on the cache hits made to the server, which can be monitored by the Admin Console. If you cannot keep the cache hits at 95% you need more RAM. In general: if you have an enterprise or mission critical solution

Page 3

with several hundred users and/or you maxed out the server with 125 files, you should install as much RAM as possible. If you have less than 50 users and only a few files hosted on the server you can probably get away with 2 GB of RAM. FileMaker Server 9 can use as much as 70% of all available RAM on the server. Anything the clients request that is not available in the cache needs to be loaded from the hard disk. Obviously accessing the hard disk takes longer than just reading it from memory. You should monitor FileMaker Server 9 during peak traffic periods and make sure the “cache hits” are high (around 95%), meaning that 95% of the client requests can be handled by the data that is available in memory and that the hard disk only needs to be consulted sporadically. This will drastically improve overall performance. The trade-off to installing more RAM is the problem associated with server crashes. If the data has not been flushed from the cache and written to the hard drive or backed up and the server crashes all the unsaved changes in RAM will be lost. Therefore you must balance the amount of RAM, cache flushing, and backup intervals with your performance requirements and the importance of your data.

RAID cards with server class computers. RAID 5 systems require a minimum of 3 hard drives. In this configuration the data is striped across all the disks and provides fault tolerance in the event that a disk fails. This means that you can hot-swap (replace) a bad hard drive and the data will automatically be rebuilt. RAID 5 will also allow you to add more drives as your storage needs increase. If you are deploying a FileMaker Pro solution that is HIPAA or 21 CFR 11 compliant with an audit trail (log file) table, you should acquire as much hardware storage as possible because the log file will get very large, very fast. We recommend installing no less than 3 X 80 GB SATA or SCSI hard drives. A typical installation with a 240 GB hard drive might include the following partitions: 1. The swap file (1 GB). All modern operating systems use swap files to create ‘virtual memory’. It’s a temporary placeholder for data that does not fit in the physically available RAM. 2. The operating system (5 GB) 3. The Applications (5 GB) 4. Live “hosted” files (114.5 GB or half of the remaining space) 5. Backup files (114.5 GB or half of the remaining space)

• RAID 5, 3 x 80 GB SATA or SCSI Hard Drives Install the fastest hard drive you can afford. With large amounts of cache to backup on a continual basis the speed of the hard drive will be critical to your server’s performance. To increase performance and capacity you should install a RAID 5 configuration. For maximum RAID performance, the RAID controller should come from a hardware RAID, not a software RAID. Both Apple and Intel-based servers offer

The key to consider when partitioning your hard drive is that the backup files need just as much space as your live files. That reduces the overall disk storage of your server by half. You might consider backing up your live files to remote network application storage (NAS) server or tape drive to save space. However, if you do this you must understand that the process of transferring the data from FileMaker Server 9 will place a tremendous load on the server and your network. Thus, greatly affecting the performance of your system if users are accessing

Page 4

the data. Although it is possible to perform backups to external locations, we recommend that this only be done during non-peak hours or in the middle of the night when users are not accessing the server or the network.

means that the server’s processor will have a significant load as more users are accessing the files. Thus, multiple processors will provide vastly improved performance. We recommend that you use a dual-core Intel or dual Xenon processor.

• 1000 BT Ethernet Card

Automatic Hosting FileMaker Server 9 will automatically host all files in the “Databases” folder (FileMaker Server 9/Data/Databases) and subfolders one level down from there when the service launches. You can also specify an additional folder if necessary. The files there and in subfolders one level down are also automatically hosted. This makes it very easy to deploy FileMaker files away from the system and application partitions and put them on their own partition on the hard disk.

Install the fastest NIC card you can afford. We do not recommend anything less than a 1000 BT NIC card for a server unless your switches are only 10/100 BT. Then 1000 BT will not be utilized to its fullest capacity. FileMaker Server 9 supports multi-homing. A server is multihomed when it has one or more IP address for more than one NIC (Ethernet) card. How that is set up depends on the Operating System, but both Mac OS X and Windows support multi-homed systems. This opens a wide variety of configuration options ranging from aliasing one IP address across multiple network cards in order to maximize server throughput, to making one FileMaker Server 9 available to different subnets with one network card configured for each subnet. In general, one NIC card should be sufficient for up to 100 concurrent users. If you have more than 100 concurrent users you should consider installing additional NIC cards.

Accessing the Admin Console FileMaker Server 9 no longer requires a special client to be installed on your computer for administration. You can download the Admin Console directly from the server using your web browser. Use one of the following URL strings to access the Admin Console Start Page. If you are on the server you can use localhost, otherwise you will need to know the IP Address of the server. Remember that FileMaker Server 9 Admin Console runs on port 16000. Click the Start Admin Console button and a java file will be downloaded to your desktop that will enable you to access FileMaker Server.

• Intel Dual-Core or Xenon Processor Install the fastest processor you can afford. FileMaker Server 9 can utilize multiple processors. The FileMaker Server 9 engine now performs many of the calculations before sending the data back to the user. This

http://localhost:16000 http://:16000 Operating System Performance Tuning The server should be dedicated to hosting FileMaker Server 9. DO NOT enable or install any additional services or share

Page 5

FileMaker Server 9 with services such as; DHCP, DNS, or email services. That is the fastest way to poor performance, unexpected crashing, and data loss. DO NOT set the server’s operating system energy saver settings to put the computer or hard drive to sleep. The server should be constantly running. OS X Energy Saver preferences are located in the System Preferences. Windows 2000/2003 Server Energy Saver preferences are located in the Power options Hibernation and Standby Mode. DO NOT configure virus checking software to scan the active database files. They will constantly change, which will give the virus software a false positive. Actively scanning the files may also corrupt the databases. Turn off Indexing Service (Windows) and Spotlight (OS X). This feature reduces performance. You should install A UPS backup system for your server. This will provide you with enough time to shut down the server in the event of a power failure. Installation of FileMaker Server 9 — Single Machine If you want to install the web components on two or more machines please consult the FileMaker Server 9 Getting Started Guide. This setup is only for a single server. 1. Double-click the FileMaker Server 9 icon. 2. Select Single Machine and click Next.

Windows: Java Runtime Environment 6 will be installed if you don’t already have it. OS X: May need to install JRE 6 using the Software Update function. 4. Start the deployment assistant. Windows: Check the Start the Deployment assistant box and click Finish. OS X: Click the continue button. 5. Follow the on-screen instructions. Each section will be detailed in below. Manual Installation of FileMaker Pro 9 Files for Hosting Place your database files in the FileMaker Server 9/Data/Databases folder. You can place files in separate folders for better organization. FileMaker Server 9 will automatically serve all databases in the main Databases folder and one folder lower. If you use OS X Sever you must assign the following privileges to the database files and plug-ins: • Group: fmsadmin • Access: Read & Write The ownership and permissions for the files can be changed by clicking the folder or file icon and choosing File>Get Info (Figure 2).

3. Enter the license key information and click Install.

Page 6

Figure 3 Upload a Database

Figure 2 Ownership and Permissions — Change the Group to fmsadmin and the Access to Read and Write.

Automatic Installation of FileMaker Pro 9 Files for Hosting The Admin Console has an automatic feature that lets you upload databases from your computer to the server. With the FileMaker Server Admin Console open, choose Server>Upload Database. Then follow the on screen instructions to upload your file (Figure 3). It even changes the file permission for OS X servers!

Page 7

Configuration of FileMaker Server Using Admin Console These instructions will balance security with ease of use and configuration to minimize the burden and cost of administration. If you need additional instructions please consult the FileMaker Server 9 Getting Started Guide. These instructions may use images from both OS X and Windows. These instructions do not endorse one platform over another. Server Information (Figure 4) Use a custom name for the server. When users open the server through the Host button they will see the custom name. You may already have naming conventions for your servers. Naming conventions usually have a standard abbreviation for the application running on the server (i.e. FMS9), the department (i.e. Production), and the property tag number or serial number of the server (i.e. 000001) = FMS9 Prod 1. The owner’s information is also information if you have more than one administrator that takes care of the server.

Figure 4 Server Information

Page 8

Email Notifications (Figure 5) FileMaker Server 9 can be configured to send email notifications for errors, warnings, backups, and completed scripts. You will need to know the email settings to configure the addresses, user account, and password. It’s always a good thing to immediately know if there is an error on the server rather than finding out several days later or from an end user when it’s too late to fix it.

Figure 5 Email Notifications

Page 9

Admin Console (Figure 6) Unless you have some security requirement that prevents you from accessing FileMaker Server from your computer rather than directly from the server you can leave the Enable access restrictions unchecked. Make sure that if you access FileMaker Server from outside your network that you do so connected via VPN or using the URL https://:16001, which is the secure connection to the FileMaker Server Admin Console.

You must authenticate yourself (i.e. enter the user name and password) to FileMaker Server when you access it using the Admin Console. If you need to change the password, this is where to change it. I do not recommend that you allow FileMaker Server to check for updates. This takes away performance from the server and may cause it to hang with a dialog box that asks you if you want to install the update. Considering this is a server and you may not see the actual desktop interface for days or weeks at a time it’s best to update the software either at defined maintenance periods or when you receive notice from FileMaker of an available update. You certainly don’t ever update a production server without testing the update first!

Figure 6 Admin Console

Page 10

Auto Start (Figure 7) In the event of a power failure or a restart you always want to automatically start any necessary services. This simply makes your life easier as an administrator.

Figure 6 Auto Start

Page 11

FileMaker Pro Clients (Figure 8) Set the maximum number of clients to 10% more FileMaker Pro users than you expect to access the server. Even though you can host up to 250 users, each user takes up worker threads on the server, which increases overhead. Reducing overhead significantly improves performance. Since this setting can be reset without requiring a restart of the server there is no reason to allow more connections more than necessary.

download them and install them on the client computers. This saves a significant amount of time and hassle for system administrators. Your internal policies will dictate how much time to allow users to be inactive. We recommend setting the maximum idle time for FileMaker Pro 9 clients to no more than 90 minutes. Idle users take up valuable threads on the server. 90 minutes is enough time to go to a meeting or lunch, come back, and then resume work. Longer periods of inactivity unnecessarily leave your solutions open for unauthorized access. For information on setting up Directory Service please consult your system administrator and the FileMaker Server 9 Getting Started guide.

Figure 8 FileMaker Pro Clients

Check the box to allow FileMaker Pro clients to download plug-in updates. Your FileMaker Pro 9 solution must be programmed to download plug-in updates. If newer plug-ins are placed on the server FileMaker Pro 9 will automatically

Page 12

Databases (Figure 9) Set the maximum number of files to host to the exact number of files hosted on the server. Since this setting can be reset without requiring a restart of the server there is no reason to host more files (i.e. open threads) than necessary.

FileMaker Server 9 is constantly flushing the cache to the hard drive. FileMaker Server 9 inspects up to 1/60th of the cache every second and writes any changes to the disk. For example, if you assign 2000 MB of RAM for cache and distribute the cache over 30 minutes it will write approximately 1.1 MB of cache to the disk each second or: 1/60 x 2000 MB RAM / 30 minutes = 1.1 MB RAM/second This means that all changes on the server will be no older than the time specified for the cache flush (30 minutes in the example above). Therefore, if your data is mission critical you may want to specify the cache flush be set to shorter time intervals. If your data is not as critical the cache flush can be set to longer time intervals. In this method FileMaker Server 9 can distribute its disk writing over time, and therefore allow the server CPU a higher priority to service client requests, as it will take much less time to inspect 1 MB compared to 2000 MB if the setting is left at 1 minute. Overall, we recommend that you leave the cache flush distribution interval to 1 minute because all modern operating systems and RAM should be able to handle this setting quite easily even with large amounts of RAM.

Figure 9 Databases

FileMaker Server 9 will tell you exactly how much RAM you can assign based on the amount of available memory on the server. In general, assigning more RAM will improve performance for larger database files and more users. How much RAM you assign to FileMaker Server 9 and how long you assign to distribute the cache flush for writing the data stored in RAM to the disk is a balancing act based on your desired performance and data integrity requirements.

Another server statistic to consider is the amount of unsaved cache as a percentage of the total cache. This number should be relatively low (less than 5%) if your data is critical. If this number is too high you can decrease the cache flush interval to ensure that the cache is flushed more frequently.

Page 13

Security (Figure 10) Client Authentication depends on how you want to authenticate the users. If you authenticate the users with the accounts stored in each database when the user logs in choose FileMaker accounts only. If you use Active or Open Directory choose FileMaker and external server accounts. The user name and password are authenticated against the account name and password specified in FileMaker Pro accounts or against an Open or Active Directory (i.e. external server). The external server returns local and domain group accounts that the user belongs to, which are then authenticated against the group accounts specified in FileMaker Pro External Server accounts. FileMaker Server does not operate in a mixed environment for authentication, so you have to choose one approach and stick to it. The easiest method is usually to authenticate using FileMaker accounts. That way you are free to develop FileMaker Pro database without dealing with the hassle of setting up new groups in Active or Open Directory for every single user. Your goal should always be to reduce the administration burden on your IT staff. The easiest setting to display the files is List all databases. If you have any security restraints you can choose to List only the databases each user is authorized to access. This will only show the list of database for which the user has an account. The downfall of this setting is that they have to first authenticate themselves to the server, then log into the database. Thus, they have to log in twice, which can be a hassle. Note that this does not prohibit the user from making a direct URL request to open the database with a shortcut. Therefore, this setting really does not provide any additional security!

Figure 10 Security

If you require a SSL connection between FileMaker Pro and FileMaker Server 9 you can check the box for Secure connections to FileMaker Server. This is the only setting on the server that will require a restart of FileMaker Server. The SSL connection is only between FileMaker Pro and FileMaker Server. It does not encrypt ODBC, JDBC, IWP, or custom web publishing connections. The connection speed is slower with encryption turned on. However, you will be quite surprised to see that the performance does not take as much as hit as you would expect. In our testing it is typically about 10% slower. You may see slower performance depending on your environment.

Page 14

Default Folders (Figure 11) FileMaker Server’s default database folders for live, hosted files are: Windows filewin:/C:/Program Files/FileMaker/FileMaker Server/Data/Databases/ OS X filemac:/Macintosh HD/Library/FileMaker Server/Data/Databses We recommend that you use the default location to host the files unless you have you have partitioned your hard drive. FileMaker Server will automatically host any files in this location as well as one folder down when the server is started. If you upload the files to the server FileMaker Server 9 will automatically host the files (if you don’t exceed the number of hosted files set in Figure 9). Otherwise you can place your databases where every you want. Just check the Use additional databases folder and enter the path. Sorry, but there is no browse button to select the folder, so you have to enter the path manually. Just make sure to use either the filewin:/ or filemac:/ format when you specify the path. Then click the validate button to make sure the path is correct. Even though FileMaker Server can host files from up to two locations, please don’t host files from outside the server on a client computer or a file server. This will provide horrible performance. It’s best practices to host the files from one central folder and use one or more sub-folders to organize the databases logically. For example, organize the

Figure 11 Default Folders

folders by work group (i.e. HR, Accounting, Purchasing, etc.) or by “modules” when 2 or more databases are use together. FileMaker Server’s default backup folders are in the following location: Windows filewin:/C:/Program Files/FileMaker/FileMaker Server/Data/Backups/ OS X filemac:/Macintosh HD/Library/FileMaker Server/Data/Backups

Page 15

You can only backup databases to a single folder. We recommend using the default location unless you have partitioned the hard drive. NEVER, ever backup the live database files to a backup drive or file server with third party software. This may corrupt the live files. Only backup the backup folder with third party software. Unfortunately, you cannot specify the backup path to a file server or backup drive to avoid using third party software. However, if you are cleaver enough you can use free resources such as Automator and iCal on OS X or the Backup utility on Windows to avoid using third party software. Just because these options are free does not mean that third party software doesn’t provide valuable automation and restoration. We highly recommend using either Retrospect Remote or Veritas (now Symantec) backup software.

Page 16

Logging (Figure 12) FileMaker Server 9 logs items such as FileMaker Server starting and stopping, database files opening and closing, clients logging in and out, failed logins, plug in downloads, scheduled tasks running, usage statistics, and changes to FileMaker Server properties. The log files have a maximum size of 40 MB.

Log files are located at: FileMaker Server/Data/Logs/. Logs can be viewed with the OS X Console, the Windows 2000 Server Performance Logs and Alerts, or the Windows 2003 Server System Monitor applications. • Windows log: Application.Log • OS X log: Event.log Server statistics are located at: FileMaker Server/Data/Logs/. Logs are best viewed in the Admin Console using the Statistics window. • Windows stats log: Stats.log • OS X stats log: Stats.log

Figure 12 Logging

When you first setup FileMaker Server 9 you should monitor the statistics frequently to determine how well the server is performing. We recommend updating the usage statistics every 15 seconds and setting the minimum size of the usage log to 40 MB. After you get your server dialed in at 95% cache hits you can either turn off the usage statistics or set the time interval to every 5 minutes.

Page 17

Server Plugins (Figure 13) Plugins that run on the server can be installed at: FileMaker Server/Extensions/Plugins/ The purpose of a plugin is to extend the functionality of FileMaker Server. For example, connecting to a clearinghouse to accept credit card payments. Check with the plugin vendor’s documentation before deploying it on FileMaker Server. Note: this is not the same feature as FileMaker Pro clients downloading plugins (Figure 8).

Figure 13 Server Plugins

Page 18

Web Publishing (General Settings Figure 14) Custom Web Publishing with PHP, ASP, and JSP is out of scope for this white paper. However, if you use Instant Web Publishing (IWP) FileMaker Server can log the usage statistics for access, errors, ScriptMaker errors, and user access (via XSLT). The setting of most importance is the maximum number of web publishing sessions. FileMaker Server allows up to 100 concurrent IWP sessions. Just because you can set it to 100 users does not mean that this is a good idea. You should limit it to the maximum number of concurrent IWP users to reduce the number of open threads. Open threads, even if unused, reduce the overall performance of the server.

Figure 14 General Settings

Page 19

ODBC/JDBC (Figure 15) FileMaker Server and the hosted databases can be used as ODBC and/or JDBC data sources. In other words, they can supply data to ORACLE, SQL, and Excel if the appropriate driver is installed on the client computer and the DSN is set up correctly to make the connection. Check with the driver manufacturer’s documentation and your system administrator for the correct settings.

making the request can also be set to store additional requests if the server is busy. Therefore, 50 concurrent connections can actually support quite a heavy load.

Figure 15 ODBC/JDBC

FileMaker Server supports 50 concurrent ODBC/JDBC connections. Although this does not seem like much, the connections are opened and closed by the driver very quickly. Once the connection is closed it goes back to the available pool. Typically the application or web server

Page 20

Creating Schedules (Figure 16) You can create automated schedules for backups, running scripts, and sending messages. Choose Create a Schedule then click the Perform Action button. Then follow the schedule wizard to define the schedule.

If you enable the feature to send the administrator an email notification after a schedule is run they will receive information whether the schedule ran correctly or not. Otherwise you can monitor the Last Run Status for problems.

Figure 16 Schedules

Backups can be run for one or more databases at any defined time criteria. Scripts can be run from any database, Windows batch file, Perl, VBScript, or AppleScript. Scripts are typically run by the server to perform an automated task on a set of data. NOTE: Only web compatible scripts steps will run with FileMaker Pro. That means scripts that printing reports in the middle of the night are still not possible without using a “robot” computer.

Page 21

Plug-ins (Figure 17) Plug-in files need to be manually placed in the correct folder location on the server. Windows FileMaker Server 9\Data\Databases\AutoUpdate\ OS X FileMaker Server 9/Data/Databases/AutoUpdate/ The FileMaker Pro Plug-ins Preferences need to be enabled to auto-update the plug-in from the server. If the client needs to use the plug-in it must also be checked in the Plug-in Preferences. Plug-ins located on the OS X server MUST be in tar compressed format (plugin.tar). Plug-ins for Windows must be in the .fmx format (plugin.fmx). You can also manually place the plug-ins (uncompressed) on the client computers running FileMaker Pro 9. Windows: FileMaker Pro 9\Extensions\ OS X FileMaker Pro 9/Extensions/

Figure 17 Auto Update Plug-in — Check the box in the FileMaker Pro Plug-in Preferences to automatically download plug-ins from the server.

Page 22

FileMaker Server 9 Best Practices Everything you need to know about hardware survival, system specifications, installation and configuration.By Todd DuellW hat do you need to do to configure your server to optimize operation ? User ’ south guides and manuals rarely answer that motion. They tend to only offer minimum settings and alone the most basic shape information without regard for the shock that the settings will have on security system and performance. This white composition will discuss everything you need to know about hardware excerpt, arrangement specifications, initiation, and configuration of FileMaker Server 9. This white newspaper will make some assumptions in the recommend shape settings to balance price, still of administration, and security. For extra details on functions not covered in this white paper please read the FileMaker Server 9 Getting Started Guide and the technical brief : upgrade to FileMaker 7 : How to take advantage of the raw server model and capabilities, which are available from FileMaker, Inc. Live Configuration Changes Almost all changes to the FileMaker Server 9 preferences can be made without requiring FileMaker Server 9 to restart.The only celebrated exception is if you want to configure SSL code connections to FileMaker Server 9. This requires a restart. Therefore, for companies whose FileMaker Server 9 software configurations are under change management control your policy or SOP for FileMaker Server 9 should clearly state that the merely change that requires approval is changing the SSL encoding set up because it requires you to stop the services and restart the server. All other FileMaker Server 9 software configuration changes should be at the free will of the system administrator. external Authentication FileMaker Pro 9 can authenticate users internally or with Active ( Windows ) or Open ( Apple ) Directory. The access privileges themselves are set in the FileMaker Pro database files ( File > Manage > Accounts & Privileges. Figure 1 ), and if “ External Server ” authentication is selected in FileMaker Pro 9, FileMaker Server 9 security settings must be configured to work with your external waiter accounts. This means that FileMaker Server 9 can not operate in a blend authentication environment. Either you set up authentication through FileMaker Pro or through Active or Open Directory. This white composition will not cover theTodd Duell is the Vice President & CIO of Formulations Pro, Inc and has been creating knock-down commercial and custom-made solutions using FileMaker Pro since 1989. He holds an MBA in Technology Management, is a certified FileMaker Pro 7 and 8 Developer, and has been a member of the FileMaker Business Alliance since 1998. Todd may be reached at [ e-mail protected ] © 2007 Formulations Pro, Inc. All rights reserved. www.formulationspro.comDO NOT backup the survive files with third base party software from vendors such as Retrospect Remote, Veritas or Network Appliance. The stand-in files will be damaged. entirely backup the files created by FileMaker Server 9 from the accompaniment booklet. You should sporadically check the backing files with a copy of FileMaker Pro 9 on your calculator ( not on the server ) to make sure they are not damaged in the font of a need to restore the datum. Although FileMaker Server 9 can be configured to monitor the health of the file, that does may mean that the file has not lost data due to corruptness. You should constantly sporadically check the robustness of the backup process. How frequently you check the backup files is dependent on how critical the files are to your business.Figure 1 Account Settings — Select the authentication method acting in FileMaker Pro 7 files.configuration of FileMaker Pro 9 solutions with Active or Open Directory. Live Backups FileMaker Server 9 starts copying the live files while users are still accessing them. At the end of the copy process the file is momentarily paused to synchronize the changes since the starting signal of the transcript. The files are physically paused for a very abruptly time so the clients are not inconvenienced while the accompaniment occurs. The replicate reflects the department of state the files were in at the end of the backup process, not the state they were in when the stand-in started. If a drug user locks any records, FileMaker Server 9 makes another run at those records until they are all backed up.User Connectivity Limits • 125 Files • 250 Concurrent users FileMaker Server 9 can host 125 files. Since each file can have up to 1 million tables, that ’ s equivalent to 125,000,000 tables per server. When you build your FileMaker Pro file ( south ) this will be an important consideration in terms of how efficiently you use the 125 charge limit. If you need ODBC, JDBC, IWP, or custom-made web publishing connectivity you will need to upgrade to FileMaker Server 9 Advanced. FileMaker Server 9 Advanced ( web publishing ) will not be covered in this white paper. Operating Systems • Mac OS X Server ( 10.4.9, Power-PC or Intel processor ) • Mac OS X ( 10.4.9, Power-PC or Intel central processing unit ) • Windows 2000 Server ( Service Pack 4 ) • Windows 2003 Server Standard Edition ( Service Pack 2 ) • Windows XP Professional ( Service Pack 2 ) page 2• •Java Runtime Environment 5 ( 6 recommended ) Java Runtime Environment 6 for Windows VistaFileMaker Server 9 runs as a background military service ( daemon ) on both operating systems. back Clients • FileMaker Pro 7, 8, 8.5, and 9. • Firefox 2.0 • Internet Explorer 6.0 and 7.0 • Safari 1.2, 1.3, and 2.0 Networking •TCP/IP • Static IP address assigned to FileMaker Server 9 The performance of the client interaction with FileMaker Server 9 will be optimized if it is running on it ’ s own subnet. The merely precipitation is that users may have more difficulty locating the server through the Host clitoris if they are not on the like subnet as the server. In this case they will have to know the IP cover of the server to store the server address as a favorite host in FileMaker Pro 9. FileMaker Server 9 supports multi-homing. By installing more than one NIC batting order FileMaker Server 9 can listen and transmit data over more than one subnet. • port 5003 : FileMaker Data port • Port 16000 : HTTP Admin Console • Port 16001 : HTTPS Admin Console • Port 16004 : Admin Console • Port 16006-16018 : web Publishing Engine • Port 50003 : FileMaker Server Service/Daemon• Port 50006 : FileMaker Server Helper/Daemon If you need to administer FileMaker Server 9 using the Admin Console through a NAT firewall you will need to open and redirect the ports for 16000. If you need to connect to the FileMaker data through a NAT firewall using FileMaker Pro 9 exposed and redirect port 5003. If you are connecting to the waiter remotely over the Internet you should use a secure association with a Virtual Private Network or enable the SSL encoding between FileMaker Server 9 and the FileMaker Pro 9 node. Server Hardware Selection As everyone knows, there is a big difference between the stated minimums and best practices. FileMaker Server 9 should be deployed on “ server class ” hardware. That means that you will spend between $ 4000 and $ 10,000 depending on your shape. If you choose Windows as your operate on system you will besides have to purchase customer applications license ( CALS ) for each user. tack on approximately $ 300 per exploiter for Windows-based servers. OS X Server comes with an outright client license. • 2 GB RAM Install as much RAM as you can afford. New chips, such as the Intel Dual-Core chip, can handle deoxyadenosine monophosphate much as 16 GB of RAM. With RAM being relatively cheap we recommend no less than 2 GB of RAM. How much RAM is adequate ? It depends on the hoard hits made to the server, which can be monitored by the Admin Console. If you can not keep the cache hits at 95 % you need more RAM. In general : if you have an enterprise or mission critical solutionPage 3with several hundred users and/or you maxed out the waiter with 125 files, you should install as much RAM as potential. If you have less than 50 users and entirely a few files hosted on the server you can probably get off with 2 GB of RAM. FileMaker Server 9 can use arsenic much as 70 % of all available RAM on the waiter. Anything the clients request that is not available in the hoard needs to be loaded from the heavily disk. obviously accessing the heavily harrow takes longer than just reading it from memory. You should monitor FileMaker Server 9 during flower traffic periods and make sure the “ cache hits ” are high ( around 95 % ), meaning that 95 % of the customer requests can be handled by the data that is available in memory and that the hard disk alone needs to be consulted sporadically. This will drastically improve overall operation. The tradeoff to installing more RAM is the trouble associated with server crashes. If the data has not been flushed from the cache and written to the hard drive or backed up and the server crashes all the cursed changes in RAM will be lost. Therefore you must balance the come of RAM, cache flush, and backup intervals with your performance requirements and the importance of your data.RAID cards with server class computers. raid 5 systems require a minimum of 3 difficult drives. In this configuration the data is striped across all the disks and provides fault tolerance in the event that a disk fails. This means that you can hot-swap ( replace ) a bad hard drive and the datum will automatically be rebuilt. RAID 5 will besides allow you to add more drives as your storage needs increase. If you are deploying a FileMaker Pro solution that is HIPAA or 21 CFR 11 compliant with an audit chase ( logarithm file ) mesa, you should acquire as much hardware storage as possible because the log file will get identical large, very firm. We recommend installing no less than 3 x 80 GB SATA or SCSI unvoiced drives. A typical initiation with a 240 GB hard drive might include the follow partitions : 1. The swap file ( 1 GB ). All mod operating systems use trade files to create ‘ virtual memory ’. It ’ s a irregular placeholder for data that does not fit in the physically available RAM. 2. The operate on system ( 5 GB ) 3. The Applications ( 5 GB ) 4. exist “ hosted ” files ( 114.5 GB or half of the remaining space ) 5. backup files ( 114.5 GB or half of the remaining space ) • RAID 5, 3 x 80 GB SATA or SCSI Hard Drives Install the fastest hard drive you can afford. With big amounts of hoard to backup on a continual footing the amphetamine of the hard drive will be critical to your server ’ s operation. To increase performance and capacity you should install a RAID 5 configuration. For maximum RAID performance, the RAID control should come from a hardware RAID, not a software RAID. Both Apple and Intel-based servers offerThe key to consider when partitioning your hard drive is that the backup files need good arsenic much space as your live files. That reduces the overall disk memory of your server by one-half. You might consider backing up your populate files to remote network application repositing ( NAS ) server or magnetic tape drive to save space. however, if you do this you must understand that the process of transferring the datum from FileMaker Server 9 will place a fantastic load on the waiter and your network. therefore, greatly affecting the performance of your system if users are accessingPage 4the data. Although it is potential to perform backups to external locations, we recommend that this only be done during non-peak hours or in the center of the night when users are not accessing the server or the network.means that the server ’ sulfur processor will have a meaning lode as more users are accessing the files. therefore, multiple processors will provide vastly improved performance. We recommend that you use a dual-core Intel or dual Xenon processor.• 1000 BT Ethernet CardAutomatic Hosting FileMaker Server 9 will automatically host all files in the “ Databases ” booklet ( FileMaker Server 9/Data/Databases ) and subfolders one level down from there when the service launches. You can besides specify an extra booklet if necessity. The files there and in subfolders one degree down are besides mechanically hosted. This makes it very easy to deploy FileMaker files away from the system and application partitions and put them on their own partition on the hard disk.Install the fastest NIC card you can afford. We do not recommend anything less than a 1000 BT NIC menu for a server unless your switches are only 10/100 BT. then 1000 BT will not be utilized to its fullest capacity. FileMaker Server 9 supports multi-homing. A server is multihomed when it has one or more IP address for more than one NIC ( Ethernet ) wag. How that is set up depends on the operate System, but both Mac OS X and Windows support multi-homed systems. This opens a across-the-board kind of configuration options ranging from aliasing one IP address across multiple network cards in club to maximize server throughput, to making one FileMaker Server 9 available to different subnets with one network card configured for each subnet. In general, one NIC tease should be sufficient for up to 100 coincident users. If you have more than 100 coincident users you should consider installing extra NIC cards.Accessing the Admin Console FileMaker Server 9 no longer requires a special node to be installed on your computer for government. You can download the Admin Console immediately from the server using your vane browser. Use one of the stick to URL strings to access the Admin Console Start Page. If you are on the server you can use localhost, otherwise you will need to know the IP Address of the server. Remember that FileMaker Server 9 Admin Console runs on port 16000. Click the Start Admin Console release and a coffee file will be downloaded to your desktop that will enable you to access FileMaker Server.• Intel Dual-Core or Xenon Processor Install the fastest processor you can afford. FileMaker Server 9 can utilize multiple processors. The FileMaker Server 9 engine now performs many of the calculations before sending the data back to the drug user. Thishttp : //localhost:16000 hypertext transfer protocol : //:16000 Operating System Performance Tuning The server should be dedicated to hosting FileMaker Server 9. DO NOT enable or install any extra services or sharePage 5FileMaker Server 9 with services such as ; DHCP, DNS, or e-mail services. That is the fastest way to hapless performance, unexpected barge in, and data loss. DO NOT set the waiter ’ s operating system energy rescuer settings to put the computer or hard drive to sleep. The waiter should be constantly running. OS X Energy Saver preferences are located in the System Preferences. Windows 2000/2003 Server Energy Saver preferences are located in the Power options Hibernation and Standby Mode. DO NOT configure virus checking software to scan the active agent database files. They will constantly change, which will give the virus software a false convinced. actively scanning the files may besides corrupt the databases. Turn off Indexing Service ( Windows ) and Spotlight ( OS X ). This feature of speech reduces performance. You should install A UPS stand-in system for your server. This will provide you with enough meter to shut down the waiter in the event of a power bankruptcy. installation of FileMaker Server 9 — Single Machine If you want to install the web components on two or more machines please consult the FileMaker Server 9 Getting Started Guide. This apparatus is only for a individual waiter. 1. Double-click the FileMaker Server 9 icon. 2. blue-ribbon Single Machine and chink Next.Windows : Java Runtime Environment 6 will be installed if you don ’ metric ton already have it. OS ten : May need to install JRE 6 using the Software Update officiate. 4. Start the deployment assistant. Windows : Check the Start the Deployment adjunct box and chink Finish. OS ten : Click the continue button. 5. Follow the on-screen instructions. Each part will be detailed in below. manual installation of FileMaker Pro 9 Files for Hosting Place your database files in the FileMaker Server 9/Data/Databases folder. You can place files in branch folders for better constitution. FileMaker Server 9 will automatically serve all databases in the independent Databases folder and one folder lower. If you use o X Sever you must assign the play along privileges to the database files and plug-ins : • Group : fmsadmin • Access : Read & Write The ownership and permissions for the files can be changed by clicking the folder or file icon and choosing File > Get Info ( Figure 2 ) .3. Enter the license key information and cluck Install.Page 6Figure 3 upload a DatabaseFigure 2 Ownership and Permissions — Change the Group to fmsadmin and the Access to Read and Write.Automatic Installation of FileMaker Pro 9 Files for Hosting The Admin Console has an automatic feature of speech that lets you upload databases from your calculator to the waiter. With the FileMaker Server Admin Console assailable, choose Server > Upload Database. then follow the on riddle instructions to upload your file ( Figure 3 ). It flush changes the file permission for OS X servers ! page 7Configuration of FileMaker Server Using Admin Console These instructions will balance security with relief of consumption and configuration to minimize the burden and cost of administration. If you need extra instructions please consult the FileMaker Server 9 Getting Started Guide. These instructions may use images from both OS X and Windows. These instructions do not endorse one platform over another. server Information ( Figure 4 ) Use a custom diagnose for the server. When users open the server through the Host clitoris they will see the custom appoint. You may already have naming conventions for your servers. Naming conventions normally have a standard abbreviation for the application running on the server ( i.e. FMS9 ), the department ( i.e. production ), and the property tag number or serial number of the server ( i.e. 000001 ) = FMS9 Prod 1. The owner ’ second information is besides data if you have more than one administrator that takes care of the server.Figure 4 Server InformationPage 8Email Notifications ( Figure 5 ) FileMaker Server 9 can be configured to send electronic mail notifications for errors, warnings, backups, and completed scripts. You will need to know the electronic mail settings to configure the addresses, drug user history, and password. It ’ mho always a good matter to immediately know if there is an error on the waiter rather than finding out several days late or from an end exploiter when it ’ south besides deep to fix it.Figure 5 Email NotificationsPage 9Admin Console ( Figure 6 ) Unless you have some security requirement that prevents you from accessing FileMaker Server from your computer preferably than immediately from the waiter you can leave the Enable access restrictions unchecked. Make certain that if you access FileMaker Server from outside your network that you do so connect via VPN or using the URL hypertext transfer protocol : //:16001, which is the secure connection to the FileMaker Server Admin Console.You must authenticate yourself ( i.e. enter the exploiter name and password ) to FileMaker Server when you access it using the Admin Console. If you need to change the password, this is where to change it. I do not recommend that you allow FileMaker Server to check for updates. This takes away performance from the server and may cause it to hang with a dialogue box that asks you if you want to install the update. Considering this is a server and you may not see the actual desktop interface for days or weeks at a time it ’ south best to update the software either at specify sustenance periods or when you receive notice from FileMaker of an available update. You surely don ’ deoxythymidine monophosphate ever update a product server without testing the update first ! figure 6 Admin ConsolePage 10Auto Start ( Figure 7 ) In the consequence of a power failure or a restart you constantly want to mechanically start any necessary services. This simply makes your life sentence easy as an administrator.Figure 6 Auto StartPage 11FileMaker Pro Clients ( Figure 8 ) Set the maximum issue of clients to 10 % more FileMaker Pro users than you expect to access the server. even though you can host up to 250 users, each exploiter takes up proletarian threads on the waiter, which increases overhead. Reducing overhead significantly improves performance. Since this fructify can be reset without requiring a restart of the server there is no reason to allow more connections more than necessary.download them and install them on the customer computers. This saves a meaning amount of time and fuss for system administrators. Your home policies will dictate how much time to allow users to be inactive. We recommend setting the maximum idle time for FileMaker Pro 9 clients to no more than 90 minutes. idle users take up valuable threads on the server. 90 minutes is enough time to go to a meeting or lunch, come second, and then resume shape. Longer periods of inaction unnecessarily leave your solutions open for unauthorized entree. For data on setting up Directory Service please consult your arrangement administrator and the FileMaker Server 9 Getting Started guide.Figure 8 FileMaker Pro ClientsCheck the box to allow FileMaker Pro clients to download circuit board updates. Your FileMaker Pro 9 solution must be programmed to download circuit board updates. If newer plug-ins are placed on the server FileMaker Pro 9 will automaticallyPage 12Databases ( Figure 9 ) Set the maximum number of files to host to the claim count of files hosted on the server. Since this setting can be reset without requiring a resume of the server there is no reason to host more files ( i.e. open threads ) than necessary.FileMaker Server 9 is constantly flushing the cache to the hard drive. FileMaker Server 9 inspects up to 1/60th of the cache every second base and writes any changes to the harrow. For model, if you assign 2000 MB of RAM for cache and distribute the cache over 30 minutes it will write approximately 1.1 MB of hoard to the harrow each second gear or : 1/60 adam 2000 MB RAM / 30 minutes = 1.1 MB RAM/second This means that all changes on the waiter will be no older than the meter specified for the cache flush ( 30 minutes in the example above ). consequently, if your data is deputation critical you may want to specify the cache flush be set to shorter time intervals. If your data is not american samoa critical the hoard flush can be set to longer fourth dimension intervals. In this method FileMaker Server 9 can distribute its phonograph record spell over time, and consequently allow the server CPU a higher precedence to service customer requests, as it will take much less time to inspect 1 MB compared to 2000 MB if the set is left at 1 minute. overall, we recommend that you leave the cache hot flash distribution time interval to 1 minute because all modern operating systems and RAM should be able to handle this setting quite easily tied with large amounts of RAM.Figure 9 DatabasesFileMaker Server 9 will tell you precisely how a lot RAM you can assign based on the amount of available memory on the server. In general, assigning more RAM will improve performance for larger database files and more users. How much RAM you assign to FileMaker Server 9 and how long you assign to distribute the cache flush for writing the datum stored in RAM to the disk is a balancing act based on your desire performance and data integrity requirements.Another waiter statistic to consider is the total of cursed hoard as a share of the total hoard. This phone number should be relatively low ( less than 5 % ) if your data is critical. If this number is besides high you can decrease the cache flush interval to ensure that the cache is flushed more frequently.Page 13Security ( Figure 10 ) Client Authentication depends on how you want to authenticate the users. If you authenticate the users with the accounts stored in each database when the drug user logs in choose FileMaker accounts entirely. If you use active or candid Directory choose FileMaker and external waiter accounts. The exploiter name and password are authenticated against the account name and password specified in FileMaker Pro accounts or against an open or active Directory ( i.e. external server ). The external server returns local and domain group accounts that the drug user belongs to, which are then authenticated against the group accounts specified in FileMaker Pro External Server accounts. FileMaker Server does not operate in a interracial environment for authentication, so you have to choose one set about and lodge to it. The easiest method is normally to authenticate using FileMaker accounts. That direction you are free to develop FileMaker Pro database without dealing with the fuss of setting up new groups in Active or Open Directory for every single exploiter. Your goal should always be to reduce the administration burden on your information technology staff. The easiest setting to display the files is List all databases. If you have any security restraints you can choose to List merely the databases each exploiter is authorized to access. This will only show the tilt of database for which the user has an account. The precipitation of this setting is that they have to inaugural authenticate themselves to the server, then log into the database. thus, they have to log in twice, which can be a harass. note that this does not prohibit the exploiter from making a conduct URL request to open the database with a shortcut. consequently, this setting in truth does not provide any extra security ! figure 10 SecurityIf you require a SSL connection between FileMaker Pro and FileMaker Server 9 you can check the box for Secure connections to FileMaker Server. This is the only setting on the server that will require a resume of FileMaker Server. The SSL connection is only between FileMaker Pro and FileMaker Server. It does not encrypt ODBC, JDBC, IWP, or custom-made web publishing connections. The connection travel rapidly is slower with encoding turned on. however, you will be quite surprised to see that the performance does not take arsenic much as hit as you would expect. In our testing it is typically about 10 % slower. You may see slower performance depending on your environment.Page 14Default Folders ( Figure 11 ) FileMaker Server ’ randomness default database folders for live, host files are : Windows filewin : /C : /Program Files/FileMaker/FileMaker Server/Data/Databases/ OS X filemac : /Macintosh HD/Library/FileMaker Server/Data/Databses We recommend that you use the nonpayment location to host the files unless you have you have partitioned your hard drive. FileMaker Server will mechanically host any files in this localization american samoa well as one booklet down when the server is started. If you upload the files to the server FileMaker Server 9 will automatically host the files ( if you don ’ t exceed the numeral of host files set in Figure 9 ). Otherwise you can place your databases where every you want. Just check the Use extra databases folder and enter the path. Sorry, but there is no shop release to select the booklet, so you have to enter the way manually. Just make sure to use either the filewin : / or filemac : / format when you specify the path. then click the validate button to make sure the path is adjust. even though FileMaker Server can host files from up to two locations, please don ’ deoxythymidine monophosphate host files from outside the server on a client computer or a file waiter. This will provide atrocious performance. It ’ south best practices to host the files from one central booklet and use one or more sub-folders to organize the databases logically. For exercise, organize theFigure 11 Default Foldersfolders by work group ( i.e. HR, Accounting, Purchasing, etc. ) or by “ modules ” when 2 or more databases are use in concert. FileMaker Server ’ mho default backing folders are in the take after location : Windows filewin : /C : /Program Files/FileMaker/FileMaker Server/Data/Backups/ OS X filemac : /Macintosh HD/Library/FileMaker Server/Data/BackupsPage 15You can only backup databases to a single booklet. We recommend using the nonpayment placement unless you have partitioned the hard campaign. NEVER, ever backup the live database files to a backup campaign or file server with third base party software. This may corrupt the live files. only backup the stand-in folder with third party software. unfortunately, you can not specify the accompaniment path to a file server or accompaniment drive to avoid using third party software. however, if you are cleaver enough you can use free resources such as Automator and iCal on OS X or the Backup utility on Windows to avoid using third base party software. just because these options are loose does not mean that third party software doesn ’ thymine provide valuable automation and restoration. We highly recommend using either retrospect Remote or Veritas ( now Symantec ) accompaniment software.Page 16Logging ( Figure 12 ) FileMaker Server 9 logs items such as FileMaker Server starting and stopping, database files opening and conclude, clients logging in and out, failed logins, chew in downloads, scheduled tasks running, use statistics, and changes to FileMaker Server properties. The log files have a maximal size of 40 MB.Log files are located at : FileMaker Server/Data/Logs/. Logs can be viewed with the OS X Console, the Windows 2000 Server Performance Logs and Alerts, or the window 2003 Server System Monitor applications. • Windows log : Application.Log • OS X log : Event.log Server statistics are located at : FileMaker Server/Data/Logs/. Logs are best viewed in the Admin Console using the Statistics window. • Windows stats log : Stats.log • OS X stats log : Stats.logFigure 12 LoggingWhen you first setup FileMaker Server 9 you should monitor the statistics frequently to determine how well the server is performing. We recommend updating the usage statistics every 15 seconds and setting the minimal size of the use log to 40 MB. After you get your server dialed in at 95 % hoard hits you can either turn off the custom statistics or set the time interval to every 5 minutes.Page 17Server Plugins ( Figure 13 ) Plugins that run on the server can be installed at : FileMaker Server/Extensions/Plugins/ The purpose of a plugin is to extend the functionality of FileMaker Server. For exemplar, connecting to a clearinghouse to accept credit menu payments. Check with the plugin seller ’ s documentation before deploying it on FileMaker Server. note : this is not the same have as FileMaker Pro clients downloading plugins ( Figure 8 ) .Figure 13 Server PluginsPage 18Web Publishing ( General Settings Figure 14 ) Custom Web Publishing with PHP, ASP, and JSP is out of telescope for this white paper. however, if you use moment Web Publishing ( IWP ) FileMaker Server can log the custom statistics for access, errors, ScriptMaker errors, and exploiter access ( via XSLT ). The arrange of most importance is the maximum number of network publication sessions. FileMaker Server allows up to 100 coincident IWP sessions. precisely because you can set it to 100 users does not mean that this is a estimable idea. You should limit it to the maximum numeral of coincident IWP users to reduce the number of open threads. Open threads, even if fresh, reduce the overall performance of the server.Figure 14 General SettingsPage 19ODBC/JDBC ( Figure 15 ) FileMaker Server and the host databases can be used as ODBC and/or JDBC data sources. In early words, they can supply data to ORACLE, SQL, and Excel if the allow driver is installed on the node calculator and the DSN is set up correctly to make the connection. Check with the driver manufacturer ’ mho software documentation and your system administrator for the chastise settings.making the request can besides be set to store extra requests if the server is busy. consequently, 50 coincident connections can actually support quite a heavy load.Figure 15 ODBC/JDBCFileMaker Server supports 50 coincident ODBC/JDBC connections. Although this does not seem like a lot, the connections are opened and closed by the driver very cursorily. Once the connection is closed it goes back to the available pool. typically the application or network serverPage 20Creating Schedules ( Figure 16 ) You can create automated schedules for backups, running scripts, and sending messages. Choose Create a Schedule then click the Perform Action button. then follow the schedule sorcerer to define the schedule.If you enable the feature to send the administrator an e-mail notification after a agenda is run they will receive information whether the schedule ran correctly or not. Otherwise you can monitor the last Run Status for problems.Figure 16 SchedulesBackups can be run for one or more databases at any define time criteria. Scripts can be run from any database, Windows batch charge, Perl, VBScript, or AppleScript. Scripts are typically run by the server to perform an automated undertaking on a set of data. note : only web compatible scripts steps will run with FileMaker Pro. That means scripts that printing reports in the middle of the night are still not possible without using a “ automaton ” computer.Page 21Plug-ins ( Figure 17 ) circuit board files need to be manually placed in the correct folder location on the server. Windows FileMaker Server 9\Data\Databases\AutoUpdate\ OS X FileMaker Server 9/Data/Databases/AutoUpdate/ The FileMaker Pro Plug-ins Preferences need to be enabled to auto-update the circuit board from the server. If the client needs to use the circuit board it must besides be checked in the Plug-in Preferences. Plug-ins located on the OS X server MUST be in mariner compressed format ( plugin.tar ). Plug-ins for Windows must be in the .fmx format ( plugin.fmx ). You can besides manually place the plug-ins ( decompress ) on the client computers running FileMaker Pro 9. Windows : FileMaker Pro 9\Extensions\ OS X FileMaker Pro 9/Extensions/Figure 17 Auto Update Plug-in — Check the box in the FileMaker Pro Plug-in Preferences to automatically download plug-ins from the server.Page 22

Leave a Reply

Your email address will not be published.