Should database be on its own hardware?

fred974

fred974

Hello all,

I have 1 PowerEdge R610 Production server that hosts 24 WordPress websites, 2 ticket system and 2 CRM and 1 postfix email server and 1 /databases/mariadb101-server database
Each application is hosted inside a jail so I have 24 jails for the website, 1 for email 1 for database etc..
All the moment ALL my application use the single /databases/mariadb101-server jail server.
I am worried that if anything happens to that database jail, I'll lose everything.
I am working on a solution to develop a more resilient system using 2 servers in a CARP scenario where the server is mirrored..

My question is do I need to move the database to its own dedicated hardware or can I keep them inside the jail and create more DB jail in a cluster ?
 
fred974 said:
can I keep them inside the jail and create more DB jail in a cluster
Click to expand...
Think of what would happen if this single server dies completely. Then everything will be gone. Plan for a complete meltdown of a server. Hardware tends to break, usually at the worst possible time.
 
SirDice said:
Think of what would happen if this single server dies completely
Click to expand...
yes but I will have 2 servers tough.. Bellow is the concept
41886591_940456159490725_6277889564111536128_n.jpg41939079_301347523999568_7951506042959953920_n.jpg41946258_2257914664249937_8455102597777326080_n.jpg42058427_2072365019462007_7910793038643855360_n.jpg
 
fred974 said:
I am worried that if anything happens to that database jail, I'll lose everything.
Click to expand...
Maybe I am stating the obvious here - but just to make sure that the ground work is done before we dive deep(er) into HA and/or replication: Do you have a proper backup system in place? No matter how many servers you have running in parallel, you must (I know, "should") always have at least one off-site backup that allows you to restore everything.

Even if you move your database stuff to a dedicated server: This still applies. A cluster is never a replacement for a backup!
 
I'd put the databases on separate machines. Database servers have a different load-type than webservers and need to be tweaked differently. By splitting them up you can more easily tune machines for specific purposes.
 
fred974 said:
will you dedicate the whole machine as 1 database or create cluster in jail?
Click to expand...
Multiple databases on the same server.

fred974 said:
Also would you use one or 2 server? do you do master to master or master / slave
Click to expand...
More is better. A client of mine actually has 3 or 4 (plus one additional off-site). One master, one slave (can be made master), one slave lagging one hour behind and one 'slave' for historic data.
 
SirDice what technology do you use for the cluster? Do you use gallera or something else? How do you load balance between databases? I am aware if maxscale but I don't think it exist in FreeBSD.
 
No clustering. No load-balancing on the databases. The webservers are balanced using HAproxy, the databases are managed by hand (their choice). Their setup is a little different due to the nature of their websites. Normally you'd have 90% read and 10% writes on a database, we have it exactly the other way around, 90% write and 10% read.
 
fred974 said:
How many database would you create on Dell R610 with 48GB RAM and 6x146GB sas?
Click to expand...
That depends on the size of the databases. Ideally a whole database should fit into memory but that's not always possible. Our database servers have at least 380 GB RAM and even that isn't enough to fit everything in memory.
 
Hi,
Do you create the databases in separate jails?
I currently have 25 individual databases in my database jail with a total of 2.5GB so far.
 
You must log in or register to reply here.
Back
Top