mariadb-server

How to set the password

mysql -u root -p 
UPDATE mysql.user SET authentication_string = PASSWORD('s0mePassword'), plugin = 'mysql_native_password' WHERE User = 'root' AND Host = 'localhost';
FLUSH PRIVILEGES;

12 total views, 2 views today

How to run multiple networks from a Mikrotik

5 Port Router?

Since a Mikrotik (example being a 750GL) is a true 5 port router and not just a consumer-grade router (which is actually a router with 4 port switch), you can set them up to run multiple networks, use multiple ISPs for WAN failover, and more.  Why you would want to do any of these things is beyond the scope of this post, but this will show you how to do it.

Let’s take an RB750GL and have it run 4 internal networks instead of one.  Like this:

Continue reading How to run multiple networks from a Mikrotik

338 total views, 1 views today

Mikrotik port mapping/forwarding

If you would like to direct requests for a certain port to an internal machine (sometimes called opening a port, port mapping), you can do it like this:

/ip firewall nat add chain=dstnat dst-port=1234 action=dst-nat protocol=tcp to-address=192.168.1.1 to-port=1234

This rule translates to: when an incoming connection requests TCP port 1234, use the DST-NAT action and redirect it to local address 192.168.1.1 and the port 1234 Continue reading Mikrotik port mapping/forwarding

189 total views, 1 views today

Benchmarking InnoDB page compression performance

InnoDB page compression is a feature that really interests me. I wrote this about it recently when describing how to improve the performance of large tables in MySQL:

“Use innodb page compression. For some workloads (particularly those with lots of char/varchar/text data types) compression will allow the data to be more compact, stretching out that performance curve for longer. It may also allow you to more easily justify SSDs which are typically smaller in capacity. InnoDB page compression was improved a lot in MySQL 5.6, courtesy of Facebook providing a series of patches.”

Continue reading Benchmarking InnoDB page compression performance

115 total views, no views today

Bad news: 10% worse battery life on Samsung Galaxy S7 and S7 Edge after Android 7.0 Nougat update

The Samsung Galaxy S7 and S7 Edge are two of the most popular Android phones out there, and now, they are getting updated to the latest version of the Android operating system: Android 7.0 Nougat.

Along with all the great new features and improvements, there was one key aspect of the experience that we wanted to test: battery life.
The Galaxy S7 and S7 Edge have traditionally delivered a very good battery life, easily lasting through a full day even when you use your phone a lot. The S7 Edge with its massive 3,600 mAh battery in particular delivered excellent battery life.
So has battery life changed with Android 7.0 Nougat?

Continue reading Bad news: 10% worse battery life on Samsung Galaxy S7 and S7 Edge after Android 7.0 Nougat update

241 total views, 2 views today