Businesses will continue to demand MySQL skills despite growing interest in alternative database platforms more suited to big data analytics and internet of things workloads, according to Percona CEO Peter Zaitsev.
Percona has been providing support for MySQL since launching in 2006, and has seen a range of competing technologies emerge to rival the open source relational database that are able to provide more scalability.
However, the demands of new applications will see a range of techniques employed, complimenting MySQL skills with others such as Hadoop and NoSQL rather than being replacing them, according to Zaitsev.
“Many are thinking about using multiple technologies together and supplementing the MySQL database with something else, not switching it out,” he said.
“Businesses undergoing smaller analytics projects are moving to Hadoop, but for their wider business applications they are supplementing MySQL with Hadoop and others.”
“It is very common for people to run both their online database and analytics on MySQL and then as you grow to switch the analytics from MySQL to Hadoop, because MySQL is not very good at large scale analytics.”
The need for this more complex environment is being driven by the demands of applications to cater for new workloads such as the internet of things, he said.
“The next revolution that is coming with the internet of things, and that is all creating a tremendous amount of data which has a lot of different needs. Some of that has to be processed in real-time, and some of it has to be stored and analysed on very large scale, and so on,” he said.
“If you look at the technology in the data store as a whole, it is growing so much faster. So even if you have an MySQL pie which is shrinking - and I expect it to shrink as you have a wider variety of data that is tailored for different applications - the amount of those applications is growing sorapidly and the amount of data is growing.”
According to Zaitsev, the combined approach has been pioneered by web-scale applications run by large tech firms such as Facebook and LinkedIn, and is creating demand for new expertise in tying the underlying technologies together.
“All of those guys, they will typically use multiple technologies – they will use MySQL, and then MongoDB for some things, as well as Cassandra and Hadoop. They need to integrate those things together, and that is a very interesting skill for people who are specialised and understand howthose technologies can be used together,” he said.