By Jag October 3, 2017, 7:15 PM
Cloud hosting infographic
- MySQL provides cluserting but not fail over for end user. So here at JaguarPC Web Hosting labs we tested MySQL fail over cluserting. To setup MySQL clustering a minimum of 3 computers are required. However recommended number is 4 or more. And to setup a failover mysql cluster, we add one more machine making it 5. There are 3 parts in a MySQL Cluster: Data: 2 or more nodes act as data. In MySQL 5.0, the data sits in memory, while in 5.1 data can go on disk as well (5.1 is release candidate). For our testing we use 2 data nodes. When one of the node dies, the other will serve the data. Management: One machine is used for cluster management. Once the cluster is started and this machine goes down, the cluster can continue to work. So this is not critical for our fail over setup. SQL:: 2 test machines were setup as SQL nodes in failover with a single "floating IP". When one died, the "floating IP" moved to the second machine using arp spoofing. MySQL client would connect to SQL node using that floating IP, so for the client MySQL Server remains up and running when one of the SQL nodes die. This part of the setup is JaguarPC's own making and is available through Dedicated Server Hosting offer. The rough diagram for this whole setup is as follows: MySQL client -> [ 2 SQL nodes fail-over ] -> [ 2 data nodes ] RAM Requirement for Data Node: Since MySQL 5.0 uses RAM to hold the data in data nodes, you can use the following formula for obtaining a rough estimate of how much RAM is needed for each data node in the cluster: (SizeofDatabase × NumberOfReplicas × 1.1 ) / NumberOfDataNodes Say our database size is 10 GB, and we make 2 replicas and host it on 4 nodes, then we need about 6GB RAM in each node. If we store our 10GB with 2 replicas in 6 nodes, then we need 4GB RAM in each node. You get the idea. More will be posted later about this topic.
Mar 17, 2008
- Google has made several changes and/or added new features to their already existing features. For example, you can now Spice up your inbox with colors and themes. This change I embraced as I am always on the lookout for a new, colorful, appealing, and/or easier-to-navigate theme for the products I use. Then Google changed the Google Reader interface. This change annoyed me quite a bit at first as they actually made some things harder to find, such as how to "show all" or "show updated" items. It took me a week to figure out that I needed to click the tiny little down arrow to the right of "Subscriptions" to get to those menu options. When they announced the change all they said about that particular change was:
- The "Show all - updated" controls are now in the Subscriptions options menu.
Jan 14, 2009
- VPS (virtual private server) hosting is commonly selected by businesses of all sizes. With VPS, the benefits of other types of hosting, such as shared and dedicated, are packaged into one versatile solution. Managed VPS hosting is especially advantageous if you’re new to web hosting and need a quick, affordable plan that addresses each of your needs. If total system isolation, customization, and managed services sound appealing, VPS hosting might be the right choice for you. Isolated Resources To put it simply, VPS hosting is similar to shared hosting in the sense that providers allocate portions of virtual private servers to users. However, VPS hosting is largely more secure than shared and allows users to enjoy total isolation. You won’t have the activity of other customers affecting you. Virtual private servers are partitioned – not necessarily shared. With a VPS hosting plan, you'll have full control over your bandwidth, disk space, and other resources. In many ways, VPS hosting is much like dedicated hosting, but without the steep costs. Server Control Choosing VPS hosting means you're able to select your own operating system, such as Windows, CentOS, Fedora Core, and others. Accordingly, you'll be free to use the programs and applications you need to create websites, databases, etc., such as PHP, MySQL, and Apache. Like dedicated hosting, VPS allows for a great deal of customization. Many VPS hosting plans come equipped with remote desktop and root access solutions – allowing users to personalize their data. If you need to make changes to your resources, you can easily configure the server to accommodate your preferences. Why Managed Hosting? Opting for managed VPS hosting affords many benefits – particularly if you're inexperienced with maintaining hardware. If your company is expanding, chances are the resources you use now will fluctuate in the future. Later down the road, you may need more disk space, bandwidth, applications, etc. to meet your customers’ standards. Managed hosting gives companies the opportunity to add or remove resources whenever needed, without the expenses and hassle associated with self-maintained, on-site hardware. Not only is this flexibility convenient, but it also helps to cut back on costs and unnecessary issues.
Dec 02, 2014