Tuesday, October 2, 2012

How to Multi-Home

What is Multi-Homing?
 Multi-homing is the process of selecting, provisioning, and installing a redundant connection to the Internet. Could be the same provider, or a different provider.

Why Multi-Home?
Slow is 1,000,000% better than dead. You may be out of bandwidth. And Telco circuits die. Routers die. Providers’ networks fail. Different networks have better performance to different sites.

A Multi-Homed Architecture
 Ideally, take advantage of the opportunity to multi-home to remove all single points of failure in your network. Use - Multiple providers, unless your current provider will let you have cheap backup Multiple routers Multiple telco vendors

Multi-Homed Architecture
Two routers, each with a different WAN connection from a different telco vendor. Use HSRP or VRRP internally to make both routers look like one “virtual” router. Eventually, multiple providers. Upcoming Boardwatch article with configs.

How the Internet Works
Well, it breaks more than it works but when it does work - The Internet is a network of networks. Each network (called Autonomous System) on the Internet announces “routes”, which are lists of the IP addresses of the boxes on their network. You need to be able to send packets *to*, and get packets *from*, everywhere.


 For more details visit www.freedman.net

Tuesday, September 11, 2012

How to optimize MySQL DataBase


MySQL optimization. Here we will give some quick help on optimizing MySQL database performance.

Requirements: MySQL.

One of the factors with the biggest impact on database performance is not the MySQL settings, but your queries! Make sure you have optimized all your queries first, and have created the right indexes on your tables for MySQL to use.

A useful MySQL command for this is EXPLAIN. If you use EXPLAIN SELECT * FROM table WHERE field="something" , MySQL will tell you how many rows it needs to search, and what index it can use for this, among other things.

After you have optimized your queries and created indexes, you can start tweaking your my.cnf MySQL configuration file. Keep in mind that if you optimize or change something you should be able to benchmark it to make sure it will actually increase the performance.

Here is a sample my.cnf file (MySQL 4.1) for use on a dual processor server with 2GB of RAM memory:

# The following options will be passed to all MySQL clients
[client]
socket=/tmp/mysql.sock


# The MySQL server
[mysqld]
tmpdir=/tmp
socket=/tmp/mysql.sock
skip-locking
skip-networking
skip-name-resolve

server-id=1

max_connections=500
key_buffer_size=384M
max_allowed_packet=16M
table_cache=256
sort_buffer_size=2M
read_buffer_size=2M
join_buffer_size=2M

# if you are performing GROUP BY or ORDER BY queries on tables that
# are much larger than your available memory, you should increase
# the value of read_rnd_buffer_size to speed up the reading of rows
# following sorting operations.
# but: change the session variable only from within those clients
# that need to run large queries
read_rnd_buffer_size=2M

max_heap_table_size=256M
tmp_table_size=256M

myisam_sort_buffer_size=64M

# increase until threads_created doesnt grow anymore
thread_cache=256

query_cache_type=1
query_cache_limit=1M
query_cache_size=32M

# Try number of CPU's*2 for thread_concurrency
thread_concurrency=4


