• We've upgraded our forums. Please post any issues/requests in this thread.

Good site or book on database management and scaling

xbonez

New Member
Joined
Nov 29, 2010
Messages
1,182 (0.46/day)
Likes
315
Location
Philly, PA (US)
System Name Winter
Processor AMD Phenom II x4 965 BE @ 4.0Ghz
Motherboard MSI 790FX-GD70
Cooling Corsair H50 Liquid Cooling
Memory 2 x 2Gb Gskill Ripjaws 1600Mhz (7-7-7-24@1.6V)
Video Card(s) Asus GTX 470 @ Stock (Zalman VF3000 cooler)
Storage 2 x Samsung Spinpoint F3 500GB (RAID 0)
Display(s) Hanns G 28" @ 1920x1200
Case Antec 1200
Audio Device(s) Onboard -- TosLink --> Z5500
Power Supply Corsair 850TX 850W PSU
Software Win 7 64-bit Ultimate
#1
Ok, here's the deal. I'm working on a website right now that serves as the face for a online service. The service is going to be heavily database driven with a lot of read / write cycles and a lot of information being stored on the databases.

We're using MySQL. Currently, for the sake of setting up the website, I'm using a single database with multiple tables depending on the information being stored and purpose being served. If things go right, this service could attract a lot of traffic and our database could blow up significantly fast.

I'm really interested in setting up the database schemas right from the get go so later down the line we don't need to carry out a major overhaul of the backend resulting in downtime.

Long story short, could you please recommend me some books / websites that teach / talk about building scalable databases. I don't need the basics of DBMS or SQL. I'm looking primarily for sources that discuss the architecture of high volume databases - normalizing, sharding etc.
 

Easy Rhino

Linux Advocate
Joined
Nov 13, 2006
Messages
14,405 (3.56/day)
Likes
4,257
System Name VHOST01 | Desktop
Processor i7 980x | i5 7500 Kaby Lake
Motherboard Gigabyte x58 Extreme | AsRock MicroATX Z170M Exteme4
Cooling Prolimatech Megahelams | Stock
Memory 6x4 GB @ 1333 | 2x 8G Gskill Aegis DDR4 2400
Video Card(s) Nvidia GT 210 | Nvidia GTX 970 FTW+
Storage 4x2 TB Enterprise RAID5 |Corsair mForce nvme 250G
Display(s) N/A | Dell 27" 1440p 8bit GSYNC
Case Lian Li ATX Mid Tower | Corsair Carbide 400C
Audio Device(s) NA | On Board
Power Supply SeaSonic 500W Gold | Seasonic SSR-650GD Flagship Prime Series 650W Gold
Mouse N/A | Logitech G900 Chaos Spectrum
Keyboard N/A | Posiden Z RGB Cherry MX Brown
Software Centos 7 | Windows 10
#2
any textbook on database design you can find on amazon.com should be helpful. also, go to the bookstore and look around in the computer section.
 

Jacko28

New Member
Joined
Sep 23, 2008
Messages
67 (0.02/day)
Likes
10
#3
As Easy Rhino said most of the database systems books on amazon will cover what you need. I've got a book which I used at University, it went into alot of detail regarding subjects such as normalization and other methodoligies, it's an information systems dev book rather than purley database management but still good. I'm at work right now but when I get home I'll find out what it's called.