Transcript It hw details

Etere distributor meeting
How to design IT infrastructure in
Etere system
Server SQL
Choosing sql server version
 How many clients will be use the system
 How Many playlist in the system
 The fault tollerant method
SQL 2005 version and limitation
Scalability and Performance
Feature
Express
Workgroup
Standard
Enterprise
Comments
Number of CPUs
1
2
4
No Limit
Includes support for
multicore processors.
RAM
1 gigabyte (GB)
3 GB
Operating system
Operating system
Memory limited to
maximum
maximum
maximum supported
by operating system.
64-bit Support
Windows on Windows WOW
supported
supported
No Limit
No Limit
(WOW)
Database Size
Partitioning
4 GB
No Limit
supported
Support for largescale databases
SQL 2005 fault tollerant
High Availability
Feature
Database
Express
NOT supported
Workgroup
NOT supported
Standard
SUPPORTED
Enterprise
SUPPORTED
Mirroring
Failover Clustering
Comments
Advanced high
availability solution
NOT supported
NOT supported
SUPPORTED only 2
SUPPORTED
nodes
Backup Log-
NOT supported
SUPPORTED
SUPPORTED
SUPPORTED
shipping
Online System
Data backup and
recovery solution
SUPPORTED
SUPPORTED
SUPPORTED
SUPPORTED
Changes
Includes Hot Add
Memory
Online Indexing
NOT supported
NOT supported
NOT supported
SUPPORTED
Online Restore
NOT supported
NOT supported
NOT supported
SUPPORTED
Hardware suggested
 Rackmount server from IBM, HP, Dell, Fujitsu siemens
etc.
 Xeon processor, single core or multicore, single
processor or dual
 Ram 2 GB
 O.S.: Windows 2003 server with the latest service pack
 Fault tollerant network gigabit card
disk configuration
description
Mirroring : cheap solution,
normaly used in small system,
good for resilient,
poor in performance.
Raid 5: commonly named striping with parity.
Good read performance
Poor write performance
N-1 capacity storage
Raid 10: stripe of mirrors
Good wirte and read performance
N/2 drive capacity
Volumes configuration
Raid 1
Raid 1
Basic configuration for small system
System volume +
sql log volume
DB volume and
TempDB volume
Raid 10
with 4
disks
System volume
DB volume
Raid 1
Raid 1
Good performance for medium system
TempDB volume
SQL Log volume
Raid 1
Raid 10
with 6
disks
Raid 1
Raid 10
with 4
disks
Best peformance for large system with MAM and HSM
System volume
DB volume
SQL Log volume
TempDB volume
SQL backup
SQL server 2005 has different option for fault
tollerant
 DB Replica: heritated from sql 2000, need to be dismount
every time is changed the DB structure
 Mirroring DB: it can impact heavily to the server
performance
 Backup DB: automatic schedule procedure can be apply,
manual restore
 Clustering: high availability solution, automatic failover
Etere Backup DB
Etere gives for free a toll that is able to backup and
restore the DB, using automatic procedure
 Easy to configure
 Its works with all SQL
version
Automation PC
Pc configuration for Automation
 To run automation module Etere needs a
standard PC
Hardware suggestion:
Intel core 2 duo
1GB Ram
Hd 120 GB
Gigabit Network adapter
1 free PCI slots could be necessary (for GPI)
Windows XP professional any language
Last service pack released by Microsoft
Is preferable to have the following fault tollerant configuration:
• System volume in Raid 1
• Dual network card configured in fault tollerant
• Dual power supply
How many instance of automation?
It is possible to have upto 4 instace of automation in the same pc
Cost effective solution
Automation 1
Good compromise solution
Automation 2
Automation 1
Automation 2
Automation 3
Main Playlist 1
Clone Playlist 1
Main Playlist 1
Main Playlist 2
Main Playlist 3
Main Playlist 2
Clone Playlist 2
clone Playlist 3
Clone Playlist 1
Clone Playlist 2
Main Palylist 3
Clone Palylist 3
Main Playlist 4
Clone Playlist 4
Automation 5
Automation 6
Clone Playlist 2
Clone Playlist 3
Best solution
Automation 1
Main Playlist 1
Automation 2
Automation 3
Main Playlist 2
Main Playlist 3
Automation 4
Clone Playlist 1
Etere WEB
Pc configuration Etere WEB
Etere web can be installed in the same server where SQL is located
For small system can be installed also in windows XP workstation
For a dedicated server this is the hardware suggestion:
Intel core 2 duo
1GB Ram
Hd 120GB
Gigabit Network adapter
Windows server 2003 any language
Last service pack released by Microsoft
Is preferable to have the following fault tollerant configuration:
• System volume in Raid 1
• Dual network card configured in fault tollerant
• Dual power supply
Etere WEB fault tollerant
To have a fault tollerant system is possible to use the windows 2003
NLB (Network Load Balancing)
DB server
192.168.1.10
Web server 1
Web server 2
Web server n
192.168.1.95
192.168.1.96
192.168.1.xx
Clustered ip address
192.168.1.100
Etere HSM
HSM Structure
Unplanned requests
Cache
Planned requests
Playlists
Hsm headquarter
Hsm headquarter
Library one
Library two
Robotics
Robotics
control
control
Roboitics
Roboitics
control
control
Data Pump 1
Data Pump 1
Data Pump 2
Data Pump 2
Data Pump n
Data Pump n
Data Pump and robotics control for HSM
Hardware requirement:
 Xeon processor
 1GB RAM
 Double capacity of the tape cartridge used (ex. 1.6 TB for LTO4)
 Gigabit Network adapter
 SCSI or FC interface for libary and tape drive
 Windows 2003 any language
 Last service pack released by Microsoft
