https://laravelarticle.com/laravel-migration-generator-online
Laravel migration generator for those of us who are fluent in SQL
Showing posts with label mysql. Show all posts
Showing posts with label mysql. Show all posts
Saturday, March 14, 2020
Tuesday, August 21, 2018
Using AWS EC2 instance store vs EBS for MySQL: how to increase performance and decrease cost
https://www.percona.com/blog/2018/08/20/using-aws-ec2-instance-store-vs-ebs-for-mysql-how-to-increase-performance-and-decrease-cost/
How to speed up MySQL on AWS, but there's some downsides.
How to speed up MySQL on AWS, but there's some downsides.
Saturday, July 7, 2018
Linux OS Tuning for MySQL Database Performance
https://www.percona.com/blog/2018/07/03/linux-os-tuning-for-mysql-database-performance/
I've done some of these before. Nice to see them all in one place.
I've done some of these before. Nice to see them all in one place.
Wednesday, July 4, 2018
Top 10 reasons for NoSQL with MySQL
https://lefred.be/content/top-10-reasons-for-nosql-with-mysql/
MySQL is making a big deal of its document store: a NoSQL layer.
MySQL is making a big deal of its document store: a NoSQL layer.
Saturday, June 16, 2018
PDO vs. MySQLi: The Battle of PHP Database APIs
https://websitebeaver.com/php-pdo-vs-mysqli
PDO and MySQLi in PHP. This author says go with PDO.
PDO and MySQLi in PHP. This author says go with PDO.
Tuesday, April 17, 2018
Migrate to Amazon RDS Using Percona Xtrabackup
https://www.percona.com/blog/2018/04/02/migrate-to-amazon-rds-with-percona-xtrabackup/
I've always thought the "mysqldump" method of migration was a bit lame.
I've always thought the "mysqldump" method of migration was a bit lame.
Friday, March 2, 2018
adminer database management in a single file
https://www.adminer.org/
I've thought for a long time that PhpMyAdmin was getting old. Here's an alternative.
I've thought for a long time that PhpMyAdmin was getting old. Here's an alternative.
Sunday, January 14, 2018
Write Set in MySQL 5.7: Group Replication
http://jfg-mysql.blogspot.sg/2018/01/write-set-in-mysql-5-7-group-replication.html
About as technical a MySQL article as I've seen in a while. New ways to replicate.
About as technical a MySQL article as I've seen in a while. New ways to replicate.
Monday, December 18, 2017
Top 5 open source tools for MySQL administrators
https://www.infoworld.com/article/3241730/database/top-5-open-source-tools-for-mysql-administrators.html
The standard phpmyadmin and 4 others.
The standard phpmyadmin and 4 others.
Friday, November 3, 2017
How to Optimize MySQL: Indexes, Slow Queries, Configuration
https://www.sitepoint.com/optimize-mysql-indexes-slow-queries-configuration/
Another article on MySQL optimization from the percona folks.
Another article on MySQL optimization from the percona folks.
Sunday, May 29, 2016
Review: DeepSQL outruns Amazon Aurora
http://infoworld.com/article/3068597/data-center/review-deepsql-outruns-amazon-aurora.html
The race for high-performance #MySQL clones heats up with DeepSQL.Monday, April 25, 2016
Logging apache access to MySQL
http://dasunhegoda.com/apache-access-logs-to-mysql-database/953/
the tough part is getting mod_log_sql_mysqlhttp://www.outoforder.cc/projects/httpd/mod_log_sql/
http://git.outoforder.cc/httpd/mod_log_sql/
https://colekcolek.com/2012/03/12/save-apache-access-log-mysql-database-libaapche2-mod-log-sql-debian-squeeze/
Subscribe to:
Posts (Atom)