codeigniter+mariadb([login to view URL]).+[login to view URL] x 2_

I want to test the speed of mariadb with 250 million records and 40 fields each record. Data can be randomly generated, but records needs to be structured as a company profile (name, address - street, city,county,country,zip, phone, email, website, setup date, domain, subdomain,financial data, field l, field m...field x). If it's possible, then i would like to make a test with imbricated searches, like to be possible to enter something in every search field to narrow the search as much as possible. One important thing is that i want this to happen on the lowest instance from amazon ([url removed, login to view] or [url removed, login to view]) or droplet from digital ocean. Now, the project sounds like this :

" 1. make website up and running on amazon instance (i need to know the modifications you make)

2. it has to work on [url removed, login to view] ubuntu + php codeigniter + mysql-mariadb (it is very important to work on the lowest technology possible)

3. There will be 2 databases - 1st contains 3 million records, 2nd database contain the rest of them up to 250 million records ( in the first phase there will be around 100 million records for the first 12 months, and after that, the 2nd database will grow so it will have to be scalable somehow)

- 2 calls on different databases will happen - 1st call on 1st mysql database with 3 million records (will fetch some data and will have a count of the records)

- 2nd call on 2nd database, will count the results from it and merge data only if from 1st call data is not enough for the client to see in one page.

So the results will be like this :

If the search results are more than 25 (75->millions)

- on the first page of data fetched will be 25 results (from the 1st call) and the rest will be loaded with LazyLoad;

- the number of the companies that appears on the same page where results are (where BUY button is) is composed from 2 results - counts from 1st call and 2nd call

If the results count is less than 25 (12 results for example):

- fetch results from 1st call on 1st mysql database, and in the same time, the second call counts the data from the second mysql database and merge the results from 2nd database till gets to the number of 25 so that the client to have a full page of results.(remember that the second database is on another virtual machine (instance, droplet)

- finish import module so i can import myself data (this module is already buildt - 90% - it just need the possibility to delete mass data as a whole country, or town, or street and the possibility to choose where to upload data, in which table from the database)

- upload and test one country with all fields

Note again! 1st database is on the main server. the second database is on the an amazon instance. Or you can test it using 2 amazon instances for the two databases."

The source code of the website will be given to you after i can test mariadb with the specification i wrote above.

Start the project with 8219 so i can figure out that you read it.

Amazon Web Services Codeigniter MariaDB Odd Jobs PHP

Project ID: #7542872

About the project