It's hard to give specific advice from what you've posted here but I do have some generic advice based on a post I wrote ages ago back when I could still be bothered to blog.
Don't Panic
First things first, there are no "quick fixes" other than restoring your system from a backup taken prior to the intrusion, and this has at least two problems.
- It's difficult to pinpoint when the intrusion happened.
- It doesn't help you close the "hole" that allowed them to break in last time, nor deal with the consequences of any "data theft" that may also have taken place.
This question keeps being asked repeatedly by the victims of hackers breaking into their web server. The answers very rarely change, but people keep asking the question. I'm not sure why. Perhaps people just don't like the answers they've seen when searching for help, or they can't find someone they trust to give them advice. Or perhaps people read an answer to this question and focus too much on the 5% of why their case is special and different from the answers they can find online and miss the 95% of the question and answer where their case is near enough the same as the one they read online.
That brings me to the first important nugget of information. I really do appreciate that you are a special unique snowflake. I appreciate that your website is too, as it's a reflection of you and your business or at the very least, your hard work on behalf of an employer. But to someone on the outside looking in, whether a computer security person looking at the problem to try and help you or even the attacker himself, it is very likely that your problem will be at least 95% identical to every other case they've ever looked at.
Don't take the attack personally, and don't take the recommendations that follow here or that you get from other people personally. If you are reading this after just becoming the victim of a website hack then I really am sorry, and I really hope you can find something helpful here, but this is not the time to let your ego get in the way of what you need to do.
You have just found out that your server(s) got hacked. Now what?
Do not panic. Absolutely do not act in haste, and absolutely do not try and pretend things never happened and not act at all.
First: understand that the disaster has already happened. This is not the time for denial; it is the time to accept what has happened, to be realistic about it, and to take steps to manage the consequences of the impact.
Some of these steps are going to hurt, and (unless your website holds a copy of my details) I really don't care if you ignore all or some of these steps, that's up to you. But following them properly will make things better in the end. The medicine might taste awful but sometimes you have to overlook that if you really want the cure to work.
Stop the problem from becoming worse than it already is:
- The first thing you should do is disconnect the affected systems from the Internet. Whatever other problems you have, leaving the system connected to the web will only allow the attack to continue. I mean this quite literally; get someone to physically visit the server and unplug network cables if that is what it takes, but disconnect the victim from its muggers before you try to do anything else.
- Change all your passwords for all accounts on all computers that are on the same network as the compromised systems. No really. All accounts. All computers. Yes, you're right, this might be overkill; on the other hand, it might not. You don't know either way, do you?
- Check your other systems. Pay special attention to other Internet facing services, and to those that hold financial or other commercially sensitive data.
- If the system holds anyone's personal data, immediately inform the person responsible for data protection (if that's not you) and URGE a full disclosure. I know this one is tough. I know this one is going to hurt. I know that many businesses want to sweep this kind of problem under the carpet but the business is going to have to deal with it - and needs to do so with an eye on any and all relevant privacy laws.
However annoyed your customers might be to have you tell them about a problem, they'll be far more annoyed if you don't tell them, and they only find out for themselves after someone charges $8,000 worth of goods using the credit card details they stole from your site.
Remember what I said previously? The bad thing has already happened. The only question now is how well you deal with it.
Understand the problem fully:
- Do NOT put the affected systems back online until this stage is fully complete, unless you want to be the person whose post was the tipping point for me actually deciding to write this article. I'm not going to link to that post so that people can get a cheap laugh, but the real tragedy is when people fail to learn from their mistakes.
- Examine the 'attacked' systems to understand how the attacks succeeded in compromising your security. Make every effort to find out where the attacks "came from", so that you understand what problems you have and need to address to make your system safe in the future.
- Examine the 'attacked' systems again, this time to understand where the attacks went, so that you understand what systems were compromised in the attack. Ensure you follow up any pointers that suggest compromised systems could become a springboard to attack your systems further.
- Ensure the "gateways" used in any and all attacks are fully understood, so that you may begin to close them properly. (e.g. if your systems were compromised by a SQL injection attack, then not only do you need to close the particular flawed line of code that they broke in by, you would want to audit all of your code to see if the same type of mistake was made elsewhere).
- Understand that attacks might succeed because of more than one flaw. Often, attacks succeed not through finding one major bug in a system but by stringing together several issues (sometimes minor and trivial by themselves) to compromise a system. For example, using SQL injection attacks to send commands to a database server, discovering the website/application you're attacking is running in the context of an administrative user and using the rights of that account as a stepping-stone to compromise other parts of a system. Or as hackers like to call it: "another day in the office taking advantage of common mistakes people make".
Why not just "repair" the exploit or rootkit you've detected and put the system back online?
In situations like this the problem is that you don't have control of that system any more. It's not your computer any more.
The only way to be certain that you've got control of the system is to rebuild the system. While there's a lot of value in finding and fixing the exploit used to break into the system, you can't be sure about what else has been done to the system once the intruders gained control (indeed, its not unheard of for hackers that recruit systems into a botnet to patch the exploits they used themselves, to safeguard "their" new computer from other hackers, as well as installing their rootkit).
Make a plan for recovery and to bring your website back online and stick to it:
Nobody wants to be offline for longer than they have to be. That's a given. If this website is a revenue generating mechanism then the pressure to bring it back online quickly will be intense. Even if the only thing at stake is your / your company's reputation, this is still going generate a lot of pressure to put things back up quickly.
However, don't give in to the temptation to go back online too quickly. Instead move with as fast as possible to understand what caused the problem and to solve it before you go back online or else you will almost certainly fall victim to an intrusion once again, and remember, "to get hacked once can be classed as misfortune; to get hacked again straight afterward looks like carelessness" (with apologies to Oscar Wilde).
- I'm assuming you've understood all the issues that led to the successful intrusion in the first place before you even start this section. I don't want to overstate the case but if you haven't done that first then you really do need to. Sorry.
- Never pay blackmail / protection money. This is the sign of an easy mark and you don't want that phrase ever used to describe you.
- Don't be tempted to put the same server(s) back online without a full rebuild. It should be far quicker to build a new box or "nuke the server from orbit and do a clean install" on the old hardware than it would be to audit every single corner of the old system to make sure it is clean before putting it back online again. If you disagree with that then you probably don't know what it really means to ensure a system is fully cleaned, or your website deployment procedures are an unholy mess. You presumably have backups and test deployments of your site that you can just use to build the live site, and if you don't then being hacked is not your biggest problem.
- Be very careful about re-using data that was "live" on the system at the time of the hack. I won't say "never ever do it" because you'll just ignore me, but frankly I think you do need to consider the consequences of keeping data around when you know you cannot guarantee its integrity. Ideally, you should restore this from a backup made prior to the intrusion. If you cannot or will not do that, you should be very careful with that data because it's tainted. You should especially be aware of the consequences to others if this data belongs to customers or site visitors rather than directly to you.
- Monitor the system(s) carefully. You should resolve to do this as an ongoing process in the future (more below) but you take extra pains to be vigilant during the period immediately following your site coming back online. The intruders will almost certainly be back, and if you can spot them trying to break in again you will certainly be able to see quickly if you really have closed all the holes they used before plus any they made for themselves, and you might gather useful information you can pass on to your local law enforcement.
Reducing the risk in the future.
The first thing you need to understand is that security is a process that you have to apply throughout the entire life-cycle of designing, deploying and maintaining an Internet-facing system, not something you can slap a few layers over your code afterwards like cheap paint. To be properly secure, a service and an application need to be designed from the start with this in mind as one of the major goals of the project. I realise that's boring and you've heard it all before and that I "just don't realise the pressure man" of getting your beta web2.0 (beta) service into beta status on the web, but the fact is that this keeps getting repeated because it was true the first time it was said and it hasn't yet become a lie.
You can't eliminate risk. You shouldn't even try to do that. What you should do however is to understand which security risks are important to you, and understand how to manage and reduce both the impact of the risk and the probability that the risk will occur.
What steps can you take to reduce the probability of an attack being successful?
For example:
- Was the flaw that allowed people to break into your site a known bug in vendor code, for which a patch was available? If so, do you need to re-think your approach to how you patch applications on your Internet-facing servers?
- Was the flaw that allowed people to break into your site an unknown bug in vendor code, for which a patch was not available? I most certainly do not advocate changing suppliers whenever something like this bites you because they all have their problems and you'll run out of platforms in a year at the most if you take this approach. However, if a system constantly lets you down then you should either migrate to something more robust or at the very least, re-architect your system so that vulnerable components stay wrapped up in cotton wool and as far away as possible from hostile eyes.
- Was the flaw a bug in code developed by you (or a contractor working for you)? If so, do you need to re-think your approach to how you approve code for deployment to your live site? Could the bug have been caught with an improved test system, or with changes to your coding "standard" (for example, while technology is not a panacea, you can reduce the probability of a successful SQL injection attack by using well-documented coding techniques).
- Was the flaw due to a problem with how the server or application software was deployed? If so, are you using automated procedures to build and deploy servers where possible? These are a great help in maintaining a consistent "baseline" state on all your servers, minimising the amount of custom work that has to be done on each one and hence hopefully minimising the opportunity for a mistake to be made. Same goes with code deployment - if you require something "special" to be done to deploy the latest version of your web app then try hard to automate it and ensure it always is done in a consistent manner.
- Could the intrusion have been caught earlier with better monitoring of your systems? Of course, 24-hour monitoring or an "on call" system for your staff might not be cost effective, but there are companies out there who can monitor your web facing services for you and alert you in the event of a problem. You might decide you can't afford this or don't need it and that's just fine... just take it into consideration.
- Use tools such as tripwire and nessus where appropriate - but don't just use them blindly because I said so. Take the time to learn how to use a few good security tools that are appropriate to your environment, keep these tools updated and use them on a regular basis.
- Consider hiring security experts to 'audit' your website security on a regular basis. Again, you might decide you can't afford this or don't need it and that's just fine... just take it into consideration.
What steps can you take to reduce the consequences of a successful attack?
If you decide that the "risk" of the lower floor of your home flooding is high, but not high enough to warrant moving, you should at least move the irreplaceable family heirlooms upstairs. Right?
- Can you reduce the amount of services directly exposed to the Internet? Can you maintain some kind of gap between your internal services and your Internet-facing services? This ensures that even if your external systems are compromised the chances of using this as a springboard to attack your internal systems are limited.
- Are you storing information you don't need to store? Are you storing such information "online" when it could be archived somewhere else. There are two points to this part; the obvious one is that people cannot steal information from you that you don't have, and the second point is that the less you store, the less you need to maintain and code for, and so there are fewer chances for bugs to slip into your code or systems design.
- Are you using "least access" principles for your web app? If users only need to read from a database, then make sure the account the web app uses to service this only has read access, don't allow it write access and certainly not system-level access.
- If you're not very experienced at something and it is not central to your business, consider outsourcing it. In other words, if you run a small website talking about writing desktop application code and decide to start selling small desktop applications from the site then consider "outsourcing" your credit card order system to someone like Paypal.
- If at all possible, make practicing recovery from compromised systems part of your Disaster Recovery plan. This is arguably just another "disaster scenario" that you could encounter, simply one with its own set of problems and issues that are distinct from the usual 'server room caught fire'/'was invaded by giant server eating furbies' kind of thing.
... And finally
I've probably left out no end of stuff that others consider important, but the steps above should at least help you start sorting things out if you are unlucky enough to fall victim to hackers.
Above all: Don't panic. Think before you act. Act firmly once you've made a decision, and leave a comment below if you have something to add to my list of steps.
Best Answer
What is your main goal?
Performance
If your goal is performance and you can spare some offline time, then your current setup is fine, and what Quintiliano commented about using your DBs in containers may stand. While using Apache as reverse proxy is easy to manage, for better performance you can check HAProxy (it's not hard but takes time to get used to it). To increase your performance, you may need 2 or more servers and a Load Balancer (Load Balancer makes no sense with a single server). If you have a good connection you can use network interface binding to double your connection speed.
Security
You can improve your security adding a router before your proxy (professional -expensive- or economic but full featured, such as ubiquiti, mikrotik, etc). You need to know how to set it up and protect your private network. In terms of security, is better to run your databases in containers and loose some performance. You can also set your proxy in containers. I would recommend to check traefik which is an easy-to-use Proxy/Load Balancer. You are right, a single server is easier to maintain than two servers.
Redundancy (failsafe)
If what you want is no-down-time, you will need to change your design. You need at least 2 routers and setup VRRP. You need to setup network interface binding and have at least 2 servers (more is best). You setup in your routers to send odd IPs into one of the servers and even IPs to the other (that way you don't need to synchronize sessions), and will load balance your connections. You will need a way to synchronize files from one server to another (in case of file upload, etc). I recommend to use unison, however I use LXD instead of docker, so I'm not sure if that will work in your case. For the database, its better to have them in a cluster, check Galera with maxscale. You usually need at least 3 servers for that, but it is possible to run it with 2 servers if you use Galera Arbitrator
That is only one way to go, there are many paths and this is my personal solution.
UPDATE (about security)
Seriously, how bad it would be if that business data leaks? You said it would be 'Fatal', but it is so? The reason I'm asking you this is because if its that important, then you shouldn't be doing this by yourself, but either with a specialized team or a security consultant. No matter how much you stick to the book, there is always room for mistakes if you don't have enough experience (and if you are asking in this site, is because you don't have it, is that right?). Don't take me wrong, if that data leaks, who is going to be blamed for it? In my personal case, I don't manage top secrets, so as long as I try to follow and apply above-standard security measures, I think its enough. From what I see in you security list, you are covering pretty much what I usually do, and so far I haven't had any security breach so far (that I'm aware of :P).
I have few more suggestions that could improve your setup:
1) Data protection: Please take a look into Data at rest encryption with MariaDB. That is a pretty easy way to get your data encrypted. The main benefit of it is that if your database files get compromised, they are useless without a key. If you store the key in memory is better as it won't be stored in your snapshots or backups, the downside is that you will have to enter that key each time you start the database. This encryption method won't help you if someone has access to the running instance (which is the most common way to hack into a database).
2) Applications: My guess is that your weakest link is in the application layer. You have to be sure your code is well protected and that is not vulnerable to XSS, SQL injections or alike. If you can't be 100% of it, better to keep highly important data as away as possible from your applications. Be sure you add more protection layers (like extra authentication, encryption of values in database, etc)).
3) Encrypted directories: Encrypting directories is usually helpful for those cases in which the server is stolen or someone gains access with a non-root user.
4) Backups: Keep a look where you store your backups and snapshots. They are as important as your databases. If your servers are infected with a ransomware (yes it could happen in Linux too), your backups can help you to save the day. Its a good idea to keep those in a safe location (restricted, encrypted and if possible immutable).
5) Local network: Be sure your servers are isolated from your local network. Don't assume that your local network is safe, so don't grant special permissions for local clients. Treat your server as if it were isolated in a remote place and only accessible through Internet, that way you will only protect a single entry point.
6) SSH: If you are still using port 22 for ssh, change it. I would recommend to use client keys additional to password for ssh (and additional to knock port).
7) Passwords: Be sure you keep all your server passwords safe with a well-tested password manager application. It doesn't matter how much you add into this security formula, if your personal computer is hacked and those passwords are compromised. So protect your personal computer as well as the servers. (you are using strong passwords, right?)
8) Backdoor: It has happened to me several times that I'm locked out! So keep in mind that it can happen to you too. Be sure that if you open an additional way to access the servers, those are as strong as the main one. If you have physical access to the servers, you don't have to worry too much about it.
9) Antivirus: Don't trust too much
clamAV
. It's not a bad software, but you just won't have the same protection as with a commercial solution. I use it for my mail servers and in some File servers (Samba), to block well-known Windows viruses, but I don't count on it when it comes to new threats. Its better not to assume that it will protect you. As you know there is a very small list of known Linux malware, so if you are having performance issues due to clamAV, it probably won't change your security too much without it (if you are already protecting your server in many other ways). If you want a commercial solution, Sophos and ESET are good options. If you really want to be on top of all threats for your servers, you can try AlienVault (but you will need an extra server just for that).Key Questions: (What would happen if someone...)
I'm aware that many of the points covered here, you are already doing them, but I didn't want to assume anything. I hope you find my insight useful and if you have any other recommendations that I didn't cover here, I want to hear it.