You will get a fully configured Mysql HA cluster of 3 or more instances

4.9

Let a pro handle the details

Buy Database Optimization & Design services from Shubhra Prakash, priced and ready to go.
4.9

Let a pro handle the details

Buy Database Optimization & Design services from Shubhra Prakash, priced and ready to go.

Project details

This will be a fully configured Mysql HA cluster with minimum of 3 instances in multi-primary configuration as default (since this require least changes to your application). Single-primary cluster configuration will be done on demand. The cluster provides automatic failover and instance recovery after a cluster instance failure or network failure.

IMPORTANT
Installation will be performed only on GNU/Linux servers.
Each cluster instance requires a dedicated server to run.

Application connection router configuration support will be provided only with post installation support addon. Application connection router configuration support if provided is done as per connection routing requirements of the application(s) accessing the database cluster.

Documentation include maintenance of cluster like adding/removing instances, recovering from loss of quorum and complete cluster outage, networking requirements and monitoring the cluster.

Post installation support is provided only from Monday to Friday between 11:00 am to 7:00 pm in IST timezone and exclude any production or emergency or on-call support. All support requests will be responded within 24 hours.
Database Type
MySQL
What's included
Service Tiers Starter
$900
Standard
$1,200
Advanced
$1,800
Delivery Time 3 days 4 days 5 days
Number of Revisions
025
Schema Diagram
-
-
-
Permissions Setup
Import/Export Data
-
-
Admin Panel Setup
Optional add-ons You can add these on the next page.
Import/Export Data (+ 1 Day)
+$240
Disaster recovery (DR) setup (+ 4 Days)
+$1,200
Post installation support (+ 10 Days)
+$600
4.9
18 reviews
89% Complete
11% Complete
1% Complete
(0)
1% Complete
(0)
1% Complete
(0)

MP

Mattias P.
4.60
Apr 25, 2025
Immediate Assistance Needed: MySQL DBA for Database Troubleshooting

CM

Chinmay M.
4.80
Jun 15, 2024
Senior IT expert needed to build a comprehensive skill ontology for IT services companies

IS

Isha S.
5.00
Jun 10, 2023
Database expert for consultation for DB design

sa

sam a.
5.00
Jun 7, 2023
Linux/Unix System Administration Shubhra quickly rectified our core issues and provided excellent documentation for handoff to a new staff member to handle the issues going forwards. He is extremely knowledgeable about Linux/Unix administration and found good solutions quickly with minimal disturbance.

JK

John K.
5.00
Jun 30, 2021
Consultation from Previous Project
Shubhra Prakash N.Status: Offline

About Shubhra Prakash

Shubhra Prakash N.Status: Offline
Expert Database Specialist, Systems Integrator and Solution Architect
100% Job Success
4.9  (18 reviews)
Kolkata, India - 5:25 pm local time
I have 17+ years of IT experience in the area Application Development, Systems Integration, Production Support, Application Maintenance and QA projects. I have played the role of Project Manager, Project Lead, Business Analyst, Developer and QA. I have managed complete SDLC for medium sized development projects. I have business domain knowledge in the area of Automotive on-board telematics and IT systems, Pharma Relationship Marketing, Manufacturing Execution Systems and Work and Asset Management. I have actively implemented LEAN practices in Production support projects.

My technical skills in Database consultancy/administration/development are as follows

1. Design and development of relational and NoSQL databases (Mysql, Oracle, MongoDB). Production support of Mysql and MongoDB databases.
2. Migrating existing databases to Mysql, Oracle and MongoDB.
3. Configuring monitoring and alerts for database servers.
4. Develop business layer applications in PL/SQL / Mysql procedures and UNIX.
5. Setup and support Mysql HA database cluster in single primary or multi primary mode without changes to your data or tables.
6. Setup and support Mysql master-slave replication for backups and failover.
7. Automated Point-in-time recovery of Mysql databases.
8. Performance tune databases like Mysql and Oracle.


My programming language skills include

1. PHP
2. C
3. PL/SQL
4. Mysql stored procedures
5. UNIX Shell scripting


My technical skills in REST API/Web Services consultancy/development are as follows

1. Creating high performance, scabale, standards compliant and secure RESTful API for backend and business logic processing as microservices or in monolithic service architecture.


My technical skills in System/Devops consultancy/administration are as follows

1. Create solution architecture for Cloud and On-Premise infrastructure based on free and open source software stack.
2. Containerize Mysql and other servers using Docker and/or LXC.
3. Deploying LXC containers to create extremely lightweight and tightly packed virtualized environments to isolate, secure and streamline your IT operations. Running LXC containers have near zero performance penalty.
4. Install and configure QEMU-KVM virtual machines with full inter VM and external networking support, 3D graphics acceleration for GUI based administration.
5. Performance tune and secure your LAMP/LEMP and other application stack.
6. Deploying directory servers like OpenLDAP, designing DIT, configuring LDAP access control, indexing, replication and single sign-on.
7. Setup in-memory databases like Memcached or a persistent in-memory database Mysql Memcached plugin for caching or sessions.
8. Setup and maintain secure Email servers using Postfix, Dovecot, Courier IMAP, maildrop, Spamassasin, ClamAV, milters, DKIM, SPF, DMARC and Roundcube webmail.
9. Maintenance and administration of Linux servers like setting up firewall, webservers, mail servers, ldap servers, imap servers, automating system admin tasks using shell scripts, applying security updates, install and uninstall of software packages.
10. Setup of Jenkins for CI/CD of complex project workflows.
11. VPN setup ( IKE/IPSec and OpenVPN )

Steps for completing your project

After purchasing the project, send requirements so Shubhra Prakash can start the project.

Delivery time starts when Shubhra Prakash receives requirements from you.

Shubhra Prakash works on your project following the steps below.

Revisions may occur after the delivery date.

Install cluster and provide documentation

Installation files / archvies which need to installed will be uploaded to servers. Documentation and networking changes which will be required to be made on the servers will also be provided. Installation will then be performed.

Review the work, release payment, and leave feedback to Shubhra Prakash.