Results 1 to 11 of 11
-
10-31-2013, 06:18 AM #1Junior Guru Wannabe
- Join Date
- Dec 2012
- Posts
- 32
How do you handle large database for your billing system?
Hello,
If you're in hosting business for years. Your database for storing customers details, tickets, invoices ... shoud be very big. I wonder how can you handle this? Delete old tickets and invoices ... or simply move the entire database to a more powerful server? How big is your database and do you want to keep it ?
Please share some information with me if you can
Thank you
-
10-31-2013, 06:35 AM #2
Depends on if you're facing any issues or not. This thread doesn't really provide much info.
Of course it's recommended to optimize the database, prune old log files, maybe attachments, etc.~]# Ethernet Servers Ltd - Est. 2014! - sales @ ethernetservers.com
~]# Try out our WordPress speed tests for yourself!
~]# NVMe Web Hosting | Unmanaged VPS | Fully Managed VPS | Dedicated Servers | Domain Names
~]# Don't settle for any less than the very best - come & join our family today!
-
10-31-2013, 06:44 AM #3Disabled
- Join Date
- Feb 2013
- Posts
- 35
What host are you with? Your hosting provider should help you out.
-
10-31-2013, 07:00 AM #4Junior Guru Wannabe
- Join Date
- Aug 2013
- Location
- gurgaon
- Posts
- 42
All the Database problems coming to me are solved by hosting provider of mine so you should also askl him about that....
-
10-31-2013, 07:22 AM #5The Linux Specialist
- Join Date
- Mar 2003
- Location
- /root
- Posts
- 23,991
Specially 4 U
Reseller Hosting: Boost Your Websites | Fully Managed KVM VPS: 3.20 - 5.00 Ghz, Pure Dedicated Power
JoneSolutions.Com is on the net 24/7 providing stable and reliable web hosting solutions, server management and services since 2001
Debian|Ubuntu|cPanel|DirectAdmin|Enhance|Webuzo|Acronis|Estela|BitNinja|Nginx
-
10-31-2013, 07:34 AM #6Junior Guru
- Join Date
- Feb 2006
- Location
- ::1/128
- Posts
- 247
-
10-31-2013, 09:08 AM #7Web Hosting Master
- Join Date
- May 2009
- Location
- The Netherlands
- Posts
- 1,057
We never delete old content (as tickets or invoices) from our system as documentation and having all that data has proven to be critical and very useful in many cases.
The right approach is to hire a DBA to do some optimization (not on a regular basis but more of a one time thing) and if still required to do so - upgrade the resources you need more of.
Please note that if your database is very big, it doesn't mean you will need a "better server" but more likely just more storage.
Good luck.Maple-Hosting - Netherlands Dedicated Servers
Award-Winning Highly-Customizable Dedicated Servers Since 2008
“After 14 months, I can’t give them less than 10/10 on all aspects!” - Read Our Customer Reviews
-
10-31-2013, 09:27 AM #8Junior Guru Wannabe
- Join Date
- Dec 2012
- Posts
- 32
Thank you for your all feedbacks. My data is not too big. It's around 700MB now but i start finding it hard to import that amount of data. I got tons of errors when importing that data and many tables were lost during the import. I have no ways to understand whats happening. Do you find it hard to import a big data, even its more than some GB ? Do you use any special tool or just use mysql command ? I will highly appreciate if you can share a way to handle this kind of issue
-
10-31-2013, 11:40 AM #9Web Hosting Guru
- Join Date
- Jan 2010
- Location
- East Lansing, MI
- Posts
- 305
That's the kind of situation where it is likely best to hire a DBA. Someone who knows the ins and outs, understand the errors, and can optimize the database. Optimization will go a long ways.
Make sure your database is backed up, and ideally redundant. That data is EXTREMELY valuable to your company. Without it you're screwed. MariaDB (MySQL drop-in replacement) clusters pretty easily.
https://mariadb.com/kb/en/getting-st...alera-cluster/
But again, for something so crucial to your business, hire a professional.
-
11-05-2013, 11:55 AM #10Newbie
- Join Date
- Nov 2013
- Posts
- 23
This is a general question. You need to be specific on Operating System and the backup tool you tried to create backups of your database. mysqldump is an excellent command/tool for creating mysql database backups from the command line in Linux. It is pretty straight forward to use and could create backups pretty quickly, if you don't have any errors in your mysql database tables.
-
11-05-2013, 01:04 PM #11Web Hosting Guru
- Join Date
- Oct 2006
- Posts
- 334
Similar Threads
-
tidy billing system vs massive junk database
By systemadminjobs in forum Running a Web Hosting BusinessReplies: 0Last Post: 11-24-2010, 01:05 AM -
what do large companies use for billing system
By bluebubble in forum Running a Web Hosting BusinessReplies: 39Last Post: 05-17-2009, 09:50 PM -
Billing system to handle POST USAGE host billing
By gigapros in forum Running a Web Hosting BusinessReplies: 9Last Post: 07-06-2008, 11:39 AM -
Need a host that can handle a large database
By vibez in forum Web HostingReplies: 23Last Post: 10-20-2006, 04:49 PM