Home > OS >  To store your MYSQL data FreeNAS ISCSI disk, provided by the great effects on MYSQL performance
To store your MYSQL data FreeNAS ISCSI disk, provided by the great effects on MYSQL performance

Time:11-13

DELL R710 installed in a MYSQL database, the database file, with a large number of binary storage database has nearly 50 gb, I am not very understand, daily backup is on cold standby,
Recently learned that the FreeNAS read/write speed is good, can also provide the ISCSI service, ISCSI disk snapshot is very convenient, can decrease The Times of cold standby
Going to do with Taiwan R710 FreeNAS installation, with 4 pieces of 2 TB hard drive, do ZFS 3 pieces, 1 piece of backup disk, in order to read and write speed to the server with 32 gb of memory,
Want to consult the database on the FreeNAS impact on the performance quite (gigabit nics), a database file, with a large number of binary storage to improve reading speed, focus on optimizing mysql those parameters? Mysql database to a Mr D interactive map server to provide services, the official configuration requires eight nuclear 32 gb.
If the database can be successfully deposited onto the FreeNAS. Want to get a R730 ESXi installation, configuration is as follows: the v3 E5-2620 * 2 64 gb of memory, mysql database will be installed to the virtual machine, will also install a windos server (domain controller) and two Centos server (a seafile installation, a test), want to consult this configuration, enough ESXi still free now?
  • Related