One MySQL db - two CMS sites that must connect - on Google App Engine or Linode

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.

Skills: Big Data Sales, Cloud Computing, Drupal, MySQL, WordPress

See more: wordpress test for freelancer, wordpress site by freelancer price, wordpress project on freelancer, wordpress on google sites, wordpress installation price, wordpress app freelancer, what we can do on freelancer, what other freelancer sites, what crm freelancer use, well known freelancer, ui reporting, traffic volume freelancer, testing app freelancer, suite freelancer, steps on how to create a website, steps and what you need to create a website, step by step free wordpress website, sites built with drupal, site freelancer app, similar sites to freelancer

About the Employer:
( 3 reviews ) Welland, Canada

Project ID: #8739073

7 freelancers are bidding on average $700 for this job


Pls dont award bfor [login to view URL] want to use Drupal for CiviCRM. Drupal has the CiviCRM integration module, and you probably installed Drupal on the Google App Engine and installed CiviCRM module. The drupal, wordpress a More

$526 CAD in 10 days
(131 Reviews)

[login to view URL] ® - Portfolio HERE, most of this are wordpress themes that we've developed. I have reviewed your project description and I am confident I can complete your Wordpress website with all the require More

$934 CAD in 7 days
(21 Reviews)

I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably More

$773 CAD in 20 days
(21 Reviews)

Hello, To provide you with an outline of the requirements along with time & cost, I need more details about some of the points you have listed: 1) You mentioned that Drupal instance/site is already set up. Can you More

$789 CAD in 0 days
(93 Reviews)

¬Hello Sir, First of all, we would like to tell you how we will initialize the project with you. According to your project description, our team would like to discuss with you, to get more understanding of the proje More

$412 CAD in 7 days
(36 Reviews)

About Myself: I have a Bachelor of Technology and I have more than 7 years of experience, worked across all areas in development. I am an experienced Web Developer with skills of Magento, WordPress, WooCommerce, PHP, More

$842 CAD in 10 days
(39 Reviews)

++ 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!

$750 CAD in 0 days
(42 Reviews)

Hey, I have a couple of questions can we talk?

$666 CAD in 3 days
(2 Reviews)