I recently managed to get my certification as MySQL 5.6 DBA, and was asked to write a blog about it, because I had trouble getting the informations I needed.

You may have figured out too, that Oracle does not really supply you with information about the certification. At least, there is the MySQL documentation. It contains all the information you need.

Further, I recommend to use a virtual linux machine in combination with our tool MyEnv. This way you can simulate multiple scenarios, including replication set-ups, and if one or two servers die during your exercises, nobody gets mad at you.

When learning, make sure to have a look at the following topics:

• Query tuning
• Parameters tuning
• MySQL client tools (mysqldump, mysqladmin, ...)
…

I’m pleased to announce that MySQL Connector/J 5.1.39 Maintenance Release is now generally available.

MySQL Connector/J can be downloaded from the official distribution channels MySQL Downloads and The Central Repository. The commercially licensed version is available for download at My Oracle Support.

As always, we recommend that you check the CHANGES file in the download archive and/or the release notes page to know what is new and if there are any changes that might affect your applications.

With MySQL Connector/J 5.1.39 you get the continuously …

Sometimes you may need to redirect on external URL from our laravel 5 application like if you use something like Amazon API Paypal API etc so Laravel 5 provide away for redirect other external link for return redirect like bellow examplestrongExamplestrongpre classprettyprint langp

In this blog post, we’ll discuss the ins and outs of Percona Server 5.7 parallel doublewrite.

After implementing parallel LRU flushing as described in the previous post, we went back to benchmarking. At first, we tested with the doublewrite buffer turned off. We wanted to isolate the effect of the parallel LRU flusher, and the results validated the design. Then we turned the doublewrite buffer back on and saw very little, if any, gain from the parallel LRU flusher. What happened? Let’s take a look at the data:

We see that the doublewrite buffer mutex is gone as expected and that the top waiters are the rseg mutexes and the index lock (shouldn’t this be fixed in 5.7?). Then we checked PMP:

2678 nanosleep(libpthread.so.0),...,buf_LRU_get_free_block(buf0lru.cc:1435),...
867 pthread_cond_wait,...,log_write_up_to(log0log.cc:1293),...
396 …

We recently introduced the Severalnines Blueprint for MySQL Replication, a new whitepaper which discusses all aspects of a MySQL Replication topology with the ins and outs of deployment, setting up replication, monitoring, upgrades, performing backups and managing high availability using proxies as ProxySQL, MaxScale and HAProxy.

If you haven’t got your copy yet, do sign up for it here:
Get your free copy of our new whitepaper

The MySQL Replication Blueprint is about having a complete ops-ready solution from end to end including:

• Installation and configuration of master/slave MySQL servers, load balancers, Virtual IP and failover rules
• Management of the topology, including failure detection, failover, repair and subsequent reconfiguration of components
• Managing topology changes when adding, …

Mon, 2016-05-09 08:26Guillaume Lefranc

Some of the most common questions asked by our users are regarding MariaDB support in Docker, and in particular how it can be used in specific development or production deployments. This series of articles will try to cover a few Docker and MariaDB use cases.

Why choose Docker for MariaDB?

• Docker containers can be used to test, deploy and release applications within any environment.
• Docker deployments can be automated easily, creating deployment environments and reproducing them easily in staging and production.
• Docker is lightweight virtualization. Hypervisors are not needed, and a MariaDB Docker container should perform just as well as a normal MariaDB installation without any noticeable overhead.
• Docker is agnostic - once you’ve installed Docker on your OS, the instructions for running containers are …

Before data insertion, updates, deletes etc, database management systems that support foreign keys (like MySQL) make sure you do not introduce any inconsistencies. So, you need to make sure you're not leaving orphan records behind in child tables.

you can set multiple database connections in same laravel application Laravel provide configration file for setup multiple database connections you can see configdatabasephp file and see mysql multiple database connections you can add setting another mysql database detail like this waystrong

In this post i want to share you how to solve tokenmismatchexception error on ajax request time in laravel application When i was working on my ecommerce website in laravel 5 I was found like bellow errorpreNetworkError 500 Internal Server Error httplearnl52hdgetProductTokenMismatc

Sometimes you may need to remove packages from your laravel application I mean if you installed package but you dont need now and that useless in your project you want to remove that useless package from your project that you remove using laravel composer command In this posts i am going to g