How to install MySQL, MySQL GUI on ubuntu?

If you are newbie on linux enviroment and familiar with Windows operating system, you come accross differences. Especially about installing application. Because it's different, there is no double-click on installation file and "next-next-yes". You have to use Terminal which is placed under "Application/Accessories". After running Terminal, follow the steps written below :

Installing MySQL :
sudo apt-get install mysql-server

Installing MySql Browser :
sudo apt-get install mysql-browser

Installing MySql Administrator :
sudo apt-get install mysql-admin

"Current Anonymous Users" and "Current Connections"

When you decide to test performance and capacity of your web application, there are two indications that shows the vital numbers of your application.

If you are new in performance tester or you already use performance counters in windows server, you may be confused about counters like "Current Anonymous Users" and "Current Connections". The worst thing is "Current Anonymous Users" counter shows different meanings in IIS 5.0 and IIS 6.0. If you are test on your local pc with IIS 5.0 you see different behaviours of the counter in IIS 6.0. Here is differences.

In IIS 5.0. Current Anonymous Users is the number of current anonymous HTTP connections. This number decreases when the connection is closed (for various reasons, such as when the connection explicitly closes or times out).

In IIS 6.0. Current Anonymous Users is the number of current anonymous requests being processed. This number decreases when the request is completed. (HTTP.sys and IIS user mode both provide numbers for this counter.)

In short, IIS 6.0 counts each request as a user, whereas IIS 5.0 counts each connection as a user.

Excerpted from http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/1e240a6e-834e-4e0d-ab2a-4335c573c06a.mspx?mfr=true

A typical scenario looks like:

1. User requests a page
2. Connection is established and "Current Connections" increase
3. The request is being processed and "Current Anonymous Users" increase
4. The request has been processed and "Current Anonymous Users" decrease
5. The connection is idle for some time
6. The connection is closed, and "Current Connections" decrease

Excerpted from http://www.gafvert.info/notes/current_connections_users.htm

Do you have any risk plan?

You have to admit that your applications or servers will be crashed. You have to be panic now. Because it's better to feel trouble than when you are in real trouble.

Most of company back up their database, their sources in case of any uninvited problem. That's great idea to back up isn't that?



What's next? Imagine that, your database is corrupted. Do you know what you should do? If you can you answer following questions, just wait trouble time comfortably, you don't need to be afraid of. You can feel a little bit fear, not to much.

1. How do you restore again?
2. How much time do you need to work the database again?
3. Who is/are responsible for restoring it?
4. Where is your database backup stored?
5. Is permission given to copy database backup from backup server to live database server?
6. Is there enough bandwidth between backup servers and live database servers?
7. Do you know username and password to access backup server?
   

Let's explain why answers of these questions are vital for your application.

1. Do you restore manually using management tool of your database or using command prompt in windows operating system or terminal in linux operating system? If you use command prompt or terminal, you have to be sure to remember code what your write. It's better to write down in any simple file like notepad. It's quick way to copy "restore statement" and paste it. Or you can create bat files for windows operation system.
2. While your database doesn't work, your users want to know when application will be used again. You should notify problem and time when database is restored and used again. Because your users will be angry. Also your managers. Ambiguity should be clarified.
3. It's simple answer. This person can be your system administrator or database administrator or both of them. Just assign any person to this vital task.
4. Person who is responsible this task have to know where back up files are stored.
5. Responsible person has to have enough permission to access backup files and copy this file to database server.
6. Bandwidth is most important factor to shorten restoring database time. It should be more bandwidth as far as possible.
7. Ok, you have enough permission to access database server and backup server. Do you remember username and password? Also you shouldn't remember you have to write down somewhere else to find it quickly.
   

Finally, all of this instructions should be written on your dashboard. It's easy accessible.

URL Unexpectedly Ending Error with ASP.NET 2.0 Web Services

When trying to run any method with parameter manually in any browser, i came accross
"URL Unexpectedly Ending Error ". I typed link manually because i want to test web services using WAST (Web Application Stress Tool). I need to write link into path value textbox in WAST.

It's really irritating that i couldn't test. After a while i found the solution. Just adding a few lines into web.config :

<system.web>
<webservices>
<protocols>
<add name="HttpGet"></add>
<add name="HttpPost"></add>
</webservices>
</system.web>