System News
 1 2 3 4 5 6 7 8 9 10 11 next
Articles for the keywords: MySQL
18 Jun 2017 SoFloPHP Miami (MySQL: Analysis, Understanding, and Optimization of Queries) [64217]
Wednesday, June 21st, 2017: 6:30 PM to ...

FIU TechStation (PG6) - Miami

This month we have a great database focused talk from an accomplished,experienced developer.

Your new database query ran quickly when you tested it, but seconds after deploying it, alarms are blaring and you're scrambling to rollback before the site goes down. What happened?!?

I can 'EXPLAIN'.

Queries that perform well under development load with limited datasets can easily bring a database to its knees under production load. In this talk, you will learn to decipher MySQL query execution plans, recognize portions that can be improved, and take the necessary steps to optimize your queries - all without starting any fires!

Adam Culp, Cal Evans
(Get More Information . .) open to premium members only

18 Jun 2017 Summary of Upcoming South Florida IT Events [64188]
See articles for details

Please encourage your IT colleagues to register to receive their own, customized version of this newsletter. There are 70 event sections to choose from!

This Week

Monday, June 19th, 2017

Tuesday, June 20th, 2017

Wednesday, June 21st, 2017

Thursday, June 22nd, 2017

Saturday, June 24th, 2017

Later This Week

Wednesday, June 28th, 2017

Saturday, August 19th, 2017

Wednesday, September 13th, 2017

Thursday, September 14th, 2017

Thursday, December 7th, 2017

Details at SF IT Events Website.

Signup for you own subscription.
(Get More Information . .) open to premium members only

15 Jun 2017 Watch the tutorial: backup best practices for MySQL, MariaDB and Galera Cluster [64349]
By Severalnines

Jean-Jerome Schmidt blogs, "Many thanks to everyone who registered and/or participated in Tuesday's webinar on backup strategies and best practices for MySQL, MariaDB and Galera clusters led by Krzysztof Książek, Senior Support Engineer at Severalnines. If you missed the session, would like to watch it again or browse through the slides, they're now online for viewing. Also check out the transcript of the Q&A session below..."
(Get More Information . .) open to premium members only

14 Jun 2017 MySQL Triggers and Updatable Views [64350]
By Percona

Agustin Gallego writes in Percona, "In this post we'll review how MySQL triggers can affect queries.

Contrary to what the documentation states, we can activate triggers even while operating on views:...

'Important: MySQL triggers activate only for changes made to tables by SQL statements. They do not activate for changes in views, nor by changes to tables made by APIs that do not transmit SQL statements to the MySQL server...'"
(Get More Information . .) open to premium members only

12 Jun 2017 How to configure MySQL Multi-Master Replication on Oracle Linux [64347]
HowtoForge, June 12th 2017

"This tutorial explains how to setup and configure MySQL multi-master replication on Oracle Linux. As you all may already know, MySQL is a well known top notch database product that has proven to be enterprise ready.

As data is crucial for every organization, most database administrators are looking for a suitable solution to setup high availability to ensure user are able to access their data 24/7. MySQL replication is a solution that can ensure a high availability policy.

On top of that, MySQL replication is also able to help database administrators to distribute the load on multiple database servers by load balancing the READ and WRITE requests. Unfortunately, basic replication can only offer benefits on READ requests. Due to that, MySQL multi-master replication was introduced to offer replication for WRITE request as well..."
(Get More Information . .) open to premium members only

 
 1 2 3 4 5 6 7 8 9 10 11 next






!-- end archive_section.tpl -->