I entered the tech industry through SQL. When I came to work as a business analyst, I was handed the credentials to an Oracle database, pointers to some tables, and let loose.

Because SQL is declarative, it’s probably the least intimidating programming language to start with, and it remains one of my favorite technologies because what you see is mostly what you get.

But coming from the world of consulting where all I knew were spreadsheets and manipulating tabs upon tabs of pivot tables, I had no clue what was going on. Indexes, b-trees, blobs, transactions and other terms flew buy my head.

“Think of a table as a file cabinet, and indexes as drawers labeled A-C, D-F, and so on,” my manager at the time said, and I was introduced to IT terminology by analogy.

I’m now at a point in my career where, at the same time as I’m learning, I’ve also begun to help more junior people. I’ve taught countless …

This blog post will discuss the issues and solutions for MySQL Data at Rest encryption.

Data at Rest Encryption is not only a good-to-have feature, but it is also a requirement for HIPAA, PCI and other regulations.

There are three major ways to solve data encryption at rest:

1. Full-disk encryption
2. Database-level (table) encryption
3. Application-level encryption, where data is encrypted before being inserted into the database

I consider full disk encryption to be the weakest method, as it only protects from someone physically removing the disks from the server. Application-level encryption, on the other hand, is the best: it is the most flexible method with almost no overhead, and it also solves data in-flight encryption. Unfortunately, it is not always possible …

And the first two Database Performance Team characters are . . .

The last blog introduced the Database Performance Team. The Database Performance Team is comprised of our services experts, who work tirelessly every day to guarantee the performance of your database. Percona’s services team is made up of superheroes that make sure your database is running at peak performance. Now we’re ready to reveal the identity of the first two team members.

The first is funny, friendly, quick-witted, supporting, fast and courteous – but still able to get the job done with amazing competence. Who is this champion?

…

When i was working on my PHP project since last 1 year on my current system and phpmyadmin was working very well but one day i was working on my prjects and electricity off suddenly and when electricity on i start my system again and open localhostphpmyadmin then i found following errorpreCo

The bug on mariadb.com has now been fixed.

An alternative location for the MariaDB Connector/J 1.3.7 jar file is: http://mvnrepository.com/artifact/org.mariadb.jdbc/mariadb-java-client/1.3.7 (click on the “Download (JAR)” button)

Most of time we work on backend and we require to redirect route or url from controller with pass query string parameter so laravel provide very simple way to pass query string parameter with redirect route In following example you can see how it is possibleIn Bellow example you can see i did

Sometimes we work on big php or other framework projects and we need to change array value as array key at that time you can learn from this post In this example you can do that without foreach loop For example if you have all country array but that array have key like 1234 etc and value is

A very interesting article on testing and coding illustrating many simple tips, important points:

- why one should test and code
- what one should test
- how and what kind of testing one can provide
- what one should not test
- how important testing is
- and others

If you are new to testing, it is a good place to start. Overall as the title of the article says "Why and how testing can make you happier", so it is time to be happy :D

Interesting read it makes. Hope you enjoy it too as I have :)

http://mikbe.com/code/testing/dx/2016/03/11/why-and-how-testing-can-make-you-happier.html

Thank you for your comments. Yes, you can add a new master to the same slave as needed via:
change master to master_host=”, master_user=’rpl’, master_port=, master_auto_position=1 for channel “”;
start slave for channel “”;
For the my.cnf on the other post on multi-source I did after this one, you can see an example of the mysqld_multi usage there, explaining what mysqld3001, mysqld3002 and so on are, and what changes between them all. Please remember that I used a single my.cnf with mysqld_multi as I was using a single server for all my masters (‘cos it was a test env of course). If you have masters spread about on different servers, there’s no need to use_mysqld_multi and an ordinary my.cnf can be fine. Or, if you have a small amount of mysql servers on the same box and you want them to be …

While being on the committee for the FOSDEM MySQL & friends devroom, I didn’t speak at that devroom (instead I spoke at the distributions devroom). But when I had time to pop in, I did take some notes on sessions that were interesting to me, so here are the notes. I really did enjoy Yoshinori Matsunobu’s session (out of the devroom) on RocksDB and MyRocks and I highly recommend you to watch the video as the notes can’t be very complete without the great explanation available in the slide deck. Anyway there are videos from the MySQL and friends devroom.

MySQL & Friends Devroom MySQL Group Replication or how good theory gets into better …