The latest from the MySQL community

Sometimes we require to get filenames from path of table column in MySQL If you are working on PHP then you can simply use basename predefine function of code PHP But in MySQL you cant use basename in select query This mysql function you can use in code PHP PHP framework like laravel code

While straight-forward to deploy, a production-ready and hence stable MySQL Replication setup requires a bit of planning and preparation. What does a solid replication configuration look like? What do you do when a topology is broken, and replication will not restart? How do you ensure performance? Or perform schema changes?

If you'd like to learn how to build a stable environment with MySQL replication, this webinar is for you. From OS and DB configuration checklists to schema changes and disaster recovery, you’ll have the information needed.

Join us next Tuesday as Krzysztof Książek, Senior Support Engineer at Severalnines, shares his top 9 tips on how to best build a production-ready MySQL Replication environment.

Top 9 Tips for building a stable MySQL Replication environment

…

In the MySQL team, one of our focuses over the last few releases has been improving the usability of the MySQL Server for operations teams.  The results can be seen in a number of areas:

• Our continued investment in Performance Schema.  

…

Over the recent years, there has been a large number of individuals as well as organizations who are ditching the Windows platform for Linux platform, and this number will continue to grow as more developments in Linux are experienced. Linux has for long been the leader in Web servers as most of the web servers run on Linux, and this could be one of the reasons why the high migration is being experienced.

In this post i going to explain how to import excel file into mysql database using PHP In this post i will give you full example of csv file ods file xls file xlsx file import into database using phpexcel packageWe always require to add data from admin panel like products items users emai

In this post i going to explain how to import excel file into mysql database using PHP In this post i will give you full example of csv file ods file xls file xlsx file import into database using phpexcel packageWe always require to add data from admin panel like products items users emai

Hacked By Not Matter who am i ~ i am white Hat Hacker please update your wordpress

In this blog post, I’d like to take a look at a few different things such as MySQL Group Replication, multi-instance MySQL setups on systemd and shell scripting the whole mess to make it easy to build, and easy to rebuild.  To be honest, it took a little help from Shinguz’s blog to get the… Read More »

Percona announces the release of Percona Server for MySQL 5.5.53-38.4 on November 23, 2016. Based on MySQL 5.5.53, including all the bug fixes in it, Percona Server for MySQL 5.5.53-38.5 is now the current stable release in the 5.5 series.

Percona Server for MySQL is open-source and free. You can find release details in the 5.5.53-38.5 milestone on Launchpad. Downloads are available here and from the Percona Software Repositories.

…

Introduction I read a very interesting article by Krešimir Nesek regarding MySQL result set streaming when it comes to reducing memory usage. Mark Paluch, from Spring Data, asked if we could turn the MySQL result set streaming by default whenever we are using Query#stream or Query#scroll. That being said, the HHH-11260 issue was created, and … Continue reading How does MySQL result set streaming perform vs fetching the whole JDBC ResultSet at once →