How Symfony create entity class from mysql database

My computer develop environment

1
2
3
4
5
6
7
8
9
10
$ cat composer.json
...
"require": {
"php": ">=5.5.9",
"symfony/symfony": "2.8.*",
...
},

$ mysqld -V
mysqld Ver 5.7.18 for Linux on x86_64 (MySQL Community Server (GPL))

Mysql5.7 MTS(multi-threaded slave)

Server environment

1
2
3
4
5
$ cat /etc/issue
Ubuntu 14.04.5 LTS

$ mysqld -V
mysqld Ver 5.7.20 for Linux on x86_64 (MySQL Community Server (GPL))

Build new mysql slave without stop service or locked table by Xtrabackup

Server environment

1
2
3
4
5
$ cat /etc/issue
Ubuntu 14.04.5 LTS

$ php -v
PHP 5.6.32-1+ubuntu14.04.1+deb.sury.org+2 (cli)

Mysql data optimization

Server environment

1
2
3
4
5
6
7
8
9
10
11
12
13
14
$ cat /etc/issue
Ubuntu 14.04.5 LTS

$ free -h
total used free shared buffers cached
Mem: 7.8G 7.7G 132M 260K 276K 6.8M
-/+ buffers/cache: 7.7G 139M
Swap: 8.0G 2.3G 5.7G

$ mysqld -V
mysqld Ver 5.5.58-0ubuntu0.14.04.1 for debian-linux-gnu on x86_64 ((Ubuntu))

$ php -v
PHP 7.1.12

Mysql Table Horizontal Split By Mycat

Server environment

1
2
3
4
5
6
7
8
$ cat /etc/issue
Ubuntu 14.04.5 LTS

$ mysqld -V
mysqld Ver 5.5.58-0ubuntu0.14.04.1 for debian-linux-gnu on x86_64 ((Ubuntu))

$ java -version
java version "1.7.0_151"

About Mysql Partition

Server environment

1
2
3
4
5
$ cat /etc/issue
Ubuntu 14.04.5 LTS

$ mysqld -V
mysqld Ver 5.5.58-0ubuntu0.14.04.1 for debian-linux-gnu on x86_64 ((Ubuntu))

Mysql Specify Slave Database And Table

Server environment

1
2
3
4
5
$ cat /etc/issue
Ubuntu 16.04 LTS

$ mysqld --version
mysqld Ver 5.7.22-0ubuntu0.16.04.1 for Linux on x86_64 ((Ubuntu))

Separate Mysql Slow Log Using Logrotate In Ubuntu

Server environment

1
2
3
4
$ cat /etc/issue
Ubuntu 16.04.2 LTS
$ logrotate --version
logrotate 3.8.7

Canal sync data to elasticsearch by Mysql binlog

Server environment

1
2
3
4
5
6
7
8
9
10
$ cat /etc/issue
Ubuntu 14.04.5 LTS

$ java -version
java version "1.8.0_151"
Java(TM) SE Runtime Environment (build 1.8.0_151-b12)
Java HotSpot(TM) 64-Bit Server VM (build 25.151-b12, mixed mode)

$ mysqld --version
mysqld Ver 5.7.20 for Linux on x86_64 (MySQL Community Server (GPL))

Mysql Slave Config With Docker

Server environment

1
2
3
4
5
6
7
8
9
10
11
12
$ cat /etc/issue
Ubuntu 14.04.5 LTS

$ docker -v
Docker version 1.6.2, build 7c8fca2

mysql> select version();
+------------+
| version() |
+------------+
| 5.7.12-log |
+------------+

Different Between MyISAM And InnoDB In MySQL

Server environment

1
2
3
4
5
$ cat /etc/issue
Ubuntu 14.04.5 LTS

$ mysqld -V
mysqld Ver 5.5.58-0ubuntu0.14.04.1 for debian-linux-gnu on x86_64 ((Ubuntu))

How PHP Connect to Mysql

My computer develop environment

1
2
$ php -v
PHP 7.0.26

Keep update MySQL error collection

This is an article about how to solve the error i meet in using MySQL

Compile and install LAMP in Ubuntu

Server environment

1
2
$ cat /etc/issue
Ubuntu 14.04.5 LTS
Your browser is out-of-date!

Update your browser to view this website correctly. Update my browser now

×