mysql
Archived Posts from this Category
Archived Posts from this Category
Xeround.com has a Cloud database service, specifically MySQL cloud.
Xeround is an elastic, always-on database-as-a-service for your MySQL applications.
With the rise of cloud computing and “big data”, database scalability issues are becoming critical to the growth and success of many applications. Xeround’s vision is to enable truly scalable and elastic cloud computing infrastructure by providing the missing piece: elastic data management within a cloud and data federation across clouds.
Xeround is a distributed cloud database. Its availability is guaranteed because it doesn’t have any single point of failure and because all the system components are automatically replicated and distributed across several cloud servers for failover purposes.
Xeround’s technology allows for arbitrarily setting the number of data replicas that the service manages, as well as the role each plays and the location each resides in. Today our service is offered with two active-active replicas, with additional high availability options offered soon.
If a cloud server fails, all the data is still available in the surviving replicas and the DB is operational. As the self-healing process kicks in, replacement servers are acquired on-the-fly and re-sync is executed from the remaining replicas.
Xeround’s distributed database-as-a-service architecture consists of three separate functional layers working in tandem to provide the service. Each layer is multiplied and automatically replicated so it is independently highly available – so the service is always maintained:
0 comments Tuesday 17 Apr 2012 | BestHosting | cloud, mysql
To create the database backup, you have three options .
1. Use the cpanel backup option. This is usually the easiest., however the file will be in .sql.gz format. If using this option, you will need to first unzip the file using a program such as winrar, then to open the file, unless you have another program already setup to open it, you would use wordpad.
2. Alternative way:
a. login to cpanel
b. click on mysql databases
c. scroll down and click on phpmyadmin
d. If you have more then 1 database, on the left hand side choose the database you want to download. Do NOT click on any tables for the individual database
e. on the right hand side, click on “export” and make sure that all your tables listed are highlighted.
f. Make sure “save as file” is selected
g. click on “go”
This will allow you to download your database into a .sql file.
3. Another alternative:
Use the same steps as above except on step 6 do NOT “save as file”. This will display your complete database within the browser window, and you can then do a “copy/paste” into a wordpad file. If using this method, if saving the information to your local system, save the file as a .sql in case you ever need to import it to phpmyadmin.
WARNING:
If your Database is excessively large, and you may experience issues with either method above if you have any instability with your connection between your location and the server.
If you continue to experience issues, contact your support, advise you are having issues, and ask if a technician can create a backup and save it to your file structure so that it can be downloaded via browser.
They will usually need the following information:
1. Last four of card on record, account username, account password (this is for ownership verification)
2. Database name, database username, database password
3, Location where you would like the database backup moved to, must be inside public_html to allow for download via browser.
4. Url of this forum, so that they can see the history of this issue
1 comment Monday 29 Mar 2010 | BestHosting | cpanel, mysql, support, tips