My organization has recently created an app on a Digital Ocean reseller site that is not handling traffic and volume well. There are about 35 concurrent users for a CRM I'd like to base in Drupal, and a website application that I'd like to link to Wordpress.
**This is important - please do not advise that I should move forward with one solution or the other. I am well aware of both CMS types and I have a full and complete understanding of what I am asking. **
Here are the steps to this project:
I have already set up the Drupal instance on the Google App Engine with the CRM application I want to work with this, which is called CiviCRM. I have experience with this.
1. I need for someone to set up the links from Drupal and the CiviCRM extension to the appropriate MySQL db tables. These tables require a prefix for the Drupal installation so they are not confused in the WordPress tables.
2. I need either the SINGLE database to connect to both Drupal and WordPress through the use of the table prefix options - OR I need to create a full replica of the MySQL (DOUBLE)instance that will connect to the WordPress installation. I understand that this can also be accomplished through a Zapier Connection - but this is a last resort.
3. I need to replicate my existing data into either the SINGLE MySQL db or the DOUBLE MySQL db. The good news is that this is already built into this CRM and so adjustments for the migration are not required. The PREFERRED course of action here is a SINGLE MySQL db that will effectively link externally as needed.
Once this is complete, I'd like to do some rather extensive USE testing to ensure that the db and the application will perform better on Google Apps Engine. I have also set up another test back up on Linode as another alternative, or we can examine AWS. Ideally, I'd like this to be housed on Google App Engine. I am looking for both a robust hosting that is stable and secure at a decent price.
There may be some troubleshooting involved with SSH and MySQL data fixes and scripting for data imports may also be required. This is primarily a Business Intelligence/MySQL project. We will do the bulk of the set up for the Drupal and WordPress instances.
Each step will be co-facilitated by my associates and I and we will be very involved and provide feedback at each step.
The integration of an Open Source Business Intelligence Suite for nimble reporting from either db set up (whether we go with a SINGLE or DOUBLE db) will be required - This can be Jaspersoft, Pentaho or BIRT - I need a solution that has an intuitive front end UI for those who are NOT tech savvy. Your recommendations are appreciated.
Finally, if all of the above is successful, I need to install an Open Source suite called Mautic - which is a Marketing Automation Tool and this also will need to connect to the database.
Kindly include your full estimated TIME and COST - with an explanation to confirm your understanding of the project and recommendations per the above. THOSE WHO DO NOT OUTLINE THIS INFORMATION WILL BE IMMEDIATELY DISQUALIFIED.
Preference will be given to those who have worked on similar projects. Please feel free to describe any known challenges with this type of project based on your own experience, and how you were able to overcome those in the past.
The bulk of this project is setups and testing - we do MOST of the data and CMS setups - hence the budgetary allocation here. While I am a proponent to giving people the opportunity to build experience, please note that preference will be given to those with established ratings and positive experience on Freelancer.
I look forward to hearing from you.
7 freelancers are bidding on average $700 for this job
++ This is my job. I'm ready to begin now. Pm for me. Thanks Looking forward to hear from you, Feel free to talk about this interesting stuff, give us any questions you have to know more about us ;-) Thanks Oleg!