Tag Archives: Server

MySQL, available in both UNIX and Windows, is one of the most popular database tools. As the latest version of MySQL, the perfected newer version, MySQL 5.0, provides you with many new features in this popular open source database server. It is incredibly fast, reliable, and easy to use for developers.

WHAT ARE THE NEW FEATURES?

To summarize, it is very simple and easy that MySQL 5.0 has added 4 great new features – trigger, views, data dictionary, and stored procedures. But of course it is not enough to just say those 4 words to describe how outstanding the features are. So, let’s not waste more time and know nothing by getting more!

Trigger

A database trigger is procedural codes that can be executed automatically to respond certain events on database particular tables. It is able to restrict access to specific data, perform logging, or audit data modifications. For the triggers, there are “row triggers” or “statement triggers”.

Row triggers is the action for every row of a table while statement triggers only happens once per INSERT, UPDATE, or DELETE statement. And these statement triggers are those that MySQL Database support – INSERT Trigger, UPDATE Trigger, and DELETE Trigger.

Stored Procedures

Stored routines (procedures and functions) are supported in MySQL 5.0. A stored routine or stored procedures are the set of SQL statements that can be stored in the server. Once this has been done, You don’t need to keep re-issuing the individual statements. Instead, you can refer to the stored routine.

Stored routines require the proc table in the mysql database. This table is created during the MySQL 5.0 installation procedure. Once it is installed, users can refer back to any statements stored in the server without having to reissue again with this ability in MySQL 5.0.

Views

In database functionality, the views consist of accessible stored query as a composed virtual table of the result set of queries. And, it is not like some ordinary tables in relational databases, as views do not form the physical schema part.

Views that also include updatable views are available in MySQL Server 5.0. Views are stored queries that when invoked produce a result set. Here, in MySQL 5.0, the views act as a virtual table. You will find this useful for some queries.

Data Dictionary

Data dictionary, as you all may have known, is a centralized repository of information about data such as meaning, relationships to other data, origin, usage, and format. It is also recognized as meta data – the data of the data.

And as you know, this is one of the new additional features in MySQL 5.0 that contains document describing a database or collection of databases that you can access. Wonderful right.

Well, with these four additional features, you will find MySQL 5.0 as even more amazing database server that you  feel hard to resist or choose the other database servers.

Ajax describes a large group of web technologies used to implement  web applications to communicate with the server in the background without any interference to the the page current state. But more than considering the description only, do you know that it offers you benefits that are hard to reject? Have you realized what makes AJAX so special?

Well, first of many pluses, AJAX has four basis of web standards and you’ll have no worries as they are well defined and supported by all major browsers. Using AJAX, web masters are able to create better, faster, and more user-friendly web applications. The four based web standards are JavaScript, XML, HTML, and CSS. Besides it is based on four web standards, Ajax also offers you with three faster capabilities. Check these out!

Connection

This must be something everybody’s looking for, faster connection. And yes it is. With AJAX, no necessity to connect the web page to server everytime. AJAX saves time for the interaction between web pages and server to improve the speed and functionality.

It also allows web page to request for smaller bits of information rather than request for the whole pages  to reload repeatedly. Surely, it results on speed increase as well. AJAX technology is based more to web browsers than to web server. Using this, you will not worry about connection and speed.

Updates

Updates are always important and that’s another stuff AJAX helps you. Whenever you’d like to update your website database, AJAX provides you with a unique feature to reduce time consumption. How? Honestly, other web languages will require you to update the database entirely everytime contents updates are necessary to be done.

However, with AJAX, you just need to spend time only on the contents updates that are required to be done. It sounds impossible but trust me that AJAX is able to select the contents that requires any updates only. It allows users to have easier process when they would like to update their websites.

Response

Another thing you should know and proud of Ajax is that it is capable to allow faster responses to any inputs even when changes are not done in the server. It responds quickly to inputs, which is definitely more responsive, although the application itself has not changed on the server side.

And what is unique about AJAX is it has the ability to reload section of pages individually without any difficulty. This is a user friendly advantage that users may benefit from. This benefit also enables users to get faster functioning of the websites.

So briefly, have you realized what makes AJAX so special by now? I am sure you have…

~Gabrielle~

Get ready for an upgrade! We proudly inform you that we will perform MS-SQL upgrade for your accounts. All accounts using MS-SQL 2000 will be upgraded to either MS-SQL 2005 or MS-SQL Express 2005. We have specified the upgrading process.

All accounts using our old cluster (old plans) will be upgraded to MS-SQL Server 2005 Express Edition. Moreover, those having accounts in our all new Premium Hosting (the new cluster) will use the MS-SQL Server 2005 Standard. What’s so special about both MS-SQL 2005?

