Configuring Turbo Linux ASE 12.5 Database Server 1, Turbo Linux Installation Process: Insert Turbo Linux into the CD-ROM drive, CMOS is set to CD-ROM boot, start the computer, type the Enter, enter the Default graphics mode of Turbo Linux, Each option settings As follows: Keyboard: Default Mouse: Default Disk Partition: TFDisk Graphic Disk Partitions Size Partition Type Boot Area: 64M Linux Ext2 Root District: 5120M Linux Ext3 DOS EXTENT Partition: SWAP District: 4 512M Swap Home District: 3072M Linux Ext3 Home1 District : 20480m Linux Ext3 Home2 Zone: Remaining Space Linux EXT3 Installation LILO: Installation Location Hard Disk Main Boot Area Settings Network: Do not use DHCP dynamic allocation IP addresses, static setting information setup time zone: PRC Set account : Setting the route installation type: All Configure the display: The display mode is 65536 colors, the resolution is: 1024 * 768 Window Manager: KDE Test X configuration, if you can display it, press Y confirmation, otherwise press N, re-select Color And resolution until the window can be displayed normally. Confirmation setting: Verify that your settings are correct, once started, this process cannot stop. Set the security level: Intermediate complete installation. Second, the installation process of ASE 12.5: 1: Type StartX Enter the KDE window manager, insert the Sybase installation disk, copy the compressed file in the disc to a certain directory.
Execution: TAR ZXVF EBF10431.TGZ CD EBF10431 / RPMS RPM-HIV Sybase-Common * RPM-Hiv Sybase-ase * rpm -hiv Sybase-Chinese * 2: Chown Sybase / Home * Chgrp Sybase / Home * CHMOD 777 / OPT / Sybase-12.5 / locals / local su - Sybase CD / Home MKDIR Sybase Export Display = IP: 0.0 IP To install the IP address of the machine to enter the graphic Sybase configuration interface: 4: Configuring Sybase Select Configure a news server a) the name of the Adaptive Server changed name SYBASE (uppercase) Backup Server is to change this SYBASE_backup Master device path: /home/sybase/master.dat Master database size: 20 Sybsystemprocs device path: / home / sybase / sysprocs .dat Error log path: /home/sybase/SYBASE.log Host name: IP Port number: 770 * b) select Edit Adanced Adaptive Server attibutes into the Server Attribute Editor: SYBASE: Configuration file path: /home/sybase/SYBASE.cfg Sybase_backup error log path: /Home/sybase/sybase_backup.log host name: IP port number: 770 * (Note You cannot repeat the Sybase's port number) Select Buile Server C) After the system is created, set the language in the localization server. For the English, Charsets (Charset) for Code Page 850 is binary ordering, for use with code page 850, Backup Server does not have to set localization. Third, the parameter configuration of ASE12.5. Take 2G memory as an example: 1. Modify Linux shared memory parameters: where NNN is the actual memory of the system (in bytes nnn = 2147483647) Modify file: /etc/rc.local Join: Echo nnn> / proc / sys / kernel / shmmax enables 2, isql -usa a) Configure memory sp_configure 'max memory', MMM (unit 2K mmm = 786432) Go sp_configure 'allocate max shared mem', 1 Go The above command configures Sybase using MMM * 2K memory, usually configured as 60-70% of the system memory, and restarting. If Sybase is not started normally, adjust the sybase.cfg file to adjust the Max Memory parameter.
b) After the above parameters take effect, configure data cache and procedure cache: sp_cacheconfig 'default data cache', 'xxxm' (xxx = 768) GO is typically configured to be 50% of Max Memory, with m units, restarting into effect sp_configure 'Procedure Cache size ', xxx (xxx = 157286) Go is typically configured to Max Memory 20%, 2K unit sp_configure' Allocate Max Shared Mem ', 0 Go C) Number of Devices (40), Open Databases (20), NUMBER Of Locks (20000), Number of User Connections (50), Open Objects (5000) parameters can be adjusted in the Sino-Standal Settings Settings. d) Adjust BCP configuration 1. Adjust the extension allocation sp_configure 'number of pre-allocated extent', 20 GO 2. Configure the I / O buffer pool sp_poolconfig 'default data cache', '256m', '16k' e) Adjust the changed index number sp_configure 'number of open indexes', 4000 four, configure Telnet service: 1, change / etc / xinetd.d / telnet file: change the disable option to NO to modify the /etc/hosts.allow file, add a line all: ip. *. * 2, open root login, modify the /etc/pam.d/login file, will Two-line plus # Note 3, start the Telnet service cd /etc/rc.d/init.d ./xinetd Start Use NetStat -TL to activate the service five, start the FTP service: CD / usr / sbin ./proftpd Restart 6, How to modify the name 1 of the local backup Server, modify the interfaces file, change the name of the backup server to a new name 2, enter the ISQL tool sp_configure 'allow updates', 1 Update sysservers set where sp_configure 'allow updatses', 0 seven, how to implement Sybase Remote backup (connected to remote Backup Server services through local Backup Servre services, back up remote databases to remote machines.
) On the local machine: 1. Modify the interfaces file, add the entry on the remote machine (Backup Server's name, address, port number) 2, add a remote Backup Server name 1> sp_addserver remote_backup_server_name, NULL 2 in the Sysservers system table > Go 3, use sp_helpserver to view at least 3 entries: - Local ASE Name - Local Backup Server Name - Remote Backup Server Name 4, Remote Backup on your local machine: 1> DUMP DATABASE DATABASE_NAME TO "Remote_Machine_Path / ... "at remote_backupserver_name 2> Go Restore backup on the local machine: 1> Load Database Database_name from" remote_machine_path / ... "at remote_backupserver_name 2> GO Note: 1. If you want to achieve remote two-way backup, please be in the remote machine Make the same configuration as the local machine. 2, the name of the local Backup Server requires different names of the remote Backup Server, how to achieve Sybase's remote database back up to local 1, modify the Interfaces file, add a new entry, The purpose is to connect to the remote machine's Server's Server (Name, Remote Server IP Address, Remote Server Service Port number) 2. Configure a new Backup Server through ASECFG, and select it in the interfaces file in the Related Server Name item. The entry name added is added. 3, adding new local sysservers system table Backup Server name 1> sp_addserver NewBackup_Server_Name, null 2> go 4, remote backup on a local machine: 1> dump database Remote_Database_Name to "Local_machine_path / ..." at NewBackupserver_Name 2> go restore the backup on the local machine: 1> load database remote_Database_Name from "local_machine_path / ..." at NewBackupserver_Name 2> go 5, start a new backup Server with the startserver -f RUN_NewBackupName_back service shut down service 1> shutdown NewBackup_Server_Name 2> go nine, how Database 1> DUMP DATABASE PUBS2 to "/Path/pubs2_dump.1" 2> stripe on "/path/pubs2_dump.2" 3> Stripe on "/Path/pubs2_dump.3" 4> Go The method can also increase the speed of backup and recovery, but pay attention to recovery must also use the corresponding equipment.
