php - What is the best way of using database host?


How to choose a web server?

I have a website and it has good traffic. But the problem is that the database gets over thousands hit per seconds so I would like to get suggestions from you guys.

The server is capable of handling much traffic but MariaDB service gets off so What should I do?

I was thinking to use remote databases and a CDN server for contents. Current server + Database server + CDN Server.

Does anyone have a better suggestion that will help me to get rid of the problem and also reduce the cost of CDN/database servers??

[Sorry for my grammatical mistakes]




but MariaDB service gets off so

I have no idea what this means.

I was thinking to use remote databases and a CDN server for contents

If you are serving content directly from your database then you will have performance problems. However using a CDN is only going to help if:

  1. A large part of your customer base has a long RTT to your server
  2. You have already optimized the caching of your content

If 1 is not the case, then you'll get as much benefit running your own cache. If 2 is the case then you're either going to have to fix your caching or enhance your database capacity.

gets over thousands hit per seconds

So what? Depending on the queries and the hardware, that might be a a constraint on your service performance. It might not. Tuning your DBMS and queries might help.




People are also looking for solutions to the problem: php - Assigning names to fields SQL


Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

Similar questions

Find the answer in similar questions on our website.