Sendgrid is very popular API to send email from our laravel application It is very fast to send mail and also you can track sended mail Tracking email is very important feature of Sendgrid api and you can also see how much user open your mail click on your mail too In this post i would like to s

Bad query performance is the most common problem DBA’s have to deal with. There are numerous ways to collect, process and analyze the data related to query performance - we’ve covered one of the most popular tools, pt-query-digest, in some of our previous blog posts:

Become a MySQL DBA blog series

• Analyzing your SQL Workload using pt-query-digest
• Deep Dive SQL Workload Analysis using pt-query-digest

When you use ClusterControl though, this is not always needed. You can use the data available in ClusterControl to solve your problem. In this blog post, we’ll look into how ClusterControl can …

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