Tag Archives: Database

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.

In the first month of this fresh new year of 2009, I am here again to report the uptime record for January 2009. Before I go with the details, you can have a look at the table below. They represent the average uptime and critical time during January 2009 in all of our servers for FTP, HTTP, MySQL, SMTP, and POP services.

Service % Time OK % Time Critical
FTP 99.991% 0.009%
HTTP 98.996% 1.004%
MySQL 99.989% 0.011%
SMTP 99.990% 0.010%
POP 99.979% 0.021%

FTP Service
FTP, important issue! It is needed when you want to upload your files into your websites. So, I clearly understand that you will find it annoying to find your FTP unaccessible. Anyway, our January’s FTP service uptime record showed that we reached 99.991% “okay” time and only 0.009% critical time reported. We gladly report that we met what you’ve expected.

HTTP Service
We also realize HTTP service is also significant for your website. We understand how inconvenient for you if your website is unaccessible by your visitors, especially when your site is critical and very important for your business.

For HTTP service in January, we reached 98.996% uptime and 1.004% critical time reported. We are really sorry that we didn’t meet 99.99% uptime guarantee for HTTP in January. It was caused from our scheduled maintenance to improve the performance of our servers for your further satisfaction.

MySQL Service
MySQL service is very important for dynamic website with MySQL database. As database records your customers’ registration data, e-commerce data, or archived materials; it is crucial to have the service available.

In January 2009, our MySQL service was 99.989% up and 0.011% critical time only. It means we actually have a rounded 99.99% uptime for MySQL service and we are glad that we met your expectations.

SMTP and POP Service

E-mails service is very important as with e-mails, you contact and get contacted by people. In delivering e-mail services, we report two records, SMTP and POP services. For SMTP service, we delivered 99.990% uptime and 0.010%. We are happy that we didn’t disappoint you in delivering the service.

And for POP service, we performed 99.979% uptime and there was 0.021% critical time in January for POP service. It showed that our okay time for POP was around 99.98% last month and we regret that we performed 0.02% critical time rather than just equal to or less than 0.01% critical time as there was regular maintenance to provide better performance in the future.

Last, we’d like to thank you for your kind understanding, patience, and loyalty towards our service and also we thank you for the time you have spent to read this uptime record. We’ll be back again next month as usual for February 2009 uptime.

Regards,
Gabrielle

Sometimes we are confused on how much resources we need for our website and then we’ll just go with the one offering us the largest one. Well, from my experience, you should  figure out the total size of your website by knowing first how many files and how much the files’ size will be in your website, including the image files. You actually will never know how much resources you’ll use in web hosting service before you finish all the whole website pages’ design. So What Should You Do to Check? Actually, for storage resource, you can check the size of the files in megabytes, including images, videos, mp3, html web pages, dynamic scripts, etc. How? Right click on the site folder, choose properties, and see the megabyte size of the folder. It will provide you a good estimation of how much space needed to host your web site.  And you will know that you don’t need too much resources as only little space is needed to host your website.

After you have known how much space required, start to ask these questions to yourself so you will know what more to determine for your website. First, are log files needed for your website? Remember that log files tend to spend your space quicker if your site is popular. Second, what about e-mail accounts like if you use webmails? Consider that if it is not maintained regularly, tons of junk mails will be in your e-mail and it will waste your space sooner too. And don’t forget database! If you have some database files and fill them them with customer registration or e-commerce data such as product information or archived materials, it will develop into large databases and grow very fast too. Another thing to pay attention is bandwidth, that is the measurement to manage resources by most web hosts. The limit for your site traffic can be set and is counted everytime someone visits your website (your website’s visitors). Why? It is because your web data is transfered through the Internet and from the web server where your site is hosted to the browser of the person visiting your website, which will create your website traffic. How much data transfer is done increases and becomes the prediction of how much bandwidth of your website is in one month. But how to estimate your bandwidth per month? Let’s say your web file is around 100 KB per page and you get around 50 visitors. Each visitor will view 7 pages. That means the bandwidth needed will be 100 KB x 50 visitors x 7 pages each one views, resulting on 35,000 KB or 35 MB bandwidth. And in one month, you will need 30 days x 35 MB, which equals to 1050 MB or 1.05 GB. And if you think this usage is too large and you’d like to reduce the bandwidth, you can do it by reducing your page size, files size, image size, or the number of files/images used in your website. It will be good if your home page is less than 50 KB and so are the other pages. Nowadays, a large number of successful small to large E-Commerce websites operate with not much storage space, ranging from only 10 MB to 200 MB.  However, the most seen difference today is storage space is sold much cheaper and web hosts give you much more than you really use; while earlier, storage space is not that cheap.  But don’t get influenced by large storage offer with cheap prices. My suggestion is, although storage space may be very cheap these days, don’t buy more than you need! Keep your money! You better buy one that give you the suitable space size for your website with good prices and quality.

Remember that if later you have reached the limit and may need more, you can always upgrade or buy more space based on your website needs. Also remember that if you have smaller site and smaller files size, your website pages will load much faster than those who have large files size or large websites. Keep in mind that people would prefer visit websites that load fast!

~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 ~