MS-SQL Server (SQL 2005 Express)

From the first of many pluses, The Express edition is a fast and easy way to develop dynamic applications, which is easy-to-use and lightweight. With MS-SQL Express 2005, you’ll be able to build robust and reliable applications. Simple but powerful application development is in your hand.

It offers you with attractive features for website development and performs fast There is full-text search features to provide powerful query capability over textual data. Additionally, You can also easily load databases to a hosted environment with XCopy feature. Native XML is also supported inside the database to ensure Web environment easily interoperates with other applications through Web services.

Another plus is that SQL Server Express cooperates with SQL Server 2005 Reporting Services to create interactive reports. Complicated reports with tables and charts are no longer impossible tasks to do as SQL Server Express reduces the complexity with graphics and integrate them in applications.

And What about MS-SQL Server (SQL2005 Standard)?

Many users recognize MS-SQL Server 2005 as the successor of the previous version, MS-SQL Server 2000. Just like the Express edition, it also has many advantages you can take from.  For example, the native XML support, that helps to manage XML data. MS SQL Server 2005 has the massive support to manage efficiently the Extensible Markup Language data.

It also has embedded some database file extensions to the T-SQL engine to allow further embedding  in any XQuery inquiries in T-SQL.  Moreover, MS SQL Server 2005 clearly identifies new file extensions named XML and DML, permitting modifications on the query based on the XML data.

Additionally, it delivers powerful and productive management tools for DBAs and simplifies management with integrated management environment to monitor and manage plus adjust all  databases and associated services throughout your enterprise. An extensible management infrastructure (easily programmed) using SQL Management Objects (SMO) is also provided, enabling you to customize and extend their management environment and build additional tools as you’d like to.

That’s why we decide to upgrade our MS-SQL into the 2005 Standard and Express, clearly nothing more than to provide more awesome web hosting experience for all users. So prepare now for perfection…

~ Gabrielle ~

Hello there! Here we’re again to provide you with the transparency of our Uptime record in November 2008. As we did in October, our availability was averagely 99.99% as guaranteed. And now, let’s evaluate our uptime in November to keep track on it.

November 2008 Availability Chart

Service % Time OK % Time Critical
FTP 99.990% 0.010%
HTTP 99.989% 0.011%
MySQL 99.992% 0.008%
SMTP 99.989% 0.011%
POP 99.990% 0.010%
IMAP 99.989% 0.011%

from the record in November, the uptime was tracked in several different services including FTP, HTTP, Email, and MySQL service as done in the previous month.

From the FTP service, we reached 99.99% of uptime and had 0.010% critical time record (downtime) tracked. The downtime recorded was resulted from the regular maintenance scheduled to improve all of our servers.

For the http service (website uptime), availability reached 99.989 out of 100%. There was 0.011% of service outage when there was regular maintenance to improve server performance.

Email service including POP, SMTP, and IMAP reached 99.99% in average for November, with only 0.001% unavailability recorded for regular maintenance.

And our database service even reached 99.992% uptime recorded and just had 0.008 unavailability tracked in the servers averagely from the scheduled maintenance.

Averagely in November, from all services in all servers, the availability of Host Department servers reached 99.989% out of 100%, which is rounded off to 99.99%.

It has been shown that so far, Host Department still meets their uptime guarantee. Well anyway, see you guys next month 🙂

~Gabrielle~

Hello everyone! Over these years, Host Department has proven to provide the
best web hosting service for all of you with rock solid network and outstanding
service. We are now here for you to show the transparency of our Uptime Fact.
Average Uptime Record October 2008
Service % Time OK % Time Critical
FTP 99.994% 0.006%
HTTP 99.996% 0.004%
MySQL 99.996% 0.004%
SMTP 99.999% 0.001%
POP 100.000% 0.000%
IMAP 100.000% 0.000%
As pictured in the table, in October, Host Department averagely reached
99.994% out of 100% uptime for FTP service. There was only 0.006% critical
time when there was scheduled maintenance and data center migration.

On the other hand, the http service reached out of 99.996% availability and was in
0.004 % critical time in October for the website service. It was because we have scheduled
maintenance resulting in the service outage. 

For email services including SMTP, POP, and IMAP, we were available for 99.999% in average
in October, interpreting that we were passing over our uptime guarantee. 0.001% critical time
was for the regular maintenance.

Our database availabilty, MySQL, reached 99.996% averagely in October with 0.004% critical time
when there was scheduled maintenance and server migration.  

The Point from the Uptime Record
These uptime record is provided for all of our readers so that you can evaluate
 on how we rock on our uptime and we can keep improving our service now and then.
We will continuously update this record in each month in our blog at
http://www.hostdepartment.com/blog