[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer=128M
sort_buffer_size=128M
read_buffer=2M
write_buffer=2M

[myisamchk]
key_buffer=128M
sort_buffer_size=128M
read_buffer=2M
write_buffer=2M

[mysqlhotcopy]
interactive-timeout
You can use the SHOW STATUS MySQL command to monitor some of the variables (like Threads_created , Created_tmp_disk_tables , Created_tmp_tables and so on).

Tuesday, December 27, 2011

How To Export Tally data to any SQL database

Export Tally data to any SQL database | DX-Fusion


Product    : DX-Fusion
Platform   : Windows 2000 and above
Tally         : Tally ERP 9 Release 1.61 and above
Category : Utility to transfer data from Tally Software into RDBMS (database) in real-time.


An Introduction to DX-Fusion


DX-Fusion is an utility that transfers data from Tally Accounting Software into your database in real-time. It supports MS-SQL Server, MS-Access, MySQL, Oracle and many other popular databases.

DX-Fusion works with Tally ERP 9 Release 1.61 and higher versions. It can retrieve data from Tally in both online (real-time) and off-line modes.

DX-Fusion utility does NOT require any coding (except for a connection-string to connect to the database) and can be used by developers and end-users both. Developers can use this data for designing of MIS reports and Integration with other external softwares.

DX-Fusion Editions



Free Edition
A fully functional edition of DX-Fusion utility which supports transfer of all masters and vouchers data from Tally Sofware into your database subject to restriction of 10 vouchers at a time. It supports off-line mode only.

Standard Edition
A software utility for transferring masters and vouchers data from Tally Accounting Software into your database in Real-time (online mode).

Source: http://www.rtslink.com/dx-fusion/



how to delete facebook account

How Do I Delete My Facebook Account - Instructions

If you've decided to delete your Facebook account, here's how you can go about it.
  1. First, sign out of any applications you might use in conjunction with your Facebook account, such as Facebook Connect and the applications that update Facebook automatically from Twitter.
  2. Cancel any blog feeds that you might be using on your account.
  3. Log in to Facebook, and then go to the delete account form. If this direct link doesn't work, go to the Help Center (click "Help" at the bottom of any page), and search for "How do I delete my Facebook Account." The first result should include a link to the form.
  4. A simple form will appear that reminds you that you won't be able to reactivate your account if you delete it. If you're sure you want to permanently remove your account, click on "Submit."
At this point your account will immediately be deactivated. The amount of time between requesting the deletion and having your information physically removed can be up to 14 days.
Refrain from trying to log in to your account for at least two weeks. After this period, you can see if your account is truly gone by attempting to log in. If you get into your account, you'll have to start the process all over again.

How to Delete a Facebook Account When Someone Dies

If a loved one has passed away, you may want to have his or her Facebook account deleted. It can be jarring to see reminders to connect with the deceased when you're visiting the site, and you may want to have all personal information of your loved one removed. Facebook offers the option to have a deceased person's page memorialized. When this occurs, all contact information is removed from the profile and anyone who isn't on the deceased's friends list will not be able to find the page. The wall is left open for friends and family to post messages.
The other option is to have the account deleted. There is now a form on Facebook, called Report a Deceased Person's Profile, which can be used by immediate family to have the account either memorialized or deleted. You'll be required to supply a link to an obituary or other report of death to ensure the information is accurate.
While anyone can make these reports, accounts will only be removed when the request comes from an immediate family member.

Make Sure You Really Want to Delete

Before deleting your Facebook account, make sure that this is something you really want to do. Since a deleted account can never be restored, all of the information and photos you have on your profile will be gone for good. If you're unsure, consider deactivating the account first before you do anything permanent.

Source : http://socialnetworking.lovetoknow.com/How_Do_I_Delete_My_Facebook_Account

how to hide selection of richedit c#

private void richTextBox1_SelectionChanged(object sender, EventArgs e)
        {
            //MessageBox.Show("Selected");

             richTextBox1.SelectionLength = 0;
        }

Monday, December 26, 2011

How to create a stunning and smooth popup using jQuery?

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <title>yensdesign.com - How to create a stuning and smooth popup in jQuery</title>
    <link rel="stylesheet" href="general.css" type="text/css" media="screen" />
    <script src="http://jqueryjs.googlecode.com/files/jquery-1.2.6.min.js" type="text/javascript"></script>
    <script src="popup.js" type="text/javascript"></script>
</head>
<body>
        <div id="button"><input type="submit" value="Press me please!" /></div>
        <a href="http://www.yensdesign.com"><img src="logo.jpg" alt="Go to yensdesign.com"/></a>
   
    <a href="#" id="ch1">click</a>
    <input type="button" onclick="document.getElementById('ch1').href='cvb'">
    <div id="popupContact">
        <a id="popupContactClose">x</a>
        <h1>Title of our cool popup, yay!</h1>
        <p id="contactArea">
            Here we have a simple but interesting sample of our new stuning and smooth popup. As you can see jQuery and CSS does it easy...
            <br/><br/>
            We can use it for popup-forms and more... just experiment!
            <br/><br/>
            Press ESCAPE, Click on X (right-top) or Click Out from the popup to close the popup!
            <br/><br/>
            <a href="http://www.yensdesign.com"><img src="logo.jpg" alt="Go to yensdesign.com"/></a>
        </p>
    </div>
    <div id="backgroundPopup"></div>
</body>
</html>


source : http://yensdesign.com/tutorials/popupjquery/

Friday, December 23, 2011

how to avoid tension?

Tension headaches are also known as stress headaches, non-progressive headaches and muscle contraction headaches. They affect 30-80% of the adult population and may be episodic or chronic in nature. Tension headache can last from a few minutes, hours and days to several years and are quite annoying.
Tension headaches are characterized by pounding pain which is felt on both sides of the head and is accompanied by the inability to concentrate, fatigue and irritability. Some patients feel as if their head is being compressed in a vice.
Tension headaches hang on even after the person has woken up from deep sleep causing him/her to feel dull and drained out. Such individuals are often unable to fall asleep or stay asleep for adequate periods of time. Stress and mental tension are the main culprits that trigger tension headaches.  Other causes include prolonged hours of work, irregular eating habits, empty stomach, sleeping or sitting in an odd posture, eye strain and caffeine withdrawal.
Treatment of tension headaches:
Avoid stress:
Stress is the main underlying cause that needs to be eliminated in order to treat tension headaches. You need to take out time for relaxation and exercise on a regular basis, meditate and relax the mind in order to battle stress.