Laravel 6 is the latest version of the most popular PHP framework for web development. It comes with a bunch of a new features and enhancements and will be the next LTS (Long Time Support) version instead of Laravel 5.5.

Laravel 6 is released on the date of September 3rd, 2019.

For v5.5, bug fixes will end on August 30th, 2019 but security updates will be made until August 30th, 2020.

This is a table from the official docs that displays the release dates and other important dates for the various versions of Laravel:

In this tutorial, we'll see the new features of Laravel 6, we'll learn how to generate a Laravel 6 project using Composer and how to build a CRM web application from scratch. We'll see how to configure a MySQL database for our app, create models, migrate our database and create controllers for exposing a REST API that will then be consumed from a Vue.js interface.

You'll also learn about the …

In this short blog post, we will check how to use linux-fincore to check which files are in the in-memory Linux page cache. To have an introductory read about the Linux page cache check here and here.

In summary, whenever you read from or write to a file (unless you are using Direct_IO to bypass the functionality), the result is cached in memory, so that subsequent requests can be served from it, instead of the orders of magnitude-slower disk subsystem (it can also be used to cache writes, before flushing them to disk). This is done as far as there is memory that is not being used by any process; whenever there is a shortage of otherwise free memory, the kernel will choose to first evict the page cache …

Why does the DIY approach fail to deliver vs. the Tungsten Clustering solution for geo-distributed MySQL multimaster deployments?

Before we dive into the 10 reasons, note why commercially-supported enterprise software is less risky and in fact less costly:

• The labor time spent building and maintaining a DIY solution costs more than a supported solution that just works.
• There is documentation, training, support, so your mission-critical process is never dependent upon an irreplaceable individual.

1. Tungsten Clustering is a complete solution, comprised of the Replicator, Manager and Connector components
   • With DIY, you must first decide the architecture, then select the individual tools to handle each layer of the topology. …

Mid September, MySQL Community, MySQL Customers and MySQL Engineers will be in San Francisco to share their experience and present the new features of your favorite database !

The event will be held in Moscone South (just Mirko Ortensi‘s Hands-on Lab will be delivered in Moscone West).

During the week, the MySQL Community Team will host the traditional MySQL Reception. We got so great feedback from last year that we decided to renew the experience in the same awesome location, the Samovar Tea Lounge at Yerba Buena Gardens. Don’t forget that you need to register for this reception but no OOW pass is required. Please register here !

Back to the conference, you can find the full schedule for the session in the …

ProxySQL Technology Day in Ghent, Belgium

As a part of the ProxySQL team I am happy to announce my trip to Ghent to ProxySQL Technology Day. With great pleasure, I will join the experts from Oracle, Percona, and Pythian to talk about various things that ProxySQL can do for a user. We are going to meet at 5PM at Ghent’s Co.Station co-working on Thursday, October 3rd to walk through key features that ProxySQL is adding to MySQL ecosystem. Join me and others for five talks and a round table about building MySQL infrastructure to serve hundreds of thousands of queries per second.

What am I going to talk about?

In my 30 minutes “Introduction to High …

Do you think Quality Assurance (QA) is more than the simplistic view of bug hunting? Do you believe that QA is important to the entire software development lifecycle and want to focus on failure testing, process and performance control, as well as best practice adoption? Do you enjoy doing performance benchmarks and noticing regressions? Do you like to write about it, from internal reports to external blog posts?

Then why not take up a challenge at Codership, the makers of Galera Cluster, as we are looking for a Galera Cluster QA Engineer (job description at link).

We’re looking for someone who is able to work remotely, join a company meeting at least once per year, be comfortable with the use of Slack and email (asynchronous communication, for developing our virtually synchronous replication solution!), but most importantly enjoy testing the …

Author: Robert Agar

The role of a corporate database administrator has evolved tremendously since the introduction of relational databases in the late 1970s. A DBA from the early 1980s would be totally unprepared for the complexities that face database professionals in 2019. It’s a completely different world and the skillset required has radically changed.

The heightened focus on the value of a company’s accumulated data has made DBAs more important to the business goals of an organization than ever before. Keeping this valuable resource safe and accessible is one of the modern DBA’s primary responsibilities. Many diverse methods are required to fulfill these duties, and a DBA must be comfortable using them all to address problems encountered in day-to-day activities.

Common Issues Faced by DBAs

The laundry list of issues that DBAs must deal with regularly is a long one. …

Overview The Skinny

Part of the power of Tungsten Clustering for MySQL / MariaDB is the ability to perform true zero-downtime maintenance, allowing client applications full access to the database layer, while taking out individual nodes for maintenance and upgrades. In this blog post we cover various types of maintenance scenarios, the best practices associated with each type of action, and the key steps to ensure the highest availability.

Important Questions Understand the Environment as a Whole First

There are a number of questions to ask when planning cluster maintenance that are critical to understand before starting.

For example:

1. What is the cluster topology?
   • Standalone (connectors write to single cluster master)
     Single cluster: …

Up to now, the way of updating dbdeployer was the same as installing it for the first time, i.e. looking at the releases page, downloading the binaries for your operating system, unpacking it and finally replacing the existing binaries.

This is not the procedure I follow, however, as for me updating means just compile the latest version I have just finished coding. For this reason, when Simon Mudd mentioned to me that dbdeployer should update itself over the Internet, I didn’t immediately grasp the concept. But then …

This title may be suitable for the new age MySQL Users. Because in 5.7 onwards its already supported to enable GTID online. But still few of my mission critical databases are in 5.6 and handling 70k QPS. So I know enabling GTID needs downtime for this. But in my case, the GTID has been already implemented. But still the replication is using Binlog file name and position for replicating the data.

This is my slave status. You can see the GTID has been enabled but the Auto_Position is still 0 which means still my replication is binlog filename and position. No issues with the replication. But the MySQL world already moved to GTID for better control on replication and Failover.

             Master_Server_Id: 10010
                  Master_UUID: c924545b-a3e3-11e8-8a39-42010a280410
             Master_Info_File: mysql.slave_master_info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL …