Pages Tagged ‘MySQL’
LAMP Development
Posted by: Lans in Case Studies on February 1st, 2009
LAMP refers to a stack of free software programs that are used to run dynamic sites or servers such as Linux, Apache, MySQL the database management system or PHP, the programming language.
LAMP offers unique advantages such as:
- Open source community along with knowledge sharing as well as resource sharing contributes in problem solving. Libraries of sample application code along with knowledge bases of the community help to reduce development time by allowing adaptation as well as re-usage.
- The compactness of LAMP component stack is easy to deploy and helps in reducing the processing overheads.
- The users have great level of flexibility at their disposal as LAMP can run on a wide range of platforms. The user also has the option to install on clusters or grids of economical x86-based servers. The computing architecture of the utility offers an optimized combination of efficient resource utilization, versatility, high availability and instant scalability.
- The LAMP server stack possess a lower bug density
Metatron Labs, being aprofessional Internet consulting and application design company caters to both Indian & overseas clients. We specialize in, LAMP (Linux, Apache, MySQL, PHP and Perl), software design application development with database integration and overall LAMP consulting. We maintain a team of software consultants, creative designers, programmers and marketing professionals that know software and good development practices so you don’t have to invest into another part of business process.
Would you like to move away from packaged delivery of software, into a world of hosted application where you receive monthly subscriptions from your customers for your software?
LAMP may be the architecture that you need to get there. We can make this happen for you, from planning the hosting environment to development of LINUX, Apache, MySQL, and PHP.
ERP
Posted by: Lans in Case Studies on February 1st, 2009
Enterprise resource planning helps in integrating all departments and functions within a company in a single computer system that serves specific needs of different departments.
ERP is often referred as back-office software and does not run the up-front selling process. When the customer service representative enters the customer order in the ERP system, he has access to all the required information such as customer’s rating, company’s inventory levels from the warehouse module, and shipping dock’s trucking schedule from the logistics module.
Enterprise Resource Planning (ERP) originally implied systems designed to plan the use of enterprise-wide resources. Although the acronym ERP originated in the manufacturing environment, in today’s world ERP systems has much broader scope.
Enterprise Resource Planning systems (ERPs) integrate (or attempt to integrate) all data and processes of an organization into a unified system. A typical ERP system will use multiple components of computer software and hardware to achieve the integration. A key ingredient of most ERP systems is the use of a unified database to store data for various system modules.
Enterprise Resource Planning (ERP) delivers a database containing:
- Manufacturing
- Supply Chain Management
- Financials
- Projects
- Human Resource
- Customer Relationship Management
- Data Warehouse
SME Organizations with international and domestic Purchases through multiple channels would benefit the most from this type of technology.
COMMON FEATURES
- This technology is web based and can be accessed from anywhere in the world through secure VPN.
- Linux based Server no licensing fees.
- MySQL based, one of the strongest open source databases available, for which no license fees needs to be paid.
- Porting Option for any database
- Independent Platform for all major browsers.
- Takes very less resources.
- Supports multiple companies.
- User based authentication.
- Transaction Log user specific.
- Can merge CRM & SCM at a later point to integrate with suppliers and clients
- Source code with the client, so not a vendor dependent solution.
Advantages offered by Us
- Our ERP solutions offer high operational efficiency by facilitating greater integration and focusing attention on specific demands of businesses.
- Our ERP solutions help in improving business responsiveness with the help of fast and effective applications and agile IT architecture.
- Our industry tailored application helps in speeding up delivery times, greatly reducing project risks and setting & running up the process fast.
ERP Customization Services
We help in customizing an ERP package that can be very reliable and cost effective. ERP packages are designed to support customization, so most businesses implement the best practices embedded in the acquired ERP system. Some ERP packages are very generic in their reports and inquiries, such that customization is expected in every implementation. It is important to recognize that for these packages it often makes sense to buy third party plug-ins that interface well with your ERP software rather than reinventing the wheel.
Customization work is usually undertaken as bespoke software development on a time and materials basis. Because of the specialist nature of the customization and the ‘one off’ aspect of the work, it is common to pay in the order of per hour for this work.
Application Servers
Posted by: Lans in Case Studies on February 1st, 2009
An application server is a server program in a computer in a distributed network that provides the business logic for an application program. The application server is frequently viewed as part of a three-tier application, consisting of a graphical user interface (GUI) server, an application (business logic) server, and a database and transaction server. More descriptively, it can be viewed as dividing an application into:
- A first-tier, front-end, Web browser-based graphical user interface, usually at a personal computer or workstation
- A middle-tier business logic application or set of applications, possibly on a local area network or intranet server
- A third-tier, back-end, database and transaction server, sometimes on a mainframe or large server
The ease of application development is the major advantage offered by appservers. As the applications do not have to be programmed and are assembled from building blocks provided by the application server.
Open Source application servers give a great ROI and low TCO along with inbuilt stability and inherent advantages of Open Source. We provide Open Source application servers broadly under two categories -
J2EE application server stack
Following the success of the Java platform, the term application server sometimes refers to a Java Platform, Enterprise Edition (J2EE) application server. The better known commercial open source J2EE application server is JBoss (Red Hat).
Programming language used is Java, the Web modules are servlets and JavaServer Pages, and business logic is built into Enterprise JavaBeans (EJB). J2EE provides standards for containing Web components.
A Java Server Page (JSP) is a servlet from Java that executes in a Web container—the Java equivalent of CGI scripts. JSPs are a way to create HTML pages by embedding references to the server logic within the page. HTML coders and Java programmers can work side by side by referencing each other’s code from within their own.
LAMP application server stack
The LAMP (Linux, Apache, MySQL, PHP/Perl/Python) open source stack has been the technology of choice for a “scale out” architecture. LAMP provides a reliable way of deploying rich Web 2.0 applications on inexpensive clusters of commodity computers. Controlled by no single vendor and backed by broad open source global community, it now powers nearly 70% of the world’s web.
Until now organizations with significant expertise in handcrafting LAMP implementations could benefit from LAMP’s scalability and cost savings. However, things have changed now; We have worked on LAMP stack for more than a decade now and has gained features expected by corporate developers.
We offer various types of application server along with Apache Application Server, Perl Server, and Enterprise JaveBeans.
Database Server Management
Posted by: Lans in Case Studies on February 1st, 2009
Database server is a computer program that offers database services to other computers or computer programs, as defined by the client-server model. Many times this term may also refer to a computer dedicated to running such a program. Usually, the Database management systems offer database server functionality, and some DBMS’s (e.g., MySQL) are fully dependent on the client-server model for database access.
Database Master Servers hold the central positions and are the main locations of data while Database Slave servers are synchronized backups acting as proxies of the master.
The increasing importance of database servers is due to the popularity of the client/server architecture model in computing. These servers store the database on the hard disc of a dedicated computer system and allowing it to maintain the integrity of the data along with handling transaction support as well as user authorization.
This database server serves the purpose of dividing an application into a front end and a back end, in compliance with the client-server model. The main function of the front end is to run the user’s computer and display the requested data while the back end runs the server, handling specific tasks such as data analysis and storage.
Remote Server Management
Posted by: Lans in Case Studies on February 1st, 2009
Vigilance is necessary for maintaining the health of the IT environment in any organization. But generally, organizations lack the expertise or necessary resources to do so. If you are focusing your precious time and resources on monitoring the system and resolving server management related problems, you are wasting crucial time and jeopardizing your long-term business prospects.
Metatron Labs is here for you so that you can concentrate more on your core business and leave server management and monitoring to us. Tetra has been managing mail server for some reputed ISP providers like YouTele, VSNL, Hathway, Bharti, We have got complete Infrastructure to provide 24X7 support with 3 levels of technologists available.
We provide a comprehensive range of solutions and support options. Qmail server management is one of the services that we believe is helpful in case of ISPs and web hosting. We build our messaging solution around Qmail having SMTP/SMTPs, POP3/POP3s and IMAP/IMAPs access. Qmail provides backend connectivity to LDAP, MySQL, Oracle, Plain text, CDB, password etc.
Many Webmail scenarios like Squirrelmail, Sqwebmail, Open Webmail, and IMP over horde is supported and customized by us to suit the required deliverable. Collaborative environments are also deployed by as using open-source environment likeopen-groupware,e-groupware, and open-xchange.
Benefits of Our Remote Management Services
- Helps identify problems before they actually occur as experts monitor and troubleshoot your network systems.
- Smoother running networks allow less down time for the employees.
- Any eventual problems are resolved faster as experts in the domain efficiently handle them.
- It helps to free your staff from monitoring functions and spending time and resources on solving computer problems.
- Have access to up-to-date security software and virus protection software.
- Lastly, you have the confidence that the domain experts properly look after your systems and you therefore, can concentrate on the business in hand without worrying about your server health.
- Automation of the configuration and provisioning of the server.
- Minimizing the cost and time taken associated with the task.
- Efficient management of geographically dispersed computer network equipments.
What are the possible repercussions if you do not opt for server monitoring?
- A very high probability of data loss.
- May result in loss of productivity.
- Result in failure of data.
- Missing out of preventative opportunities before manageable problems turn into crisis and affect Uptime of your organization.
Why Outsource to Us?
- Implemented India’s first open source ISP setup
- Mailing solutions implemented by Metatron Labs having more than a 50000+ Mailboxes
- Pure open source player – since 1997
- Large team capable of handling projects of any size
The key value propositions include
- Reduced operating Costs while never compromising quality
- Innovative approach
- Flexibility in resizing and scaling team quick response
Professional Server Management
Supported Operating Systems: Linux
Recommended for all dedicated or co-located servers, this plan is often employed on web hosting servers that need maximum uptime and require a reasonable level of external management. Customers with management plans are given priority to those without and will be able to contact Server Surgeon 24 hours a day, 7 days a week for immediate service during emergencies. Those without management plans will have to wait until regular business hours as well as pay higher hourly rates.
Services include:
- 1 hour of “by request” system administration time per month
- 24/7 monitoring of server and services & 24/7 emergency on call access
- Daily patching & security updates (Linux only)
- 10 minute live response to server and service outages
Enterprise Server Management with Security
Supported Operating Systems: Linux
This plan includes everything in the Professional Management plan above plus
- Advanced Server Linux Hardening package
- Daily security monitoring and live response
- On the box process, disk, and cpu monitoring and live response
- Custom by request monitoring (application monitors, URL monitors, log monitors, etc.)
- 10 minute live response to security and custom monitors
Managed Full System Backup
Supported Operating Systems: Linux, Windows 2000/2003, BSD, OSX
Having a current mirror or copy of your complete file system stored on a secured, external server is a must if you intend to be able to rebound from a crashed disk, security compromise or similar issue. Our Full System Backup uses the readily available Rsync utility to transfer your data to our server. We fully configure the backup for you based on your needs, provide the transfer of the data to our servers, and provide monitoring to insure backups are valid and occurring at regular frequencies
Essential Linux Hardening
- BFD – (Brute Force Detection) – Most Linux servers on the Internet are attacked by brute force multiple times each week. BFD detects brute force connections and automatically enters the offending IPs into the firewall to be blocked.
- SSH Server Hardening – Locks down and hardens the SSH server. Provides additional protection against brute force attacks.
- Firewall Installation – APF (Advanced Policy Firewall) iptables based firewall and anti-dos rule sets.
- LES – (Linux Environment Security) – Enforces root-only permissions on system binaries as well as other restrictions on system programs.
- /tmp, /var/tmp and /dev/shm Hardening – The /tmp, /var/tmp and /dev/shm directories are the most common cause of security compromises on web hosting servers. Hardening prevents execution of malicious scripts from being launched from these directories.
- Disable Unused Services/Software – Unused services and software are disabled to prevent them from being exploited.
Advanced Linux Hardening
- Everything in the Essential Linux Hardening
- Mod-Evasive – Blocks HTTP Denial of Service attacks.
- IM – (System Integrity Monitor) – Automatically monitors and restarts required services including HTTP, FTP, DNS, SSH, and MYSQL.
- LSM (Linux Socket Monitor) – Identifies and alerts you when rogue services are started on your server
- SPRI – (System Priority) – Sets the priority to current processes being run on your server, decreasing load 5-25%
- PSAD – Detects port scan attacks and and automatically enters the offending IPs into the firewall to be blocked.
- CHKRootKIt – Simple script that detects software used by hackers. It scans once a day and emails the client if any suspicious scripts are found.
- Mod-Security – Adds another layer of security for your web applications. (Note: Mod-security will only be installed by request when you order this package as its rules can break certain websites — if you want mod-security installed on your servers please let us know.)
Anti Virus & Anti Spam
Features of using this system include:
- Customized Clam Antivirus installation
- Customized SpamAssassin installation
- Automated hourly virus and daily spam signature updates
- Customizable RBL (Realtime Blackhole List) checks
- Customizable whitelists and blacklists
- Customizable attachment filename and file type checks
- Customizable per-domain rules
- Bayesian spam filtering
Remote Server Management
Posted by: Lans in Case Studies on February 1st, 2009
Vigilance is necessary for maintaining the health of the IT environment in any organization. But generally, organizations lack the expertise or necessary resources to do so. If you are focusing your precious time and resources on monitoring the system and resolving server management related problems, you are wasting crucial time and jeopardizing your long-term business prospects.
Metatron Labs is here for you so that you can concentrate more on your core business and leave server management and monitoring to us. Tetra has been managing mail server for some reputed ISP providers like YouTele, VSNL, Hathway, Bharti, We have got complete Infrastructure to provide 24X7 support with 3 levels of technologists available.
We provide a comprehensive range of solutions and support options. Qmail server management is one of the services that we believe is helpful in case of ISPs and web hosting. We build our messaging solution around Qmail having SMTP/SMTPs, POP3/POP3s and IMAP/IMAPs access. Qmail provides backend connectivity to LDAP, MySQL, Oracle, Plain text, CDB, password etc.
Many Webmail scenarios like Squirrelmail, Sqwebmail, Open Webmail, and IMP over horde is supported and customized by us to suit the required deliverable. Collaborative environments are also deployed by as using open-source environment likeopen-groupware,e-groupware, and open-xchange.
Benefits of Our Remote Management Services
- Helps identify problems before they actually occur as experts monitor and troubleshoot your network systems.
- Smoother running networks allow less down time for the employees.
- Any eventual problems are resolved faster as experts in the domain efficiently handle them.
- It helps to free your staff from monitoring functions and spending time and resources on solving computer problems.
- Have access to up-to-date security software and virus protection software.
- Lastly, you have the confidence that the domain experts properly look after your systems and you therefore, can concentrate on the business in hand without worrying about your server health.
- Automation of the configuration and provisioning of the server.
- Minimizing the cost and time taken associated with the task.
- Efficient management of geographically dispersed computer network equipments.
What are the possible repercussions if you do not opt for server monitoring?
- A very high probability of data loss.
- May result in loss of productivity.
- Result in failure of data.
- Missing out of preventative opportunities before manageable problems turn into crisis and affect Uptime of your organization.
Why Outsource to Us?
- Implemented India’s first open source ISP setup
- Mailing solutions implemented by Metatron Labs having more than a 50000+ Mailboxes
- Pure open source player – since 1997
- Large team capable of handling projects of any size
The key value propositions include
- Reduced operating Costs while never compromising quality
- Innovative approach
- Flexibility in resizing and scaling team quick response
Professional Server Management
Supported Operating Systems: Linux
Recommended for all dedicated or co-located servers, this plan is often employed on web hosting servers that need maximum uptime and require a reasonable level of external management. Customers with management plans are given priority to those without and will be able to contact Server Surgeon 24 hours a day, 7 days a week for immediate service during emergencies. Those without management plans will have to wait until regular business hours as well as pay higher hourly rates.
Services include:
- 1 hour of “by request” system administration time per month
- 24/7 monitoring of server and services & 24/7 emergency on call access
- Daily patching & security updates (Linux only)
- 10 minute live response to server and service outages
Enterprise Server Management with Security
Supported Operating Systems: Linux
This plan includes everything in the Professional Management plan above plus
- Advanced Server Linux Hardening package
- Daily security monitoring and live response
- On the box process, disk, and cpu monitoring and live response
- Custom by request monitoring (application monitors, URL monitors, log monitors, etc.)
- 10 minute live response to security and custom monitors
Managed Full System Backup
Supported Operating Systems: Linux, Windows 2000/2003, BSD, OSX
Having a current mirror or copy of your complete file system stored on a secured, external server is a must if you intend to be able to rebound from a crashed disk, security compromise or similar issue. Our Full System Backup uses the readily available Rsync utility to transfer your data to our server. We fully configure the backup for you based on your needs, provide the transfer of the data to our servers, and provide monitoring to insure backups are valid and occurring at regular frequencies
Essential Linux Hardening
- BFD – (Brute Force Detection) – Most Linux servers on the Internet are attacked by brute force multiple times each week. BFD detects brute force connections and automatically enters the offending IPs into the firewall to be blocked.
- SSH Server Hardening – Locks down and hardens the SSH server. Provides additional protection against brute force attacks.
- Firewall Installation – APF (Advanced Policy Firewall) iptables based firewall and anti-dos rule sets.
- LES – (Linux Environment Security) – Enforces root-only permissions on system binaries as well as other restrictions on system programs.
- /tmp, /var/tmp and /dev/shm Hardening – The /tmp, /var/tmp and /dev/shm directories are the most common cause of security compromises on web hosting servers. Hardening prevents execution of malicious scripts from being launched from these directories.
- Disable Unused Services/Software – Unused services and software are disabled to prevent them from being exploited.
Advanced Linux Hardening
- Everything in the Essential Linux Hardening
- Mod-Evasive – Blocks HTTP Denial of Service attacks.
- IM – (System Integrity Monitor) – Automatically monitors and restarts required services including HTTP, FTP, DNS, SSH, and MYSQL.
- LSM (Linux Socket Monitor) – Identifies and alerts you when rogue services are started on your server
- SPRI – (System Priority) – Sets the priority to current processes being run on your server, decreasing load 5-25%
- PSAD – Detects port scan attacks and and automatically enters the offending IPs into the firewall to be blocked.
- CHKRootKIt – Simple script that detects software used by hackers. It scans once a day and emails the client if any suspicious scripts are found.
- Mod-Security – Adds another layer of security for your web applications. (Note: Mod-security will only be installed by request when you order this package as its rules can break certain websites — if you want mod-security installed on your servers please let us know.)
Anti Virus & Anti Spam
Features of using this system include:
- Customized Clam Antivirus installation
- Customized SpamAssassin installation
- Automated hourly virus and daily spam signature updates
- Customizable RBL (Realtime Blackhole List) checks
- Customizable whitelists and blacklists
- Customizable attachment filename and file type checks
- Customizable per-domain rules
- Bayesian spam filtering
Hello world!
Posted by: Lans in Case Studies on February 1st, 2009
Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!