Small HSM system
FC cable
SONY
IN USE
SON
Y PetaSite
IN USE
I/O Port
HSM and data pump
I/O Port
FC cable
Disk Array
Medium HSM system
Robotic control
SONY
SONY
IN USE
PetaSite
IN USE
I/O Port
I/O Port
FC cable
Gigabit Switch
Data Pump
Data Pump
FC cable
Disk Array with 2
parition
Disk array configuration
• The disk array should have Fiber channel or ISCSI interface
• The volume should be configured in Raid 0
Data Pump
FC cable or
ISCSI
FC cable or
ISCSI
Partition 1
Partition 2
Disk Array with 2
parition
Data Pump
Large HSM system
Data Pumps
Robotic Control Main
SONY
SONY
IN USE
PetaSite
IN USE
Gigabit Switch
I/O Port
I/O Port
FC cable
Robotic control bkp
Tape drives
Conrol
SON
Fc switch
IN USE
SO
Y
PetaSite
NY IN USE
I/O Port
I/O Port
San storage
Etere clients
PC client desktop







Desktop
Pentium IV
1GB Ram
Hd 40GB
Gigabit Network adapter
1 free PCI slots could be necessary
Models



IBM Desktop ThinkCentre A series, M Series, S Series,
IntelliStation M Pro series,
Hp Compaq Business Desktop d330 series, d530 series, dx2000 –
dx6100 and dx7100 series
Dell Dimension series, Precision series, OptiPlex series
 Windows XP professional any language
 Last service pack released by Microsoft
Vpn connection for support
Goals
 To allow a secure connection through Internet
to all customers.
 Avoid any virus & worm propagation
 Keep low the cost without compromise on
security.
 Allow 24h monitoring using SMNP traps
 Keep it simple
Logical Diagram
VPN- PPTP/IPSEC
connection
Etere Firewall
Etere Vpn engine
Customer VPN engine
Protocols allowed : FTP
Etere Network
Customers
Network area
Customer site
Customers network area
To Internet
SNMP server & console
Vpn engine
Support 1
Support 2
Secure why
 No communication between customers is possible
 The communication is restricted to:




FTP – to send/receive files
Remote access for XP
VNC for all the other machine
SNMP traps (receive only)
 No communication between the customer area and
internet
 No communication between the customer area and
any ETERE area except ftp site
Why and hardware VPN
 It is more easy to setup
 It is difficult to break
 The hardware selected (Zyxel) is quite
inexpensive
 It’s easy to disconnect ( a single cable)
 Encryption 3DES
Suggested models
 Zywall 2
 Zywall 35
 Zywall 70
Zywall 2
 It is the solution quite alla the sites.
 It allows the full connection of all the pc
through VPN.
Tech details
 The VPN box has one internal Ipaddress of
the form 10.3.x.x with a subnet mask
255.255.255.0
 It must have on the external a public ip
address on internet.
 If only a dynamic public address is provided a
DDNS subscription must be provided.
 If there is a firewall to access internet
PPTP,IPSEC and GRE47 must be enabled.
Etere example system
Small system
Eth switch
Automation
presentation editor
Serial hubs
Sql server
express edition
Traffic
Recording
Videoserver
VTRs
Sql server
express edition
with Etere DB
backup
ON AIR
Live
Medium System
SQL server main
SQL server bkp
Gigabit switch
Low resolution 2
Automation 1
Presentation editor
Serial hubs
Automation 2
Instant editor
ET 558
Recording
BMC 3 nodes
Memory pc1
VTRs
ON AIR
Evertz PKG9625SW
ON AIR
Live
Memory pc2
Large system
Firewall
Cluster SQL and web
server
Instant editor
FC storage
Automation Main
1 PC each channel
Redundant Switch gigabit
Automation Clone
1 PC each channel
N° 5 workstation
Recording
Maestro MC
Nport 4 main 4 bkp
8 VTR for
playout
Logo
N° 3 workstation
3 vtr for ingest
Studio feeds
Shared
Shared
storage BKP storage Main
Scheduling & import
K2 Main
N° 2 workstation
K2 Bkp
Trinix router
Question
Thank You