- On July 13, 2016
- 0 Comments
Out of all large-scale database servers MySQL is the most popular. It is a feature rich, open-source product that powers a very large numbers web-sites and online applications. MySQL is an open source relation database management system (RDBMS), to store and manage huge volumes of data.
MySQL released under an open-source license and is a very powerful program in its own right. Being able to handle a large subset of functionality that is offers by the most expensive and powerful database packages, by remaining open source is unique. MySQL works on many operating systems and with many languages, uses a standard form of the well-known SQL data language. It is very friendly to PHP, the most appreciated language for web development and also other languages are included such as PERL, C, C++, JAVA, etc. MySQL works very quickly, even with the large data sets, supports large database, up to 50 million rows or more in a table. The default file size limit for a table is 4GB, but you can increase this (if your operating system can handle it) to a theoretical limit of 8 million terabytes (TB). MySQL is customizable.
The new multi-source feature allow us to create new replication environments that were impossible in the past without some complex “hacks”. Of course, your application should be designed and developed with this new architecture in mind. Like with multi-master, multi-source needs special care to not end up with your data messed up.
Replication enables data from one MySQL database server (the master) to be copied to one or more MySQL database servers (the slaves). Replication is asynchronous by default; slaves do not need to be connected permanently to receive updates from the master. Depending on the configuration, you can replicate all databases, selected databases, or even selected tables within a database.
MySQL replication is getting better on every release giving us more configuration, performance and design possibilities. And all those new features can be combined. Your replication environment can be even better if you mix some of the new (and old) features added recently to the replication. For example, you can configure GTID or enable multi-threaded slave per schema or infra-database.
Some of the advantages include:
- Scale-out solutions – spreading the load among multiple slaves to improve performance. In this environment, all writes and updates must take place on the master server. Reads, however, may take place on one or more slaves. This model can improve the performance of writes (since the master is dedicated to updates), while dramatically increasing read speed across an increasing number of slaves.
- Data security – because data is replicated to the slave, and the slave can pause the replication process, it is possible to run backup services on the slave without corrupting the corresponding master data.
- Analytics – live data can be created on the master, while the analysis of the information can take place on the slave without affecting the performance of the master.
- Long-distance data distribution – you can use replication to create a local copy of data for a remote site to use, without permanent access to the master.
MySQL 5.7 supports different methods of replication. The traditional method is based on replicating events from the master’s binary log, and requires the log files and positions in them to be synchronised between master and slave. The newer method based on global transaction identifiers (GTIDs) is transactional and therefore does not require working with log files or positions within these files, which greatly simplifies many common replication tasks. Replication using GTIDs guarantees consistency between master and slave as long as all transactions committed on the master have also been applied on the slave.
Replication in MySQL supports different types of synchronisation.
SuperAdmins provides you with real-time electronic and phone based support. Our 24×7 availability policy ensures that you can always reach one of our technical experts to solve issues very fast. We care about support and we striving to ensure our support customers get great value.