Which is the best database for 5000 Daily Active Users

[Harman_Deep]

@Hadi_Editz Thanks for suggesting contabo, I am going for its 16 gb ram plan

[Hadi_Editz (Hadi Bangash)]

Good Currently I’m also using 30GB Ram but may b i downgrade it to 8gb because I think 8gb is enough for me now.

[Coder007 (S.H)]

Which is the best database for 5000 Daily Active Users

Firstly my app link - My app has 5k daily active users and currently I am using firebase database. The database costs were OK for a 1000 active users But now my database costs crossed 3000$ per month, I need help which database is best to use and which is cheap too. Total read Queries to database are around 400k/day Total write queries are too 400k/day I used airtable spreadsheet too but its too slow to get cell and set cell. Please suggest me cheapest and fastest database which can be…

Link isn’t working.

[Harman_Deep]

Just unpublished the app, I started working on mysql

[shafiqanjum056 (Perdesi)]

Your app link not opening please give one new

[Rogerio_Rios (Professional Support)]

Which Server should I Use?

Mysql. It is an established database. With lots of research material. It works with SQL language, which is a language with a lot of research material. So you have stability, robustness and research material. Free. Imagine who bought it? ORACLE. The giant ORACLE. Who use Mysql :

[Harman_Deep]

@Hadi_Editz I need help setting up mysql in contabo.

[ShaikhSajidAli (Muhammed Sajid Ali)]

You need to create custom api in nodejs or php.
And for fast data supply use Redis to cache common and most used data to serve this fast.

[Harman_Deep]

Hey @ShaikhSajidAli I am using deephost Mysql extension, A php file is provided by him so I just need help with contabo, Where can i upload that file on contabo

[Hadi_Editz (Hadi Bangash)]

Did you buy Cpanel/WHM with your VPS?

[Harman_Deep]

No, Can I buy it now?

[ShaikhSajidAli (Muhammed Sajid Ali)]

On publichtml folder on your web storage.
Don’t use deephost extension, he didn’t give any support and make a php file that run queries not from app side to prevent hacking

[ShaikhSajidAli (Muhammed Sajid Ali)]

Not needed we can access vps by putty software and as a root user

[Harman_Deep]

Can you please setup mysql for me, I am a noob at these things.

[ShaikhSajidAli (Muhammed Sajid Ali)]

Suggestion:- before doing anything know about that product

[Harman_Deep]

@Hadi_Editz Please help me with contabo , I will be very thankful

[Hadi_Editz (Hadi Bangash)]

@ShaikhSajidAli

Not needed we can access vps by putty software and as a root user

Ya i know but i didn’t understand the lengthy processes thats why i also purchased Cpanel with VPS.

[Hadi_Editz (Hadi Bangash)]

@Harman_Deep

Please help me with contabo

Sure DM me

[Meghraj_Singh (Meghraj Singh Beniwal)]

I will suggest, don’t just go ahead and buy everything. First understand what all pieces you will need to make it happen then evaluate the learning curve and then proceed as you are comfortable.

Here are the things you will need:

1. You will need a hosting provider where your database will be hosted
2. You will need to create a database, this can be a little tricky task as compared to Firebase because in firebase everything is key-value pair but in mysql we will be having tables and columns and rows. It’s not difficult but just different.
3. Also you will need the php code to interact between your app and the database hosted on server.
4. PHP code also need to be hosted on your hosting server.