MySQL Multi-instance, on one server, the MySQL service opens several different ports, runs multiple service processes, these MySQL server processes through different sockets to listen to different data ports, complementary interference to provide their own services.
Advantages:
1 Efficient use of server resources
When a single server resource is too abundant, you can take advantage of the remaining resources to provide more services.
2 Conserve server resources
When the company funds tight, but the database needs to provide services between the database, and also want to use the master-slave replication, then the multi-instance is better.
3 Convenient post-architecture extension
When a project in a company starts, it does not necessarily have a large number of users during startup, so a set of physical database servers can be used. Deploy multiple instances above to facilitate subsequent extensions, migrations
Disadvantages:
Resource preemption Issues
When a server instance is high or slow, the entire instance consumes more memory CPU and IO resources, which results in a degraded quality of service on other instances on the server.
Internet companies mostly use the database is MySQL, want to stand out from the many IT workers, need to have advanced technology, learning to add value is essential. The way of learning is your insistence. Old boy Education MySQL DBA course, after several update courses, to eliminate the theory, the whole enterprise real case combined with theoretical teaching, want to deep learning MySQL DBA knowledge, can pay attention to the old boy education.
What is MySQL multi-instance? How to set?