MySQL HA System Setup
Budget: $250 – $750 USD
I need a High Availability MySQL setup using two Linux servers for an existing MySQL 5.7.44 database.
So in any moment if any server is stopped, the database must be accessible.
The database cannot be modified in any way.
Key Requirements MANDATORY:
- Active/active mechanism with simultaneous processing on both servers (write/read at same time on both servers).
- Must work with MyISAM and InnoDB storage engines
- No primary key addition or schema changes allowed
- Servers are in the same physical location
- do not worry about load balancer, already implemented.
Ideal Skills and Experience:
- Deep understanding of MySQL 5.7.44 limitations
- Expertise in setting up MySQL HA with MyISAM and InnoDB
- Experience with Linux server administration
Please only respond if you fully comprehend the MySQL constraints. Thank you.
PS: The project will be awarded ONLY after a brief discussion before.
So in any moment if any server is stopped, the database must be accessible.
The database cannot be modified in any way.
Key Requirements MANDATORY:
- Active/active mechanism with simultaneous processing on both servers (write/read at same time on both servers).
- Must work with MyISAM and InnoDB storage engines
- No primary key addition or schema changes allowed
- Servers are in the same physical location
- do not worry about load balancer, already implemented.
Ideal Skills and Experience:
- Deep understanding of MySQL 5.7.44 limitations
- Expertise in setting up MySQL HA with MyISAM and InnoDB
- Experience with Linux server administration
Please only respond if you fully comprehend the MySQL constraints. Thank you.
PS: The project will be awarded ONLY after a brief discussion before.